Skip to main content

Celonis Product Documentation

Updating the Business Logic

The business logic is packaged into formulas (KM KPIs) to reuse in the different parts of the app or inside of other KPIs/formulas 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.

To give you an example, the formula FORMULA_TOUCHLESS_ORDER is used in many different places like filters (FILTER_TOUCHLESS_PO), records and it attributes (PO_ITEMS.TOUCHLESS_CLASSIFICATION), KPIs (KPI_PO_ITEM_TOUCHLESS_ORDER_RATE_THIS_MONTH, KPI_PO_ITEM_TOUCHLESS_ORDER_RATE_LAST_MONT, KPI_PO_ITEM_TOUCHLESS_ORDER_RATE, KPI_PO_ITEM_TOUCHLESS_ORDER_COUNT) and it could be also used on flag as well.

So by adjusting the underlying business logic in that one place, you adjust the business logic for all KPIs and related definitions at once.

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 listed KPIs below. You can identify by the prefix whether it’s defined as KPI or formula.

Business Logic (KPI ID)

Description

FORMULA_TOUCHLESS_ORDER

Business Logic for Touchless Order

FORMULA_PO_ITEMS_MANUAL_ACTIVITIES

Business Logic for Manual Activities on Item Level

FORMULA_OTD

Business Logic for On-Time Delivery

FORMULA_THREE_WAY_MATCH

Business Logic for Three-Way Match

FORMULA_CONTRACT_USAGE

Business Logic for Contract usage

FORMULA_CATALOG_BUYING

Business Logic for Catalog Buying

FORMULA_PAY_TERMS_MISMATCH

Business Logic for Payment Term Mismatch

In case you update the underlying business logic or used variables, please make sure to also update the documentation for the business users in the Documentation folder.