How do I get the browser's MDX query in AS 2005??

#1

Ok, so the cube browser tab in Analysis Server 2005 is nice, but how do
view the MDX query that it ran to get the data that is displayed?
I'm new to MDX, and just to be able to see the query would help me
immensely. I don't understand why I can't find it...and if it isn't
there, why in the world would they not have allowed you to see it?

#2

One way is to use the SQL Server Profiler app, which lets you trace MDX
queries going to SSAS.

"Michael Stuart" <noemail (AT) noemail (DOT) com> wrote

Quote:

Ok, so the cube browser tab in Analysis Server 2005 is nice, but how do
view the MDX query that it ran to get the data that is displayed? I'm new
to MDX, and just to be able to see the query would help me immensely. I
don't understand why I can't find it...and if it isn't there, why in the
world would they not have allowed you to see it?

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

How do I get the browser's MDX query in AS 2005??

microsoft.public.sqlserver.olap microsoft.public.sqlserver.olap

How do I get the browser's MDX query in AS 2005?? - 03-03-2006 , 08:12 AM

Re: How do I get the browser's MDX query in AS 2005?? - 03-03-2006 , 11:18 AM