 |
 |
| SQL Server Tips: |
|
 |
 |

DATA WAREHOUSING AND BUSINESS INTELLIGENCE
More powerful Analysis Services MDX in SQL Server 2005
By Baya Pavliashvili 02.23.2007
Rating: --- (out of 5)




|
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.
| 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.
Copyright 2007 TechTarget
|
|
More on this topic:
Use cube partitions to improve Analysis Services performance
Analysis Services 2005 in SQL Server has improved security
SQL Server Business Intelligence toolbox
 |

|
Rate this Tip
|
To rate tips, you must be a member of SearchSQLServer.com. Register now
to start rating these tips. Log in if you are already a member.
|


');
// -->
DISCLAIMER: Our Tips Exchange is a forum for you to share technical advice and expertise with your peers and to learn from other enterprise IT professionals. TechTarget provides the infrastructure to facilitate this sharing of information. However, we cannot guarantee the accuracy or validity of the material submitted. You agree that your use of the Ask The Expert services and your reliance on any questions, answers, information or other materials received through this Web site is at your own risk.
|
 |
|
|
 |
|
 |
 |
 |
 |
| TechTarget provides technology professionals with the information they need to perform their jobs - from developing strategy, to making cost-effective purchase decisions and managing their organizations' technology projects - with its network of . |
|
| |
All Rights Reserved, , TechTarget |
|
|
|
|
|