Introduction to SQL Server 2000 Analysis Services: Parent-Child Dimensions - Page 7

October 7, 2002

The Dimension Wizard - Finish the Dimension Wizard dialog appears.

40. Name the dimension HumanResource. (See my comments above about why I like to use this versus "Employee" as a dimension name.)
41. Uncheck the Share This Dimension with Other Cubes checkbox (the default is checked).
42. Click on the "+" signs to the left of some of the dimension members displayed in the Preview window to get a feel for the structure of the dimension.

The Dimension Wizard - Finish the Dimension Wizard dialog appears, as shown below (with a portion of the Preview window displayed).

Illustration 24: The Dimension Wizard - Finish the Dimension Wizard Dialog

43. Click Finish.

The Dimension Wizard - Finish the Dimension Wizard dialog disappears. We are returned to the Cube Wizard, where we briefly left it at the Select the Dimensions for your Cube dialog. We see the newly added HumanResource member, as shown in Illustration 25 below.

Illustration 25: The Cube Wizard - Select the Dimensions for Your Cube Dialog

The hierarchy shows sibling members, some with children and some without, as one example of the unbalanced nature of the parent-child dimension. The provision in the Dimension Wizard for allowing unbalanced hierarchies offers us needed flexibility while giving us an easy means of creating parent-child dimensions.

Let's conclude the cube build we have started for the purposes of exploring the parent-child dimension, with the following steps.

44. Click Next.

The Fact Table Row Count warning dialog appears, as shown below.

Illustration 26: Fact Table Row Count Warning Dialog

45. Click Yes.

The Cube Wizard - Finish the Cube Wizard dialog appears.

46. Name the Cube MyCube2.

The Cube Wizard - Finish the Cube Wizard dialog now appears as shown in Illustration 27.

Illustration 27: The Cube Wizard - Finish the Cube

47. Click Finish.

We return to the Cube Editor. We will process the cube after making a few modifications to the HumanResource dimension in the next sections.

We will take a look at many of the properties and characteristics of the parent-child dimension in our next section, but first we will focus on level definition in the building of the parent-child dimension.

Page 8: Working with Levels in a Parent-Child Dimension

See All Articles by Columnist William E. Pearson, III

The Network for Technology Professionals



Legal Notices, Licensing, Permissions, Privacy Policy.
Advertise | Newsletters | E-mail Offers