Free Newsletters:
DatabaseDaily  
Database Journal
Search Database Journal:
 
MS SQL Oracle DB2 Access MySQL PostgreSQL Sybase PHP SQL Etc SQL Scripts & Samples Links Database Forum DBA Videos
internet.com

» Database Journal Home
» DBA Videos
» Database Articles
» Database Tutorials
MS SQL
Oracle
MS Access
MySQL
DB2
» RESOURCES
Database Tools
SQL Scripts & Samples
Links
» Database Forum
» DBA Jobs
» Sitemap

News Via RSS Feed



follow us on Twitter

Marketplace Partners
Be a Marketplace Partner

internet.commerce
Be a Commerce Partner


















Mariposa Bot Shipped With Vodafone Smartphone

IT Job Market Heating Up: Report

Bing Makes Strides But Momentum Stalls

internet.com
IT
Developer
Internet News
Small Business
Personal Technology

Search internet.com
Advertise
Corporate Info
Newsletters
Tech Jobs
E-mail Offers


Database Journal | DBA Support | SQLCourse | SQLCourse2







Senior Systems Administrator – Windows (IL)
Next Step Systems
US-IL-Chicago

Justtechjobs.com Post A Job | Post A Resume

Featured Database Articles

MS SQL

October 7, 2002

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

By William Pearson


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

 

 

 

 

 

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.


Page 7: Building a P-C Dimension Continued


See All Articles by Columnist William E. Pearson, III




Go to page: Prev  1  2  3  4  5  6  7  8  9  10  11  Next  

Tools:
Add databasejournal.com to your favorites
Add databasejournal.com to your browser search box
IE 7 | Firefox 2.0 | Firefox 1.5.x
Receive news via our XML/RSS feed

MS SQL Archives








Latest Forum Threads
MS SQL Forum
Topic By Replies Updated
Inner and outer select mussab 2 March 10th, 04:16 AM
SQL server 2008 in windows 7 pro problem theresatan 2 March 6th, 08:35 PM
code for re-build index and shrink db or file? mib 7 March 5th, 08:50 AM
sql maintenance plan fails database missing tbrownch 3 February 24th, 08:53 AM









The Network for Technology Professionals

Search:

About Internet.com

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