Moving Average with periods in OBIEE
913419May 8 2012 — edited May 14 2012Hello,
I need to create a measure in OBIEE which is the variation of the last 6 months by the 7th~12th months.
Measure = (( last 6 months ) / ( 7h ~ 12th months ) ) - 1
For example
2011-1 150
2011-2 200
2011-3 130
2011-4 120
2011-5 100
2011-6 160
2011-7 150
2011-8 140
2011-9 100
2011-10 150
2011-11 130
2011-12 140
2012-01 100
Measure for 2011-12 0,941860465
Measure for 2012-01 -0,11627907
Using MAVG I get the last 6 months but I dont know how to get the 6 months before. Any ideas ?
Using PeriodRolling does not work since the base indicator is already a derived aggregated measure.
Thanks,