Skip to Content
author's profile photo Former Member
Former Member

Allocation Logic

*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

Add a comment
10|10000 characters needed characters exceeded

Related questions

2 Answers

  • author's profile photo Former Member
    Former Member
    Posted on Oct 12, 2010 at 11:01 AM

    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.

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Oct 12, 2010 at 03:27 PM

    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

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.