How to reduce MDX code redundancy in SQL Server Analysis Services (SSAS)

Posted on SQL Server Central See other posts from SQL Server Central
Published on Tue, 01 Mar 2011 07:00:00 UT Indexed on 2011/03/01 7:30 UTC
Read the original article Hit count: 231

Filed under:
To query an Analysis Services cube, MDX is used as the query language. In most business settings, one would find a set of queries that are common across a number of user query requirements. To cater to this, even with a modest size IT team, there is a good chance that the same queries are developed redundantly either within a SSAS MDX script or repetitively in an ad-hoc manner in client applications. In this tip we would look at how to reuse queries without redeveloping them over and over.

© SQL Server Central or respective owner