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.


Formula description


Business Logic for Stockouts


Business Logic for Under Stock


Business Logic for Excess Stock


Business Logic for Obsolete Stock


Business Logic for Untouched Stock


Business Logic for Stockout during Replenishment Period


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.