Building and Managing a Parent-Child Dimension
We now enter the dimension construction phase of the guided cube build, where we will begin our exploration of the parent-child dimension.
Creating the PARENT-CHILD DIMENSION with the Dimension Wizard
The Cube Wizard now prompts us to select dimensions for our cube. The dimensions are, as yet, undefined, and at this stage, we will launch the Dimension Wizard to begin designating the dimensions.
31. Click the New Dimension button.
The Dimension Wizard - Welcome dialog appears, as shown in Illustration 19 below:
Illustration 19: The Dimension Wizard Appears
32. Click Next.
The Dimension Wizard - Choose How You Want to Create the Dimension dialog appears.
33. Select Parent-Child: Two Related Columns in a Single Dimension Table by clicking the respective radio button.
We are given a description of the parent-child dimension choice in the lower section of the dialog, which is depicted in Illustration 20 below.
Illustration 20: The Dimension Wizard - Choose How You Want to Create the Dimension Dialog
34. Click Next.
The Dimension Wizard - Select the Dimension Table dialog appears.
35. Select the employee table.
The columns from the employee table appear in the right side Details area of the dialog, as shown below.
Illustration 21: The Dimension Wizard - Select the Dimension Table Dialog
36. Click Next.
We arrive at the Dimension Wizard - Select the Columns that Define the Parent-Child Hierarchy dialog.
37. Select the columns shown in Table 1 below for the respective dropdown lists within the dialog:
|
Parent-Child Hierarchy
|
|
Dialog Setpoints
|
|
|
|
|
|
|
|
Dropdown List
|
|
|
|
Selection
|
|
|
|
|
|
|
|
1.
Member Key
|
|
|
|
employee_id
|
|
|
|
|
|
|
|
2.
Parent Key
|
|
|
|
supervisor_id
|
|
|
|
|
|
|
|
3.
Member Name
|
|
|
|
full_name
|
|
|
|
|
|
|
The Dimension Wizard - Select Advanced Options dialog appears, as shown below.
» 
Comment and Contribute
