Chapter 8. Advanced MDX Topics

In this chapter, we will cover:

• Displaying members without children (leaves)

• Displaying members with data in parent-child hierarchies

• Implementing the Tally table utility dimension

• Displaying random values

• Displaying random sample of hierarchy members

• Displaying a sample from random hierarchy

• Performing complex sorts

• Using recursion to calculate cumulative values