Hello There,

I am trying to create a calculated memmber that will
aggregate last twelve monhts of data based on the current
month.
Let's say the current month in time dimension is
2003.OCT, so I would like to desing a calculated member
that will aggregate 2003.OCT + 2003.SEP+...2003.JAN +
2002.NOV + 2002.DEC

I was thinking on the lag function but never used it
before, so i am not sure if that would work.

any help will be highly appreciated thanks!!

martino

Assuming the calculated member is a measure, something like this:

SUM(LastPeriods(12), MyMeasure)

public @ the domain below
www.tomchester.net


"martino rivaplata" <anonymous (AT) discussions (DOT) microsoft.com> wrote

You can use the Lag function or also the YTD or ParallelPeriod functions
depending on what you want to do with these 12 months (get data from same
month last year, get the YTD value of these two month, rolling average....)

Thierry
This posting is provided "AS IS" with no warranties, and confers no rights.

"martino rivaplata" <anonymous (AT) discussions (DOT) microsoft.com> wrote

would not something like this work:?

SUM(LastPeriods(12),[TIME].[2003.OCT]),CATEGORY.ACTUAL)

thanks a lot for your thoughts!

You don't want to hardwire the end date -- by omitting it the current member
is the default.

Also, whatever dim the calc belongs to must be part of the tuple that is the
2nd arg to SUM. If it's a measure you must specify a measure.

public @ the domain below
www.tomchester.net


"martino rivaplata" <anonymous (AT) discussions (DOT) microsoft.com> wrote