In this article, we will examine another special type of dimension, the Parent-Child dimension, and explore the attributes that make it different from a regular dimension. We will discuss the considerations that surround the Parent-Child dimension, such as the recursive nature of their data sources, and various actions that must be handled differently in their creation and maintenance.

In this article, we will:

• Discuss unbalanced hierarchies, and scenarios where we need a parent-child dimension
• Create a parent-child dimension using the Dimension Wizard
• Work with levels in a parent-child dimension
• Work with parent-child dimension properties
• Enable values at the parent level of a parent-child dimension

Read the Article ...

About the Series:

This article is a member of the series Introduction to MSSQL Server 2000 Analysis Services. The series is designed to provide hands-on application of the fundamentals of MS SQL Server 2000 Analysis Services, with each installment progressively adding features and techniques designed to meet specific real - world needs. For more information on the series, as well as the hardware / software requirements to prepare for the exercises we will undertake, please see my initial article, Creating Our First Cube.

Analysis Services, Parent-Child, Ragged Hierarchy, Recursive, Dimension, Properties

All Contents Copyright Island Technologies Inc. ^®  Island Technologies^® and Island Technologies Inc.^®  are registered trademarks of Island Technologies Inc., protected in the United States and other countries.  For information, contact Island.