General Product Q&A

Hi Can anyone help me getting start to Celonis? Any training link? regardsRaheel Irshad Khan

Hello, in the ML workbench, as the R language is available, is there a way to push and pull data from a data model using R kernel? Or is it possible only in Python using the pycelonis package?

Hi All, In celonis transformation I would like to use Dynamic parameter to store the select query output and the same parameter i need to use in upcoming queries for further processing.  Could you please help me with option for the same? Thanks in Advance.

Hey there! is it possible to extract the saved variable values in a specific analysis using pycelonis/ML workbench? Any insights on this is appreciated. Thanks in advance!

When sending an email using "Email By Celonis" using a Smart Sensor in Studio, how does one create/specify/add an attachment to the email? Can it be an external document or only information that is stored in the knowledge model? Thank you.

As a Business View user I would like to re-arrange columns in a table and show/hide columns and save these configurations as a favorite or pre-set so that I can always return to my customized view

Hi,I was trying to set a schedule for my action flow, but on the time icon scheduling mode option, I only have this option: According to scheduling. And I cant find where that scheduling is. Is there a new way to schedule action flows?

Creating a drop-down field that will change the dimension of the first column in a table. E.g. I want to be able to switch between dimensions like, country, regions, Vendors, etc.To display in a chart the top 5 values (like Top 5 Vendors) with the possiblity to scroll beyond the top 5 (adding a scrolling functionality).  Normally it’s quite straight forward but within Views I can´t find the solution.  Many thanks and best regards, Manuel

I have setup a ML Duplicate Checker model that runs daily, it is connected to the Action Engine and generated a Dashboard Report as well. Whenever there are new duplicates I receive signals alerts and the information gets pushed to the Dashboard report as well. How can I include the signals creation date to the reporting Dashboard in Studio?

Is it possible to color code the unwanted connection?

I have two CSV files with the same headers. The only difference between the files is that it contains data from two different dates. For example one csv file has data for today's sales. The other CSV file has yesterday's sales. In Celonis I have already uploaded the CSV for yesterday's sales. How do I now upload and combine the CSV for today's sales, into the data for yesterday's sales which is already in Celonis.

We would like to send alerts / reports via mail. Currently these mails are sent by Celonis . We would like to change that to use a generic company mail id. How can this be achieved.

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?

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

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 reg

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?