Post reply

Any way to look at MDX queries created by browsing?

  • November 10, 2008 at 4:45 pm

    #195690

    Is there any way to look at the MDX queries created by browsing a cube in either BI Studio or Management Studio? I just learning MDX, and this would really help.

  • November 11, 2008 at 6:35 am

    #896904

    You can run a trace against the SSAS database with Profiler to get at the MDX, but it is going to be broken up into session sets as you drag and drop dimension attributes and hierarchies onto the rows or columns. Another option would be to connect with Excel and use the OLAP PivotTable Extensions to get at the generated MDX to become more familiar with the syntax.

    OLAP PivotTable Extensions

    ----------------------------------------------------------------------------------------
    Dan English - http://denglishbi.wordpress.com

  • November 11, 2008 at 10:02 am

    #897042

    Thanks much! OLAP PivotTable Extensions worked great.

    Chuck Bevitt

Viewing 3 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply