MDX Studio Quick Tips

Recently I had to use MDX Studio for some MDX query tuning. 2 quick tips:

Also very quickly, if you are finding that the Perfmon section in MDX Studio shows 0 for most values such as ‘Cells calculated’ then try running the MDXStudio.exe with the ‘Run as Administrator’ option.

Also take a look at Ashwani Roy’s SQL Bits session ‘Supercharge MDX performance using MDX Studio’ which is available from


Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.