Skip to main content

Celonis Product Documentation

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.