cancel
Showing results for 
Search instead for 
Did you mean: 

Changing Move DM Package

Former Member
0 Kudos

HI, All!

We are using BPC 10.0 NW.

We need to move same values from one combination to another in the same model. It's an employee movement (ex: need to change the costcenter and function and give a promotion)

The customer will be at a Excel form with all his employees. We think in have a DM package where the customer select the source and the target members.

We think in change the Move DM Package something like below. It is a solution? Is ther another one where the customer less infromation to pass as a parameter?

++++++++++++++++++++++++++++++++++++

PROMPT(SELECTINPUT, %SELECTION1%, , "Selectione Category, Cost Center, Employee and Time:", "CATEGORIA,CENTROCUSTO,FUNCIONARIO,TEMPO")

PROMPT(SELECTINPUT, %SELECTION2%, , "Select another fixed member:", "FLUXO,VISAO,CLASSECUSTO")

'INFO(%SELECTION2%,"VALORORIGINAL,INSERCAOPROJ,SALARIOBASEINICIAL")   // another fixed members from FLUXO, VISAO and CLASSECUSTO dimensions

PROMPT(COPYMOVEINPUT,%SELECTION3%,%TOSELECTION3%,"Select source and target members:","TURNO,TIPOSALARIO,CARGO",0)

INFO(%TAB%,;)

INFO(%TEMPNO1%,%INCREASENO%)

INFO(%ACTNO%,%INCREASENO%)

INFO(%SELECTION%,%SELECTION3%%TAB%%SELECTION1%%TAB%%SELECTION2%)

INFO(%TOSELECTION%,%TOSELECTION3%%TAB%%SELECTION1%%TAB%%SELECTION2%)

INFO(%SELECTION_KEYDATE%,)

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

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

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

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

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

TASK(/CPMB/CM_CONVERT,TOSELECTION,%TOSELECTION%)

TASK(/CPMB/CM_CONVERT,KEYDATE,%SELECTION_KEYDATE%)

TASK(/CPMB/CLEAR_SOURCE_CUBE,CHECKLCK,1)

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

TASK(/CPMB/CLEAR_SOURCE_CUBE,KEYDATE,%SELECTION_KEYDATE%)

TASK(/CPMB/CLEAR_SOURCE_CUBE,DUMPLOADMODE,3)

TASK(/CPMB/APPEND_LOAD,PREPROCESSMODE,0)

TASK(/CPMB/APPEND_LOAD,TARGETMODE,0)

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

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

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

TASK(/CPMB/APPEND_LOAD,CHECKLCK,1)

TASK(/CPMB/APPEND_LOAD,KEYDATE,%SELECTION_KEYDATE%)

TASK(/CPMB/CLEAR_CUBE,CHECKLCK,1)

TASK(/CPMB/CLEAR_CUBE,ACT_FILE_NO,%ACTNO%)

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

TASK(/CPMB/CLEAR_CUBE,DUMPLOADMODE,3)

TASK(/CPMB/CLEAR_CUBE,KEYDATE,%SELECTION_KEYDATE%)

++++++++++++++++++++++++++++++++++++++++++++++++

Tks a lot!

Best regards,

Ana Teresa

Accepted Solutions (0)

Answers (1)

Answers (1)

former_member186338
Active Contributor
0 Kudos

Hi Ana,

No it will not work like this. Please, read my answers here:

to get an idea to combine members in advanced script for standard packages.

Vadim

P.S. And here: