Hierarchy management: Create Hierarchy statement

Creates a user hierarchy within a project.

CREATE HIERARCHYhierarchy_name[IN FOLDERfolder_name] [DRILLHIERARCHY (TRUE|FALSE)] [DESCRIPTIONdescription] [LONGDESCRIPTIONlong_description] [HIDDEN (TRUE|FALSE)] ATTRIBUTESattribute_name1INfolder_name1(LOCKED|UNLOCKED|LIMITlimit) [ENTRYPOINT (TRUE|FALSE)], [attribute_name2INfolder_name2(LOCKED|UNLOCKED|LIMITlimit) [ENTRYPOINT (TRUE|FALSE)]] ... [attribute_nameNINfolder_nameN(LOCKED|UNLOCKED|LIMITlimit) [ENTRYPOINT (TRUE|FALSE)]] 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 description of the new hierarchy, of type string, between double quotes (" ").
• long_description is the long description of the new hierarchy, of type string, between double quotes (" ").
• attribute_name1..N is the name of an attribute in the hierarchy, of type string, between double quotes (" "). These attributes are automatically considered entry point attributes.
• folder_name1..N 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 the hierarchy is created in, of type string, between double quotes (" ").

This statement can only be executed in a Windows environment.

Example

CREATE HIERARCHY "Customers" IN FOLDER 
 "\Schema Objects\Hierarchies" ATTRIBUTES "Customer Age" 
 IN FOLDER "\Schema Objects\Attributes\Customers" FOR PROJECT 
 "MicroStrategy Tutorial";