OTC Data granularity issue
I have 2 questions and need some help.
1.Is it possible to combine Shipping and Delivery Information in a cube? If so then what will be the joining condition. I just see Shipment # in Shipment header and dont know if we can relate to a delivery document.
2. Can we Combine billing and billing condition data. I see ther are of different granularity i.e. for one record in billing, there ate amny records in billing condition. What is the standard way to manage this info i.e. 2 seprate data provider and join the billing and billing conditions with infoset when required.
Thanks a million for your help in the past and on this one.
Brian Anthony replied
Yes, it is possible to combine this data, but it is going to be a slow and huge cube. You might want to combine the data so that you get your billing and delivery data on a sales order record in an ODS, then upload the summary data to the cube. On your report, if you want the details, do a jump (RRI) to a report off the ODS. That way, you don't need to include all your document numbers in the cube.
Or you can use COPA.