MicroStrategy ONE

Hierarchy management: Remove Attribute From Hierarchy statement

Removes an attribute from a hierarchy.

Copy
REMOVE ATTRIBUTEattribute_nameIN FOLDERattribute_folder_nameFROM HIERARCHYhierarchy_name[IN FOLDERfolder_name] FOR PROJECTproject_name;

where:

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

  • attribute_folder_name is the location of the 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, of type string, between double quotes (" ").

This statement can only be executed in a Windows environment.

Example

Copy
REMOVE ATTRIBUTE "Customer Age" IN FOLDER 
 "\Schema Objects\Attributes\Customers" FROM HIERARCHY "Customers" 
 IN FOLDER "\Schema Objects\Hierarchies" FOR PROJECT "MicroStrategy 
 Tutorial";