SO monthly summary
The SO Monthly Summary aggregate fact table is derived from the SO Line fact and consists of the following dimensions:
Dimensions
- Enterprise
- Document type
- Calendar (Month)
Measures
The following table provides a list of the SO Monthly Summary measures:
- Measure
- Description
- Fulfilled Revenue
Indicates the fulfilled revenue of a customer in a month.
- Order Count
Indicates the total number of orders placed by a customer.
- Customer Count
The number of customers for the Enterprise.
Grouped measures
The following table provides a list of the SO Monthly Summary grouped measures:
- Measure
- Description
- Average Customer Revenue
Indicates the amount of revenue generated by an average customer. An average customer is the customer with whom other customers are compared in terms of revenue generated
- Customer Spent
Indicates the total amount that a customer has spent.
- Customer Spent Ratio
Indicates the ratio of the amount spent by a customer by the total amount.