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 |