General Product Q&A

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

hello to everyone, is there an example how action flows interact with rpa ?

Hi, can someone help me with a filter script. I need to show a KPI with a date filter for today at 5:00 am. The client wants to see a snapshot every day of the cases open at 5:00 in the morning. Thank you, Denise

CASE WHEN "AE_SIGNALS"."AE_SKILL_NAME" LIKE ('%Veredelung%') THEN COUNT ( "AE_SIGNALS"."SIGNAL_ID" ) * 30 / 60 ELSE NULL ENDI get the following error:The aggregation function COUNT cannot be used together with a dimension function input. Please check that there are no aggregations and dimensions used together as function inputs.

I wanted to create a KPI with reference to Variable <%= Discount %> (Users could define their Discount value). For example KPI as Actual Sales: (KPI (Sales)- KPI(Sales)* <%= Discount %>)).I'm able to create it in Analysis by defining Variable and adding the VARIABLE INPUT (Users may add their discounted values) Component however not in Views.

Slider Bar component like below:

Is it possible to create a Gantt chart like the image?If so please tell me how. Thanks!

I assumed one is actual data size and the other is allocated storage space, but that does not seem to be the case as in some cases A>B and in some B>A.

I loaded data into EMS (C4C+) from an Excel file, using the Quickstart for CSV/XLSX. The load works Ok, but when I try to do an Export Data from an Analysis component, I get the error message "Failed! Bad Request. Data Export is not supported". How can I resolve this issue? (The export to Excel is activated in the Analysis Settings). If I try the same steps using a model I created from scratch, the export works fine. Regards,Pablo

Anybody has been able to use KM from an Analysis?  I am trying but, although I can use any KPI defined in the KM, I can not use a Record from an Analysis (i.e. in a OLAP table)

After last year the system update, I uploaded a file and then clicked the action button, which kept showing file status failed. I tried to use the file that successfully uploaded and generated the flowchart in studio, but it also showed failure. The failure reason of this case is in the picture below the text. Please see how I should deal with it. Could you please give me a copy of the latest template format file for reference.Many Thanks!

Hello everyone, I am writing here because I couldn´t solve my issue with other questions asked. My Situation: I have an OLAP-Table with a lot of Data and dates regarding finances.Now I want to add an Input Variable where User can input a single date.Depending on that input, the OLAP-Table should change (2 columns)The field is OPTIONAL and I am struggling with handling the case of "null" as input. My current idea: FILTER "Table"."SomeDate" >=  CASE WHEN <%=DATE_OPEN_ITEMS%> is not NULL      THEN TO_DATE( <%=DATE_OPEN_ITEMS%>, FORMAT ( '%d-%m-%Y' ) )     ELSE ignore the filter all together     END;  Now if I type in '31-12-2022' it works great! But 1. If the input field is empty there is an errorand 2. the User has to use ' ' while typing it in. Any ideas? Thanks! 

Hi Celopeers,In My Activity table , 1 case has 10 Activities. I am creating a report in which I need only 6 out of this 10 Activities. So, I introduced a Compound Filter and restricted the not-required 4 activities. Now, I was asked to find out the time taken between activities. I used the PQL query 'DATEDIFF (hh, ACTIVITY_LAG ( "_CEL_CS_ACTIVITIES"."EVENTTIME", 1),"_CEL_CS_ACTIVITIES"."EVENTTIME" ) - It has two issues. Due to Compound filter, the 4 activities are not showing up (which is the requirement), but the above PQL calculates the DateDiff for the 10 all Activities. So,When the 6 Activities showing up in the report, the DateDiff does not makes sense, that's because datediff is calcalated for all the 10 activity at the background. Any thoughts on how can I fix it? 2.Activity A happens at Jan 10th 8 O'clock.Activity B happens at Jan 11th 10 O'clock.DateDiff of Hour function gives only the value as 2. But logically it should

How can we create second Process Explorer in my Analysis?

Are there any experience reports from the connection of the Data Warehouse to Celonis?I want to connect the data warehouse and still have some questions about the concept. Have you created an intermediate database and duplicated the required tables? Or did you let Celonis access the entire data warehouse directly? I would be pleased if suggestions were made here, taking data security into account.