MicroStrategy ONE

List Attribute Properties statement

Lists all properties from a given attribute within a project.

Copy 
LIST [ALL] PROPERTIES 
 FOR ATTRIBUTE attribute_name 
 IN [FOLDER] location_path FOR 
 PROJECT project_name;

where:

  • attribute_name is the name of the attribute whose properties are to be listed, of type string, between double quotes (").

  • location_path is the folder where the attribute resides, of type string, between double quotes (").

  • project_name is the name of the project, of type string, between double quotes (").

This statement can only be executed in a Windows environment.

Example

Copy 
LIST ALL PROPERTIES FOR ATTRIBUTE "Customer" 
 IN FOLDER "\Schema Objects\Attributes\Customers" FOR PROJECT 
 "MicroStrategy Tutorial";

ResultSet Columns

ATTRIBUTE_CHILDREN: A ResultSet containing information about the attribute's child.

  • ATTRIBUTE_CHILD: The child of the current attribute, returned as a string.

  • ATTRIBUTE_CHILD_RELATIONSHIP: Relationship between the attribute and child attribute, such as many to one. Returned as a string.

  • ATTRIBUTE_CHILD_TABLE: Table the attribute child is stored in, returned as a string.

  • PATH: Folder path of the attribute child, returned as a string.

    • ATTRIBUTE_DISPLAY: A ResultSet concerning details that determine attribute display.

  • ATTRIBUTE_ELEMENT_DISPLAY: Whether attribute element display is locked or unlocked, returned as a string.

  • ATTR_APPLY_SEC_FILTERS_TO_ELEM_BROWSING: Whether security filters are applied to element browsing, returned as a boolean value.

  • ATTR_ENABLE_ELEMENT_CACHING: Whether element caching is enabled, returned as a boolean value.

  • BROWSE_FORMS_LIST: A ResultSet containing information about the display of attribute forms when browsing.

    • ATTR_BROWSE_DISPLAY: The attribute forms displayed when browsing, returned as a string.

  • REPORT_DISPLAY_LIST: A ResultSet concerning the display of attribute forms in the context of a report.

    • ATTR_REPORT_DISPLAY: The attribute forms displayed on a report, returned as a string.

    ATTRIBUTE_FORM: A ResultSet describing the attribute forms of the current attribute.

  • ATTRIBUTE_EXPRESSION_LIST: A ResultSet describing the attribute expression.

    • ATTRIBUTE_MAPPING_TABLE_LIST: A ResultSet containing information about attribute mapping.

      • SCHEMA_CANDIDATE_TABLE: Tables from which the attribute can return data, returned as a string.

    • MAPPING_METHOD: The mapping method between the attribute and the source table, either automatic or manual. Returned as a string.

    • SCHEMA_EXPRESSION: The schema expression associated with the attribute expression, returned as a string.

  • ATTRIBUTE_FORM_BROWSESORT: The order in which to sort the elements for browsing, returned as an integer:

    • 1: Ascending

    • 2: Descending

  • ATTRIBUTE_FORM_CATEGORY: The category of the attribute form, returned as a string.

  • ATTRIBUTE_FORM_DESC: The description of the attribute form, returned as a string.

  • ATTRIBUTE_FORM_MULTILINGUAL: Whether the attribute form is multilingual, returned as an integer:

    • 0: False

    • 1: True

  • ATTRIBUTE_FORM_NAME: The name of the attribute form, returned as a string.

  • ATTRIBUTE_FORM_REPORTSORT: The order in which to sort the elements in a report, returned as an integer:

    • 1: Ascending

    • 2: Descending

  • ATTRIBUTE_FORM_TYPE: The type of the attribute form, returned as a string.

  • ATTRIBUTE_LOOKUP_TABLE: The lookup table of the current attribute form, returned as a string.

    • ATTRIBUTE_PARENTS: A ResultSet containing information about the attribute's parent.

  • ATTRIBUTE_PARENT: The parent of the current attribute, returned as a string.

  • ATTRIBUTE_PARENT_RELATIONSHIP: Type of relationship the attribute has with its parent, such as many to one. Returned as a string.

  • ATTRIBUTE_PARENT_TABLE: Table the attribute's parent is stored in, returned as a string.

  • PATH: The folder path of the parent attribute, returned as a string.

    • CREATION_TIME: Date and time the attribute was created, returned as a date/string.

    DESCRIPTION: The attribute's description, returned as a string.

    HIDDEN: Whether the attribute is hidden, returned as a boolean value.

    ID: ID of the attribute, returned as a string.

    LONG_DESCRIPTION: Long description of the attribute, returned as a string.

    MODIFICATION_TIME: Date and time the attribute was last modified, returned as a date/string.

    NAME: Name of the attribute, returned as a string.

    OWNER: Owner of the attribute, returned as a string.