General Product Q&A

How to pass an existing variable from button dropdown to OLAP table dimension in Celonis?

How to remove unused Microsoft Connection in Action Flows?

Hi, how do I achieve the following?My colleague as agreed to free up 50GB from an already running project of 80GB on C4C+ for my usageHow can I reduce the storage consumption of my colleague's project and allocate the now available 50GB to a project environment I will create?

Hi all,  when trying to upload my CSV file with my event log data I can upload it and see the actual data, however when trying to go to the next step i receive following error message (see below). Any idea on how to proceed here?  Thanks

Can we set up the component which will take into consideration the calendar days and all components are going to be filtered accordingly as it is not going to be based on any of the columns? 

OVING_MAX(COUNT( DISTINCT CASE  WHEN  DAYS_BETWEEN ( "BSEG"."AUGDT", ${INVOICE_DUE_AT}) >= - ${BUFFER_LATE} AND ${VARIABLE_RELEVANT_INVOICES_FOR_OTP} THEN ${VARIABLE_INVOICE_IDENTIFIER}  END) / COUNT(DISTINCT CASE WHEN ${VARIABLE_RELEVANT_INVOICES_FOR_OTP} THEN ${VARIABLE_INVOICE_IDENTIFIER} END  ),0,0)  I would like to create second part of this KPI- below only standard pay on time PQL formula

We have installed Celonis extractor in a virtual machine where Oracle database is already placed. We are experiencing a error in connection now. I would like to know whether if we can place extractor in same machine as that of Data source and have jdbc connection.

Is it possible to set Activity color in Process / Variant Explorer by formula? ...or by activity table field? It will be usefull in multilog scenario. Thanks, Alex.

Hi all, I have implemented the following sheet filter statement, which only applies a filter if at least one value is in a variable (selected through a dropdown): <% if(customer_selection != "") { %>  FILTER whatever; <% } %>  ---------------- However, when I try to add another statement like the above for a second variable within the same sheet load script, then NONE of the two conditional filter statements work.  Can someone provide me with the correct syntax to define multiple of the above conditional filter statements in one sheet load script?   -------------------------  A second question is whether it is possible and if yes what the correct syntax is to define a conditional filter statement like the following: <% if(search_pattern_selection LIKE "XYZ") { %> FILTER whatever;<% } %> Thus, not testing for emptiness but testing with a LIKE comparer if certain values are in a variable.    @david.beche12​ any input on the two questions?  Than

Hi, In the Celonis 'Solution Professional ' certification track, I can't click 'Proof Methodologies' course. When I tried to search and find, this course is NOT showing up. Can you pls help me on what I am missing here? Thanks!

I am also trying the Root cause analysis described in the Pycelonis tutorial from the top. https://celonis.github.io/pycelonis/1.6.0/tutorials/root_cause_analysis/01_Root_Cause_Analysis_Tutorial/ At the data model connection, I get a NameError when I specify a data model.I'm copying and pasting the data model ID, so I don't think it's wrong, but am I missing some operation?   The data model attempts to use this

How is that possible?With best regards,Elizaveta

How to send Vendor specific information emails dynamically to only that vendors according to their email setup using Action flows and skills ?

In sandbox, I am trying to build the analysis from demo data model of production. There are 2 data model, production planning and production. I am using the production one. Please help so that i can understand the data and build the analysis

i have a column that contains date and time , i only want to have time from that column , how can i get that using pql , Thankyou

do we have any Record to report case studies 

Does anyone use the function of simulation?・What process did you analyze?・What results have you seen?・For which KPIs were you effective? I would like to know what the benefits of using the simulation feature are and if it is actually useful.​

When creating the simulation, the following question came up with me.Could you please answer the questions?​1：When setting up Degital Twin, should I enter actual business hours for the From and To fields of Incoming Cases? Or, should I set the time when the process is running as configured in Degital Twin?​2：When setting up Degital Twin, what does the Incoming Cases case per day value mean?​3：When creating a Simulation scenario, is it sufficient to enter actual business hours in the From and To fields of Incoming Cases? Or should I set the time when the process is actually running?​4：​When creating a Simulation scenario, what does the value of Case per day in Incoming Cases mean?​

What are the different types of Extractor in Celonis?

As you can see below we have Ticket On Hold as always the starting point (with diff event time) and need to calculate the time diff. with the next following activities that can ONLY be - Ticket in Progress / Ticket - Waiting for Issue / Ticket Resolved (first one to occur after starting activity) As you can see from the example below we have to calculate 4 time differences:1) From Start 1 Ticket On Hold to End 1 - Ticket in Process2) From Start 2 Ticket On Hold to End 2 - Waiting for issue3) From Start 3 Ticket On Hold to End 3 - Ticket in Process4) From Start 4 Ticket On Hold to End 4 - Ticket Resolved 

Is there any document available for On Premise to EMS Migration?

Hi,How can I apply a conditional format color scale, based on the minimum and maximum values of an OLAP table that has aggregations like COUNT and SUM to calculate its values (similar to what is done by Excel)?  I've tried the background color mapping, but the options are specific values and not the minimum/maximum depending on the calculation of the table Thanks

Is it possible to perform predictive process monitoring the way tools like Apromore has integrated plugins to perform prediction of delivery time etc ?

I want to create a table which will auto increment the id. Identity is not working, do we have any other solution?CREATE TABLE production_categories (    category_id INT IDENTITY (1, 1) PRIMARY KEY,    category_name VARCHAR (255) NOT NULL);

Hi there I started the training track and within training "configure standard processs KPIs in the visual editor" the visual editor does not correspond to the training video (I am using the example PO data and successfull implremented examples so far)   What do I have to do to get to the visual editor?  Best regardsDieter