SO customer monthly summary star schema grouping
The SO Customer Monthly Summary aggregate fact table is derived from the SO Line fact and consists of the following dimensions:
Dimensions
- Enterprise
- Document type
- Customer
- Calendar (Month)
Measures
The following table provides a list of the SO Customer Monthly Summary measures:
- Measure
- Description
- Fulfilled Revenue
Indicates the fulfilled revenue by a customer in a month.
- Order Count
Indicates the total number of orders placed by a customer.
Grouped measures
The SO Customer Monthly Summary grouped measure is Average Order Value. It indicates the average lifetime order value for a customer.