Post reply

Extracting MDX code from browsed cube in BIDS

  • October 30, 2010 at 12:16 am

    #141215

    Is there a way to extract MDX code which makes up the values from a cube which one is browsing (displaying measured and dimensional values) in the BIDS environment?

    Also how (if it can be done) does one save MDX code (i.e. like SP type fashion in T-SQL.) to reuse for extracting cube data?

    Yes I am new to MDX and SSAS. Trying to fast track my learning.

    Thanks in advance for any help.

  • October 30, 2010 at 12:12 pm

    #1244560

    Use SQL Server profiler and connect to analysis services trace. You will get MDX code.

    Thanks,
    Amit G
    http://www.msbiconcepts.com

  • October 30, 2010 at 2:33 pm

    #1244568

    Hi Amit,

    How exactly do I extract the MDX code from the SQL Profiler.

    Thanks,

  • October 31, 2010 at 11:18 pm

    #1244703

    In Profiler, Query Begin and Query End Event Class will show you MDX in Text Data.

    Thanks,
    Amit G
    http://www.msbiconcepts.com

  • October 31, 2010 at 11:32 pm

    #1244707

    Thanks I have so much too learn.

    Thanks again.

Viewing 5 posts - 1 through 4 (of 4 total)

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