Updateroule with formula or routine?
I have forecastdata and want to compare forecast from last week with this weeks forecast. Therefore I want to create a seperate keyfigure B (forecast from last week)
In my ODS I have 0calweek, zcalweek in the key and Keyfigure A, holding each week with acutal forecast data.
0calweek = 35.2008, zcalweek = 36.2008, A=2
0calweek= 36.2008, zcalweek = 37.2008, A=5
Now I want to load data to cube according to the following logic where I have 0calweek and keyfigure B
Find zcalweek, where zcalweek = 0calweek and return A.
In can not use variable- offset in report.
Is it possible to solve this with a formula or do I need a routine? Can you give me example or some links?
Thanks for your help