MicroStrategy ONE

Hierarchy management: List Hierarchy Properties statement

Lists the properties of hierarchies in a project.

Copy 
LIST [ALL] PROPERTIES FOR HIERARCHYhierarchy_name[IN FOLDERfolder_name] FOR PROJECTproject_name;

where:

  • hierarchy_name is the name of the hierarchy, of type string, between double quotes (" ").

  • folder_name is the location of the hierarchy, of type string, between double quotes (" ").

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

This statement can only be executed in a Windows environment.

Example

Copy 
LIST ALL PROPERTIES FOR HIERARCHY "Customers" 
 IN FOLDER "\Schema Objects\Hierarchies" FOR PROJECT "MicroStrategy 
 Tutorial";

ResultSet Columns

CREATION_TIME: The date and time the hierarchy was created, returned as a date/string.

DESCRIPTION: The description of the hierarchy, returned as a string.

DRILLHIERARCHY: Whether or not the hierarchy is a drill hierarchy, returned as a boolean value.

HIDDEN: Whether or not the hierarchy is hidden, returned as a boolean value.

HIERARCHY_ATTRIBUTE: A ResultSet containing a list of attributes associated with the hierarchy.

  • ATTRIBUTE: The name of the attribute, returned as a string.
  • ATTRIBUTE_CHILD: A list containing the children of the attribute, returned as a string.
  • LOCKED: Whether or not the attribute is locked. If locked, this column will return the number of  attributes that will be initially displayed, such as in the value "Limit: 50". Returned as a string.
  • PATH: The path to the attribute, returned as a string.

ID: The object ID of the hierarchy, returned as a string.

LONG_DESCRIPTION: The long description of the hierarchy, returned as a string.

MODIFICATION_TIME: The date and time the hierarchy was created, returned as a date/string.

NAME: The name of the hierarchy, returned as a string.

OWNER: The owner of the hierarchy, returned as a string.