MicroStrategy ONE

Hierarchy management: Remove Relationship statement

Removes an existing relationship between two existing attributes in a hierarchy.

Copy 
REMOVE RELATIONSHIP PARENTATTRIBUTEparent_attribute_nameIN FOLDERparent_folder_nameCHILDATTRIBUTEchild_attribute_nameIN FOLDERchild_folder_nameFROM HIERARCHYhierarchy_name[IN FOLDERfolder_name] FOR PROJECTproject_name;

where:

  • parent_attribute_name is the name of the parent attribute, of type string, between double quotes (" ").

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

  • child_attribute_name is the name of the child attribute, of type string, between double quotes (" ").

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

This statement can only be executed in a Windows environment.

Example

Copy 
REMOVE RELATIONSHIP PARENTATTRIBUTE "Customer 
 Age" IN FOLDER "\Schema Objects\Attributes\Customers" CHILDATTRIBUTE 
 "Customer Birth Date" IN FOLDER "\Schema Objects\Attributes\Customers" 
 TO HIERARCHY "Customers" IN FOLDER "\Schema Objects\Hierarchies" 
 FOR PROJECT "MicroStrategy Tutorial";