Skip to Content
0
Former Member
Apr 19, 2010 at 07:22 AM

How to use variables in scriptlogic

30 Views

Hi BPC gurus,

I'd like to make a condition in my scriptlogic for an allocation of a planned value on year base to the months values. If there is reference data in the past year, I would like to allocate according to the reference. If not, I would just like to make an even distribution. Unfortunately I didn't find a way to use variables in scriptlogic and assign values to them. Here's my coding:

*LOOKUP Vertrieb

*DIM MEASURES="PERIODIC"

*DIM CATEGORY="ACTUAL"

*DIM P_DATASRC="UPLOAD"

*DIM PREVYEAR:TIME="2009.TOTAL"

*DIM PREVJAN:TIME="2009.JAN"

*DIM PREVFEB:TIME="2009.FEB"

...

*ENDLOOKUP

*WHEN TIME

*IS "2010_INPUT"

*WHEN CATEGORY

*IS "PLAN"

*WHEN P_DATASRC

*IS "MANUAL"

//here I would like to add a condition if the value for the past year is not 0

*REC(FACTOR=LOOKUP(PREVJAN)/LOOKUP(PREVYEAR),TIME="2010.JAN")

*REC(FACTOR=LOOKUP(PREVFEB)/LOOKUP(PREVYEAR),TIME="2010.FEB")

...

//or here I would like to add a condition if the value for the past year = 0

*REC(FACTOR=1/12,TIME="2010.JAN")

*REC(FACTOR=1/12,TIME="2010.FEB")

*ENDWHEN

Thanks for your assistance.

Regards,

Ulrike