Hierarchy management: List Hierarchies statement

List the hierarchies in a project.

LIST [ALL] HIERARCHIES [IN FOLDERfolder_name] 
 FOR PROJECTproject_name;

where:

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

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

This statement can only be executed in a Windows environment.

Example

LIST ALL HIERARCHIES IN FOLDER "\Schema Objects\Hierarchies FOR PROJECT 
 MicroStrategy Tutorial;

ResultSet Columns

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

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

PATH: The path to the hierarchy, returned as a string.