cancel
Showing results for 
Search instead for 
Did you mean: 

BPC Delta load, rejected records are not loaded in the subsequent run

t_vierhout
Explorer
0 Kudos

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?

Accepted Solutions (0)

Answers (3)

Answers (3)

t_vierhout
Explorer
0 Kudos
former_member186338
Active Contributor
0 Kudos

Then please accept your own answer!

t_vierhout
Explorer
0 Kudos

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

former_member186338
Active Contributor
0 Kudos

Can you provide a full details on your Delta load?