Skip to Content
0
Jun 28, 2020 at 06:54 PM

issue while passing variable from DM package using Script in BPC

38 Views

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)