Analysis Services 2005 (part of the SQL Server suite of products) introduced many improvements over its predecessors OLAP Services 7 and Analysis Services 2000. In many ways, the product seems to have been re-architected from the ground up. Although the MDX (multidimensional expressions) language hasn't changed dramatically, the new version does offer some exciting improvements.
In this tip, I'd like to discuss a few improvements that are worth being thrilled about, since they are likely to apply to many intricate business intelligence solutions. In particular, I'll talk about CASE statements, sub-queries and the SCOPE function, which make MDX more powerful and flexible than before.
More powerful Analysis Services MDX in SQL Server 2005
Part 2: Sub-queries supported in Analysis Services MDX
Part 3: MDX functions: SCOPE, THIS and FREEZE
ABOUT THE AUTHOR
Baya Pavliashvili is a DBA manager overseeing database operations that support more than one million users. Pavliashvili's primary areas of expertise are performance tuning, replication and data warehousing.
This was first published in February 2007