Chapter 11. Advanced MDX

Now that you’ve seen MDX examples in the previous chapter, we turn our attention to more advanced uses of MDX, including using MDX in real-world applications. In this chapter, we take a look at a number of examples related to advanced MDX query writing. These include querying dimension properties, creating calculated members, using the IIf function, working with named sets, and gaining an understanding of scripts and SOLVE_ORDER. We also look at creating KPIs programmatically. We close the chapter with an introduction to working with MDX in SQL Server Reporting Services (SSRS) and PerformancePoint Server.

Querying Dimension Properties

We spent considerable time in the last chapter talking about hierarchies and drilling down ...

Get Smart Business Intelligence Solutions with Microsoft® SQL Server® 2008 now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.