RO daily summary star schema grouping
The RO Daily Summary schema grouping consists of the RO Daily Summary measures and the following dimensions:
Dimension
Measures
The following table provides a list of the RO Daily Summary measures:
- Measure
- Description
- Returned Quantity
- Indicates the quantity that is returned.
- Return Value
- Indicates the return value when the order line is in received status.
- No of Return Order Lines
- Indicates the number of return order lines in received status.
- Fulfilled Revenue
- Indicates the revenue from the sales order line.
- No of Sales Order Lines
- Indicates the number of sales order lines.
Group measures
The following table provides a list of the RO Daily Summary grouping measures:
- Measure
- Description
- Percentage Return Value
- Indicates the percentage of returned lines compared to the revenue of all the lines that were fulfilled for a given time period.
- Percentage Of Order Lines Returned
- Indicates the percentage of the number of return order lines compared to the number of sales order lines.