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 1: CASE statements now supported by MDX script
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.