*RUNALLOCATION can't generate the correct result

[Former Member]

*RUNALLOCATION can't generate the correct result. The example and script is:

*XDIM_MEMBERSET ACCOUNT = 6601002

*RUNALLOCATION

*FACTOR = USING/TOTAL

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

*DIM CATEGORY WHAT = BUDGET; WHERE = <<<; USING = ACTUAL_IN; TOTAL= <<<;

*DIM TIME WHAT = 2021.INP; WHERE = BAS(2021.TOTAL); USING = BAS(2020.TOTAL); TOTAL= <<<; *ENDALLOCATION

But the result of 2021.01 should is 2000*500/(500+200+300)=1000, how could to correct the script to generate the right data ？

Thanks!

[former_member30]

Hi and welcome to the SAP Community!

Thank you for visiting SAP Community to get answers to your questions. Since you're asking a question here for the first time, I recommend that you familiarize yourself with https://community.sap.com/resources/questions-and-answers (if you haven't already), as it provides tips for preparing questions that draw responses from our members. For example, you can outline what steps you took to find answers (and why they weren't helpful) and share screenshots of what you've seen/done. The more details you provide, the more likely it is that members will be able to assist you.

Should you wish, you can revise your question by selecting Actions, then Edit (although once someone answers your question, you'll lose the ability to edit the question -- but if that happens, you can leave more details in a comment).

Finally, if you're hoping to connect with readers, please consider adding a picture to your profile. Here's how you do it: https://www.youtube.com/watch?v=F5JdUbyjfMA&list=PLpQebylHrdh5s3gwy-h6RtymfDpoz3vDS. By personalizing your profile with a photo of you, you encourage readers to respond.

Cheers,

Julia SAP Community Moderator

[former_member186338]

Please post the screenshot of your TIME dimension members

[Former Member]

Please see the screenshot of the time dimension:

[Former Member]

Hi，Vadim

Screenshot already posted . Thanks!

[former_member186338]

May be the issue is related to the order of TIME members as a result of BAS(YYYY.TOTAL)

I have tested allocation with the list of TIME members defined manually:

*XDIM_MEMBERSET ACCOUNT=PL110
*XDIM_MEMBERSET ENTITY=DE
*XDIM_MEMBERSET AUDITTRAIL=Input
*XDIM_MEMBERSET PRODUCT=ProductA
*XDIM_MEMBERSET INTERCO=ThirdParty
*XDIM_MEMBERSET RPTCURRENCY=LC

*RUNALLOCATION
*FACTOR=USING/TOTAL
*DIM CATEGORY WHAT=Budget;WHERE=<<<;USING=Actual;TOTAL=<<<
*DIM TIME
WHAT=2017.INP;WHERE=2017.01,2017.02,2017.03;USING=2016.01,2016.02,2016.03;TOTAL=<<<
*ENDALLOCATION

Test is based on ENVIRONMENTSHELL Planning model

Result

Everything is correct!

[Former Member]

Thanks for your reply!

Pls see the TIME dimension screenshot:

Thanks.

[former_member186338]

837488533

Sorry, but your 2021.INP member is incorrectly configured (missing mandatory property values etc) This may result in unpredictable system behavior!

Correct setup will be:

2021.INP 001 MONTH 1 JAN 10210100 1021 2021.INQ

2021.INQ 003 QUARTER 3 Q1 <empty> 1021 2021.INY

2021.INY 012 YEAR 12 TOTAL <empty> 1021

Use artificial year 1021 and TIMEID 10210100

Also test script with list of time members like in my sample.

[Former Member]

HI,Vadim Kalinin

The 2021.INQ and 2021.INY was created，but the result didn't change when we run the allocation again！

Maybe it‘s not the problem of 2021.INP member which cause this .

Thanks!

[former_member186338]

837488533

Post again your script! Have you tested list of periods?