MicroStrategy ONE

Hierarchy management: Alter Hierarchy statement

Modifies a hierarchy within a project.

Copy 
ALTER HIERARCHYhierarchy_name[NAMEnew_hierarchy_name] [IN FOLDERfolder_name] [DRILLHIERARCHY (TRUE|FALSE)] [DESCRIPTIONdescription] [LONGDESCRIPTIONlong_description] [LOCATIONnew_folder_name] [HIDDEN (TRUE|FALSE)] [ATTRIBUTEattribute_name1INfolder_name1(LOCKED|UNLOCKED|LIMITlimit)] 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 (" ").

  • description is the new description of the hierarchy, of type string, between double quotes (" ").

  • long_description is the new long description of the hierarchy, of type string, between double quotes (" ").

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

  • attribute_name1 is the name of an attribute to be added to the hierarchy, of type string, between double quotes (" "). This attribute is automatically considered an entry point attribute.

  • folder_name1 is the location of that attribute, of type string, between double quotes (" ").

  • limit is the number of elements of that attribute shown at one time, of type integer.

  • 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 
ALTER HIERARCHY "Customers" NAME "New 
 Customers" IN FOLDER "\Schema Objects\Hierarchies" ATTRIBUTE 
 "Customer Age" IN FOLDER "\Schema Objects\Attributes\Customers" 
 FOR PROJECT "MicroStrategy Tutorial";