MDX Performance improvement on MAX aggregation

Today I offered what I think was quite a clever solution to improve a fellow community members MDX query using a MAX aggregation.

It took his query time down from 8 minutes to a fraction of a second 😉

 

Read about it at the link below:

http://social.msdn.microsoft.com/Forums/sqlserver/en-US/aef61262-6a42-4348-9426-9a7a9b5bf41f/performance-issue-on-max-function-mdx

Advertisements

About ditchie2013

A Microsoft SQL Server Analysis Services developer.
This entry was posted in Analysis Services, MDX Performance. Bookmark the permalink.

Leave a Reply

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

WordPress.com Logo

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

Twitter picture

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

Facebook photo

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

Google+ photo

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

Connecting to %s