Hi all,

I have a question regarding a calculated member. I have created a calculated
member to calculate growth from a parallel period on a measure like this:

[MyMeasure] - ([Time].[Calendar].CurrentMember.PrevMember, [MyMeasure])

Is there any way I can make another calculated member from this, that will
"act" like a regular measure with aggregation type SUM?

Regards,
John

If I understand you correctly - you want to define such calculation on the
lowest level in Time dimension, and let it aggregate as SUM along Time
dimension. The best way to do it is to define cell calculation on loweset
level in Time. You will need Enterprise Edition for that.

--
==================================================
Mosha Pasumansky - http://www.mosha.com/msolap
Analysis Services blog at http://www.sqljunkies.com/WebLog/mosha
Development Lead in the Analysis Server team
All you need is love (John Lennon)
Disclaimer : This posting is provided "AS IS" with no warranties, and
confers no rights.
==================================================

"John Smith" <sunedh (AT) hotmail (DOT) com> wrote

Or custom level formula (for which you can get away with standard edition)?

--
_______________
Disclaimer : This posting is provided "AS IS" with no warranties, and
confers no rights.


"Mosha Pasumansky [MS]" <moshap (AT) online (DOT) microsoft.com> wrote