About the Logical Table Source's Parent-Child Settings
When a logical table is part of a dimension with a parent-child hierarchy that's based on relational tables, the logical table includes both a physical source and a source for the parent-child relationship table required by the parent-child hierarchy.
Parent-child relationship tables explicitly define the inter-member relationships for parent-child hierarchies.
You can view details for the parent-child relationship table source in logical table's Hierarchy tab.
-
Relationship Table - The name of the parent-child relationship table that the source is based on.
-
Member Key - The name of the column in the parent-child relationship table that identifies the member.
-
Parent Key - The name of the column in the parent-child relationship table that identifies an ancestor of the member.
-
Relationship Distance - The name of the column in the parent-child relationship table that specifies the number of parent-child hierarchical levels from the member to the ancestor.
-
Leaf Node Identifier - The name of the column in the parent-child relationship table that indicates if the member is a leaf member (1=Yes, 0=No).