on ‎2020 Mar 06 10:33 PM
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:
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
Request clarification before answering.
Your SP is very old! Upgrade to the latest and check
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
"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...
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Absolutely incorrect script!
RUNALLOCATION can't be used inside WHEN/ENDWHEN
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
| User | Count |
|---|---|
| 40 | |
| 9 | |
| 4 | |
| 4 | |
| 3 | |
| 2 | |
| 2 | |
| 2 | |
| 2 | |
| 2 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.