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
Table 1: Columns that Define the Parent-Child Hierarchy Setpoints
The completed dialog appears as shown in Illustration 22 below.
Illustration 22: The Dimension Wizard - Columns that Define the Parent-Child Hierarchy
38. Click Next.
The Dimension Wizard - Select Advanced Options dialog appears, as shown below.
Illustration 23: The Dimension Wizard - Select Advanced Options Dialog
39. Click Next to skip this dialog and to continue to its successor.
Add databasejournal.com to your favorites Add databasejournal.com to your browser search box IE 7 | Firefox 2.0 | Firefox 1.5.xReceive news via our XML/RSS feed
IE 7
Firefox 2.0