on 2021 May 01 1:25 AM
Hello
My situation is the next; in sap bpc 10.1 standard
I was testing my copy package with a setup where I need to send the current month's data to the next month. I have tried it, but the value is copied to the following month and the current month is deleted. Can someone guide me?
PROMPT(MESSAGE,Copy Percentajes % month to next month Segment UNE) PROMPT(MESSAGE,================================================) 'CHOSE COPY FROM and COPY TO - "only COPY FROM, and then COPY TO will be the same" function is commented out: PROMPT(COPYMOVE,%SELECTION%,%TOSELECTION%,"Seleccionar los datos para copiar","%TIME_DIM%,%VERSION_DIM%") 'PROMPT(SELECT,%SELECTION%,,,"%TIME_DIM%,VERSION") 'Copy FROM and To - ALL DIMENSIONS NOT MENTIONED WILL BE COPIED FROM "ALL" TO "SAME" INFO(%SUFFIX1%,DIMENSION:AUDITORIA|SAP_BAL_DIST2|) INFO(%SUFFIX2%,DIMENSION:FLUJO|F99|) INFO(%SUFFIX3%,DIMENSION:GRUPO|G_NONE|) INFO(%SUFFIX4%,DIMENSION:INTERCOMPANY|I_NONE|) INFO(%SUFFIX5%,DIMENSION:MONEDA|LC|) INFO(%SUFFIX6%,DIMENSION:SEGMENTO|SEGMENTO_NA|) INFO(%TEMPNO1%,%INCREASENO%) INFO(%ACTNO%,%INCREASENO%) 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%) 'Remember to select the correct FROM's here: TASK(/CPMB/CM_CONVERT,SELECTION,%SELECTION%%SUFFIX1%%SUFFIX1%%SUFFIX3%%SUFFIX4%%SUFFIX5%%SUFFIX6%) 'Remember to select the correct TO's here: TASK(/CPMB/CM_CONVERT,TOSELECTION,%TOSELECTION%%SUFFIX1%%SUFFIX1%%SUFFIX3%%SUFFIX4%%SUFFIX5%%SUFFIX6%) 'TASK(/CPMB/CLEAR_SOURCE_CUBE,SELECTION,%SELECTION%%SUFFIX1%%SUFFIX1%%SUFFIX3%%SUFFIX4%%SUFFIX5%%SUFFIX6%) 'TASK(/CPMB/CLEAR_SOURCE_CUBE,CHECKLCK,%CHECKLCK%) 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,CLEARDATA,%CLEARDATA%) TASK(/CPMB/APPEND_LOAD,RUNLOGIC,0) TASK(/CPMB/APPEND_LOAD,CHECKLCK,0) 'TASK(/CPMB/APPEND_LOAD,CLEARDATA,0)
_____________________________________________________________________
When I run the package from 2017.08 to 2017.09 it passes the value to the month correctly, but the month 2017.08 clears the record and I need it to keep the record in the current month as well.
What should I do so that the registry does not delete me?
Request clarification before answering.
By the way, why not to use script logic to copy data instead of copy package?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Dear sir Vadim, I appreciate your comment, I agree that the consultant must guide the client in an appropriate way, however, this is by rules of the client's organization, they do not accept using vba macros and the least amount of Script logics, this recommendation was given and they don't accept more script logics than there are. I hope I have been clear with his comment.
diegofeliperozo
Script logic is the main calculation engine in BPC standard and have no relation to vba. Looks like you have to explain the customer that there is some misunderstanding. And for the user there is no difference to run customized DM Copy package or DM package with script logic. Script logic will be easier to maintain then custom copy package.
User | Count |
---|---|
9 | |
3 | |
2 | |
2 | |
2 | |
1 | |
1 | |
1 | |
1 | |
1 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.