Product Q&A

We have a ServiceNow analysis and the business would like to know how long tickets are spending in a series of states. We are trying to analyse if we are putting calls on hold for too long. We are looking to do two things. For any set of tickets give me the total time this ticket has spent in a particular activity. So the event time of this activity until the next activity. The ticket may be in this state more than once through it's process journey. There are more than one of these states. Report on any tickets that have exceeded a specific threshold of time in one of these states. So the flow might go Ticket Created - Time 1Ticket On Hold - Time 2Ticket Active - Time 3Ticket On Hold - Time 4Ticket Active - Time 5Ticket Resolved - Time 6 I'm looking for the total time between Time 2 & Time 3 added to the time between Time 4 and Time 5. I cannot see a way to do this. Any ideas greatly appreciated.  

Hi All  We have created a custom REST API to pull data into Celonis. This is working well for full data extractions. How do we create and use a variable within the API rest query to enable delta extract? ie. We want a way to replace the text in {{}} with the last date within the datamodel: http://xxx.service-now.com/api/now/table/sys_audit?sysparm_display_value=true&sysparm_query=tablename=interaction^sys_created_on>javascript:gs.dateGenerate({{MAX DATE FROM MODEL}}','00:00:00')^ORDERBYsys_created_on&sysparm_offset=0&sysparm_limit=1000 thanksDavid

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

connecting uipath using API Key

Hello, In the process explorer analysis the dropdown component supports multi value paste, is it possible to do this in the studio (even if using a diferent component). Exemple: Use case: the user copies a number of clients from a diferent aplication, pastes these in the dropdown and the analysis is filtered for thoses clients. Kind regards,João

Imprementation TrackProcess Connection Basics  Exercise: Extract Data - Create Extraction TRAINING.EKKO Suggested solution: EKKO.AEDAT >= '01.06.2014’ Configure columns: AEDAT == STRING Extraction Preview: AEDAT(1) ==  2016-05-02 00:00:00.0 Doesn’t work:1.     EKKO.AEDAT >= '01.06.2014’2.    EKKO.AEDAT >= '2014-06-01 00:00'3.    EKKO.AEDAT >= '2014-06-01 00:00:00.0' Filter contains a data type mismatch. Column "AEDAT" has data type: " DATETIME". You supplied an value of type: "STRING". Please adjust your value. 4.    AEDAT >= DATETIME('2014-06-01 00:00:00.0') Error parsing filter: AEDAT >= DATETIME('2014-06-01 00:00:00.0') caused by: Encountered " <LIST_STRING> "(\\'2014-06-01 00:00:00.0\\') "" at line 1, column 18. Was expecting one of: <EOF> "AND" ... "OR" ... 5 .  AEDAT >= DATE('201

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

Dear All, I am looking for a similar functionality to sparklines in excel. This means I want to look at the trend for the sales price value development. But this should be represented as a single KPI for example using a math function. That gives us the gradient of the trendline. Thank you

In conformance history, we have the month wise intervals based on the selection criteria in the top. Need to know how to get the history on a daily or weekly intervals. image1735646 60.4 KB

Hello, has anyone had any experience in payroll process mining? The data is in Mepco software. I could not find any apps in the app store rather than recruitment process in HR. What I am interested in is mining the payroll process of HR from Mepco. Thanks

Is there an inbuilt process connector for SAP Success Factor in Celonis IBC

Please help from which table we can get the Comment section of the Action Engine, please find the attached screenshot. The Commented Text, the user commented and the timestamp it has been posted Background for this requirement: To understand the usability of the Action Engine created an Analysis taking the help of the Action Engine Tables like Event, Signal Attributes, Skills and others. Need to capture the Comment added by the user in any particular signal.

Hi all, I have the following issue: I have 2 tables Table1: articlenumber, Table2: articlenumber, I have no key defined in data model due to other reasons. Is it possible to define the key in the analysis, e.g. by using the pullup function so use both tables together (e.g. to find out how many articles are in table1 but not in table 2? Many thanks and br Daniel

Hi, Im getting a graphical bug where a table with horizontal scrolling in a fixed width sheet wont scroll to the end. Here is what it looks like. Untitled picture918358 6.82 KB Does anybody have a solution?

Hello, I am trying to filter observations in particular column which begins with SYS or ENG while counting (Number KPI). How can I do it with Celonis? I have read about MATCH_PROCESS_REGEX, but did not quite get it. Please help

Hello, Celonis community and team, this is our first C4C project. We have provided the client with a Celonis ABAP-Skript and used the SAP ABAP Output Uploader. In the third stage Processing, some of the 86 SAP tables could not be processed. The following issues arise for the respective tables: EINA: Convert to parquet failed. The following chunks could not be processed: EINA_1_20201203_155035.csv, EINA_1_20201203_154720.csv, EINA_0_20201203_155035.csv, EINA_0_20201203_154720.csv EINE: Convert to parquet failed. The following chunks could not be processed: EINE_1_20201203_155048.csv, EINE_0_20201203_154734.csv, EINE_0_20201203_155048.csv MARC: Convert to parquet failed. The following chunk could not be processed: MARC_2_20201204_080156.csv MSEG: Convert to parquet failed. The following chunk could not be processed: MSEG_93_20201204_102543.csv T023UT: Job failed T16FE: Job failed What could be the reasons for these issues? The tables incurring the error Convert to parquet failed. The fol

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?

Hi All, Am currently working on ML. Can I get the sample Dataset for the ServiceNow or SAP Applications ? Br/VM

Hello, All. We were working on the examples that once you published your ML suite website. Such as, Anomaly Detection, Duplicate Payments, Root Cause Analysis However, yesterday when I visit the website I couldnt find the samples. Coul you please let me know where can I find them? Since we are trying to adapt those logics into our P2P and AP processes. Thank you! Latife

Hi, is there a way we can use the python API to find and replace field names specified in PQL within an analysis? For example, Im linking an existing analysis to a new data model and some of the field names differ slightly e.g. BSEG.TS_AUGDT is now BSEG.AUGDT. Is there a way I can easily update the PQL to use the new fieldname definition via the API without having to update manually via the front end?

Hi Team , Is there any simple way to write a PQL query for select * from table name in celonis ML for get_data_frame(query). As of now we need to add all the column names separately one after the other PQLColumns(). Any suggestions would be helpful. Thank you Amruth