Shipment line star schema grouping

Dimensions

• Seller
• Ship node
• Enterprise
• Buyer
• Address region
• Product
• Product category hierarchy
• Address region hierarchy
• Calendar
• Document type

Measures

The following table provides a list of the Shipment Line measures:

Measure

Description

Shipped Quantity

This measure indicates the quantity that has been shipped.

Elapsed Time Expected Ship

This measure indicates the difference between the shipped time and the expected time (in minutes).

Is Procured

This measure indicates whether the shipment line has been procured.

Is Shipped

This measure indicates whether the shipment has been shipped.

Is Delayed

This measure indicates whether a shipment line has been delayed.

Delay in Shipment per Line

This measure indicates the delay in shipment for each shipment Line.

Elapsed Time Released Ship

This measure indicates the difference between the shipment time and the released time (in minutes).

Is Shipped on Time

This measure indicates whether the shipment has been shipped on time.

Is Backordered from Node

This measure indicates whether the order line has been backordered from a node.

Ordered Quantity

This measure provides the ordered quantity.

Is Fulfillment Partner

This measure indicates whether the ship node of a shipment line is a fulfilled partner.

Delay in Shipment

This measure indicates the delay in shipment for each shipment.

Grouped measures

The following table provides a list of the Shipment Line group measures:

Measure

Description

Percentage Shipped on Time

This is the percentage of order lines that are shipped on or before the first promised date.

No. of Shipment Lines Shipped

This is the total number of shipment lines shipped.

Avg. Release to Ship Time

This is the average time required to move the shipment lines from the release stage to the ship stage.

Percentage Procured

This is the percentage of shipment lines procured for a node.

No. of Shipments Shipped

This is the total number of shipment shipped.

Avg. Value of an Order

This is the average booked value of the confirmed orders.

Avg. Delay in Shipment

This is the average delay in the delayed shipments shipped.