Chapter 8. Using MDX

After completing this chapter, you will be able to:

  • Use multidimensional expressions (MDX) to calculate contribution percentages.

  • Execute MDX queries using SQL Server Management Studio.

  • Use set functions.

  • Create calculated members that aggregate sets of values.

  • Use script assignments to change cube values.

  • Create key performance indicators (KPIs).

In the chapters of Part II, you were introduced to MDX by creating calculations that added new measures to your cube. In this chapter, you’ll expand your understanding of MDX by creating more complex calculated measures as well as calculations that create new dimension members. You’ll also learn how to construct MDX queries so that you can build analytical reports in custom applications ...

Get Microsoft® SQL Server™ 2005 Analysis Services Step by Step now with O’Reilly online learning.

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