SO daily range summary star schema grouping
The SO Daily Range Summary schema grouping consists of the SO Daily Range Summary measures and the following dimensions:
Dimension
Measures
The following table provides a list of the SO Daily Range Summary measures:
- Measure
- Description
- Released Count
- Indicates the number of order lines in released status.
- Shipped Count
- Indicates the number of order lines in shipped status.
- Elapsed Time Confirm Release
- Indicates the time elapsed in minutes from the order released to order confirm status.
- Is Shipped ASAP Order
- Order lines are called ASAP when they do not have a requested shipped date or requested delivery date. Is Shipped ASAP Order indicates if the order line is an ASAP order or not.
- Capture to Ship Time ASAP
- Indicates the time elapsed in minutes between the shipped time and the order created time for ASAP order lines.
Group measures
The following table provides a list of the SO Daily Range Summary grouping measures:
- Measure
- Description
- Avg. Capture to Ship Time (ASAP)
- Indicates the average time elapsed between the shipped time and the order created time for ASAP order lines.
- Avg. Order to Release Time
- Indicates the average time elapsed between the order created time and released time.
- No. of Order Lines Shipped
- Indicates the number of order lines shipped.