In BI SD how to get Sales Document wise Order Delivery and balance Quantity

We are on the verge of SAP BI implementation. We are facing a problem as in BI we have to

show Sales Order wise - Order Quantity then associated all the deliveries and the Quantity delivered

and finally Billed Quantity

Format Required is

Order No Order Qty Delivery Qty Billed Qty

We are using 0sd_c03 cube here Order , delivery and Billing come as separate Line items

Now bringing them to one line item is a chellange for us

can any body help us