MicroStrategy ONE

Hierarchy management: Add Relationship statement

Creates a relationship between two existing attributes in a hierarchy.

Copy 
ADD RELATIONSHIP PARENTATTRIBUTEparent_attribute_nameIN 
 FOLDERparent_folder_nameCHILDATTRIBUTEchild_attribute_nameIN FOLDERchild_folder_nameTO 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 
ADD RELATIONSHIP PARENTATTRIBUTE "Customer Age" 
 IN FOLDER "\Schema Objects\Attributes\Customers" CHILDATTRIBUTE 
 "Customer Birth Date" IN FOLDER "\Schema Objects\Attributes\Customers" 
 FROM HIERARCHY "Customers" IN FOLDER "\Schema Objects\Hierarchies" 
 FOR PROJECT "MicroStrategy Tutorial";