MicroStrategy ONE

Add Attribute to Hierarchy statement

Add an attribute to an existing hierarchy.

Copy 
ADD ATTRIBUTEattribute_name(LOCKED|UNLOCKED|LIMITlimit) IN FOLDERattribute_folder_name[ENTRYPOINT (TRUE|FALSE)] CHILDATTRIBUTESchild_attribute_name1IN FOLDERfolder_name1, [child_attribute_name2IN FOLDERfolder_name2] .. [child_attribute_nameNINfolder_nameN]] TO HIERARCHYhierarchy_name[IN FOLDERfolder_name] FOR PROJECTproject_name;

where:

  • attribute_name is the name of the attribute to be added to the hierarchy, of type string, between double quotes (" ").

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

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

  • child_attribute_name1..N is an attribute in the hierarchy that is a child of this attribute, of type string, between double quotes (" ").

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

  • 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.

This statement can only be executed in a Windows environment.

Example

Copy 
ADD ATTRIBUTE "Customer Age" LOCKED IN 
 FOLDER "\Schema Objects\Attributes\Customers" CHILDATTRIBUTES 
 "Customer Birth Date" IN FOLDER "\Schema Objects\Attributes\Customers" 
 TO HIERARCHY "Customers" IN FOLDER "\Schema Objects\Hierarchies" 
 FOR PROJECT "MicroStrategy Tutorial";