SO daily region summary star schema grouping
The SO Daily Region Summary aggregate fact table is derived from the SO Line fact and consists of the following dimensions:
Dimensions
- Enterprise
- Document type
- Address region hierarchy
- Calendar (Transaction Date)
Measures
The following table provides a list of the SO Daily Region 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.
Grouped measures
The SO Daily Region Summary grouped measure is B2C Fulfilled Revenue (Currency). It indicates the fulfilled revenue of B2C orders.