General Product Q&A

Hi team! We've figured out a use case where modeling the target Business Process via BPMN in Celonis may not be enough. We'd also want to: Be able to indicate target throughput times for specific activities while building/uploading Process Model in the Conformance CheckerBe able to run the comparison of the target Process Model against the actual process taking into account indicated throughput time, so that the user doesn't need to enter Targets as constants and build the OLAP table to compare against them using PQL.

I have a question regarding process automation: I need to get the max. value of one column and therefore use the "Query Data Model" node. After that I want to add a new row with exactly this max value. Actually, the "Write Data to Table" node would need an int value then but the "Query Data Model" only gives me a list. How can I convvert this value?

I'm trying to connect to an on-premise SQL server and wanted to confirm my understanding that an extractor is not required if the IPs are whitelisted to allow traffic. If anyone has done this before, I would appreciate your response.

I have an activity (Claim Denial,) here I'm trying get the count of activities got paid after the Claim Denial,. payment happened before Denial and after denial as well, but I need to consider the first payment made after the Denial,  it can be many payment as well and payment activities we have 5 different type. also payment span should be >= 60. days between(First Denial date , first payment date(after the denial)>=60payment A- 01/01/2021Denial- 02/01/2021Payment B-03/01/2021 PU_FIRST works for First Denial but for Payment if we use PU_FIRST it will look for the Payment A but it should take Payment B date

 I am using celonis IBC and file uploads option to export eventlogs . By defalut celonis creates table with the csv file name, which we have uploaded. can we change the table name? if i upload the same file multiple times with different data only the latest data available. How can we preserve previous versions of data?

Case when and Calc throughput focus on the full case and not a part(sub-process instead of process) for each case. I want KPIs to focus both on the entire case and sub process as well. I tried providing the first occurence and last occurence workaround, however this assumes that the process sequence is adhered to, it skips cases where the process sequence is not fully adhered to.

Try celonis Order Management(EN) DemoNow instance not working

Hey guys, do you have any idea on how to setup a week number calculation that includes timestamps of monday in the following week? (tuesday as the first day of the following week) Thank you,Alex

Background: for Plant Maintenance we want to use the AUFK and MHIS tables for exploration

I have questions related Celonis App creator course. " 1:What is the function used to replace all instances of a certain term with the YAML editor" " 2: what is the syntax used to search all sections with the YAML editor" your fast response will be a

I'm using the formular:TO_TIMESTAMP("AFKO"."GSTRI", 'YYYY.MM.DD') and I'm getting the following error message - see attached screenshot 1 I'm using the same formular for "AFKO.GSTRS and there are no errors at all - see screenshot 2. Please help. Thanks a lotAnne  

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