Delivery performance analysis fact
The Delivery Performance Analysis fact is used to analyze DIFOT and average turnaround days. The fact granularity is one row for every customer order item or customer order release item record which qty_shipped > 0.
Calculation rules and references:
| Name | Calculation Rule | Value |
|---|---|---|
| Lines Delivered In Full |
(Qty_Shipped_Under < = coitem.shipped_under_ordered_qty_tolerance or coitem.shipped_under_ordered_qty_tolerance is null) and (Qty_Shipped_Over < = coitem.Shipped_Over_Ordered_Qty_Tolerance and coitem.Shipped_Over_Ordered_Qty_Tolerance is null) |
1 else 0 |
| Lines Delivered On Time | (Shipped_Before_Due_Date < = coitem. days_shipped_before_due_date_tolerance or coitem. days_shipped_before_due_date_tolerance is null) and (Shipped_After_Due_Date < = coitem. days_shipped_after_due_date_tolerance or coitem. days_shipped_after_due_date_tolerance Is null) |
1 else 0 |
| Shipped Order Lines | coitem.qty_shipped > 0 | 1 else 0 |
| DIFOT | Lines Delivered In Full = 1 and Lines Delivered On Time = 1 | 1 else 0 |
| DIFOT % | ([Due Date: Sum: DIFOT] / [Due Date: Sum: Shipped Order Lines]) | |
| Fully Shipped Order Lines | coitem.qty_shipped > = coitem.qty_ordered | 1 else 0 |
| Turnaround Days |
if co.Type = R, then Order date = co.order_date if co.Type = B, then Order date = coitem.release_date |
datediff (day,Order date,coitem.ship_date) |