Sourced measures and KPIs

This table shows the measures that are sourced directly in Data Warehouse:

These measures can be analyzed by different time series. These time series are available:

  • Month Ago
  • Quarter Ago
  • Quarter-To-date
  • Trailing 12 Months
  • Trailing 3 Months
  • Year Ago
  • Year-To-date

Available aggregations for most of the measures are Avg, Max, Min, and Sum. Aggregation exceptions for some measures are indicated in this table:

Measure Description
Abs Catch Weight Var Absolute value of the catch weight variance
Bonus and Commission Amt Reserved bonus and commission amount in the division currency
Catch Weight Actual catch weight
Catch Weight Count Number of catch weight transactions

Aggregations: Avg, Sum

Catch Weight Var Catch weight minus the net weight
COGS Standard Total standard cost of the order line in the division currency
Disc Amt 1 Discount amount 1
Disc Amt 2 Discount amount 2
Disc Amt 3 Discount amount 3
Disc Amt 4 Discount amount 4
Disc Amt 5 Discount amount 5
Disc Amt 6 Discount amount 6
Gross Profit 1 Invoiced net amount minus the cost price
Gross Profit 2 Invoiced net amount minus cost price, net costs 1-5, and reserved bonus and commission
Gross Weight Gross weight of the item in the order line
Invcd Gross Amt Net line amount plus discount amounts 1-6 in the division currency
Invcd Net Amt Invoiced net line amount in the division currency
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
Invoiced Qty Invoiced quantity in basic unit of measure
Issued Cost Amt Cost amount at stock issue in the division currency
Net Cost 1 Net cost 1
Net Cost 2 Net cost 2
Net Cost 3 Net cost 3
Net Cost 4 Net cost 4
Net Cost 5 Net cost 5
Net Weight Net weight of the item in the order line
No. of Lines Number of invoiced lines

Aggregation: Sum

Order Currency Amt Recorded amount in the order currency
Promoted Number of lines with promotions applied

Aggregations: Avg, Sum

Promotional Disc Amt Total discount amount due to promotions
Total Cost Cost price plus the total net cost
Total Disc Amt Sum of discount amounts 1-6 in the division currency
Total Net Cost Sum of net costs 1-5 in the division currency
Volume Volume of the item in the order line