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 ...

Get Microsoft® SQL Server™ 2000 Analysis Services Step by Step now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.