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