Table of Contents

Inventory KPIs & Measures

Catalog of the 106 measures shipped with the Inventory 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.

Counts

Measure (EN) Measure (DE) Format Description
# Items Issue # Artikel abgegangen #,##0 Number of Items issued
# Items OnHand # Artikel vorrätig #,##0 Number of Items on stock
# Items OnHand (having Transactions) # Artikel vorrätig (mit Bewegung) #,##0 Number of Items (with transactions) on stock
# Items OnHand PY # Items OnHand PY #,##0 Number of Items on stock
# Items OnHand YoY # Items OnHand YoY #,##0 Number of Items on stock
# Items OnHand YoY % # Items OnHand YoY % #,##0 % Number of Items on stock
# Items OutOfStock # Artikel nicht vorrätig #,##0 Number of Items out of stock
# Items OutOfStock % # Artikel nicht vorrätig (%) #,##0 % Share of out of stock Items
# Items OutOfStock (all Items) # Artikel nicht vorrätig (alle Arikel) #,##0 Number of Items out of stock (considers all items maintained)
# Items Receipt # Artikel zugegangen #,##0 Number of Items receipt
# Items without Transactions # Artikel ohne Bewegung #,##0
# UniqueItems # Artikel #,##0
# UniqueItems ATD # Artikel ATD #,##0 Number of Items with any transaction in data-history

Inventory KPIs

Measure (EN) Measure (DE) Format Description
Reach % Lagerreichweite (%) 0\ %;-0\ %;0\ %
Reach (Days) Lagerreichweite (Tage) #,##0 average days to run out of stock (in case nothing will be receipt/produced)
Reach (Days) PY Lagerreichweite (Tage) PY #,##0
Reach (Days) YoY Lagerreichweite (Tage) YoY #,##0
Reach (Days) YoY % Lagerreichweite (Tage) YoY % #,##0 %
Turnover Rate Lagerumschlag #,##0.0 Issued Quantity in selected period / Ø OnHand Quantity
Turnover Rate (per Yr) Lagerumschlag (pro Jahr) #,##0.0 Issued Quantity in selected period / Ø OnHand Quantity scaled on a Year
Turnover Rate (per Yr) PY Lagerumschlag (pro Jahr) PY #,##0.0
Turnover Rate (per Yr) YoY Lagerumschlag (pro Jahr) YoY #,##0.0
Turnover Rate (per Yr) YoY % Lagerumschlag (pro Jahr) YoY % #,##0 %

OnHand KPIs

Measure (EN) Measure (DE) Format Description
OnHand CostAmount Adjustment Lagerwert Regulierung #,##0
OnHand CostAmount Posted Lagerwert #,##0 cumulative Cost Amounts posted to general ledger
OnHand CostAmount Posted PY Lagerwert PY #,##0
OnHand CostAmount Posted YoY Lagerwert YoY #,##0
OnHand CostAmount Posted YoY % Lagerwert YoY % #,##0 %
OnHand CostPrice Einstandspreis Vorräte #,##0 cumulative Cost Price (cum. Cost Amount / cum. Quantity)
OnHand CostPrice PY Einstandspreis Vorräte PY #,##0
OnHand CostPrice YoY Einstandspreis Vorräte YoY #,##0
OnHand CostPrice YoY % Einstandspreis Vorräte YoY % #,##0 %
OnHand Quantity Vorrätige Menge #,##0 cumulative Quantity of inventory movements
OnHand Quantity EndPeriod Vorrätige Menge Periodenende #,##0
OnHand Quantity PY Vorrätige Menge PY #,##0
OnHand Quantity StartPeriod Vorrätige Menge Periodenbeginn #,##0
OnHand Quantity YoY Vorrätige Menge YoY #,##0
OnHand Quantity YoY % Vorrätige Menge YoY % #,##0 %
∅ OnHand Duration (Days) Ø Lagerdauer (Tage) #,##0 Average days of Items in stock, derived from Turnover Rate (per Year)
∅ OnHand Quantity Ø Vorrätige Menge #,##0 Average stock quantity within selected period (On Hand quantity beginning of period + On Hand quantity end of period / 2)
∅ OnHand Quantity PY Ø Vorrätige Menge PY #,##0 Average stock quantity within selected period (On Hand quantity beginning of period + On Hand quantity end of period / 2) previous year
∅ OnHand Quantity YoY Ø Vorrätige Menge YoY #,##0
∅ OnHand Quantity YoY % Ø Vorrätige Menge YoY % #,##0 %

