Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

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.

For example:

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

Birgit

Not what you were looking for? View more on this topic or Ask a question