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:
Go to the Data Integration section of Celonis and select the Data Pool that you are using for the Starter Kit.
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".
Click New Transformation. We recommend naming it "Create Inefficiency Table" and without using a task template.
Copy and paste the sample code provided below.
Select all code and click the Execute button.
Go to the Data Model that you are using for the Starter Kit.
Add the INEFFICIENCIES table using the Add Tables button and then click Finish.
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' |