Parent-Child Dimensions - Introduction , drawback and alternative approach
User Rating: / 4
PoorBest 
Written by Ashwani Roy   
Thursday, 24 December 2009 00:43

First of all lets understand what Parent Child dimensions are and where and When they are modelled.

From MSDN

A parent-child dimension is based on two dimension table columns that together define the lineage relationships among the members of the dimension. One column, called the member key column, identifies each member; the other column, called the parent key column, identifies the parent of each member. This information is used to create parent-child links, which are then combined into a single member hierarchy that represents a single meta data level.

Read more...

 
 
Comments (3)
3 Sunday, 24 April 2011 05:28
himali
hi!ashwani u have written very well i m imperious by u.
2 Wednesday, 06 January 2010 20:15
VidasMatelis
All Parent-Child related articles that are published online and known to me are listed here:
http://www.ssas-info.com/tags/parent_child

I also would recommend you read this book :

http://www.ssas-info.com/analysis-services-news/1653-july-21-2009-new-book-released-expert-cube-development-with-microsoft-sql-server-2008-analysis-services
1 Wednesday, 06 January 2010 20:11
mehrdad
Hi, I need some new pdf articles in the field of mine, would you kindly guide me.
my email is This e-mail address is being protected from spambots. You need JavaScript enabled to view it
best regards

 

Varigence Vivid