Invalidate Error As I pass variable through DM package

[Former Member]

Hi Experts,

I am getting the below error as I pass the parameter values using logic script through the DM package.

Here, i have not assigned the variables Y and Y1 to any dimension, but passing it as a TEXT prompt in the DM package. When i execute it, i receive this error.

Can anyone please provide any suggestions?

Please note that this works in UJKT when i pass the PARAM values for Y and Y1.

Below is my Logic Script where I pass Y and Y1 at runtime

*XDIM_MEMBERSET RPTCURRENCY = LC *XDIM_MEMBERSET INTERCO = I_3RD
*XDIM_MEMBERSET TIME = $Y$.04,$Y$.05,$Y$.06,$Y$.07,$Y$.08,$Y$.09,$Y$.10,$Y$.11,$Y$.12,$Y1$.01,$Y1$.02,$Y1$.03 *WHEN TIME *IS * *REC(EXPRESSION = %VALUE%,TIME = $Y1$.03) *ENDWHEN *XDIM_MEMBERSET TIME = $Y$.04,$Y$.05,$Y$.06,$Y$.07,$Y$.08,$Y$.09,$Y$.10,$Y$.11,$Y$.12,$Y1$.01,$Y1$.02 *WHEN TIME *IS * *REC(EXPRESSION = %VALUE%,TIME = $Y1$.02)
*ENDWHEN

[former_member186338 · Accepted solution]

Sorry, but I don't see REPLACEPARAM statement in your advanced DM script!

Also EQU and TAB settings

The following lines has to be added:

PROMPT(TEXT,%Y%,"FYEAR",,,)
PROMPT(TEXT,%Y1%,"FYEAR1",,,)
INFO(%EQU%,=)
INFO(%TAB%,;)
TASK(/CPMB/DEFAULT_FORMULAS_LOGIC,TAB,%TAB%)
TASK(/CPMB/DEFAULT_FORMULAS_LOGIC,EQU,%EQU%)
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,REPLACEPARAM,Y%EQU%%Y%%TAB%Y1%EQU%%Y1%)
TASK(/CPMB/DEFAULT_FORMULAS_LOGIC,LOGICFILENAME,TEST_YTD_JM.LGF)

And remove

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

you have no selection with PROMPT(SELECTINPUT...

[former_member186338 · Accepted solution]

P.S. If you want to select to Year and next Year you don't need to ask user to enter next Year.

Please read my blog:

https://blogs.sap.com/2018/11/04/how-to-calculate-next-or-previous-time-member-in-bpc-script-logic/

Also, it's better to use PROMPT(COMBOBOX,... to select Year!

Read my blog:

https://blogs.sap.com/2014/09/19/dm-promptcombobox-behavior-in-bpc-nw-10-and-75/

[Former Member]

Thank you Very much Vadim!