Intelligent modelling question for real BI people
Notification Notif-itme Matl Plant Vendor Source Customer Notif-counter Defect
1000 1 4RA 100 Manuf 5000 1 Kink
1001 1 4RA ABC Purch 5001 1 Break
1002 1 5RA 300 Manuf 6000 1 Kink
Deliv Deliv-item Matl Customer Deliv qty
8000 1 4RA 5000 10
8001 1 4RA 5001 30
8002 1 5RA 6000 50
Purch: Purchased goods
ECC LO Data sources: 2LIS_05_0QITEM (for notification) and 2LIS_12_VCITM (for deliveries)
DSOs: Notification DSO and Delivery DSO.
My reporting reqmt needs to combine both DSOs. Only Material, Customer and Batch nos are common in both DSOs.
KPI: Notification counter / Delivery quantity.
Drill downs can be any.
I know that multiprovider on DSOs will show data as shown in above table.
I want all data to come in same row based on material, batch and customer. Can I solve it by using Infoset or APD.
Is there alternate solution for modeling.
Edited by: Shankar Shankar on Sep 12, 2008 3:02 AM