MDX Macro or Function syntax - by Darren Gosbell

Status : 


Sign in
to vote
ID 651646 Comments
Status Active Workarounds
Type Suggestion Repros 0
Opened 3/15/2011 6:01:43 PM
Access Restriction Public


MDX should have the capability of defining re-usable MDX expressions in the form of a function or macro or function so that a complex expression can be defined once and then re-used in multiple places.

Named sets go part way towards achieving some re-usability, but they are not a good solution from a performance perspective because they prevent the engine from using block mode computations.
Sign in to post a comment.
Posted by Michael Barrett on 3/17/2011 at 12:06 AM
This is a great suggestion. It is unfortunate that the options for writing structured and easily-maintainable code is currently so inhibited by performance considerations.
Posted by Microsoft on 3/16/2011 at 2:17 PM
Thanks for opening the issue, Darren. We'll include this in our planning for future versions based on the amount of feedback we get.