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?
+1
A:
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?
Meff
2010-05-19 22:15:44
I would like to see it in Excel, but I will try with Profiler. Thank you.
Espo
2010-05-20 05:22:04
A:
You can download the OLAP Pivot Table Extensions from the codeplex site( http://olappivottableextend.codeplex.com/)
Install it.
You can then right click and see the OLAP query.
Regards, Ambarish
Ambarish Ganguly
2010-06-07 08:55:03