Marcorusso has posted an awesome piece of code that lets you see the MDX query that Excel 2007 uses to query Analysis Services 2005.
How did we live without it. Sort of falls into the “why didnt I think of that” class. A must have. Thank you very much