O'Reilly logo

Smart Business Intelligence Solutions with Microsoft® SQL Server® 2008 by Kevin S. Goff Lynn Langit Davide Mauri, Sahil Malik, and John C. Welch

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

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 ...

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