SSAS Articles 
Parent-child Parent-Child Dimensions - Introduction , drawback and alternative approach
Parent-child Parent-Child Dimensions - Introduction , drawback and alternative approach
| Parent-Child Dimensions - Introduction , drawback and alternative approach |
| 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.
|
Comments (2)
Latest Author Articles
- Dynamic Management Views for SSAS
- How can solve order effect your MDX calculations
- Parent-Child Dimensions - Introduction , drawback and alternative approach
- Creating Sub Cubes - Visual and Non Visual Mode
- Using AMO to query cube , partitions and other SSAS objects- How to find query definition of the partition
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
my email is This e-mail address is being protected from spambots. You need JavaScript enabled to view it
best regards