Dear BI-colleagues,
The big international firm I work for has loads into BW 24/7. To avoid Master Data inconsistencies they want to implement the following loading strategy:
1. load Transaction data into PSA
2. load and activate Master data
3. load Transaction data from PSA into InfoProviders
This obviously to avoid SID-errors (MD check turned on) as transactions will be entered in R/3 while MD-load is running.
The problem is that the way process chains work is that the process chain wants the "infopackage to PSA" run in the same process chain that "pushes from PSA". Or the other way to describe it is that with process chains we cannot pick up data from PSA that was put there by an infopackage which was executed outside of the process chain. Thus we cannot de-couple them in order to run the master data process chains in between.
A solution we came up with is
- to create a custom Process type (copy of Process type "Read PSA and Update Data Target");
- Modify it to take some parameters like infopackage name, PSA table and data target;
- Add some logic that enables it to determine how many PSA requests (FIFO) should be pushed into the targets;
- Add some logic for unusual exceptions like if it does not find any requests.
Does anybody have hints/tips/sample source code etc?
(I already got hold of the How-to paper for creating custom Process Types).
Thanx a lot!
Regards,
Marco
Message was edited by: Marco Verbaan
Add comment