on 2021 Apr 29 5:05 PM
Hi everyone,
I am on SAP BPC10.1 Standard. I am trying to configure a “Copy” data packet to look like this;
1. Data is delimited, that is, these parameters will always be fixed.
2. Data that can be selected by the user.
I was looking at an article in the community that seemed appropriate to me and I used it, but it still does not work.
https://blogs.sap.com/2013/01/06/customize-the-standard-sap-bpc-packages/
This is the parameter that I have left in the package;
'PROMPT(RADIOBUTTON,%CLEARDATA%,”Select the method for copying the data from the source to destination database”,0,{“Merge data values (Copies specified records, leaving all remaining records in the destination intact)”,”Replace && clear data values(Copies specified records, and clears the data values for any records that mirror each entity/category/time/datasource combination defined in the source)”},{“0″,”1”})
'PROMPT(RADIOBUTTON,%RUNLOGIC%,”Select whether to run default logic for stored values after copying”,1,{“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(COPYMOVEINPUT,%SELECTION%,%TOSELECTION%,”Select the members to COPY and where to”,”%TIME_DIM%,%ENTITY_DIM%,%CATEGORY_DIM%”)
PROMPT(SELECTINPUT,%SELECTION%,,,”%TIME_DIM%,%ENTITY_DIM%”)
INFO(%SUFFIX1%,DIMENSION:AUDITORIA|IMP_SAP_BAL|)
INFO(%SUFFIX2%,DIMENSION:AUDITTRAIL|IMP_SAP_IC|)
INFO(%SUFFIX3%,DIMENSION:FLUJO|F99|)
INFO(%SUFFIX4%,DIMENSION:GRUPO|G_NONE|)
INFO(%SUFFIX5%,DIMENSION:VERSION|V_0|)
INFO(%SUFFIX6%,DIMENSION:VERSION|V_1|)
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%)
TASK(/CPMB/CM_CONVERT,SELECTION,%SELECTION%%SUFFIX1%%SUFFIX3%%SUFFIX4%%SUFFIX5%)
TASK(/CPMB/CM_CONVERT,TOSELECTION,%SELECTION%%SUFFIX2%%SUFFIX3%%SUFFIX4%%SUFFIX6%)
TASK(/CPMB/CM_CONVERT,CLEARDATA,%CLEARDATA%)
TASK(/CPMB/CLEAR_SOURCE_CUBE,CHECKLCK,%CHECKLCK%)
TASK(/CPMB/CLEAR_SOURCE_CUBE,SELECTION,%SELECTION%%SUFFIX2%%SUFFIX3%%SUFFIX4%%SUFFIX6%)
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,1)
TASK(/CPMB/APPEND_LOAD,CHECKLCK,1)
TASK(/CPMB/APPEND_LOAD,CLEARDATA,0)
What I can be doing wrong? Could you guide me on what is wrong?
Request clarification before answering.
Never copy paste code from web page without checking.
For example:
PROMPT(SELECTINPUT,%SELECTION%,,,”%TIME_DIM%,%ENTITY_DIM%”)
Incorrect quote character used:
Not: ” Have to be "
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
10 | |
9 | |
2 | |
2 | |
1 | |
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.