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

» Database Journal Home
» Database Articles
» Database Tutorials
MS SQL
Oracle
DB2
MS Access
MySQL
» RESOURCES
Database Tools
SQL Scripts & Samples
Links
» Database Forum
» Sitemap
Free Newsletters:
DatabaseDaily  
News Via RSS Feed


follow us on Twitter
Database Journal |DBA Support |SQLCourse |SQLCourse2
 

Featured Database Articles

MS SQL

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

Comment and Contribute

 


(Maximum characters: 1200). You have characters left.

 

 




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


















Thanks for your registration, follow us on our social networks to keep up-to-date