MDX Solutions is both a tutorial and a reference guide to the MDX query language. It shows data warehouse developers what they need to know to build effective multidimensional data warehouses. And it teaches users what they need to know to access and analyze data to make better business decisions.
The Second Edition provides 200 additional pages of new material covering both changes in the MDX language itself as well as major changes in its implementation with the latest software releases of Microsoft SQL Server Analysis Services 2005 and Hyperion Essbase.
Chapter 1 A first introduction to MDX
Chapter 2 Introduction to MDX calculated members and
named sets
Chapter 3 Common calculations and selections in MDX
Chapter 4 MDX query context and execution
Chapter 5 Named sets and set aliases
Chapter 6 Sorting and ranking in MDX
Chapter 7 Advanced MDX application topics
Chapter 8 Using the attribute data model of Microsoft analysis
services
Chapter 9 Using attribute dimensions and member properties
in Hyperion Essbase
Chapter 10 Extending MDX through external functions
etc.