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";