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