Skip to main content


Excel Add-in to help beginners (and experts) write MDX

A client found a cool add-in for Excel the other day that allows users to view the underlying MDX associated with Pivot tables called PTPower. This is great because beginning MDX developers can use it to quickly view the underlying MDX for a Pivot table and use it to build elements within the SSAS cube, filters on PerformancePoint dashboards, and SSRS reports. In fact, in most cases the MDX can just be ripped directly from Excel with only slight cleanup. This tool is also useful for end users that do custom Excel reporting using cube functions such as CUBEVALUE() and CUBEMEMBER().
To use it, simply install the add-in found here.
Once installed, create a simple Pivot table. Within the ribbon find the PTPower add-in and click “Show MDX”!!
Note: This is not a Microsoft licensed add-in so use at your own risk! I have been using for a long time with no issues.

Thoughts on “Excel Add-in to help beginners (and experts) write MDX”

  1. This is the best blog for anyone who needs to search out out about this topic. You realize a lot its virtually laborious to argue with you (not that I truly would needÖHaHa). You definitely put a new spin on a topic thats been written about for years. Nice stuff, just nice!

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.

Mike Burger

More from this Author

Follow Us