Home Forums SQL Server 2008 SQL Server 2008 - General How to dynamically change Aggregate function in Cube ? RE: How to dynamically change Aggregate function in Cube ?
haskie
Newbie
Points: 9
More actions
March 26, 2010 at 2:00 pm
#1140739
In the cube script (or in the query) you ll need to create a calculated measure with a CASE statement to to apply the logic you need to.
If the logic is stored in a dimension you can get the definitions from there.
Hope this helps
Haskie