Hierarchies Section

This section defines the dimension members, their member and relationship properties, and hierarchical/parent-child relationships. This section:

  • is required for new dimensions and existing dimensions that use the replace method.

  • is optional for existing dimensions that use the merge method.

  • controls the order of members under a parent. Members of existing dimensions are reordered during replace-mode import execution if all members under a parent are present in the Hierarchies section.

Syntax

!Hierarchies=Dimension_Name

'Parent;Child;Member-Relationship_Property1;…;Member-Relationship_PropertyN

Parameter

Description

Dimension_Name

 Name of dimension whose members are being defined.

Parent

 Name of parent member. This is a required column.

Child

 Name of child member. This is a required column.

Member-Relationship_PropertyX

 Member-level property or member relationship property name for the respective dimension type. See the product-specific chapters for member property information.

IsPrimary

 Specifies whether an instance of a member under a parent is primary or shared. The IsPrimary parameter is optional; however, we strongly recommend that you use it. If left undefined, it defaults to “True”, which assumes that the member is primary. See Specifying Primary and Shared Instances of a Member using IsPrimary.

Example

!Hierarchies=Currency
'Parent;Child
#root;EURO
#root;GBR
#root;USD
!Hierarchies=Scenario
'Parent;Child
#root;Actual
#root;Budget
!Hierarchies=Entity
'Parent;Child
#root;Entity_[None]
#root;Regional
Regional;UnitedStates
UnitedStates;California
California;Sunnyvale
California;FosterCity
UnitedStates;Connecticut
Connecticut;Stamford
!Hierarchies=Account
'Parent;Child
#root;Account_[None]
#root;ExchangeRates
ExchangeRates;Rate1
ExchangeRates;Rate2
#root;Plug

Note:

The token '#root' is used to refer to the top dimension member as the parent. Alternatively, the dimension name can also be used to refer to the top dimension member as the parent.

Tip:

Properties containing multiple values, like Alias and UDA can be defined in the Hierarchies section.

Example

Example of defining the Alias property in the Hierarchies section:

!Hierarchies=Entity
'Parent;Child;DefaultParent;Currency;AllowAdjs;AllowAdjFromChildren;HoldingCompany;Alias=English;Alias=French
#root;Entity_[None];Y;[None];N;N;;Entity None Alias;French None Alias
#root;Regional;Y;USD;Y;N;;Regional Operations;Operationes Regionale

Example

Example of defining the UDA property in the Hierarchies section:

!Hierarchies=Plan1Account
'Parent;Child;UDA1; UDA2;UDA3;
111092;HSP_NOLINK;Plan1;Plan3
111093;HSP_NOLINK;Plan3