How to extract MDX or SQL query from excel pivot table

Question

I have an excel file reading some data from an OLAP service. The query was constructed using the GUI. How can I obtain the corresponding MDX or SQL query that excel actually communicates to the OLAP server?

Answer 1

You can do it through SQL server profiler. Just run the profiler on Analysis Services and run/refresh your query in Excel and you will see the MDX query in the profiler.