O'Reilly logo

MDX with Microsoft SQL Server 2008 R2 Analysis Services: Cookbook by Tomislav Piasevoli

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Displaying members without children (leaves)

Parent-child hierarchies, also known as unbalanced or recursive hierarchies, are hierarchies with flexible-level depth. Unlike regular user hierarchies, the depth in a parent-child hierarchy is not determined in advance. It is a direct consequence of recursive relation inside the dimension table. Members, irrespective of the level they are at, are not required to have descendants. The Adventure Works database has several such dimensions: the Employee dimension, the Account dimension, and the Organization dimension.

Ragged hierarchies are another type of non-balanced hierarchies. Their depth is fixed, known in advance, but some of the members on intermediate levels are hidden. The final effect is identical ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required