Hello,

I want to create a Calculated Measure that retrieves values for a
fixed period previous year, this should be independent on which period
I have selected in the time dimension. E.g. Calculated Measure N112
should always retrieve values for December previous year. If period
0302 is selected, values for 0212 should be retrieved, 0303 should
still retrieve 0212, etc. Selected period 0401 should retrieve values
for period 0312.

I have tried parallelperiod, prevmember, lead, lag etc, but nothing
seems to work. Please advice!

This Foodmart Query might help:

with member measures.[FixedPeriod] as '(closingperiod(Month,ancestor(time.currentmember, year).prevmember),[unit sales])'
select {[unit sales],[fixedperiod]} on columns,
month.members on rows
from sales

HTH,
--
Brian
www.geocities.com/brianaltmann/olap.html


"Rickard" wrote: