issue while passing variable from DM package using Script in BPC

[former_member687971]

I am performing certain calculations based on which I need to use the data from the source Category and post the data to the Target category .And here the source and target category will be entered by user . But I am trying the below code as shown below , it throws me error saying invalidate selection .

Script Logic

*XDIM_MEMBERSET FP_ACCOUNT=BAS(AC_LE_OPERATIONAL_PL)

*XDIM_MEMBERSET PRCTR = BAS(PC_TOTAL_PRCTRS)

*XDIM_MEMBERSET FUNC_AREA= NO_FUNC_AREA

*XDIM_MEMBERSET MTYPE = DC,LC,GC

*XDIM_MEMBERSET FP_DATASRC = BAS(ALL_DS),RECLASS

*XDIM_MEMBERSET TPARTNER = BAS(TOTAL_TP)

*XDIM_MEMBERSET INTORD = BAS(IO_TOTAL_INTERNAL)

*XDIM_MEMBERSET FP_CATEGORY=$SRC_CAT$,$REC_CAT$

*XDIM_MEMBERSET TIME=BAS(%TIME_SET%)

*WHEN FP_CATEGORY

*IS $SRC_CAT$

*WHEN FP_ACCOUNT.ACCTYPE

*IS INC

*REC(FACTOR=1,FUNC_AREA=FA02_RECLASS,FP_DATASRC=RECLASS,FP_CATEGORY= $REC_CAT$)

*ENDWHEN

*ENDWHEN

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

DYNAMIC SCRIPT IN THE ADVANCED OPTION OF DM PACAKGE

PROMPT(TEXT,%SRC_CAT%,"Input Source category")

PROMPT(TEXT,%REC_CAT%,"Input target category")

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,SELECTION,%SELECTION%) 'TASK(/CPMB/DEFAULT_FORMULAS_LOGIC,MEMBERSELECTION,SRC_CAT%EQU%%SRC_CAT%%TAB%REC_CAT%EQU%%REC_CAT%) TASK(/CPMB/DEFAULT_FORMULAS_LOGIC,REPLACEPARAM,SRC_CAT%EQU%%SRC_CAT%) TASK(/CPMB/DEFAULT_FORMULAS_LOGIC,REPLACEPARAM,REC_CAT%EQU%%REC_CAT%) TASK(/CPMB/DEFAULT_FORMULAS_LOGIC,LOGICFILENAME,RECLASS_TEST.LGF)

[former_member186338]

The correct dynamic script will be:

PROMPT(TEXT,%SRC_CAT%,"Input Source category")
PROMPT(TEXT,%REC_CAT%,"Input target category")
INFO(%EQU%,=)
INFO(%TAB%,;)
TASK(/CPMB/DEFAULT_FORMULAS_LOGIC,EQU,%EQU%)
TASK(/CPMB/DEFAULT_FORMULAS_LOGIC,TAB,%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,REPLACEPARAM,SRC_CAT%EQU%%SRC_CAT%%TAB%REC_CAT%EQU%%REC_CAT%)
TASK(/CPMB/DEFAULT_FORMULAS_LOGIC,LOGICFILENAME,RECLASS_TEST.LGF)

Line:

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

to be removed - no selection!

Some extra lines to be added.

By the way it's better to use combobox like in my blog:

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