Updating the Business Logic
The business logic is packaged into formulae (KM KPIs) to reuse in the different parts of the app or inside of other KPIs/formulae to make the setup more concise. These PQL-statements define the calculations of KPIs, filter statements on your data, and inefficiencies. Hence they are one of the most important parts of the app.
For example, the formula KPI_MATERIAL_PUSUM_EXCESS_INVENTORY_RATE is used for all excess inventory KPIs (e.g. Obsolete Stock, Excess Stock, etc.). By adjusting the underlying business logic in that one place, you adjust the business logic for all KPIs and related definitions simultaneously.
This list is not exhaustive and should be checked inside of the Knowledge Model. Make sure to also check nested formulas that might be used within the KPIs listed below. You can identify by the prefix whether it’s defined as KPI or formula.
KPI ID | Formula description |
|---|---|
FORMULA_MATERIAL_INDICATOR_STOCK_OUT | Business Logic for Stockouts |
FORMULA_MATERIAL_INDICATOR_STOCK_UNDER | Business Logic for Under Stock |
FORMULA_MATERIAL_INDICATOR_STOCK_EXCESS | Business Logic for Excess Stock |
FORMULA_MATERIAL_INDICATOR_STOCK_OBSOLETE | Business Logic for Obsolete Stock |
FORMULA_MATERIAL_INDICATOR_STOCK_UNTOUCHED | Business Logic for Untouched Stock |
FORMULA_MATERIAL_INDICATOR_STOCK_OUT_DURING_REPLENISHMENT | Business Logic for Stockout during Replenishment Period |
FORMULA_MATERIAL_INDICATOR_SERVICE_LEVEL_STOCKOUT_SALES_ORDER | Business Logic for Upcoming Demand without Supply |
If you update the underlying business logic or used variables, make sure to also update the documentation for the business users in the Documentation folder.