SO line star schema grouping

Dimensions

• Enterprise
• Buyer
• Seller
• Channel
• Calendar
• Delivery method
• Fulfillment type
• Product
• Product category hierarchy
• Address region
• Ship node
• Address region hierarchy
• Customer
• Customer hierarchy
• Document type
• User ranges

Measures

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

Measure

Description

Bundle Line count

This measure is count of bundle components for bundle orders.

Total Line Charges

This is the total amount pertaining to an order line.

Is Shipped

This measure indicates whether the order line is shipped.

Elapsed Time Actual Ship Promised

The time that has elapsed between the actual shipment time and the promised time (in minutes).

Elapsed Time Actual Ship Released

The time that has elapsed between the actual shipment time and the released time (in minutes).

Elapsed Time Confirm Release

The time that has elapsed between the released time and confirmed time (in minutes)

Shipped Quantity

This is the shipped quantity of the order lines.

Is ASAP Order

This measure indicates whether the order is an ASAP order.

Ordered Quantity

This is the ordered quantity of the order lines.

Capture to Shipment Time for ASAP Order

This is the time between the shipped time and the captured time for ASAP orders.

Is Delayed

This measure indicates whether the order line has been delayed.

Is BackOrdered

This measure indicates whether the order line has been backordered.

Is BackOrdered and Delayed

This measure indicates whether the order line has been backordered and delayed.

Is Shipped On Time

This measure indicates whether the order line has been shipped on time.

Elapsed Time Actual Ship Confirmed

The time that has elapsed between the actual shipment time and the confirmed time (in minutes).

Elapsed Lead Time ASAP

The time that has elapsed for the ASAP orders (in minutes).

Sales Order Line Count

This is the total number of order lines.

Fulfilled Revenue (Currency)

This is the fulfilled revenue of an order line.

Is Released

This measure indicates whether the order line has been released.

Booked Value (Currency)

This measure indicates the booked value.

Is Shipped ASAP Order

This measure indicates whether the shipped order is an ASAP order.

Not Cancelled

This measure indicates whether the order line has been cancelled.

Is Currently Backordered

This measure indicates if the order line is presently in back ordered status.

Backordered Quantity

This measure indicates the back ordered quantity.

Allocated Quantity

This measure indicates the quantity scheduled to be shipped from the allocated node.

Is Scheduled

This measure indicates if the order line has been scheduled, but not shipped.

Grouped measures

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

Measure

Description

Percentage Shipped on Time

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

No. of Orders Shipped

This is the total number of orders shipped.

Avg. Exp. Lead Time (ASAP Orders)

This is the time between the promised date and the confirmed date for ASAP orders.

Avg. Capture to Ship Time (ASAP)

This is the average amount of time between the stage an ASAP order line is captured and the time it is shipped.

Avg. Lead Time to Ship

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

Avg. Value of an Order

This is the average booked value of confirmed orders.

No. of Order Lines Confirmed

This is the total number of order lines confirmed.

Delayed Order Line

This indicates the order line which has missed the promised date and is not shipped.

Percentage BackOrdered

This is the percentage of shipment lines backordered from a node.

No. of Order Lines Shipped

This is the total number of order lines shipped.

Avg. Capture to Ship Time (ASAP)

This is the average amount of time between the stage when an ASAP order line is captured and the time it is shipped.

Avg. Order to Release Time

This is the average time required to move the order lines from the order capture stage to the order release stage.

Avg. Order Lines per Order

This is the average number of order lines in a confirmed order.