Search code examples
excel-2007ssasmdxpivot-table

How can I display the MDX generated by Excel 2007 when using a pivot table?

Pretty much what the title says. Is it possible to show the MDX that is sent to OLAP source when using a pivot table in Excel 2007?

Solution

  • If you have profiler you could set up an Analysis Services trace and catch it on the way, or do you need to see it without executing it?