KPI Definitions

Dimensions :


 Perfect Order

 Complete Order

 Order Line Fill

Definitions

 % Complete: % of number of orders fully dispatched at first dispatch

 % Perfect Orders: % of orders on time and in full

 % Value Fill: % of value/quantity dispatched at first dispatch

 % On Time: % of orders dispatched on or before the requested delivery date

 % Line Fill: % of number of lines fully dispatched at first dispatch

Possible solution

 Build a new DSO to for the Metrics based on DSO of Orders,Sales Order Schedule Line . Deliveries using Shipment Info and Status with count as Key figure for each dimension.

 Built an Cube over this DSO and built Query over this.