Need help on DM Advanced script

[Former Member]

Hi Every one,

i need small help on DM Advanced script,

when i am run the package its showing success but no records generated

my script logic is

*XDIM_MEMBERSET TIME = %TIME_SET%

*XDIM_MEMBERSET AUDIT = INPUT

*XDIM_MEMBERSET CAT = R_VALUE

*WHEN F_TYPE

*IS = MP

*REC(EXPRESSION = %VALUE%,F_TYPE = MP)

*ENDWHEN

DM Advanced script is:

PROMPT(COPYMOVE,%SELECTION%,%TOSELECTION%,"PLEASE SELECT PREVIOUS WEEK IN SOURCE AND CURRENT WEEK IN DESTINATION","%TIME_DIM%") 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,%TOSELECTION%) TASK(/CPMB/DEFAULT_FORMULAS_LOGIC,EQU,%EQU%) TASK(/CPMB/DEFAULT_FORMULAS_LOGIC,LOGICFILENAME,MP.LGF)

package status is:

#dim_memberset=3

TIME:05.2017,1 in total.

AUDIT:INPUT,1 in total.

CAT:R_VALUE,1 in total.

REC :%VALUE%

CALCULATION BEGIN:

QUERY PROCESSING DATA

QUERY TIME : 0.00 ms. 0 RECORDS QUERIED OUT.

QUERY REFERENCE DATA

CALCULATION TIME IN TOTAL :0.00 ms.

NO RECORDS GENERATED.

CALCULATION END.

ENDWHEN ACCUMULATION: 0 RECORDS ARE GENERATED.

SCRIPT RUNNING TIME IN TOTAL:0.00 s.

LOG END TIME:2017-05-05 21:34:47

File path: \ROOT\WEBFOLDERS\Planning\FORECAST\PRIVATEPUBLICATIONS\xxxx\tempfiles\20170505213447\MP.LOG

Kindly suggest me to fix this,

regards,

kumar

[former_member186338]

First - do you look on your post results? Strings unreadable without correct line ends...

Second - the script:

*WHEN F_TYPE

*IS = MP

*REC(EXPRESSION = %VALUE%,F_TYPE = MP)

*ENDWHEN

will simply do nothing! It will write the same value over the same destination.

And at the end - why I don't see any logic explanation?

What do you want to achieve with this script????

Please read:

https://blogs.sap.com/2014/01/31/how-to-ask-questions-about-script-logic-issues/