Distinct counts in SSRS Report Builder 3.0 with cube

[JanetStackpole]

I am migrating several cubes from from SQL Server 2005 std to 2008 enterprise and am running into a problem. All of our cubes have a distinct client count measure. In the 2005 version, the row and column totals remained distinct. In 3.0, the totals default to the sum function. As a result it is summing the grouped distinct counts. The end user may change the totals from a sum to a distinct count function, but I am concerned that they will not remember to do so. Has anyone run into this and is there a configuration for the default total behavior? I have Googled, but have not seen anything promising. Thanks for your feedback.

 

[blom0344]

Janet,

Can't really help you with this, but check out :

http://richardlees.blogspot.nl/2008/10/

'An Alternative to a physical Distinct Count Measure'

Ties Blom