Hi,
I have an issue regarding SAP reject handling while loading to BW.
Data flow for my job is Essbase files to SAP BW, business requirement is i have to drop the error file in the staging area. How is reject handling done in SAP load stage. how will datastage know that there are some records which are rejected and dropped in to error stack.How can i capture those rejects in to a flat file.
Thanks
Rajesh
SAPBW - Reject Handling
Moderators: chulett, rschirm, roy
SAPBW - Reject Handling
--
Raj
Raj
-
- Participant
- Posts: 10
- Joined: Sun Oct 08, 2006 8:01 am
Hi Rajesh,
I am not sure if I understood your question completely but let me try to answer anyways. I am assuming you are using BW Load pack stage to load data into SAP BW (now referred to as SAP BI). Basically, there's not an ooption for reject data in the BW load stage. Anything that gets dropped from PSA (Persistent Storage Area) IN BW is captured inside BW. We use BW load stage to load tons of data and BW team generates a list of records that gets dropped either in PSA or at the base cube level.
Hope that helps. If not, please provide more details with sample scenario of what you mean by records being dropped in BW.
Regards,
Arun
I am not sure if I understood your question completely but let me try to answer anyways. I am assuming you are using BW Load pack stage to load data into SAP BW (now referred to as SAP BI). Basically, there's not an ooption for reject data in the BW load stage. Anything that gets dropped from PSA (Persistent Storage Area) IN BW is captured inside BW. We use BW load stage to load tons of data and BW team generates a list of records that gets dropped either in PSA or at the base cube level.
Hope that helps. If not, please provide more details with sample scenario of what you mean by records being dropped in BW.
Regards,
Arun
I understand that the rejected data will go and sit in PSA.
In my case before loading into SAPBW i have some validation errors, and while loading even there might be some SAP rejects as you said they will be dropped in PSA. If i want to append these SAP rejects to the error files that i have while validation what can be done.
How can i capture these rejects because my business requirement is they need error files to be dropped in the staging area.
Thanks
Rajesh
In my case before loading into SAPBW i have some validation errors, and while loading even there might be some SAP rejects as you said they will be dropped in PSA. If i want to append these SAP rejects to the error files that i have while validation what can be done.
How can i capture these rejects because my business requirement is they need error files to be dropped in the staging area.
Thanks
Rajesh
--
Raj
Raj
-
- Participant
- Posts: 10
- Joined: Sun Oct 08, 2006 8:01 am