Create and Manage Parent-Child Hierarchies in a Semantic Model

This topic provides information to help you understand and create a parent-child hierarchy in a semantic model.

Topics:

• About Parent-Child Hierarchies

• About Levels and Distances in Parent-Child Hierarchies

• About Parent-Child Relationship Tables

• Create Dimensions with Parent-Child Hierarchies

• Generate Scripts to Create a Parent-Child Relationship Table

• Add the Parent-Child Relationship Table to the Semantic Model

• Define Parent-Child Relationship Tables

• About Modeling Aggregates for Parent-Child Hierarchies

• About Storing Facts for Parent-Child Hierarchies

• About Aggregating Parent-Child Hierarchies

• Maintain Parent-Child Hierarchies Based on Relational Tables