Product Q&A

Hello Everyone, I am creating / looking for an overview of all the Celonis / Process Intelligence related events in 2024.  Could you all give some recommendations which events to visit or which are upcoming? Thanks! 😎

Hi all! I would like to set a sheet filter, always for the last 12 months. Something like: "FILTER "VBAP"."TS_ERDAT" || CALENDAR_MONTH(TODAY) -12" Could anyone give support on it? Many thanks in advance! Regards Simon

Hi guys, I'm trying to get my head around Celonis Snap. However, I am finding a lot of documentation about it and links to the site. But each of these pages redirects me to the EMS. Are the Celonis Snap documentations outdated? Has there been any changes that should be known? Or is this now built into EMS and you don't have to make an extra Celonis Snap account. What is the current status and why does every Celonis Snap page give me an error?

Error: The operation failed with an error. Failed to map '0.columnName': Function 'formatDate' finished with error! 'SALES_ORDER.REQUESTED_DELIVERY_DATE' is not a valid date.

I would like to create a role that only has the rights to manage the permissions of data pools, without the person being able to edit the data pool itself.I have already implemented the same with the Spaces, where the role can only distribute permissions but cannot see the content of the packages.  Unfortunately, Data Integration does not have the option "Manage Permissions" for a Data Pool separately, while the option "Edit Data Pool" includes the right ton manage permissions. With the "Edit Data Pool" option, the user can also edit the entire data pool. How can we devide the admin right to create data pools and to manage the permissions of a data pool, which needs to be granted to another role?  I look forward for some support. Best regards, Tim

Hello Team, Ask : I have 4 OLAP Tables with same no. of columns, I need to combine the results of all 4 OLAP tables into in single OLAP Table/Table. Requesting a help on my ask.

Can anyone suggest the best way to extract the parameters used in extraction jobs in to machine learning workbench using python.

In the CSV module: The CSV output file:

HII Everyone! If I may ask a question, When creating an Action Flow and using the Celonis (query data) module how can we refer to a KPI or an attribute created in our Knowledge model in the module variable (to be a column for this module) ?

Hi,I want to migrate data along with Data pool/ Analysis/Views, from one env to another. Is that possible? I migrated the data pool, analysis and other items, but migrating the data , I am not sure. Can you please help me on this?

Hello, I'd like to download sql and json files that I exported with the backup_content method. I tried using the copy download link with wget.download() but that downloaded the file into the jupyter environment. Do I need to add a token somwhere Is there a way of directing the download to my local machine? Or are there better ways of doing this? All the best and have a great new year,Sasa

Hello everyone, I have created a table through the use of HTML in the textbox in order to display the Related KPIs. I wanted to know if there is a possibility to apply the displaycontentrule for the KPI values displayed through placeholders.

Hi Community, I have a tricky situation with a webhook behaviour that I don't understand. I have created an Action Flow starting with a webhook supposed to listen to any sollicitation. First of all, I'd like to say that the way to instruct the Action Flow to use webhook entries a little bit stupid but ok, I did it, creating first the webhook with scheduling type = "Immediately", then published, ran the webhook, sent data under JSON format through API client, got my data received by the webhook, then added the other modules and mapped data received by the webhook into the CSV module (then map under base64 to send attached file in an email sent with a skill). I then ran again the complete action flow, sending data the same way from API client. All worked fine, I received data inside CSV by email. Now I created an actionable view to activate this action flow from a selected line in that view. To make it work, I created an action into the knowledge model but there, you h

Hi,I am a beginner in Python. But I have intermediate skill in Celonis Data Engineering / Analysis / Knowledge Model.I would like to start with PyCelonis. Can anybody guide me like where to start and slolwy how to load a file / update a file/copy data and then go to advanced level in Python/ PyCelonis. Can anyone please help me on this?

Hi,is there a way to combine a PU Function with a CALC_CROP Function? CASE WHEN PROCESS # 'Change Requested Delivery Date' THENTO_TIMESTAMP ( PU_FIRST ( "VBAP" , "_CEL_O2C_ACTIVITIES"."CHANGED_TO" , "_CEL_O2C_ACTIVITIES"."ACTIVITY_EN" = 'Change Confirmed Delivery Date'), 'YYYYMMDD' )ELSE"VBEP"."EDATU"END This is the formula without CALC_CROP. But doing this, Celonis is looking at the first "Change Confirmed Delivery Date".I would like to look at the first "Change Confirmed Delivery Date" Event after the last "Change Requested Delivery Date" Event.

We have requested (Niels Deckers) a new project so that we can start analyzing a customer journey for our customer. Can you give an update about the status? Our customer is waiting for the results.

I am a manager @deloitte Greece and we are working on an offering for task mining for a bank and would like to propose Celonis. Any partnership doc? Any licensing scheme and reselling model? Thank you

Hi Celopeers Team, I have a profile view with a comment component, I need to creat an Action Flow that sent to the user especific data more de comments that there are. Does anyone know how I can read the data in the comments of an action flow? Thanks 😉

Hi,I'm extracting data from SAP ECC, but when I try to pseudonymize fields from tables I receive an error of aborted operation from SAP system, with log "Error: Error during Hash calculation for value 100"Someone please know why? Thank you!

Hello! Among my data I have records with four possible values in the column Class ('Inactive', 'Proc Manage', 'non-Proc Manage' and '-'). The last option occurs when there is no value for the record inside Class column.  Although without filtering I can see records with all values of Class listed above, trying to filter as in the picture, I can't get them (I receive only Inactive ones, my goal is to get empty ones also). If I want to get for example only those where Class = 'Inactive', it's easy, but what about the requirement to filter only records with no value for Class column? I don't know how to do it in a table, and inside Action Flows filtering as well. My intuitive code inside Action Flow is FILTER "MyTable"."CLASS" IS NULL , but unfortunately, there is no result. Do you have any idea how to solve this issue? I will be grateful for your support.

What are the differences bewteen Celonis EMS and Celonis SNAP+ versions?

Hi guys, is it possible to display a view variable as a column in a table within the same view? The value of the view variable will be updated by a input box in the same view. Thanks in advance.

Hi - pl suggest I can one create documentation of all analysis one have bulit in Celonis. Documentation should include data sources used (incl tables, fields and thier structures), queries/calculations used, preseptation (i.e. OLAP table, matrix, filters)

We want to make an alert within an inputbox that is related to an action (view) that leads to an increased attribute indicating that it has exceeded a maximum number of characters. Do you know how to achieve this?

Ex: 12345 Stage1 Task1 Timestamp12345 Stage1 Task2 Timestamp12345 Stage2 Task1 Timestamp12345 Stage3 Task1 Timestamp12345 Stage1 Task1 Timestamp12345 Stage3 Task2 Timestamp Note: Activity->stage