Transaction CostAmounts

Measure (EN) Measure (DE) Format Description
CostAmount Adjustment Kosten (reguliert) #,##0
CostAmount Adjustment PY Kosten (reguliert) PY #,##0
CostAmount Adjustment YoY Kosten (reguliert) YoY #,##0
CostAmount Adjustment YoY % Kosten (reguliert) YoY % #,##0 %
CostAmount Physical Kosten (physisch) #,##0
CostAmount Posted Kosten (gebucht) #,##0
CostAmount Posted PY Kosten (gebucht) PY #,##0
CostAmount Posted YoY Kosten (gebucht) YoY #,##0
CostAmount Posted YoY % Kosten (gebucht) YoY % #,##0 %
CostPrice Einstandspreis #,##0
CostPrice PY Einstandspreis PY #,##0
CostPrice YoY Einstandspreis YoY #,##0
CostPrice YoY % Einstandspreis YoY % #,##0 %

Transaction Quantities

Measure (EN) Measure (DE) Format Description
Quantity Menge #,##0 Quantity of Transaction
Quantity Issue Menge Abgang #,##0 Quantity of Transaction of all Issued Transaction Status
Quantity PY Menge PY #,##0 Quantity of Transaction Previous Year
Quantity Receipt Menge Zugang #,##0 Quantity of Transaction of all Receipt Transaction Status
Quantity Transfer (Issue) Menge Umlagerungsabgang Quantity of Transaction of all Issued transfer movements
Quantity Transfer (Receipt) Menge Umlagerungszugang Quantity of Transaction of all Receipt transfer movements
Quantity YoY Menge YoY #,##0 Deviation of Quantity compared to Previous Year
Quantity YoY % Menge YoY % #,##0 % Deviation of Quantity compared to Previous Year in %

General

Measure (EN) Measure (DE) Format Description
Adjustments Label Adjustments Label
Cost Price development Label Cost Price development Label
Inventory Movements Label Inventory Movements Label
InventoryCostAmountAdjustmentTargetCurrency InventoryCostAmountAdjustmentTargetCurrency
InventoryCostAmountExpectedTargetCurrency InventoryCostAmountExpectedTargetCurrency
InventoryCostAmountPhysicalTargetCurrency InventoryCostAmountPhysicalTargetCurrency
InventoryCostAmountPostedTargetCurrency InventoryCostAmountPostedTargetCurrency
InventoryQuantityBase InventoryQuantityBase
Item Label Item Label
ItemPage Label ItemPage Label
Last Refresh Label Last Refresh Label
Location Label Location Label
LocationsPage Label LocationsPage Label
On-Hand / Stock development Label On-Hand / Stock development Label
OverviewPage Label OverviewPage Label
Period Label Period Label
QAPage Label QAPage Label
Report Label Report Label
Statistics byItem Label Statistics byItem Label
Statistics byLocation Label Statistics byLocation Label
Today Label Today Label
Unit Label Unit Label

Tech

Measure (EN) Measure (DE) Format Description
App Version App Version
Current User Current User
DaysInFilter Tage gefiltert Number of days within selected filter period
DynMeasure DynMeasure
EffectiveDate Datum (effective)
InventoryRowCount # Lagerbuchungen Count of inventory transactions
Last Refresh Letztes Update
Last Refresh Card Last Refresh Card
MeasureDumpFilter MeasureDumpFilter
Today Card Today Card

Tech\Formatting

Measure (EN) Measure (DE) Format Description
# Items OnHand YoY CF # Items OnHand YoY CF
# Items OnHand YoY Icon # Items OnHand YoY Icon
OnHand CostAmount YoY CF OnHand CostAmount YoY CF
OnHand CostAmount YoY Icon OnHand CostAmount YoY Icon
OnHand Quantity YoY CF OnHand Quantity YoY CF
OnHand Quantity YoY Icon OnHand Quantity YoY Icon
Reach (Days) YoY CF Reach (Days) YoY CF
Reach (Days) YoY Icon Reach (Days) YoY Icon
Turnover Rate (per Yr) YoY CF Turnover Rate (per Yr) YoY CF
Turnover Rate (per Yr) YoY Icon Turnover Rate (per Yr) YoY Icon
Edit this page