Skip to Content
0

Passing variable from Data manager package

Jan 05, 2017 at 10:48 PM

35

avatar image

Hi,

I am trying to pass a variable MTHS from the data manager package. But I get the error: RUN_LOGIC:Runtime error ReferenceError: $MTHS$ is not defined

Can you please help me out with this? I am on BPC10.1 without HANA. I am trying to save the months entered by the user in the DMP.

2nd question: is there a way to compare against this variable. for example if the $MTHS$ value is > 3 then do something etc.

Sincerely,

Nicky

PROMPT(SELECTINPUT,,,Select Period:,"%TIME_DIM%") PROMPT(COMBOBOX,%MTHS%,"Select No. of Prior Months",0,,{1,2,3,4,5,6}) INFO(%EQU%,=) INFO(%TAB%,;) TASK(/CPMB/DEFAULT_FORMULAS_LOGIC,EQU,%EQU%) TASK(/CPMB/DEFAULT_FORMULAS_LOGIC,TAB,%TAB%) TASK(/CPMB/DEFAULT_FORMULAS_LOGIC,REPLACEPARAM,VARIABLE%EQU%%MTHS%) 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,SELECTION,%SELECTION%) TASK(/CPMB/DEFAULT_FORMULAS_LOGIC,LOGICFILENAME,TEST.LGF)

-----------------------------------------------------------------------------------------------------------------------

*XDIM_MEMBERSET TIME = %TIME_SET% *WHEN TIME *IS 2017.04 *FOR %PRD% = $MTHS$ *REC(EXPRESSION=%PRD%,TIME=2019.01,VERSION=WV_MNTH_FCST,ACCOUNT=N_MNTHS,SCENARIO=ML,AUDITTRAIL=INPUT,CHANNEL=NO_CHANNEL,RPTCURRENCY=CUSD) *NEXT *ENDWHEN

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Vadim Kalinin Jan 05, 2017 at 11:13 PM
0

REPLACEPARAM is incorrect.

Has to be:

REPLACEPARAM,MTHS%EQU%%MTHS%

but the logic of your script is not clear. Please explain with some data sample.

Share
10 |10000 characters needed characters left characters exceeded