Purchase KPIs & Measures
Catalog of the 133 measures shipped with the Purchase semantic model, grouped by their display folder. Captions are shown in English and German together with the number format. Use any measure with any dimension to build your own analysis.
AvgAmounts
| Measure (EN) | Measure (DE) | Format | Description |
|---|---|---|---|
| Avg Invoice Amount | Ø Rechnungsbetrag | #,##0 | Purchase Invoice Amount divided by Number of Purchase Invoices |
| Avg Order Amount | Ø Bestellbetrag | #,##0 | Purchase Order Amount divided by Number of Purchase Orders |
| Invoice Unit Price | Ø Einkaufspreis pro Einheit (Rechnung) | #,##0.0 | Purchase Invoice Amount divided by Quantity |
| Order Unit Price | Ø Einkaufspreis pro Einheit | #,##0.0 | Purchase Order Amount divided by Quantity |
Basic
| Measure (EN) | Measure (DE) | Format | Description |
|---|---|---|---|
| Gross Weight | Bruttogewicht | #,##0 | |
| Invoice Amount | Rechnungsbetrag | #,##0 | Invoice Amount excl. Discounts |
| Invoice Amount Gross | Rechnungsbetrag Brutto | #,##0 | Quantity x Unitprice |
| Invoice Cost Amount | Kosten (kalk. Rechnung) | #,##0 | Cost Amount of Purch Invoice |
| Invoice Gross Weight | Bruttogewicht (Rechnung) | #,##0 | Gross weight of purchase invoice |
| Invoice Quantity | Menge (Rechnung) | #,##0 | Quantity from Purchase Invoice |
| Order Amount | Bestellbetrag | #,##0 | Order Amount excl. Discounts |
| Order Amount Gross | Bestellbetrag Brutto | #,##0 | Quantity x Unitprice |
| Order Amount Open | Bestellbetrag (offen) | #,##0 | Purchase Order Amount excl. Discounts (Status Open) |
| Order Cost Amount | Kosten (kalk. Bestellung) | #,##0 | Cost Amount of Purch Order |
| Order Gross Weight | Bruttogewicht (Bestellung) | #,##0 | Gross weight of purchase order |
| Order Quantity | Bestellmenge | #,##0 | Quantity from Purchase Order |
| Purch Amount | Einkaufsbetrag | #,##0 | |
| Purch Amount Gross | Einkaufsbetrag (Brutto) | #,##0 | |
| Purch Cost Amount | Kosten (kalk.) | #,##0 | |
| Purch Discount | Einkaufsrabatt | #,##0 | |
| Purch Discount % | Rabatt der Bestellung (%) | #,##0.0 % | Discounts related to Purchase Amount |
| Purch Header End Discount | Einkaufskopfrabatt | #,##0 | |
| Purch Line Discount | Positionsrabatt | #,##0 | |
| Purch Quantity | Einkaufsmenge | #,##0 | |
| Purch Unit Price | Ø EK Preis | #,##0.0 | Purchase Amount divided by Quantity |
| Receipt Amount | Lieferscheinbetrag | #,##0 | Amount of the receipt |
| Receipt Gross Weight | Bruttogewicht (Lieferschein) | #,##0 | Gross weight receipt |
| Receipt Quantity | Lieferscheinmenge | #,##0 | Quantity on Receipt |
Basic\TimeIntelligence\PY
| Measure (EN) | Measure (DE) | Format | Description |
|---|---|---|---|
| Purch Discount PY | Purch Discount PY | #,##0 |
Basic\TimeIntelligence\YoY
| Measure (EN) | Measure (DE) | Format | Description |
|---|---|---|---|
| Purch Discount YoY | Purch Discount YoY | #,##0 |
Basic\TimeIntelligence\YoY %
| Measure (EN) | Measure (DE) | Format | Description |
|---|---|---|---|
| Purch Discount YoY % | Purch Discount YoY % | #,##0 % |
Counts
| Measure (EN) | Measure (DE) | Format | Description |
|---|---|---|---|
| # Unique Invoices | # Rechnungen | #,##0 | Number of Purchase Invoices |
| # Unique Items Invoiced | # Artikel verrechnet | #,##0 | Number of Items invoiced |
| # Unique Items Ordered | # Artikel bestellt | #,##0 | Number of Items ordered |
| # Unique Items Receipt | # Artikel geliefert | #,##0 | Number of Items received |
| # Unique Orders | # Bestellungen | #,##0 | Number of Purchase Orders |
| # Unique Receipts | # Lieferscheine | #,##0 | Number of Receipts |
| # Unique Vendors | # Lieferanten | #,##0 | Number of active Vendors |
Counts\TimeIntelligence\PY
| Measure (EN) | Measure (DE) | Format | Description |
|---|---|---|---|
| # Unique Vendors PY | # Unique Vendors PY | #,##0 | |
| Purch Amount PY | Einkaufsbetrag PY | #,##0 | Purchase Amount Previous Year |
| Purch Quantity PY | Einkaufsmenge PY | #,##0 | Purchase Quantity Previous Year |
| Purch Unit Price PY | Ø EK Preis | #,##0 | Purchase Amount divided by Quantity Previous Year |
Counts\TimeIntelligence\YoY
| Measure (EN) | Measure (DE) | Format | Description |
|---|---|---|---|
| # Unique Vendors YoY | # Unique Vendors YoY | #,##0 | |
| Purch Amount YoY | Einkaufsbetrag YoY | #,##0 | |
| Purch Quantity YoY | Einkaufsmenge YoY | #,##0 | |
| Purch Unit Price YoY | Ø EK Preis | #,##0 |
Counts\TimeIntelligence\YoY %
| Measure (EN) | Measure (DE) | Format | Description |
|---|---|---|---|
| # Unique Vendors YoY % | # Unique Vendors YoY % | #,##0 % | |
| Purch Amount YoY % | Einkaufsbetrag YoY % | #,##0 % | |
| Purch Quantity YoY % | Einkaufsmenge YoY % | #,##0 % | |
| Purch Unit Price YoY % | Ø EK Preis | #,##0 % |
Discounts
| Measure (EN) | Measure (DE) | Format | Description |
|---|---|---|---|
| Invoice Discount | Rechnungsrabatt | #,##0 | Header Discount and Line Discount of Purchase Invoices |
| Invoice Discount % | Rechnungsrabatt % | #,##0.0 % | Discounts related to Purchase Invoice Amount |
| Invoice Header End Discount | Rechnungskopfrabatt | #,##0 | Header discount of the Purchase Invoice |
| Invoice Line Discount | Rechnungspositionsrabatt | #,##0 | Line discount of the Purchase Invoice |
| Order Discount | Rabatt der Bestellung | #,##0 | Header Discount and Line Discount of Purchase Orders |
| Order Discount % | Rabatt der Bestellung (%) | #,##0.0 % | Discounts related to Purchase Order Amount |
| Order Header End Discount | Bestellkopfrabatt | #,##0 | Header discount of the Purchase Order |
| Order Line Discount | Bestellpositionsrabatt | #,##0 | Line discount of the Purchase Order |
Explicit KPI
| Measure (EN) | Measure (DE) | Format | Description |
|---|---|---|---|
| Order Amount PY | Bestellbetrag PY | #,##0 | Order Amount excl. Discounts Previous Year |
| Order Amount YoY | Bestellbetrag YoY | #,##0 | |
| Order Amount YoY % | Bestellbetrag YoY % | #,##0 % |
Frequencies
| Measure (EN) | Measure (DE) | Format | Description |
|---|---|---|---|
| Invoice Frequency (Days) | Rechnumgsfrequenz (Tage) | #,##0 | Days in current filter divided by the number of purchase invoices |
| Order Frequency (Days) | Bestellfrequenz (Tage) | #,##0 | Days in current filter divided by the number of purchase orders |
| Receipt Frequency (Days) | Lieferfrequenz (Tage) | #,##0 | Days in current filter divided by the number of receipts |
General
| Measure (EN) | Measure (DE) | Format | Description |
|---|---|---|---|
| Amount-Discount relation by Employee Label | Amount-Discount relation by Employee Label | ||
| Avg Order Amount Label Label | Avg Order Amount Label Label | ||
| by Employee Page Label | by Employee Page Label | ||
| by Item Page Label | by Item Page Label | ||
| by Vendor Page Label | by Vendor Page Label | ||
| Client Label | Client Label | ||
| Document Type Label | Document Type Label | ||
| Employee Label | Employee Label | ||
| GrossWeightBase | GrossWeightBase | #,##0 | |
| Invoice Label | Invoice Label | ||
| Item Label | Item Label | ||
| ItemPage Label | ItemPage Label | ||
| Last Refresh Label | Last Refresh Label | ||
| Map Label | Map Label | ||
| OverviewPage Label | OverviewPage Label | ||
| Period Label | Period Label | ||
| Price & Quantity development by Vendor Country Label | Price & Quantity development by Vendor Country Label | ||
| Purch Amount & -Discount by Primary Vendor Label | Purch Amount & -Discount by Primary Vendor Label | ||
| Purch Amount vs PY by Item Category Label | Purch Amount vs PY by Item Category Label | ||
| Purch Amount vs PY Label | Purch Amount vs PY Label | ||
| Purch Unit Price vs PY Label | Purch Unit Price vs PY Label | ||
| PurchAmountTargetCurrency | PurchAmountTargetCurrency | #,##0 | |
| Purchase Amount by Document Type Label | Purchase Amount by Document Type Label | ||
| Purchase Invoices Label | Purchase Invoices Label | ||
| Purchase Orders Label | Purchase Orders Label | ||
| Purchase Receipts Label | Purchase Receipts Label | ||
| Purchase Trend Label | Purchase Trend Label | ||
| PurchCostAmountTargetCurrency | PurchCostAmountTargetCurrency | #,##0 | |
| PurchDiscountTargetCurrency | PurchDiscountTargetCurrency | #,##0 | |
| PurchGrossAmountTargetCurrency | PurchGrossAmountTargetCurrency | #,##0 | |
| PurchHeaderEndDiscountTargetCurrency | PurchHeaderEndDiscountTargetCurrency | #,##0 | |
| PurchQuantityBase | PurchQuantityBase | #,##0 | |
| QAPage Label | QAPage Label | ||
| Report Label | Report Label | ||
| Share of Discount(s) Label | Share of Discount(s) Label | ||
| Statistic by Employee Label | Statistic by Employee Label | ||
| Statistic by Item Label | Statistic by Item Label | ||
| Statistic by ItemCategory Label | Statistic by ItemCategory Label | ||
| Statistic by Vendor Label | Statistic by Vendor Label | ||
| SummaryPage Label | SummaryPage Label | ||
| Today Label | Today Label | ||
| Vendor Label | Vendor Label |
Tech
| Measure (EN) | Measure (DE) | Format | Description |
|---|---|---|---|
| App Version | App Version | ||
| Current User | Current User | ||
| DaysInFilter | Tage gefiltert | ||
| DynMeasure | DynMeasure | ||
| EffectiveDate | Datum (effective) | ||
| Last Refresh | Letztes Update | ||
| Last Refresh Card | Last Refresh Card | ||
| MeasureDumpFilter | MeasureDumpFilter | ||
| PurchRowCount | # Einkaufspositionen | ||
| Today Card | Today Card |
Tech\Formatting
| Measure (EN) | Measure (DE) | Format | Description |
|---|---|---|---|
| # Unique Vendors YoY CF | # Unique Vendors YoY CF | ||
| # Unique Vendors YoY Icon | # Unique Vendors YoY Icon | ||
| Purch Amount YoY CF | Purch Amount YoY CF | ||
| Purch Amount YoY Icon | Purch Amount YoY Icon | ||
| Purch Discount YoY CF | Purch Discount YoY CF | ||
| Purch Discount YoY Icon | Purch Discount YoY Icon | ||
| Purch Quantity YoY CF | Purch Quantity YoY CF | ||
| Purch Quantity YoY Icon | Purch Quantity YoY Icon | ||
| Purch Unit Price YoY CF | Purch Unit Price YoY CF | ||
| Purch Unit Price YoY Icon | Purch Unit Price YoY Icon |
Tech\Formatting\IBCS
| Measure (EN) | Measure (DE) | Format | Description |
|---|---|---|---|
| Purch Amount Delta | Purch Amount Delta | #,##0 | Order Amount excl. Discounts (Status Open) |
| Purch Amount Delta % | Purch Amount Delta % | #,##0 % | Order Amount excl. Discounts (Status Open) |
| Purch Amount DeltaColor | Purch Amount DeltaColor | ||
| Purch Amount GreenMax | Purch Amount GreenMax | #,##0 | |
| Purch Amount MaxValue | Purch Amount MaxValue | #,##0 | |
| Purch Amount Plan | Purch Amount Plan | ||
| Purch Amount RedMax | Purch Amount RedMax | #,##0 |