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 with data in parent-child hierarchies

In the previous recipe we saw how to display members without children. The idea was to separate members with direct, fact table values from those whose value is a result of an aggregation. Quite a common thing if you're working with assignments and allocations in order to have correct calculations.

However, some business scenarios require direct values on non-leaf members. For example, a manager of salespeople generates sales himself too. Of course, this feature is supported in the parent-child hierarchy model built into SQL Server Analysis Services. The key properties to be used in this scenario are the MembersWithData and MembersWithDataCaption properties.

Separating the leaves is not good ...

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