Customer category quotes daily summary star schema grouping
The Customer Category Quotes Daily Summary aggregate fact table is derived from the Quote Line fact and consists of the following dimensions:
Dimensions
Measures
The following table provides a list of the Customer Category Quotes Daily Summary measures:
- Measure
- Description
- Maximum Discount Percentage
Indicates the maximum discount percentage that is provided for a quote line.
- Minimum Discount Percentage
Indicates the minimum discount percentage that is provided for a quote line.
- Discount Percentage Total
Indicates the percentage of the discount that is provided on a quote line.
- Number of Quote Lines
Indicates the total number of quote lines selected for the given criteria.
- Profit Margin Percentage Total
Indicates the total profit margin percentage made when an order was created for a quote.
Grouped measures
The following table provides a list of the Customer Category Quotes Daily Summary grouped measures:
- Measure
- Description
- Average Discount Percentage
Indicates the average of the discount percentage that is provided for a quote line.
- Maximum Discount Percentage
Indicates the maximum discount percentage that is provided for a quote line.
- Minimum Discount Percentage
Indicates the minimum discount percentage that is provided for a quote line.
- Average Profit Margin Percentage
Indicates the average of the profit margin percentage that is made for a quote line.