Product Q&A

Hello,  I've just by accident went into Integromat website, and seen that it has been transformed into new product "Make". Unfortunately I couldn't see any official Celonis communication about that. In FAQ secion I've also seen that it will be treated as legacy product, and support and updates will be discontinued in 2023.  As Integromat is a part of Celonis in a form of Action Flows, could you kindly describe how that change will affect Celonis Action Flows environment? What's your strategy on that? Best Regards,Mateusz Dudek

Hi everyone! I need to build an action flow which will send an excel file attached, I followed the steps on the documentation, but I am getting an error and I am not sure how to solve it. I took step by step on the process.... Any advices? thanks a lot

in E2E there are some data missing like i found the data in OMS but i didn't find them in E2E ?

Hello! I wanted know if anyone was able to successfully have a Hubspot use case, I am currently in the middle of creating the tables for Celonis, but I wonder if anyone else did it before me. 😎

Hi Group! Wondering if Celonis has a connector for SAP Business One. Regards, Victor

What do you know about the term “Big Data”?

On the X axis, I have Hours (event. timestamp)On the Y axis, I want to have a graph with the maximum amount of cases that have happened. but on a day. ( So for example 1-01-2022 at 9 hours the count was 10 and on 2-01-2022 at 9 hours the count was 30, I want the output for 9 hours to be 30)  At the moment I use this to calculate the averageCOUNT ( DISTINCT CASE WHEN "eventlog_T1"."ACTIVITY" = 'activity'' THEN "eventlog_T1_CASES"."cases" END )/( COUNT ( DISTINCT Round_Day ( "eventlog_T1"."TIMESTAMP" ) ) ) Does any one has a suggestion how to get the maximum value on a day per hour

Using the skill "Email by celonis" when I select a line item it sends an email for each line. Is it possible to aggregate several selected lines and send them all in one email?

I am trying to create a formula to calculate the total of all invoices for a vendor (but not yet cleared) when an invoice for that vendor is posted. I am using SAP data, and trying to calculate using data from the BSEG table. I am displaying this total in an OLAP table in an analysis. I am passing in the posting date of the current invoice as a parameter ({p1}). The result displayed is the vendor invoice total for all invoices, for all records. PU_SUM("LFA1", "BSEG"."WRBTR", ("BSEG"."BUDAT" <= {p1}) AND ("BSEG"."AUGDT" >= {p1})) The Vendor Master table (LFA1) and the Invoice Line Item table (BSEG) are linked in the data model via MANDT (Client) and LIFNR (Vendor ID). Whatever help you can provide would be greatly appreciated.

Hello, I'm trying to do an analysis where I require the item data from delivery notes ( LIPS table), however for some reason in this specific table I have no information regarding items with delivery type = HOD, NL, and NLCC, only LF and LR appear. I checked all analysis filters and found nothing. LIKP table has HOD, NL, and NLcc information and so do VTTTP and VTTK.Can someone tell me what the issue might be? Thank you

The 'Create CSV' module allows you to specify which columns will appear in the CSV file by selecting them in the 'Aggregated fields' I would like to know how we can rearrange the columns of the Create CSV module (e.g. 'Document type' is always the first column output in the file, would like to move this to the 5th column)  The Create CSV file also will show commas ( , ) instead of decimal places when showing a calculated field (e.g. Throughput Time column in the Create CSV file shows 35,29 days instead of 35.29 days - I cannot see a way to alter this)

What's the correct setup for Replication Cockpit if we want to filter based on a date column for the initialization and the date column is in the table itself (There is no join). For example UDATE >= ''2023-02-27' did not work expected.

A. How can we edit/update a bookmark that was created & shared by a colleague, this person is out on long leave. One option I can think of:I save a copy of the bookmark, make the updates and re-share. But we will now have 2 versions of the bookmark. Can Celonis team help in any way? B. If we temporarily deactivate this person's account, will the shared bookmarks be lost or will they remain? Thanks in advance for you suggestions

how to delete my account in this

We have an OLAP table and most of the columns are from the BSEG, BKPF, and LFA1 tables. However, we would like to also have the DOC ID field from either /OPT/VIM_1HEAD or /OPT/VIM_1ITEM tables. How do we connect these tables?  Thank you!

I receive an error when trying to add comma separated emails in Microsoft 365 Email module - Create and send a message for an Action Flow. "To Recipients" field. "Validation failed for 1 parameter. Invalid email addressin parameter 'address'"

Fairly simple - we are using C4C EMS and would like to know the costs/commercial model once you have used up your free entitlement - cannot seem to find that information easily anywhere

Hello everyone, I would like to remove the leading zeros from some attributes. This is not a problem with the normal extractions and can be done with an update command. The question arises as to how I can implement this in the Replication Cockpit. The data is stored in a view, which I cannot update. Does anyone already have a solution for this or a suggestion as to how I can implement this?

Hello, I am trying to create objects and events in my OCPM model using CSV files that I have manually uploaded to the EMS but when I create a transformation in the Objects & Events environment, I can't proceed as I don't have a connection to a source system. Does anyone know if there is a way to proceed without a connection?

Hello everyone, Is there a change log / release notes of PyCelonis somewhere? This would be very helpful to make decisions when to upgrade to a new version. Thanks a lot!Pablo

Hello Community, today, we upgraded one of our ML Workbench to PyCelonis 2.6.Since then DEBUG informations are shown (see below). In the Jupyter Notebook we use: logging.getLogger("pycelonis").setLevel(logging.WARNING) If we execute the notebook on local computer, no DEBUG information if shown. On the other hand, if we execute it on the EMS, following DEGUB informations is shown: [2024-01-31 13:39:56] DEBUG: Request: 'POST' -> '/pql-language/api/lsp/publishDiagnostics/batch'[2024-01-31 13:39:56] DEBUG: Request: 'POST' -> '/pql-language/api/lsp/publishDiagnostics/batch'[2024-01-31 13:39:56] DEBUG: Initialize Series.[2024-01-31 13:39:56] DEBUG: Request: 'POST' -> '/pql-language/api/lsp/publishDiagnostics/batch'[2024-01-31 13:39:56] DEBUG: Initialize Series.[2024-01-31 13:39:56] DEBUG: Request: 'POST' -> '/pql-language/api/lsp/publishDiagnostics/batch'[2024-01-31 13:39:56] DEBUG: Initialize Series.[2024-

For some reason I am not able to scroll down or select the case ID. Maybe it is a UI issue?

First, I am not sure if this will make sense because I'm having a hard time describing it to myself... but looking for any guidance or hints on how to approach this... I have a multi step process where one party is responsible for the first half and another party is responsible for the second half. A simplified example is: Process Steps:New widgetWidget step 1 done (Party 1)Widget step 2 done (Party 2) I can easily create OLAP tables around specific events... ex. date widget uploaded, count, most common color1/1/24, 100, blue but I'm having a hard time anchoring different events in the process to the same date row when I'm using pull up aggregation to get the counts General Date, Count uploaded, Count where widget step 1 completed, count where widget step 2 completed1/3/24, 100, 24, 581/2/24, 80, 42, 981/1/24, 110, 120, 20 The challenge that I'm seeing is that my PQL statements for each of the columns don't relate to the same date, and I don't know how to dyna

Community FAQ: How do I join/subscribe to a Community Topic? Answer:To join/subscribe to a community topic, please follow these steps: 1. Visit our community topics from the main navigation bar.2. Click on the topic you are interested in.3. Locate the "Follow" button on the right side and click on it. Once you follow a topic, you will see two options for email notifications as shown in the screenshot below.Same applies for other topics that are not listed here. Also, feel free to follow as many topics as you want!