Database Journal
MS SQL Oracle DB2 Access MySQL PostgreSQL Sybase PHP SQL Etc SQL Scripts & Samples Tips Database Forum

» Database Journal Home
» Database Articles
» Database Tutorials
MS Access
SQL Scripts & Samples
» Database Forum
» Slideshows
Free Newsletters:

News Via RSS Feed

Database Journal |DBA Support |SQLCourse |SQLCourse2

Featured Database Articles


Posted Oct 7, 2002

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

By William Pearson

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

MS SQL Archives

Latest Forum Threads
MS SQL Forum
Topic By Replies Updated
SQL 2005: SSIS: Error using SQL Server credentials poverty 3 August 17th, 07:43 AM
Need help changing table contents nkawtg 1 August 17th, 03:02 AM
SQL Server Memory confifuration bhosalenarayan 2 August 14th, 05:33 AM
SQL Server Primary Key and a Unique Key katty.jonh 2 July 25th, 10:36 AM