A problem with the DistinctCount aggregate function for measures in Analysis Services 2000 is that it will not aggregate at leaf level if filtering only on a subset of the members in a level (or attribute). A customer or ours is all too familiar with
Read More...