Quote line star schema grouping
The Quote Line star schema grouping consists of the Quote Line measures and the following dimensions:
Dimensions
Measures
The following table provides a list of the Quote Line measures:
- Measure
- Description
- Is Ordered
Indicates If the quote to which this quote line belongs has been converted to an order.
- Is Abandoned
Indicates if the quote to which this quote line belongs has been abandoned.
- Sold At Price
Indicates the price of a quote line at which it is sold. This price includes all the charges considered for the quote line.
- Ordered Quantity
Indicates the quantity of a quote line in an order.
- Profit Margin Percentage
Indicates the percentage of the profit margin made when an order was created for a quote line.
- Selling Price
Indicates the selling price of a quote line as specified in a quote.
- Cost Price
Indicates the cost price of a quote line.
- Quote Line Count
Indicates the count of a quote line for a specific criteria.
- Total Profit Margin
Indicates the total profit margin made when an order was created for a quote line.
- Total Discount
Indicates the total discount provided for a quote line.
- Discount Percentage
Indicates the percentage of the discount that is provided on a quote line.
Grouped measures
The following table provides a list of the Quote Line 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.