Sales delivery analysis fact

The Sales Delivery Analysis fact is used to view customer order and shipment data, including delivery-by ship dates, customers, and shipping delivery interval. The fact granularity is one row for every customer order line. Orders with Planned/Stopped status should be excluded. If there are multiple shipments for one order line, then the last shipment date is used for calculation. For the no shipment order line, set the quantity shipped to 0 and set the shipment date to current date.