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 O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.