cancel
Showing results for 
Search instead for 
Did you mean: 
Read only

Error using FACTOR = 1/12 with RUNALLOCATION on SAP BPC 11.0 (Standard)

syedsj
Explorer
0 Likes
798

Hi Experts,

I am trying to run allocation in BPC 11.0 for spreading the annual Plan version stored in one month (example: 2019.12" to all the months (in 2019) for the Budget version.

I am testing the same using UJKT but getting error - "UJ_STATIC_CHECK:Error found in system" when i try to use *FACTOR = 1/12

This issue was already reported in the below link but seems to be closed without giving the proper resolution or the BPC version.

https://answers.sap.com/questions/320443/how-to-use-factor--112-with-runallocation-on-sap-b.html#

This is the Allocation logic i am using:

*XDIM_MEMBERSET P_AUDIT = <ALL>

*XDIM_MEMBERSET RptCurrency = LC

*SELECT(%Y%, "[ID]",TIME,"[BUDG_BASE]=2019.12")

*XDIM_ADDMEMBERSET TIME = %Y%

*WHEN TIME.PERIOD

*IS "DEC"

*WHEN P_ACCOUNT *IS BAS(PL000000)

*RUNALLOCATION

*FACTOR = 1/12

*DIM P_ACCOUNT WHAT = BAS(PL000000); WHERE = BAS(PL000000); USING=<<<;

*DIM BUSUNIT WHAT = BAS(BUS00000); WHERE = BAS(BUS00000); USING =<<<;

*DIM CATEGORY WHAT = Plan; WHERE = Budget; USING = Plan;

*DIM TIME WHAT = 2019.12; WHERE = %Y%; USING = 2019.12;

*DIM ANALYSIS WHAT = AN_NONE; WHERE = AN_NONE; USING =<<<;

*ENDALLOCATION

*ENDWHEN

*ENDWHEN

This is the error when i execute in UJKT:

bpc-11-allocation-error1.jpg

bpc-11-allocation-error2.jpg

Following are additional details:

Version : BPC 11.0 (Standard)

Database System : HDB

Release : 2.00.033.00.153

Thanks in advance for your help.

Regards

Accepted Solutions (0)

Answers (6)

Answers (6)

former_member186338
Active Contributor
0 Likes

Your SP is very old! Upgrade to the latest and check

syedsj
Explorer
0 Likes

Sp version is 4

syedsj
Explorer
0 Likes

Thanks Vadim.

I think Factor = 1/12 is not supported in this version even though the parameters "ENABLE_ACCELERATOR" & "ACCELERATOR_ON" are set to X

I tried a workaround with Factor = .0833333333333333 and this is working. There are no differences due to roundoff too.

Shiraj

former_member186338
Active Contributor
0 Likes

What is your BPC11 SP?

former_member186338
Active Contributor
0 Likes

"is there a way to limit the allocation to work only when the 12th month is selected" - instead of user selecting month - ask user to select year using PROMPT(COMBOBOX...

syedsj
Explorer
0 Likes

i Vadim,

Thanks for having a look. Inserted image as required.

Also, is there a way to limit the allocation to work only when the 12th month is selected. When & Endwhen used only for this as a test case.

former_member186338
Active Contributor
0 Likes

Absolutely incorrect script!

RUNALLOCATION can't be used inside WHEN/ENDWHEN