SO hold summary star schema grouping
The SO Hold Summary aggregate fact table is derived from the SO Hold fact and consists of the following dimensions:
Dimensions
- Enterprise
- Document type
- Hold type
- Calendar (Hold Date)
Measures
The following table provides a list of the SO Hold Summary measures:
- Measure
- Description
- Hold Duration
Indicates the duration for which an order is held.
- Order Count
Indicates the number of orders that are on hold.
Grouped measures
The following table provides a list of the SO Hold Summary grouped measures:
- Measure
- Description
- No. of Orders on Hold
Indicates the number of orders on hold.
- Avg. Hold Duration
Indicates the average duration for which an order is kept on hold.