Report Portal

Creating Ragged Hierarchies in SQL Server Analysis Services

I have created a data model in Analysis Services. This model contains a couple of hierarchies. One of those hierarchies is a ragged hierarchy, which means not all branches of the hierarchy tree have the same number of levels. Right now, if a branch stops, the leaf member is repeated until the lowest level. How can I model this correctly in Analysis Services?

Read more...

 

Tags: design, multidimensional, tabular

 

2007-2015 VidasSoft Systems Inc.