General Product Q&A

Hello,  I'm attempting to create a data connection via .xlsx file on my computer. I created a space and then made the data pool connection alias. However, once i select "Connect to Data Source" and successfully connect my data, it does not proceed to make the connection.  Can you please help and or instruct me on the correct method to complete the next steps? (See images below)  Once I selected Esc, the remains equivalent to image one, any help is greatly appreciated.  Thanks!!

How to change the activity order?

Hello, I have a excel database where there is a date column. I try to change the format of this column using this function :CAST( column_name AS timestamp) But it shows me a lot of empty value and its not supposed to... For some raws its working but not all of themDo you have an idea ?

How to change my account as partner account?

Hello all, I have tried to manipulate the timestamp in SQL, which worked on our Oracle server, but seems to have no effect on the back end in EMS. I suspect there is some kind of time zone problem? I have attached a few screenshots. The timestamp should have the following format:Original: YYYY-MM-DD 00:00:00 --> manipulated YYYY-MM-DD 23:45:00 Thanks for your answers in advance. With kind regardsChristoph EMS not working Local Database the SQL query works   

In the analysis I've a kpi related to a 90th quantile that displays a value = 19.01, some filters are applied. Without any filter, the value is 19.49. Since I need to compare every instance in a table with that value, I stored it in a static value variable, that for some reasons shows the value 18.70. Another strange thing is that if I enter the code editor of the variable, the value displayed is 19.49, so coherent with the not filtered one in the analysis. Why it show me 18.70 outside the editor? And how I can apply the same filters on the variable in order to show the correct value of 19.01? (using case when condition met then compute quantile does not work, since there is the aggregation function error). Thanks! 

Hello, I am using the Query Data module in an Action Flow. The output of the various date fields appears as below - instead of a regular date format like YYYY-MM-DD. How can I change the output of the column in Query Data?

Hi, i am just starting to familiarise myself with Celonis and have started with the Celonis Academy. Now I have a simple question.  Currently I have this formula: COUNT(DISTINCT "OCH_Cases". "Party_Request_KEY")I want only values greater than 2 to be displayed. What should the formula look like then? Best regardsRene

What does dotted line means in the Process explorer?

I wanted to build an automated report tracking the number of logins / usage in celonis. How to do that? I know log gets created for all the activites in celonis. But I wanted to build the report out of that. Is it possible to do that in celonis.

What does it mean if my happy path throughput time is more than average throughput time of the Process? Suppose my process takes 50 days in average, but my happy path takes 60 days. Is it bad?

Hi all, My interest is to calculate the THROUGH PUT time for all the desired set of process flows. I would like to view the distribution over a BOX PLOT. I am using the below approach.CASE WHEN PROCESS EQUALS 'event A' TO ANY TO 'eventB' then 'Process1'WHEN PROCESS EQUALS 'event B' TO ANY TO 'eventC' then 'Process2'ENDThe above formula will act as dimension axis for my box plot. I am calculating the tp time accordingly. However, since most of my cases(for e.x. 97%) satisfy the first condition, i cannot seem to calculate the tp time independently for other event or process correctly. The tp is calculated only for the remaining cases.Kindly suggest any other approach for the same. Thank you in advance :)

any function used in pql to calculate days between the two date column such as in excel networkdays does (consider start date and end date , exclude weekends, ignore timestamps)

Is there any function in PQL which calculate days such as networkdays (used in excel and it will ignore timestamps, exclude weekends ,conside start and end date )does?

Dear Experts , We wanted to understand the possibility of integrating Celonis EMS platform with third party BPM application like ARIS Connect to transfer discovered BPMN model from Celonis EMS to ARIS BPM application. Thanks in Advance. Regards,Navalan Veerapandian

What is the difference between an eventlog and digital footprint?

Imagine you speak with a client at a first meeting of Process mining. They ask you What is the benefit of Process mining ? How it works? What is Process mining? How would you convince them it is useful? Which arguments would you use?

Hi,I am trying to leverage the existing P2P cockpits for KPIs and Dashboards. There is an KPI which has definition as below - WHEN ISNULL(<%= VAR_KPI_DELIVERY_TYPE %>) = 1 //         -- Date Selection           AND PU_FIRST("EKPO", "<%= VAR_GS_ACTIVITY_TABLE %>"."EVENTTIME", "<%= VAR_GS_ACTIVITY_TABLE %>"."ACTIVITY_EN" = '<%= VAR_ACTNAME_CREATE_POI %>') >  {p1}        AND PU_FIRST("EKPO", "<%= VAR_GS_ACTIVITY_TABLE %>"."EVENTTIME", "<%= VAR_GS_ACTIVITY_TABLE %>"."ACTIVITY_EN" = '<%= VAR_ACTNAME_CREATE_POI %>') <= {p2}        THEN NULL         //Here there are 2 parameters p1 and p2. The values are blank for those parameters. I am not sure what values to be given for those. Can you please help me here?

Dear All, In my system report , CASE ID - Truck No , Activities , Time stamp are in column because of this , Error found in CSV/XLSX Upload screen. How to convert my report to upload in EMS format. Regards Rajkumar Pitchiah CMILT , CLTD , LSSBB Chief Digital Transformation officer – CDO  http://www.inspiretechnopark.com

What is the difference btw. an event log and a digital footprint?

Looking to add a variant explorer in the Views based on my knowledge model.  Similarly - is it possible to have a case explorer?  I believe I can create an analysis linked to the Knowledge model, but then I don't seem to have the ability to select the case table I want to use in the explorers...

In Detail I want to know how I could get the times of my (20) activities (P2P-Process from Celonis). Specially the time between the activities without working in an activity and the time which is needed only for the progress itself.

Hello everyone,  i would like to build Line Chart from this following data structure:   I would like to set up the line chart with different lines with dates on the x axis and each line presents an group of column A, where Column B are the y-values for the corresponding x value.  I tried "CASE WHEN column A = 'AA' THEN Columb B END" as KPI and date as dimension but it doesnt work since the NULL values for BB and CC in Column A are still presented in the line chart. Also a component filter did not work with it.  Thank you for every help. Best regards, Jurgen