Extracting MDX code from browsed cube in BIDS

Question

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

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

amit_gupta01 SSChasing Mays Points: 605 More actions · Answer 1

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

Mark F-428640 Hall of Fame Points: 3659 More actions · Answer 2

Hi Amit,

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

Thanks,

amit_gupta01 SSChasing Mays Points: 605 More actions · Answer 3

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

Mark F-428640 Hall of Fame Points: 3659 More actions · Answer 4

Hall of Fame

Points: 3659

October 31, 2010 at 11:32 pm

Thanks I have so much too learn.

Thanks again.