Problem solve Get help with specific problems with your technologies, process and projects.

More powerful Analysis Services MDX in SQL Server 2005

MDX in SQL Server 2005 Analysis Services brings exciting improvements including query support and expression/calculation language.

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
 Home: Introduction
 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

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 last published in February 2007

Dig Deeper on Microsoft SQL Server 2005

Start the conversation

Send me notifications when other members comment.

By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Please create a username to comment.