Product Q&A

Dear Team, similar to what someone has previously posted I am also following the ML Training and am receiving an exception saying that I am either missing the correct permissions to query the datamodel or that I havent loaded them correctly. Neither seems to be true, because I set all permissions as required and I cross-checked that the datamodels have been successfully loaded. Could you kindly help me out on this one, please? ! Screenshot is attached, my training environment is: Process Data Models | Event Collection (celonis.cloud) Exception|690x359

Using the SAP ABAP Output Uploader:  Have the header files as .csv, and data files as .csv.gz The processing portion 'converting input files to parquet' is stuck processing for hours & has not yet been able to get through this step. I have tried uploading separately to see if size of data is the issue, but processing for a table with 1 singular data file attached is having the same issue.  Please advise. Currently unable to create a case in celopeers...   

Is there any webinar / knowledge base article on how to run the S/4HANA migration with Celonis? Also, any recording of past S/4HANA Lunch & Learn sessions? cc @Janine Guertler​ 

Hi , I'm trying to build a KPI that checks the date fields which have the correct date format or not. In my case I want to check if the date is in format mm-dd-yyyy. I tried with below PQL code but it is not working, could you please help me on this? I have loaded the file and assigned DATE IN column as STRING.  IN PQL code, I have converted the DATE IN column to date format with (m-d-y) but it is not working :( CASE WHEN ISNULL ( TO_DATE ( "DATE_xlsx_Sheet1"."DATE IN" , FORMAT ('%m-%d-%Y'))) = 1 THEN 'INCORRECT'ELSE 'CORRECT'END     

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?

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. 

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

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:

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