Chris Webb's BI Blog

Analysis Services, MDX, PowerPivot, DAX and anything BI-related

Distinct Count White Paper

with one comment

Yet another excellent paper on optimising distinct count measures from the SQLCat team:
http://sqlcat.com/whitepapers/archive/2008/04/17/analysis-services-distinct-count-optimization.aspx

Actually I’m beginning to wonder whether I should be linking to the SQLCat team site – in the same way I never link to Mosha because I assume that everyone who reads my blog reads his too, then I would hope everyone subscribes to the SQLCat team blog as well.

One topic missing is a comparison of the performance of distinct count measures with the technique of using many-to-many dimensions to get the same result that Marco Russo describes in his famous m2m white paper:
http://www.sqlbi.eu/Projects/Manytomanydimensionalmodeling/tabid/80/language/en-US/Default.aspx

Marco presented on this at PASS Europe and mentioned (which tallies with my experience) that this approach can perform as well as, and sometimes better than, a distinct count measure.

Written by Chris Webb

April 19, 2008 at 7:54 am

Posted in Uncategorized

One Response

Subscribe to comments with RSS.

  1. Thanks for the comments!  We did have some customer evidence that the many-to-many approach got slower in comparison to this version of Distinct Count Optimization as the we started hitting enterprise sizes.  Saying this, I wouldn\’t say that this is conclusive – in the end both methodologies definitely stress the need for performance tuning for distinct count calculations, eh?!

    Denny

    April 19, 2008 at 9:56 pm


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

Follow

Get every new post delivered to your Inbox.

Join 3,144 other followers

%d bloggers like this: