Skip to main content

Celonis Product Documentation

Value Discovery App Configuration (if required)

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

Modifications to the Data Model

The Value Discovery App requires a new table to be added in the Data Model using the following steps:

  1. Go to the Data Integration section of Celonis and select the Data Pool that you are using for the Starter Kit.

  2. Click Data Jobs and then click on New Data Job with the option to add it as a Global (no data connection). We recommend naming it "Create Inefficiency Table".

  3. Click New Transformation. We recommend naming it "Create Inefficiency Table" and without using a task template.

  4. Copy and paste the sample code provided below.

  5. Select all code and click the Execute button.

  6. Go to the Data Model that you are using for the Starter Kit.

  7. Add the INEFFICIENCIES table using the Add Tables button and then click Finish.

  8. Force a complete reload of the Data Model.

Sample Code
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 'Late Deliveries','C - High','Working Capital' UNION
   SELECT 'Contract Leakage','B - Medium','Spend Reduction' UNION
   SELECT 'Manual Price Changes','A - Low','Labor Productivity' UNION   
   SELECT 'Free-Text Orders','C - High','Spend Reduction' UNION   
   SELECT 'Free-Text Requisitions','C - High','Labor Productivity' UNION   
   SELECT 'Unfavourable Payment Term','A - Low','Working Capital' UNION   
   SELECT 'Spend w/o Contract Available','C - High','Spend Reduction' UNION   
   SELECT 'Retrospective POs','B - Medium','Spend Reduction' UNION   
   SELECT 'Price Increases','A - Low','Spend Reduction' UNION   
   SELECT 'Manual Delivery Date Changes','A - Low','Labor Productivity' UNION   
   SELECT 'Manual Quantity Changes','B - Medium','Labor Productivity' UNION   
   SELECT 'Manual PO Sending (EDI)','A - Low','Labor Productivity' UNION   
   SELECT 'Order Bundling','C - High','Spend Reduction' UNION   
   SELECT 'Manual Contract Changes','B - Medium','Labor Productivity' UNION   
   SELECT 'Purchase Order Deletions','B - Medium','Labor Productivity' UNION   
   SELECT 'Manual PR Creation','A - Low','Labor Productivity' UNION   
   SELECT 'Manual PO Creation','A - Low','Labor Productivity' UNION   
   SELECT 'Invoices w/o PO','B - Medium','Spend Reduction';
Updating the Run Time Variables

Next, configure the runtime variables in the table below to your specifications.

Variable ID

Variable Description

Default Value

NetOrderValue

Select the dimension that refers to the Net Order Price on the Data Model. We suggest using (EKPO.NETWR) as all currencies are translated into a common one.

(EKPO.NETWR)

fte-cost-annual

Annual cost of a full time employee.

55000

fte-hours-annual

Number of working hours of a full time employee in a year.

1800

manualuser

Considered Manual User from USR02. USTYP.

'A'