PDA

View Full Version : semi-additive aggregators



persapiens
10-30-2003, 12:42 PM
Hi All,
I'd like to create a measure using a standard
deviation as the aggregator function?
I also read an old thread that says that mondrian
hadn't this kind of aggregator... Does it have
this functionn now? If not, is there any workarounds?
TIA,
Rodrigo Galvao (rodrigo(a)persapiens com)

avix
10-31-2003, 06:37 AM
The account balance is an example for a measure that is semi-additive in the time dimension and additive in the other dimensions. We define a measure like
with member [measures].[avg balance] as '
avg(descendants([time].currentmember, [time].[daylevel]), [balance])'
to average over time ([time].[daylevel] is the lowest level of the time dimension).
Andreas