Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

OTC Data granularity issue

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

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.

Brian

0 View this answer in context
Not what you were looking for? View more on this topic or Ask a question