Allocation Logic

[Former Member]

*XDIM_MEMBERSET TIME=2008.JAN,2009.JAN

*XDIM_MEMBERSET ACCOUNT=RENT

*XDIM_MEMBERSET C_CATEGORY=TARGET,ACTUAL

*XDIM_MEMBERSET SBU=$SOURCE$,$TARGET$

*WHEN SBU

*IS "A_IN"

*REC (EXPRESSION=$ASARENT$,TIME=2009.JAN,C_CATEGORY=TARGET)

*ENDWHEN

*COMMIT

*RUNALLOCATION

*FACTOR=USING/TOTAL

*DIM ACCOUNT WHAT=RENT; WHERE=<<<; USING=<<<; TOTAL=<<<

*DIM SBU WHAT=$SOURCE$; WHERE=BAS($TARGET$); USING=<<<; TOTAL=<<<

*DIM TIME WHAT=>>>; WHERE=2009.JAN; USING=2008.JAN; TOTAL=<<<

*DIM C_CATEGORY WHAT=>>>; WHERE=TARGET; USING=ACTUAL; TOTAL=<<<

*ENDALLOCATION

*WHEN SBU

*IS "A_IN"

*REC (EXPRESSION=0,TIME=2009.JAN,C_CATEGORY=TARGET)

*ENDWHEN

Am using this logic to allocate "Rent" for 2009.Jan from A_IN (base member) to A_India (it has its base members) on the basis of 2008.Jan actual values for the respective base members.

However, when i run this logic using Run historical allocation package...the logic keeps on running till it has to be aborted or after loooong time it gives the error as

/CPMB/MODIFY : Completed in 0 seconds

[Selection]

-

---

ASARENT=10000

SOURCE=A_IN

TARGET=A_INDIA

(Member Selection)

C_CATEGORY: ACTUAL,TARGET

RPTCURRENCY: LC

TIME: 2008.JAN,2009.JAN

[Messages]

-

---

Application : Finance. Package status: RUNNING

Please advice if am entering some wrong parameters in my code. Am following the How to allocate....

Also, my SBU is user defined dimension and we are on SP07

Edited by: abhinav a on Oct 12, 2010 9:03 AM

[former_member200327]

Can you try splitting this script into 3 scripts (*WHEN, *RUNALLOCATION an another * WHEN) and run them separately to check which of them takes so much time?

Regards,

Gersh

[Former Member]

Hi Abhinav,

The problem is the scope. After the first WHEN statement, you have used a commit statement. This commit statement will end the scope defined by xdim statements. So, you need to use the xdim statements once again after the commit.

Hope this helps.