Working with a Parent-Child Dimension
The Employee dimension you created in Chapter 2 is an unbalanced, parent-child dimension. The levels of the dimension hierarchy come from recursive columns in a single table, rather than from individual columns in star schema or snowflake schema tables. The Dimension Editor does not allow you to create a parent-child dimension. You must always use the Dimension Wizard to create a new parent-child dimension. Once the dimension is created, you can use the Dimension Editor (if the dimension is shared) or the Cube Editor (if the dimension is private) to modify its properties.
Create a Parent-Child Dimension
The most interesting properties of a parent-child dimension are visible only within the context of a ...