SO daily category summary star schema grouping
The SO Daily Category Summary aggregate fact table is derived from the SO Line fact and consists of the following dimensions:
Dimensions
- Enterprise
- Document type
- Product category hierarchy(Category)
- Calendar (Transaction Date)
Measures
The following table provides a list of the SO Category Summary measures:
- Measure
- Description
- 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.
- Shipped Quantity
Indicates the shipped quantity.
- B2C Fulfilled Revenue
Indicates the fulfilled revenue of B2C orders.
- B2B Fulfilled Revenue
Indicates the fulfilled revenue of B2B orders.
- Backordered Count
Indicates the number of orders that have been backordered.
Grouped measures
The following table provides a list of the SO Category Summary grouped measures:
- Measure
- Description
- B2C Fulfilled Revenue (Currency)
Indicates the fulfilled revenue of a B2C order.
- B2B Fulfilled Revenue (Currency)
Indicates the fulfilled revenue of a B2B order.
- Percentage Shipped On Time
Indicates the percentage of the orders that have been shipped on time.