Pivot Tables and MDX

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: brian p (anonymous_at_discussions.microsoft.com)
Date: 03/15/04 

Date: Mon, 15 Mar 2004 06:26:15 -0800

Hi!

I want to write some MDX queries that pull the same data I'm retriving into an excel pivot table that is hitting my cube. Up front, I'm pretty sure this is not doable, but need to ask anyway. I want some way of hooking into the MSOLAP provider to see the MDX that's generated and sent to analysis services to retrieve the data into the pivot table. This would be an excellent shortcut to getting my MDX query results to match what I'm getting in the pivot table.

Any anyone know of a way to see the MDX that's being generated from the pivot table?

-thanks