SO daily summary star schema grouping
The SO Daily Summary aggregate fact table is derived from the SO Line fact and consists of the following dimensions:
Dimensions
- Enterprise
- Document type
- Seller
- Fulfillment type
- Calendar (Transaction Date)
Measures
The following table provides a list of the SO Daily Summary measures:
- Measure
- Description
- ASAP Order Count
Indicates the number of orders that are to be shipped as soon as possible.
- BackOrdered Count
Indicates the number of orders that have been backordered.
- BackOrdered and Delayed Count
Indicates the number of orders that have been backordered and delayed.
- Released Count
Indicates the number of orders that have been released.
- Shipped Count
Indicates the number of orders that have been shipped.
- Shipped On Time Count
Indicates the number of orders that have been shipped on time.
- Elapsed Lead Time ASAP
Indicates the time that has elapsed between the promised time and the confirmed time (in minutes).
- Elapsed Time Actual ship Confirmed
Indicates the time that has elapsed between the actual shipment time and the confirmed time (in minutes).
- Elapsed Time Actual ship Promised
Indicates the time that has elapsed between the actual shipment time and the promised time (in minutes).
- Elapsed Time Actual ship Released
Indicates the time that has elapsed between the promised time and the released time (in minutes).
- Elapsed Time Confirm Release
Indicates the time that has elapsed between the released time and confirmed time (in minutes).
- Fulfilled Revenue
Indicates the fulfilled revenue of an order.
- Shipped Quantity
Indicates the shipped quantity.
- Promised Count
Indicates the number of orders that have been promised to be delivered.
- Confirmed Order Lines
Indicates the confirmed order lines.
- Ordered Quantity
Indicates the ordered quantity.
- Confirmed Orders
Indicates the confirmed orders.
- Booked Value
Indicates the booked value of the confirmed order.
- B2B Booked Value
Indicates the booked value of the B2B orders.
- B2C Booked Value
Indicates the booked value of the B2C orders.
- B2B Fulfilled Revenue
Indicates the fulfilled revenue of the B2B orders.
- B2C Fulfilled Revenue
Indicates the fulfilled revenue of the B2C orders.
- B2B Shipped Quantity
Indicates the shipped quantity of the B2B orders.
- B2C Shipped Quantity
Indicates the shipped quantity of the B2C orders.
- B2B Ordered Quantity
Indicates the ordered quantity of the B2B orders.
- B2C Ordered Quantity
Indicates the ordered quantity of the B2C orders.
- B2B Orders Confirmed
Indicates the B2B orders that have been confirmed.
- B2C Orders Confirmed
Indicates the B2C orders that have been confirmed.
- B2B Order Lines Confirmed
Indicates the B2B order lines that have been confirmed.
- B2C Order Lines Confirmed
Indicates the B2C order lines that have been confirmed.
- B2B Shipped Count
Indicates the number of B2B orders lines that have been shipped.
- B2C Shipped Count
Indicates the number of B2C orders lines that have been shipped.
- B2B Shipped Order Count
Indicates the number of B2B orders that have been shipped.
- B2C Shipped Order Count
Indicates the number of B2C orders that have been shipped.
- B2B Order Count
Indicates the number of B2B orders.
- B2C Order Count
Indicates the number of B2C orders.
- Order Delay
Indicates the time taken to ship an order.
- Capture to Ship Time
Indicates the amount of time between the stage an order is captured and the time it is shipped.
- Delayed Count
Indicates the number of orders that have been delayed.
- Shipped ASAP Order Count
Indicates the number of ASAP orders that have been shipped.
Grouped measures
The following table provides a list of the SO Daily Summary grouped measures:
- Measure
- Description
- Percentage Shipped on Time
Indicates the percentage of orders that have been shipped on time.
- Percentage BackOrdered
Indicates the percentage of orders that have been backordered.
- No. of Order Lines Shipped
Indicates the number of order lines that have been shipped.
- Avg. Exp. Lead Time (ASAP Orders)
Indicates the average expected lead time for ASAP orders.
- Avg. Capture to Ship Time (ASAP)
Indicates the average amount of time between the stage an ASAP order line is captured and the time it is shipped.
- Avg. delay for Delayed Orders
Indicates the average amount of delay occurred in the delayed orders.
- Avg. Order to Release time
indicates the average time required to move the order lines from the order capture stage to the order release stage.
- Avg. Lead Time to Ship
Indicates the average time required to move the order lines from the release stage to the ship stage.
- Avg. Order Lines per Order
Indicates the average number of order lines in a confirmed order.
- Avg. Value of an Order
Indicates the average booked value of confirmed orders.
- No. of Orders Confirmed
Indicates the number of orders that have been confirmed.
- No. of Order Lines Confirmed
Indicates the number of order lines that have been confirmed.
- No. of Order Lines Shipped (B2B)
Indicates the number of shipped order lines pertaining to a B2B order.
- No. of Order Lines Shipped (B2C)
Indicates the number of shipped order lines pertaining to a B2C order.
- B2B Booked Value (Currency)
Indicates the booked value of a B2B order.
- B2C Booked Value (Currency)
Indicates the booked value of a B2C order.
- B2B Fulfilled Revenue (Currency)
Indicates the fulfilled revenue of a B2B order.
- B2C Fulfilled Revenue (Currency)
Indicates the fulfilled revenue of a B2C order.
- Avg. Value of an Order B2B
Indicates the average value of a B2B order.
- Avg. Value of an Order B2C
Indicates the average value of a B2C order.
- Avg. Order Lines per Order B2B
Indicates the average number of order lines confirmed per a B2B order (excluding bundle component line).
- Avg. Order Lines per Order B2C
Indicates the average number of order lines confirmed per a B2C order (excluding bundle component line).
- No. of Order Lines Confirmed B2B
Indicates the average number of B2B order lines confirmed.
- No. of Order Lines Confirmed B2C
Indicates the average number of B2C order lines confirmed.
- No. Of B2B Orders Shipped
Indicates the number of B2B orders that have been shipped.
- No. Of B2C Orders Shipped
Indicates the number of B2C orders that have been shipped.