General Product Q&A

🌿 Reduce Shipping Emissions: Webinar with Celonis & Climatiq 🚢Looking to reduce your shipping emissions? Join us in a webinar with Climatiq Co-Founder Philipp von Bieberstein 🌍 🗓️ Date: September 13th⏰ Time: 3PM CEST / 9AM EST🕒 Duration: 1 Hour What You'll Learn:1️⃣ About the Celonis & Climatiq partnership2️⃣ How to automate shipping emissions calculations3️⃣ Ways to drive carbon-conscious decisions in logistics Don't miss this opportunity and RSVP Now! 👇 https://academy.celonis.com/courses/drive-sustainability-with-the-celonis-ems-the-shipping-emissions-reduction-app @michael.hogen​ @1460037707​ 

i want to send an email with all the selected records by an action flow.Everything is already in place (action in knowlegde model, action flow), but the filtering does not work. I only manage to add a static filter, but it would be great to use the filters in my view to collect only that data in my table to send in an email. Thanks in advance for the response!

Hi there,I have a Data Model and a Data Pool containing two tables: "REQUESTS" and "ACTIVITIES".I want to access "REQUESTS" in the Workbench via PyCelonis, select several columns and transfer them into a DataFrame. The connection could be established successfully:data_pool = celonis.data_integration.get_data_pools().find('Process-Block')data_model = data_pool.get_data_models().find('Data Model') If I now try to output the individual tables with data_model.get_tables(source: https://celonis.github.io/pycelonis/1.6.0/tutorials/api_tutorial/04_PQL_and_Python_2/#4-interaction-with-the-celonis-resource-object)I get as output ID and name of the datamodel, but not the individual tables, as described in the documentation. Also the commands are outdated. Instead of .tables .get_tables must be used in the current version. Since I can't display the tables, I also can't proceed with the following function according to the doc:List all the colum

How can I delete a Data pool?

Hi all experts, Let me ask a question: where can I find license grade whether that is C4C or C4C+E for example? In my case, I just would like to invite my client but I didn't know which license I'm using until I ask to my manager. I checked license tab in admin setting but cant find it. Thanks and regards,

Hello Community, I've created an Action Flow in Celonis which contains an UI Path Queue Item which gets data from a webhook item. The webhook item data comes from a Skill, which gets data from a Record of a View. I couldn't figure out how to set up the "Add specific content" field of the UI Path Queue Item.  I am really thankful for your help!   The json Data file which comes from the Skill and goes into the webhook looks like this: 

Hello, do you know any methods for calculating the first match ratio in the 3waymatch application based on the P2P model? I'm referring to the initial matching in the process based on the PO line. Keep in mind that a PO line can have multiple invoices.

Hi all, I'm working with an Augmented attribute generated in a skill. After several test runs, I now want to clear all the signals and the autogenerated augmented skill table, however I'm not able to do so. Does anyone know where I could empty this table? A back-up solution would be to set-up a new knowledge model, though this is not the most desirable solution. Kind regards,Maurits

why does Celonis use Snowflake schema instead of Star schema?

Hi all, i have implemented a multilog and i want to build the following analysis in a multilog enviroment (Eventlog merged is activated in the data model and there are 2 different eventlogs).  The problem i am encountring is that i can't "select" the eventlog to analyse. Everytime i click on any of the following predefined analysis, it automatically choses the _cel_merged_activities (only in Comformance i found the option to change the Eventlog). Is there a workaround or a feature request in Pipeline regarding this? Can i just change the whole analyses to point towards an eventlog of my choice? Thanks  Himanshu

Example: line belnr bukrs koart1 12345 d01 K2 12345 d01 S3 12345 S01 D4 12345 S01 Shere my extraction logic should pull only line 2 and not line 4.

I am trying to replicate the following in Cloud connector extraction job for a table named order_status: create table `order_status_filtered` as( SELECT S.order_id ,S.created_dt from `order_status` S where exists (select * from `fact_order` O where O.id = S.order_id) and S.STATUS NOT IN ('Created','Sale Confirmed','Not Started'));  I am unable to add the where exists part in the extraction filters.Is there a way to do it?

Hey guys,I want to select periods, week, month, quarter, year. I would like to create a custom objectBut it's not letting me save, I've never created a CUstomObjects before. - id: date_contract_    displayName: Período Contrato    customAttributes:      columns:        - id: EKPO.for_week        - id: EKPO.for_month        - id: EKPO.for_quarter        - id: EKPO.for_year  

For eg; I have a values in column like 9, 30, sixty days, five monthsI want to convert these sixty days to 60and five months to 5I have done this using case when for possible scenarios looking if there is any direct function I can make use of..Thanks in Advance!!

Hello everyone, We are in the process of implementing Replication Cockpit and have several questions about the best way to adapt our current pipelines to this new paradigm: 1- Our business uses multiple SAP systems and we need to unify tables across them. Is there a way to do this in real time through Replication Cockpit or should we keep the unification scripts on a scheduled data job that runs before the data load? 2- For optimization purposes, we make extensive use of filter joins during extraction to restrict our tables to just the relevant data. Outside initialization joins, what is the recommended way to maintain this behavior for replications? Should we create a transformation that deletes all rows from Table A where there are no matching entries in Table B? 3- It is our understanding that once a table is being extracted through Replication Cockpit we should remove any scheduled extraction involving it to avoid conflicts. Is this understanding correct? 4- Once a table is activel

Action Flow: Is it possible to save a CSV file on the local PC drive with an Action Flow?

Hey community, I had the opportunity to join the Celonis for Consulting and I would like to ask you what VMD Mismatch stands for:

Hi,I am using Celonis training instance and trying out ML workbench.I am referring Celonis documentation to fetch analysis data using python in ML workbench (https://celonis.github.io/pycelonis/1.6.0/tutorials/api_tutorial/01_Pulling_data/) I am getting this error on this line of code:Error:AttributeError: 'Celonis' object has no attribute 'analyses' On Line:analysis= celonis.analyses.find("testanalysis") Looking for some help on this.Please suggest. Thank you.

Hello, for some reason I can´t find any solution online for this problem. It is probably out there but I cant find it. I simply want to showcase the following: The Average throughput time between Activity A and C, but ignore all cases where it touched Activity B inbetween.  This feels like a very easy task but I can´t seem to find how to filter out Activity B. Basically I thought it would like this: AVG ( CALC_THROUGHPUT (  FIRST_OCCURRENCE [ 'A' ]  TO  LAST_OCCURRENCE [ 'C' ] ,  REMAP_TIMESTAMPS ( "_CEL_O2C_ACTIVITIES"."EVENTTIME" , DAYS ) )) And then in the component filter: FILTER "_CEL_O2C_ACTIVITIES"."ACTIVITY_EN" NOT IN ('B') This obviously doesn´t work so I am here. Maybe someone can answer me this rather simple question I suppose.  Thanks!

Hi all, How can I retrieve the second values from a source column. I want the second LINK from the PU_FIRST("MARC","PICTURES"."LINK")

We are trying to migrate a package between Celonis teams using the ML workbench. Some assets are correctly downlading while others disappear without showing an error. What is happening?

For SRM tables understanding which site is better? e.g SAP - leanx

Is there an easy way to use Action Flow to generate an Export of an OLAP table into an xls file? (the standard export capability of an OLAP table). The OLAP table was created via in an Analysis and has some rather robust calculations. I'd prefer not to have to effectively recreate it via Queries.

Hi Everyone, We got a requirement from client where they are asking whether we have the option to use Power BI dashboard as a source system and get the data into Celonis EMS. Kindly help if anyone is aware of the options available.

What are the top 3 industries that Celonis is deployed in? What are the top 3 use cases that Celonis is deployed for?