Question:
I have created 2 ODS and loaded data.
ODS 1 reads data sources 2LIS_13_VDHDR & 2LIS_13_VDITM
ODS 2 reads data source 2LIS_18_IONOTIF
The first ODS contains data with ref to "BIll-to-party" and second ODS has data with ref "Customer"
I need to create another ODS or a cube which would contain the data from ODS1 & ODS 2.
I have a problem because the first one has data with bill-to-party and the second one has customer.
Pls help me to design this.
Thanks.
Answer:
You only give a property of both ODS1 and 2, but what do you finaly want in the next layer?
Answer:
Hi,
Create your third ODS with the objects desired. I presume 0CUSTOMER or some infoobject pertaining to customer will be used.
You will then need to create two update rules, one for each of the ODSs. In the update rules, Characteristics --> Customer, map the 0CUSTOMER from one ODS and the 0BILLTO from the other ODS.
Cheers,
Zubin