Hierarchies
This metadata file section defines parent-child relationships. A parent-child relationship is referred to as a node. A node can have its own set of attribute values.
A node record is a delimited list. The first two items of each line of the list identify a parent and child. You can use delimiters to represent missing attribute values as empty. All top-level members in a hierarchy should be represented as children of an empty parent.
Tip:
Node records for Custom dimensions contain a third attribute. See Custom Hierarchies.
To begin a hierarchies section, enter this line, replacing the <>
characters with the dimension name:
!HIERARCHIES=<>
Do not include spaces when starting sections for Custom dimensions. For example, begin the Hierarchies section for the FLOW dimension with this line:
!HIERARCHIES=Customers
;[None];1
;AllCustomers;0
AllCustomers;Customer2;1
AllCustomers;Customer3;1
AllCustomers;Customer4;1
AllCustomers;Customer5;1
Note:
For Custom dimensions, this section must use the Custom dimension alias name.
These topics list the formats for the Hierarchies sections of the Account, Scenario, Entity, and Custom dimensions.