on 10-18-2017 3:22 PM
Situation at one of my clients:
The have a new account in the account structure. This is loaded during the nightly loads into BW. However, this load failed, the account is now not in BPC. During the delta load, the records for this account have been rejected. This all works fine. However, in the delta load I have flagged KEEP_REJECT_DATA to be 1. We add the missing account to BPC, but the next time the delta load is executed, the missing records are not loaded into BPC.
Is there something else I need to configure in order for this to work?
I was able to fix the issue by applying the following notes:
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Sure.
We are loading data from a cube with financial data, which has 0ACCOUNT in it as an object. We filter on:
Fiscal year between 2017 and 9999
Currency type = 10
For the options, when executing the package, we have selected:
Run default logic = 0
Check work status = No
Keep rejected data = Yes, keep the rejected data for the next delta loading
Below is the script that is called in the data manager package:
PROMPT(INFOPROVINITNAME,%INFOPROV_INIT_NAME%,"Please select delta initialization")
PROMPT(RADIOBUTTON,%RUNLOGIC%,"Select whether to run default logic for stored values after importing",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(KEYDATE,%KEYDATE%,"Key date",0)
PROMPT(RADIOBUTTON,%KEEPREJDATA%,"IF Keep Rejected Data",0,{"Yes, Keep the rejected data for the next delta loading","No, Do not keep the rejected data for the next delta loading"},{"1","0"})
INFO(%TEMPNO1%,%INCREASENO%)
INFO(%TEMPNO2%,%INCREASENO%)
INFO(%KEYDATE%,)
TASK(/CPMB/SOURCE_DELTA_IP,OUTPUTNO,%TEMPNO1%)
TASK(/CPMB/SOURCE_DELTA_IP,INFOPROV_INIT_NAME,%INFOPROV_INIT_NAME%)
TASK(/CPMB/SOURCE_DELTA_IP,BYPASS_COMPRESS,0)
TASK(/CPMB/SOURCE_DELTA_IP,KEEP_REJECT_DATA,%KEEPREJDATA%)
TASK(/CPMB/INFOPROV_DELTA_CONVERT,INFOPROV_INIT_NAME,%INFOPROV_INIT_NAME%)
TASK(/CPMB/INFOPROV_DELTA_CONVERT,OUTPUTNO,%TEMPNO2%)
TASK(/CPMB/INFOPROV_DELTA_CONVERT,SUSER,%USER%)
TASK(/CPMB/INFOPROV_DELTA_CONVERT,SAPPSET,%APPSET%)
TASK(/CPMB/INFOPROV_DELTA_CONVERT,SAPP,%APP%)
TASK(/CPMB/INFOPROV_DELTA_CONVERT,INPUTNO,%TEMPNO1%)
TASK(/CPMB/INFOPROV_DELTA_CONVERT,KEYDATE,%KEYDATE%)
TASK(/CPMB/APPEND_LOAD_DELTA_IP,INPUTNO,%TEMPNO2%)
TASK(/CPMB/APPEND_LOAD_DELTA_IP,RUNLOGIC,%RUNLOGIC%)
TASK(/CPMB/APPEND_LOAD_DELTA_IP,CHECKLCK,%CHECKLCK%)
TASK(/CPMB/APPEND_LOAD_DELTA_IP,INFOPROV_INIT_NAME,%INFOPROV_INIT_NAME%)
TASK(/CPMB/APPEND_LOAD_DELTA_IP,PREPROCESSMODE,0)
TASK(/CPMB/APPEND_LOAD_DELTA_IP,TARGETMODE,0)
TASK(/CPMB/APPEND_LOAD_DELTA_IP,KEYDATE,%KEYDATE%)
With kind regards,
Tim
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Can you provide a full details on your Delta load?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
14 | |
4 | |
2 | |
1 | |
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.