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