Enter a long URL to make tiny:

Excel Addin to extract MDX Query

One the question raised by my end users is, how they can view the MDX query out the Pivot table in excel they created connecting to an OLAP database. Excel has the excellent facilty to connect to a OLAP database and generate Pivot table using multi-dimensional cube. The pivot table can be defined by dragging and dropping the measures and dimension values with ease.

Found this super cool addin which eases out this pain of exacting the MDX query out of the Pivot table.

http://www.codeplex.com/OlapPivotTableExtend

The addin is easy to install and use.