SAP BPC 10.0 - Copy Package on Many (base level members) to One (base level member) basis

[former_member531615]

Hi Everyone,

After searching I havent been able to find a clear solution so hoping someone here can help.

Currently our copy package only allow you to copy on a one member to one member basis. Our customer requires changes to allow us to copy on a many to one basis on the audittrail dimension member.

Our current DM Package Logic is as per the below:

PROMPT(RADIOBUTTON,%TARGETMODE%,"Handling of records",0,{"Copy records with match key","Copy by replacing data in same data region of Entity, Category, Time and Audit ID"},{"0","2"})

PROMPT(RADIOBUTTON,%RUNLOGIC%,"Select whether to run default logic for stored values after copying",0,{"Yes","No"},{"1","0"})

PROMPT(RADIOBUTTON,%CHECKLCK%,"Select whether to check work status settings when importing data.",1,{"Yes, check for work status settings before importing","No, do not check work status settings"},{"1","0"})

PROMPT(COPYMOVE,%SELECTION%,%TOSELECTION%,"Select the members to COPY and where to",%DIMS%,0)

INFO(%TEMPNO1%,%INCREASENO%)

INFO(%ACTNO%,%INCREASENO%)

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,%CHECKLCK%)

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

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,%TARGETMODE%)

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,%CHECKLCK%)

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

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

Is it possible to change the current DM Package logic to cater for this or will we need to create a new Script Logic or BADi?

Thanks in advance.

[former_member186338]

Instead of copy package you have to use script logic! I have written about it number of times, why not to search?

*XDIM_MEMBERSET AUDITTRAIL=%AUDITTRAIL_SET% //%AUDITTRAIL_SET%=IN_HIST,IN_MAN,...
*WHEN AUDITTRAIL
*IS * //Already scoped
*REC(EXPRESSION=%VALUE%,AUDITTRAIL=Input)
*ENDWHEN

Target AUDITTRAIL can be also selected with $$ variable

Easy!

[chandrakanthk01]

Hi Vadim,

I do have the same kind of requirement where in copying the rates to other time periods from one time period. its basically, copying one to many. Could you help me with the logic please..

Thanks,

Chandrakanth.K

[former_member186338]

chandrakanthk01

Please ask a new question and I will help you!