Define Parent-Child Relationship Tables

The parent-child relationship table must have at least four columns that describe how the inter-member relationships are derived in the logical table selected for the hierarchy.

When you configure the parent-child relationship table, you can select an existing relationship table. Or you can create, generate, and import the required relationship table into the physical layer. For information about how to generate the table, see Generate Scripts to Create a Parent-Child Relationship Table.

1. On your home page, click Navigator and then click Semantic Models.
2. In the Semantic Models page, click a semantic model to open it.
3. Click Logical Layer .
4. In the Logical layer, double-click a logical table, and then click the logical table's Hierarchy tab.
5. In the Hierarchy Type field and select Parent-Child.
6. Scroll to Relationship Table, click Select to select and add a logical table source, and then in the Relationship Table field, click Add.
7. In Select Physical Table, click a Physical Table to act as the parent-child relationship table for your hierarchy, and then click Select.
8. Map the Member Key, Ancestor Key, Relationship Distance, and Leaf Node Identifier column fields to the physical parent-child relationship table.
9. Click Save.