Shipment summary star schema grouping
The Shipment Summary aggregate fact table is derived from the Shipment Line fact and consists of the following dimensions:
Dimensions
- Enterprise
- Document type
- Calendar (Actual Ship Date)
- User ranges
- Ship node
Measures
The following table provides a list of the Shipment Summary measures:
- Measure
- Description
- Procured Count
Indicates the number of shipments that have been procured.
- BackOrdered from Node Count
Indicates the number of shipments that have been backordered from a node.
- Shipped Count
Indicates the number of shipments that have been sent.
- Ordered Quantity
Indicates the ordered quantity.
- Delay in Shipment per Line
Indicates the delay in shipment per line.
- Elapsed Time Released Ship
Indicates the time elapsed between the released date and the actual shipment date.
- Shipment Number
Indicates the shipment number.
- Shipped On Time Count
Indicates the number of shipments that have been sent on time.
Grouped measures
The following table provides a list of the Shipment Summary grouped measures:
- Measure
- Description
- No. of Shipment Lines Shipped
Indicates the number of shipment lines that have been shipped.
- Percentage Backordered From Node
Indicates the percentage of orders that have been backordered from a given node.
- Percentage Procured
Indicates the percentage of the orders that have been procured.
- No. of Shipments Shipped
Indicates the number of shipments that have been shipped.
- Avg. Delay in Shipment
Indicates the average amount of delay that occurred when sending shipments.