Skip to main content

Celonis Product Documentation

Validating KPIs for the object-centric Inventory Management Control Center app

In the Inventory Management Control Center app’s Knowledge Model “Knowledge Model”, check that all the KPIs (key performance indicators) contain the correct business logic for your organization.

The main Knowledge Model for the Inventory Management Control Center app is “Knowledge Model”, which is at the top level in the app package. Work with this Knowledge Model to validate and change KPIs. “Knowledge Model” points to the base Knowledge Model stored in the Celonis Marketplace, which you can’t update directly. Changes that you make to the PQL formulas, KPI names, or formatting in “Knowledge Model” override the base Knowledge Model.

Each KPI in a Knowledge Model contains a PQL (Process Query Language) formula. Some KPIs are reused inside other KPIs as nested formulas. When you adjust the business logic in a single formula, and save it, the change is simultaneously reflected in all the KPIs that reuse the formula.

You work with Knowledge Models in Studio, and any changes you make are applied when you publish a new version of the app. You’ll need Analyst permissions on Studio and the Knowledge Model to modify any of the KPIs and their calculations. If you need training, check out the training track “Build Knowledge Models and Views” on the Celonis Academy.

Here’s how to work with the KPIs in “Knowledge Model”:

  1. In the Celonis navigation menu, select Studio.

  2. Find the Inventory Management Control Center app in your Studio space navigation.

  3. Expand the package’s structure using the arrow.

  4. Select “Knowledge Model”.

  5. Select the KPIs section of the Knowledge Model.

  6. You can sort and search the KPIs using their name or ID. The prefix to the ID shows what type of component they are. At the end of these instructions, we’ve noted the most important KPIs to check.

  7. To see and edit the full PQL formula and other settings for a KPI, click its row to open an editor. The editor automatically validates any changes that you make in the PQL formula.

  8. If you want a fuller-featured PQL editor that lets you select from the tables and columns in your data, click on the pen icon next to the PQL formula.

  9. If you need to disable a KPI or formula, click the three vertical dots at the top of the editor, and select Disable Scope, then click Disable to confirm. When you do this, the object can't be accessed or used anywhere in the package, including by other apps that depend on it.

  10. If you make any changes to the business logic used in a KPI, update the end user documentation in the app’s Documentation folder.

  11. When you’ve made changes to the KPIs, use the Publish Package button at the top of the screen in your Studio space to publish a new version of the app.


The in-app documentation that you can find using the “About this View” button in the Control Center view has information about the KPIs used in the tab and their calculations. Here’s the descriptions and the matching KPI IDs from the Knowledge Model:

Table 20. KPIs surfaced in the Inventory Management Control Center app



KPI ID in Knowledge Model

Excess Inventory Rate

The percentage of inventory on hand (i.e. total stock) which exceeds current target stock. Target stock is computed based on safety stock and cycle stock


Material Availability

The average share of days on which a given material has had a stock greater than zero in a given timeframe. The time period considered for evaluation is given in parentheses, for example (1y) limits the input to the last twelve closed months


Turnover Rate

The total consumption divided by the average inventory across the same time period based on valuated stock and consumption. Consumption is defined as the amount of consumed inventory in the considered timeframe


Service Level

The share of Sales Orders delivered between one day before and one day after the confirmed date during the considered timeframe


Days of Cover

The amount of days a particular material would have stock based on historical consumption levels, if no other replenishment took place


Supplier Reliability

The share of purchase orders received between five days before or one day after the scheduled date during the considered timeframe


Production Adherence

The share of Production Orders completed between one day before or one day after the scheduled date during the considered timeframe


Here’s a summary for the most important KPIs as they appear in the Knowledge Model:

Table 21. Main KPIs in the Knowledge Model for the Inventory Management Control Center app


Formula description


Business logic for stockouts -  identifies a stockout if inventory on hand and consignment stock are zero while safety stock is greater than zero


Business logic for under stock - identifies under stock if inventory on hand is between zero and safety stock, or if inventory on hand is zero while there is still consignment stock available


Business logic for excess stock - identifies excess stock if excess inventory rate is greater than zero but smaller than 100%


Business logic for obsolete stock - identifies obsolete stock if excess inventory rate equals 100% and there is no future demand


Business logic for untouched stock - identifies untouched stock as minimum unsold stock level if said minimum is greater than safety stock


Computes overall inventory classification


Identifies open planned orders


Identifies open purchase requisitions


Identifies open purchase orders


Identifies open production orders


Identifies if a material reservation is open


Identifies open sales orders


Identifies if an independent material requirement is open


Indicates if a purchase order was received early, on time, or late - used to compute supplier reliability KPIs


Indicates if a production order was completed early, on time, or late - used to compute production adherence KPIs


Indicates if a sales order was shipped early, on time, or late -  used to compute service level KPIs (this logic is identical to the “On Time Deliveries” in the Celonis Order Management apps)

While stockout and under stock scenarios rely on “hard values” like no inventory or a certain safety stock, the threshold for excess or obsolete stock is determined dynamically based on actual replenishment lead times and consumption. This threshold is referred to as “target stock”. Here’s the KPIs that influence it:

Table 22. KPIs influencing Excess Stock


Formula description


Share of excess in a material’s inventory


Threshold to excess stock - computed by adding current safety stock to initial stock (sometimes also referred to as cycle stock)


Total of consumed quantity for a material in a given time period


Actual replenishment lead time (Purchasing or Production) of a Material Plant combination - used if no past orders are available to compute an actual value


Planned replenishment lead time (Purchasing or Production) of a Material Plant combination - used if no past orders are available to compute an actual value