Very happy to see that my Power Query Management Studio isn’t just perceived nerdy but useful as well 🙂 Thanks to Dusty for his nice review.
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 🙂
Thanks for the plug and thanks for the nifty tool! 🙂
When I click on the ‘Send A Frown’, it doesn’t produce an outgoing email message.