Skip to Content
0
Former Member
Feb 20, 2009 at 12:49 PM

Script logic - how to use a selection variable within an allocation logic

32 Views

Hi,

I want to implement a simple top-down distribution to distribute values from a yearly budget (Y20xx.TOTAL) to a quarter budget (Q20xx.Q1, ... Q20xx.Q4) using the actuals of the previous year as reference.

If we hard code the members it works fine:

*RUNALLOCATION

*FACTOR=USING/TOTAL

*DIM ACCOUNT WHAT=ACC_NOT_ASSIGNED; WHERE=BAS(FIN); USING=<<<; TOTAL=<<<

*DIM TIME WHAT=Y2009.TOTAL; WHERE=BAS(Q2009.TOTAL); USING=BAS(Q2008.TOTAL); TOTAL=<<<

*DIM CATEGORY WHAT=SBO; WHERE=<<<; USING=ACTUAL; TOTAL=<<<

*ENDALLOCATION

Of course, we want to make this dynamic, using the values inputted in the selection screen of the package: time, entity and category.

So if we start with write the following logic, it does not work anymore:

*RUNALLOCATION

*FACTOR=USING/TOTAL

*DIM ACCOUNT WHAT=ACC_NOT_ASSIGNED; WHERE=BAS(FIN); USING=<<<; TOTAL=<<<

*DIM TIME WHAT=%TIME_DIM%; WHERE=BAS(Q2009.TOTAL); USING=BAS(Q2008.TOTAL); TOTAL=<<<

*DIM CATEGORY WHAT=%CATEGORY_DIM%; WHERE=<<<; USING=ACTUAL; TOTAL=<<<

*ENDALLOCATION

So, how to use the selection variables in this allocation logic? %TIME%, %CATEGORY% also did not work ...

regards

Dries

solved it ...

Edited by: Dries Paesmans on Feb 22, 2009 8:31 PM