Question:
Hi
We are runnig with BW 3.0B and with one R/3 source system. We have to connect another R/3 system. I need all your help & Inputs on this.
MDM is out of the scope.
Compounding :
- How should i compoud with 0SOURSYSTEM. Will there be any effect on the existing design??will there be ne effect on master data.
- Reload of transactionla data from the existing R/3 again is also out of scope.
That is existing data and design should not be distrubed.
PS: I searched in the forum CHC had the same issue some time before. I think he can help me out.
regards
-Pal
Answer:
If you can't touch the existing schema, you can't achieve the task you've been assigned.
What is compounding (simplified explanation) ?
Take the sample of customer number 50
in system A, it's called DUGENOU
in system B, it's in fact DUCOUDE
What you try to do is to load in the same system the customer 50, but you need to differentiate between DUGENOU and DUCOUDE.
To do this, you use the compound concept that will add one info to the customer number : the system it's coming from.
So, DUGENOU is now A/50, while DUCOUDE is B/50.
---> in your master data tables, one more attribute to fill for customer, the source system -> reload
---> in your transaction table, whenever you had "50", you now need to RELOAD with "A/50" instead
---> in your queries, you have to include the source system, otherwise all customers will show as A/50 instead of 50 (and the A filtered, for instance)
Now, you could fool the system in order not to have to reload all transaction data by keeping the same SID for A/50, that was used for 50 ; depending on the size of your bw project.
I strongly suggest you to search OSS about this, there are some notes dealing with this.
Keep in mind that if you use the compound for customer, and customer is an attribute of something else, this other characteristic is also impacted.
This is a MAJOR change to implement in a LIVE system, following me.
Ch
_________________
_
There are only 10 types of people in the world :
those who understand binary and those who don't.