MDX query and browsing cubes in management studio

Question

I'm using management studio browsing a cube. Since im interested of how the MDX query looks like, ss it possible to change view from design to text?

Answer 1

Hi Adevi,

You may want to check out SQL Profiler against an Analysis Services server to see what is actually running when you query the cube.  Or turn on query logging in the server.

You cannot toggle between the two views in SSMS.  You either start a new query (MDX/DMX/XMLA) or browse the cube.

Some other possibilities to see MDX queries.

Reporting Services would allow you to toggle between views. 
Excel macros would allow you to see Pivot Table MDX. 
Proclarity has a show MDX option.
MDX Studio - http://www.mdxstudio.com/

Cheers,
Andrew

---

Andrew Sears, T4G Limited, http://www.performancepointing.com

Answer 2

This free Excel 2007 add-in lets you see the MDX that Excel is generating
http://olappivottableextend.codeplex.com/

---

http://geekswithblogs.net/darrengosbell - please mark correct answers