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 |