OTC Data granularity issue

[Former Member]

Hi Gurus

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.

Anil

[Former Member · Accepted solution]

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.

Brian