Issue with Script logic while upgrading from SP14 to SP18

[Former Member]

We are in the process of upgrading from BPC SP14 to BPC SP18 and all of our script logics are working fine in SP14 production environment, but the same logic is failing in SP18 environment.

For example the below code:

*XDIM_MEMBERSET CURRENCY=LOCAL

*XDIM_MEMBERSET CMACCT=A_VOLUME

*XDIM_MEMBERSET CMDRIVER=D_NONE

*XDIM_MEMBERSET CMVENDOR=V_99

*XDIM_MEMBERSET FIN<>F_99

*XDIM_MEMBERSET VERSIONBASE=MASTER

*XDIM_FILTER TIME=[TIME].PROPERTIES("YEAR")=$FISYR$

*XDIM_FILTER CMRAW=[CMRAW].PROPERTIES("BUYER")=$BUYERCODE$

*RUNALLOCATION

*FACTOR=1

*DIM CMACCT WHAT=A_VOLUME; WHERE=<<<

*DIM CMDATASRC WHAT=DS_BW; WHERE=DS_BW,DS_MANOVERRIDE,DS_NEGOVERRIDE,DS_AUTOOVERRIDE

*DIM PRDCNG_COPLANT WHAT<>P_NONE; WHERE=P_NONE

*ENDALLOCATION

*COMMIT

This logic fails and this is error we get:

RUN_LOGIC:

Suppressed zero-value records:8,109

Failed

Application: VOLUME Package Status : ERROR

When I go and look in the formula log, I do not see any errors.

We have a go-live on July 15th and struggling to resolve this, has anyone encountered this? Please help.

Attached is the screen shot of the error/ package log

[former_member196060 · Accepted solution]

Note 2158885 should resolve your problem. Next time please specify your BPC version. Tks

[Former Member]

yes, the note was just released and that solved the problem, thanks for answering.

[former_member186338]

Ups, strange but this note is currently NOT released....

[Former Member]

Sometimes already released notes are later marked as "not released" for some reason and you see only the topic in your browser. 

[Former Member]

Where do I get this SAP Note?

Can't find it...

[former_member186338]

It's a not released note and I do not understand how the topic author got it...

[Former Member]

For $FISYR$ and $BUYERCODE$ user enters the values in the prompt screen, which in this case is 2016 and CN respectively.

[former_member186338]

Hi Deepti,

Please test the script in UJKT and provide the log!

The line:

*DIM CMACCT WHAT=A_VOLUME; WHERE=<<<

is useless, it's scoped! Remove it.

Also COMMIT is absolutely useless!

Read:

Vadim

P.S. Also strange:

*DIM CMDATASRC WHAT=DS_BW; WHERE=DS_BW,DS_MANOVERRIDE,...

[Former Member]

Hi Vadim,

Thanks for your prompt reply, can you please check the attached log file and let me know what I can do fix this? I will remove the statements that you mentioned previously.

log.txt.zip

[former_member186338]

You can see that there are no errors in the log:

Records succeeded to write back :32364

Please correct the script itself (remove strange things...)

Vadim

P.S. May be $FISYR$ and $BUYERCODE$ are not passed correctly? Test script in the DM package with fixed 2016 and CN

P.P.S. Please, show the DM package advanced script to see how you get variables $FISYR$ and $BUYERCODE$

[Former Member]

Hi Vadim,

Please find attached the DM advanced package details to see how the variables are passed and also the entire script logic file attached here. Previously I had only sent one section of code.

Full_Script.txt.zip

[former_member186338]

Ups, what BPC version you are talking about - I hope 7.5? Not 7.0?

I see a lot of strange things in the script and in the advanced script...

Vadim

[Former Member]

yes, we are on 7.5 SP14 trying to upgrade to SP18 and the BW backend is moving to 7.4 SP18 as well.

[former_member186338]

Looks like originally the system was 7.0

Anyway, correct DM advanced script to (using standard chain DEFAULT_FORMULAS_LOGIC!):

PROMPT(TEXT,%BUYERCODE%,"YOU MUST Enter a Single Buyer Code (ex: GA)")

PROMPT(TEXT,%FISYR%,"YOU MUST Enter a Fiscal Year (ex: 2011)")

INFO(%EQU%,=)

INFO(%TAB%,;)

TASK(/CPMB/DEFAULT_FORMULAS_LOGIC,SUSER,%USER%)

TASK(/CPMB/DEFAULT_FORMULAS_LOGIC,SAPPSET,%APPSET%)

TASK(/CPMB/DEFAULT_FORMULAS_LOGIC,SAPP,%APP%)

TASK(/CPMB/DEFAULT_FORMULAS_LOGIC,TAB,%TAB%)

TASK(/CPMB/DEFAULT_FORMULAS_LOGIC,EQU,%EQU%)

TASK(/CPMB/DEFAULT_FORMULAS_LOGIC,LOGICFILENAME,BUYER_ALLOC_REQ_QTY.LGF)

TASK(/CPMB/DEFAULT_FORMULAS_LOGIC,REPLACEPARAM,BUYERCODE%EQU%%BUYERCODE%%TAB%FISYR%EQU%%FISYR%)

Second: the script itself contains absolutely old (From BPC 7.0 How-To):

*START_BADI DAPP

...

Have to be properly replaces with standard:

*DESTINATION_APP=...

And other things in the script have to be analyzed!

Vadim