Hello, everybody.
We have a cube with lot's of measures that need to be aggregated normally
along all dimensions except time. Along the time dimension every new member
is displaying a new state of the measure at that moment so we'd like to
calculate the difference between every current member and the previous
member. This can be done quite easily by creating a calculated member for
every measure as in:

c1: ([measures].m1 - [measures].m1,[time].currentmember.prevmember)

c2: ([measures].m2 - [measures].m2,[time].currentmember.prevmember)

....

Can this be done some other way or do we really have to create 50+ calculate
members?

Thanks in advance,
Koni.

You might want to consider a separate dimension to hold calculations.

public @ the domain below
www.tomchester.net

"Koni Kogan" <k_kogan (AT) hotmail (DOT) com> wrote