Skip to Content
0

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

Oct 18, 2017 at 02:22 PM

80

avatar image

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?

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

2 Answers

Vadim Kalinin Oct 18, 2017 at 02:31 PM
0

Can you provide a full details on your Delta load?

Share
10 |10000 characters needed characters left characters exceeded
T. Vierhout Oct 18, 2017 at 02:54 PM
0

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

Share
10 |10000 characters needed characters left characters exceeded