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.
Red Flag Submitted
Thank you for helping keep Tek-Tips Forums free from inappropriate posts. The Tek-Tips staff will check this out and take appropriate action.
Reply To This Thread
Posting in the Tek-Tips forums is a member-only feature.