Celonis Product Documentation

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

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';

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