Celonis Product Documentation

In order to correctly apply the logic that defines the content of the Starter Kit different variables, KPIs and filters need to be configured and validated. The following section will guide you through the App configuration process, with a main focus on the KM configuration and variable configuration.

1. Variable configuration

To start with the variable configuration, please go to the "Settings" page first and then to the settings pages of each usecase tab (Touchless Orders, On-time delivery, ...). Go through the current value in the descriptions and validate whether the input used for the variables is correct for your business needs. To view all variables in use, you can navigate to the variables section of the package settings.

In some cases, variables are used are for storing values (strings, integers, etc.) that are used inside of KPIs and inefficiencies, such as the Late Delivery Buffer, for storing target and benchmark values of KPIs and frequently used activity names like the goods issue activity. Some variables are more important than others to update, in the sense that the business logic of the app will not work if they are not set correctly. An example is the variables that reference different fields and activity names, e.g. the ‘Record Goods Issue' activity. On the other hand, all variables are set with a default value and, in some cases, the app will still function properly if they are not updated, e.g. the ‘days late threshold’. If you identify some variables that need to be adjusted, you can easily update them directly with the dropdowns. If you cannot find the dropdown, then search for the variable in the KM that is connected to the package variable that you are looking for (then take into account that changing the value of the dropdown won't affect any longer the KPI).

2. 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_ORDER_INDICATOR_DELIVERY_BLOCK_BUSINESS_LOGIC is used for all delivery block KPIs (e.g. Sales orders with Delivery Blocks, Delivery Block Rate, etc..) 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.

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.

3. Value Discovery App Configuration (only if required)

In order for the Value Discovery (VD) App to work, some modifications to the Data Model have to be made as well as to some of the runtime variables.

3.1 Modifications to the Data Model

The VD App needs a new table in the DM and the process to add it is the following:

DROP TABLE IF EXISTS INEFFICIENCIES;
CREATE TABLE INEFFICIENCIES (
  INEFFICIENCY_NAME VARCHAR(100),
  TIME_TO_VALUE VARCHAR(100),
  BUSINESS_OBJECTIVE VARCHAR(100)
);
 
INSERT INTO INEFFICIENCIES
    (INEFFICIENCY_NAME,TIME_TO_VALUE,BUSINESS_OBJECTIVE)
 
    SELECT 'Manual Order Creations','B - Medium','Labor Productivity' UNION    
    SELECT 'Customer Cancellations','C - High','Revenue' UNION    
    SELECT 'Late Deliveries','B - Medium','Working Capital' UNION    
    SELECT 'Manual Delivery Blocks','A - Low','Labor Productivity' UNION    
    SELECT 'Unbilled Orders','A - Low','Revenue' UNION    
    SELECT 'Returns','B - Medium','Revenue' UNION    
    SELECT 'Manual Credit Blocks','A - Low','Labor Productivity' UNION    
    SELECT 'Late Billing','A - Low','Working Capital' UNION    
    SELECT 'Manual Delivery Date Changes','B - Medium','Labor Productivity' UNION    
    SELECT 'Seller Rejections','C - High','Revenue' UNION    
    SELECT 'Manual Billing Blocks','A - Low','Labor Productivity' UNION    
    SELECT 'Manual Invoice Creations','B - Medium','Labor Productivity' UNION    
    SELECT 'Manual Price Changes','B - Medium','Labor Productivity' UNION    
    SELECT 'Manual Delivery Creations','B - Medium','Labor Productivity' UNION    
    SELECT 'Manual Quantity Changes','B - Medium','Labor Productivity';

Here are some most commonly asked questions regarding the Order Management Starter Kit.