Skip to Content

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

script logic/allocation

Hi Experts,

This is my requirement. We need to project the budget values of next year using current year actuals incremented by some percent.We get the year for which the budget values are to be calculated and percent of increase using data manager prompt and I tried the following allocation and logic.But was not able to finish it.

>USING ALLOCATION

>*RUNALLOCATION

>*FACTOR=%PERCENT%

>*DIM TIMEINWEEK WHAT=BAS(%BUDYEAR%(-1).TOTAL);WHERE=BAS(%BUDYEAR%.TOTAL)

>*DIM CATEGORY WHAT=ACTUAL;WHERE=BUDGET

>*ENDALLOCATION

The above logic returns an error and when I replace %percent% by 2, %budyear%(-1).total is multiplied by 2 and allocated to all base members of %budyear%.total

I tried this logic even

*when *

*is *

*Rec(factor=2,category=budget,timeinweek=timeinweek.nextyear)

*endwhen

*commit

where nextyear is a property in timeinweek, which stores the time period to store. For example 2007.jan will have 2008.jan in nextyear property.

Any help will be appreciated.

Kranthi

Edited by: kranthi kumar on Oct 7, 2008 8:46 PM

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