December 28, 2007 at 8:02 am
I am very new to analysis services and am working on adding some new dimensions and measures to a cube. When I add the new measures, a new measures group gets added instead of adding it to the current measure group. So what I end up with is:
Measures:
claims
total paid
charges
discount
....
claims 1
new measure
claims 2
new measure
The new measures are from the same fact table. They are actually ID's that are using the distinct count aggregate function to calculate the number of claims, reversals, ...
I added a column the day before and tested the distinct count aggregate function on that column and it was created in the same measure group so I am not sure why new groups are being created.
Any help would be appreciated
John Walbert
December 28, 2007 at 12:26 pm
I figured out what the issue is. You can only have 1 measure with a distinct count aggregatate function per measure group. When I added in the new measures, new measurement groups were created automatically. I got this from the white paper:
Microsoft SQL Server 2005 Analysis Services Performance Guide
SQL Server Technical Article
There is a problem in the interfact in that it let me add in the 2 measures as the standard sum aggregation. When I went back in and changed the to distinct count, it let me do it and did not throw an error until I tried to deploy the updates.
John Walbert
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply