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 |
|---|---|
| Allocated Qty | Allocated quantity in basic unit of measure |
| Contribution | Order value minus the standard cost |
| Cost Price | Standard cost of the item calculated per item/facility per basic unit of measure and quantity in the division currency |
| Delivered Qty | Delivered quantity in basic unit of measure |
| Invoiced Qty | Invoiced quantity in basic unit of measure |
| Line Amt | Recorded amount in the division currency |
| Line Amt – Order Currency | Recorded amount in the order currency |
| No. of Lines | Number of order lines Aggregation: Sum |
| No. of Orders | Number of customer orders Aggregation: Count Distinct |
| No. of Overdue Lines | The number of order lines where the line status is
less than 65 and the confirmed delivery date is less than the ETL run
date Aggregations: Avg, Sum |
| No. of Stopped Orders | The number of customer orders where customer order stop is greater than zero |
| Order Qty | Order quantity in basic unit of measure |
| Order Value | Order quantity in basic unit of measure multiplied by the sales price in the division currency |
| Order Value – Order Currency | Order quantity in basic unit of measure multiplied by the sales price in the order currency |
| Picking List Qty | Quantity in basic unit of measure with picking list printed |
| Qty not Delivered | Quantity not yet delivered or invoiced in basic unit of measure |
| Qty not Invoiced | Quantity not yet invoiced in basic unit of measure |
| Remaining Qty | Remaining quantity in basic unit of measure |
| Sales Price | Price paid by the customer per basic unit of measure
and quantity in the division currency Aggregations: Avg, Max, Min |
| Sales Price – Order Currency | Price paid by the customer per unit of measure and
quantity in the order currency Aggregations: Avg, Max, Min |
| Standard Cost | Order quantity multiplied by the cost price in the division currency per basic unit of measure |