General Product Q&A

The pricing model for C4C+ Execution is Business Users and Analysts. For customer "Analysts" what access is provided? Are they able to maintain the system or does that require another level of access? If another level of access is needed, is there a pricing category for this in C4C+ Execution?

How the Instream connector is used how do we capture the instream data event log while extracting those flat files in celonis. And also need what would be the activity flow for this data.

Hi there,I am getting this strange behaviour and was wondering if somebody can explain this?I want to create an activity for when NETPR in CDPOS changed to 0 but when I look for 0s the table is empty. Query 1: My first entry happens to be a case that I am looking for.    SELECT DISTINCT FNAME,VALUE_NEW from CDPOS    WHERE FNAME = 'NETPR'   ORDER BY VALUE_NEW   LIMIT 1    FNAME  VALUE_NEW   NETPR  0.00 Query 2: But I get an empty table when I use these conditions.     SELECT DISTINCT FNAME,VALUE_NEW    FROM CDPOS    WHERE FNAME = 'NETPR' AND VALUE_NEW = '0.00'    FNAME  VALUE_NEW   - Next I wanted to see if my VALUE_NEW = '0.00' might be wrong somehow.    Why do I get different smallest values '0.000' and '0.00' from query 3 and query 4 respectively? Query 3   SELECT DISTINCT VALUE_NEW from CDPOS   ORDER BY VALUE_NEW     VALUE_NEW    0.000    1.000 Query 4   SELECT DISTINCT FNAME, VALUE_NEW   FROM CDPOS   WHERE FNAME = 'NETPR'  ORD

We are trying to establish the connection using Oracle Cloud Connector between Oracle HCM-Recruiting and Celonis.We are able to establish connection successfully . When we are trying to access the tables in extraction, we can only see Finance tables and are unable to access any HCM tables

Hello,  I would like to provide analyses in German and English. But I would like to maintain only 1 analysis. Depending on the set user language, the correct variables should then be used. Name mapping is already used for descriptions and texts, but I haven't found a way to use it in variables. Is there a standard way to do this? Many thanks in advance, Stephan

Hi Team, I am facing an Issue with Time zone timings in multievent log data models.the issues is we are having a PO created in ASIA and SO in Europe and when we merger both activities then because of time zones the sequence of activities are not in order. Could you please help us if there a way to convert all the timestamps into one single time zone. Thanks,venkat N

Hello everyone, I'm currently wondering how the date picker exactly filters the dates within the P2P process. Since: "_CEL_P2P_ACTIVITIES"."EVENTTIME" refers to several activities for a single purchase order item, does it "cut off" PO's that have a single activity outside the defined range?  Let's say I filter only for the 1st of September and a single PO has 3 activities: one on 31st of August, one on the 1st of September and another one on the 2nd of September. Would the date picker then consider this order because a single activity lies within the specified time period or cut it off because one or more activities are out of the defined scope? Either way feels I little bit inaccurate.  Another question: How would I have to adapt the date picker to see only PO's for which the "Record Goods Receipt" lies between the specified time period? Thank you in advance and best regardsAram

Can we update the dates to appear in the descending order - so that the latest violations appear first before older ones?

IN specfic analysis the activity selection is not working, the list of activities is blank. How can I enadble it?

Hello all,i have the issue that I want to join two different tables based on a time filter. Table 1 describes different materials going to different Targets with an exact event-time.Unique-ID | Eventtime | Target 1|Unique-ID | Eventtime | Target 2|Unique-ID | Eventtime | Target 1| Table 2 is a status-table which is updated in irregular intervals (Date_1, Date_2, Date_3..) and contains for each Target a string with either Mode_A oder Mode_B.Target 1 | Date_1 | Mode_ATarget 2 | Date_1 | Mode_ATarget 1 | Date_2 | Mode_ATarget 2 | Date_2 | Mode_BTarget 1 | Date_3 | Mode_BTarget 2 | Date_3 | Mode_A I now want to join table 2 into table 1 and match the Mode-A to each unique-ID based on the condition, that the Eventtime is between the respective Date-Intervalls.  Any Idea how to solve this?

How can we create process models, using BPMN2.0, with Celonis?

Hi team Can any one explain me about the difference between aris process mining tools and celonis tool what features we have in celonis better than aris..

Hi everyone, Is there a way to find out the value that appears most often in the dataset? I could not find it in PQL references. Example Values in a Dataset2221035 In this example, the value 2 appears most often.  Looking forward to your replies. Many thanks and best regards,Thorsten 

Hi, I am trying to utilize Ratio of cases with certain process flow KPI, however I am permanently getting values which do not make sense to me. In attached pictures you can see, there's 221 cases out of 13943 which goes from V stage to V stage (about 1,6 %). However, when I try to get the ratio of such cases using KPI I get result 2,1 %, which is from my perspective incorrect. Any idea what is happening there? Tomas

I have created an OLAP table with a dropdown button where I can select dimension and I have linked the outcome of the conformance check by using:  READABLE (<%= conformance %>). I put a filter on it so that it doesn't include "Conforms". However, it now lists all deviations and I am only interested in the top 3. How do I limit it to only show the top 3 deviations per result?

Hi, in our celonis_integration PostgreSQL DB, we can see 4 different status (cpm_status) of data jobs: "ERROR", "NEW", "RUNNING", "DONE". I would like to understand what does status "NEW" mean? Can anyone help? Thanks!

I have a column chart component which displays for each status(activity) the number of cases for which this activity is the last per week. So in dimensions I have this kind of expression ROUND_WEEK("ACTIVITIES"."EVENTTIME") but I want to display for each week for each status(activity) the number of cases for which this activity is the last and from a week to another I want to sum the cases which have not moved to another activity. Is there a way to do that, so in dimensions I want to have a kind of calendar of all weeks and then according to the date of the activities I want to display what I explained above. Thanks in advance for your help !  

Hi there, intuitively I would have thought that this checkbox selects values that are NULL but this was not the case when I tested it. So what does it do? Kind regards,Sasa

hi, I would like to calculate number of cases that have some particular throughput time. I want to divide total number of cases for the cases that happened in less than 4 days and for hose that happened in more than 4 days. I tried to use avg but it calculates for all of the cases and put them all in one column. To be clear: there are cases with status "Closed" that have TT<4, but in the table I have 0 there (in column case count where TT<4)

Hello All, Is there any way to get the sum of the Throughput time other than what is there. For example want to group by with some activities, the throughput only available for the avg, median and mean. If we can get the sum of the same. 

Hi Team, I'm trying to build a KPI shows which column data has wrong fields. I'm using the KPI syntax as below but it is not working. Could you please help me on this case.CASE WHEN LEN ("TableA_xlsx_TableA"."Name") > 4 OR ("TableA_xlsx_TableA"."Name") IN_LIKE ('!','@','#','$','^','*','(',')','-','_','+','=','{','}','[',']','|','/',':',';','"','<','>',',','.','?','[%]') THEN 'Name, ' ELSE '' END ||CASE WHEN ("TableA_xlsx_TableA"."Country") IN_LIKE ('!','@','#','$','^','*','(',')','-','_','+','=','{','}','[',']','|','/',':',&#39

How to use OR in numerator and denominator while writing KPI in ratio format

Is there any way to integrate/add checkbox or any indicators into an OLAP table in an analysis ??

I want to get only numeric values from the column. I'm trying with the syntax '%[^0-9]%' but it is not working.