Sales Analysis sourced measures and KPIs

This table shows the Sales Analysis measures that are sourced directly in Data Warehouse.

You can use different time series to analyze these measures. For the list of available time series measures, see Time.

Aggregations available are Avg, Max, Min, and Sum. For cases where this does not apply, the available aggregations are indicated in this table:

Measure	Description
Invcd Net Amt – Transaction	Invoiced net line amount in the order currency
Invcd Net Amt – Division	Invoiced net line amount in the division currency
Invcd Net Amt – Company	Invoiced net line amount in the company currency
Invcd Gross Amt – Transaction	Net line amount plus discount amounts 1-6 in the order currency
Invcd Gross Amt – Division	Net line amount plus discount amounts 1-6 in the division currency
Invcd Gross Amt – Company	Net line amount plus discount amounts 1-6 in the company currency
Disc Amt 1 – Transaction	Discount amount 1 in the order currency
Disc Amt 1 – Division	Discount amount 1 in the division currency
Disc Amt 1 – Company	Discount amount 1 in the company currency
Disc Amt 2 – Transaction	Discount amount 2 in the order currency
Disc Amt 2 – Division	Discount amount 2 in the division currency
Disc Amt 2 – Company	Discount amount 2 in the company currency
Disc Amt 3 – Transaction	Discount amount 3 in the order currency
Disc Amt 3 – Division	Discount amount 3 in the division currency
Disc Amt 3 – Company	Discount amount 3 in the company currency
Disc Amt 4 – Transaction	Discount amount 4 in the order currency
Disc Amt 4 – Division	Discount amount 4 in the division currency
Disc Amt 4 – Company	Discount amount 4 in the company currency
Disc Amt 5 – Transaction	Discount amount 5 in the order currency
Disc Amt 5 – Division	Discount amount 5 in the division currency
Disc Amt 5 – Company	Discount amount 5 in the company currency
Disc Amt 6 – Transaction	Discount amount 6 in the order currency
Disc Amt 6 – Division	Discount amount 6 in the division currency
Disc Amt 6 – Company	Discount amount 6 in the company currency
Total Disc Amt – Transaction	Sum of discount amounts 1-6 in the order currency
Total Disc Amt – Division	Sum of discount amounts 1-6 in the division currency
Total Disc Amt – Company	Sum of discount amounts 1-6 in the company currency
Promotional Disc Amt – Transaction	Total discount amount due to promotions in the order currency
Promotional Disc Amt – Division	Total discount amount due to promotions in the division currency
Promotional Disc Amt – Company	Total discount amount due to promotions in the company currency
Bonus and Comm Amt – Transaction	Reserved bonus and commission amount in the order currency
Bonus and Comm Amt – Division	Reserved bonus and commission amount in the division currency
Bonus and Comm Amt – Company	Reserved bonus and commission amount in the company currency
Issued Cost Amt – Transaction	Cost amount at stock issue in the order currency
Issued Cost Amt – Division	Cost amount at stock issue in the division currency
Issued Cost Amt – Company	Cost amount at stock issue in the company currency
Gross Profit 1 – Transaction	Invoiced net amount minus the cost price in the order currency
Gross Profit 1 – Division	Invoiced net amount minus the cost price in the division currency
Gross Profit 1 – Company	Invoiced net amount minus the cost price in the company currency
Gross Profit 2 – Transaction	Invoiced net amount minus cost price, net costs 1-5, and reserved bonus and commission in the order currency
Gross Profit 2 – Division	Invoiced net amount minus cost price, net costs 1-5, and reserved bonus and commission in the division currency
Gross Profit 2 – Company	Invoiced net amount minus cost price, net costs 1-5, and reserved bonus and commission in the company currency
COGS Standard – Transaction	Total standard cost of the order line in the order currency
COGS Standard – Division	Total standard cost of the order line in the division currency
COGS Standard – Company	Total standard cost of the order line in the company currency
Net Cost 1 – Transaction	Net cost 1 in the order currency
Net Cost 1 – Division	Net cost 1 in the division currency
Net Cost 1 – Company	Net cost 1 in the company currency
Net Cost 2 – Transaction	Net cost 2 in the order currency
Net Cost 2 – Division	Net cost 2 in the division currency
Net Cost 2 – Company	Net cost 2 in the company currency
Net Cost 3 – Transaction	Net cost 3 in the order currency
Net Cost 3 – Division	Net cost 3 in the division currency
Net Cost 3 – Company	Net cost 3 in the company currency
Net Cost 4 – Transaction	Net cost 4 in the order currency
Net Cost 4 – Division	Net cost 4 in the division currency
Net Cost 4 – Company	Net cost 4 in the company currency
Net Cost 5 – Transaction	Net cost 5 in the order currency
Net Cost 5 – Division	Net cost 5 in the division currency
Net Cost 5 – Company	Net cost 5 in the company currency
Total Cost – Transaction	Cost price plus the total net cost in the order currency
Total Cost – Division	Cost price plus the total net cost in the division currency
Total Cost – Company	Cost price plus the total net cost in the company currency
Total Net Cost – Transaction	Sum of net costs 1-5 in the order currency
Total Net Cost – Division	Sum of net costs 1-5 in the division currency
Total Net Cost – Company	Sum of net costs 1-5 in the company currency
Invcd Qty	Invoiced quantity in basic unit of measure
Invcd Qty Alt Unit	Invoiced quantity in alternate unit of measure
Invcd Qty Sales Price Unit	Invoiced quantity in sales price unit of measure
Invcd Qty Stat Unit	Invoiced quantity in statistical unit of measure
No. of Lines	Number of invoiced lines Aggregations: Avg, Sum
Promoted	Number of lines with promotions applied Aggregations: Avg, Sum
Net Weight	Net weight of the item multiplied by the invoiced quantity
Gross Weight	Gross weight of the item multiplied by the invoiced quantity
Gross Weight – Threshold Unit	Competitor erosion weight threshold as defined per warehouse
Volume	Volume of the item multiplied by the invoiced quantity
Volume – Threshold Unit	Competitor erosion volume threshold as defined per warehouse