So let’s push it a bit further and add some MDX functions to it that cannot be done by DMVs:
- get a list of all unique fields used in a specific MDX query
- translate your code to a different cube using a simple field-translation table
How to use this for MDX:
In sheet “Source” copy your code into cell A2. Refresh the queries and have a look at sheet “List” where you find your unique fields in column A.
You can now fill in the field names of your new cube into column D, refresh again and fetch your translated code from cell F2.MDXCodeTranslationManager.xlsx
Enjoy & stay queryious 🙂