Finally, after about 7 months of analysis, customer validation, and just general randomization – I have finally propped up the Analysis Services Distinct Count Optimization whitepaper which is available here: http://sqlcat.com/whitepapers/archive/2008/04/17/analysis-services-distinct-count-optimization.aspx

.

Distinct count (such as unique visitor counts on a Web site) calculations provide valuable information but come with a number of performance challenges. This white paper describes tests that were performed to determine how best to optimize these calculations and includes best practices based on the test results.