Data Manager Package - Copy

[Former Member]

Hello Experts,

Based on Document: http://scn.sap.com/docs/DOC-34892 I have a DMP as follows:

(SELECTINPUT,%SELECTION%,,,"%TIME_DIM%,%ENTITY_DIM%")

(%SUFFIX1%,DIMENSION:AUDIT_TRAIL|PLAN_INPUT|)

(%SUFFIX2%,DIMENSION:CURRENCY|LC|)

(%SUFFIX3%,DIMENSION:FLOW|F_NONE|)

(%TEMPNO1%,%INCREASENO%)

(%ACTNO%,%INCREASENO%)

(/CPMB/CM_CONVERT,OUTPUTNO,%TEMPNO1%)

(/CPMB/CM_CONVERT,ACT_FILE_NO,%ACTNO%)

(/CPMB/CM_CONVERT,SAPPSET,%APPSET%)

(/CPMB/CM_CONVERT,SAPP,%APP%)

(/CPMB/CM_CONVERT,SELECTION,%SELECTION%%SUFFIX1%%SUFFIX2%%SUFFIX3%)

(/CPMB/CM_CONVERT,TOSELECTION,%SELECTION%%SUFFIX1%%SUFFIX2%%SUFFIX3%)

(/CPMB/CM_CONVERT,CLEARDATA,%CLEARDATA%)

(/CPMB/CLEAR_SOURCE_CUBE,CHECKLCK,%CHECKLCK%)

(/CPMB/CLEAR_SOURCE_CUBE,SELECTION,%SELECTION%%SUFFIX2%%SUFFIX3%%SUFFIX4%%SUFFIX6%)

(/CPMB/APPEND_LOAD,INPUTNO,%TEMPNO1%)

(/CPMB/APPEND_LOAD,ACT_FILE_NO,%ACTNO%)

TASK(/CPMB/APPEND_LOAD,RUNLOGIC,%RUNLOGIC%)

TASK(/CPMB/APPEND_LOAD,CHECKLCK,%CHECKLCK%)

TASK(/CPMB/APPEND_LOAD,CLEARDATA,%CLEARDATA%)

(/CPMB/APPEND_LOAD,RUNLOGIC,1)

(/CPMB/APPEND_LOAD,CHECKLCK,1)

(/CPMB/APPEND_LOAD,CLEARDATA,0)

The requirement is that for the Version Dimension there should be an Option to specify from and to selection which is not hardcoded.

Kindly Advise.

Regards,

[former_member186338 · Accepted solution]

If you have to select TIME and ENTITY (same for source and target) then for version you can use only COMBOBOX with the list of members hard coded. 2 COMBOBOX PROMPTs will ask user to select source and target version and you will be able to combine the results with selection and suffixes.

Vadim

[Former Member · Accepted solution]

Hello Vadim,

I am not able to clearly understand what you said but i changed the code as follows:

(COPYMOVEINPUT,%SELECTION%,%TOSELECTION%,"Select the members to COPY and where to","%TIME_DIM%,%ENTITY_DIM%,%CATEGORY_DIM%",0)

Commented the following Code:

'PROMPT(SELECTINPUT,%SELECTION%,,,"%TIME_DIM%,%ENTITY_DIM%")

Now it gives select "from and to" for all the 3 dimensions, though I require only for Version.

Certain other Dimension are hardcorded in the SUFFIX1 etc and others are not mentioned. I understand that the ones which are "From and to" same need not be mentioned.

Is my understanding correct?

[former_member186338 · Accepted solution]

You can't combine COPYMOVEINPUT and SELECTINPUT to create a concatenated %SELECTION%. But you can use COMBOBOX prompts to select values for version and combine the results with SELECTINPUT.

PROMPT(COMBOBOX,%VER_FROM%,"Select VERSION from",0,,{ACTUAL,BUDGET})

PROMPT(COMBOBOX,%VER_TO%,"Select VERSION to",0,,{ACTUAL,BUDGET})

Vadim