Skip to main content

Product Q&A

Ask questions and get answers about Celonis products from experts and peers.

4429 Topics
emilia.stepi
Level 2
emilia.stepiLevel 2
asked in Data Ingestion & Infrastructure
Restricting access to specific data model column

Hello everyone,I want to restrict access to a specific column in a data model so that non-admins cannot see the values in that column or the column itself. Is there a way to achieve this using data permissions? Thank you!Best,Emilia

322
benjamin.delay
Level 2
shane.proct
Level 3
shane.proctLevel 3
asked in Process Analysis
Filtering for last activity of each day.

In an OLAP table, I am looking at sales documents "VBAK"."VBELN".  I only want to see the last change of each day.  How do I filter for the last "_CEL_O2C_ACTIVITIES"."EVENTTIME" of each day?  I’ve experimented with PU_MAX, but I keep getting errors.

242
julia.bauer
Level 5
julia.bauer
Level 5
julia.bauerLevel 5
asked in Process Analysis
Input Button Dropdown in JAB Views

Hello everyone, I’m currently migrating an old view to a JAB view. In the old view I had an input dropdown (made with a custom object “Time Dimension” with the content columns: Year, Year-Month, Quarter, Week, Day). In the new JAB view I now want to implement this as well (filtering charts according to Quarter, Week and so forth). I’m already aware of the Celonis documentation: Configuring user inputs (input box, input dropdown, button), but this is really too intransparent for me.  Can someone give me a step by step guide on how to implement this?I already created a variable as object like this: {"Year": "String","Year-Month": "String","Quarter": "String","Week": "String","Day": "String"} However, within the input dropdown component, I don’t know how to proceed as the dimensions Year, Year-Month, Quarter, Week, Day are not stored in a single attribute/dimension. They are all calculated with the EVENTTIME separately. Thanks in advance! Best regardsJulia Bauer 

100
julia.bauer
Level 5
julia.bauer
Level 5
julia.bauerLevel 5
asked in Process Improvement
Add Powerpoint Attachment to Mail Sent by AF

Hello everyone, this is my current AF setup: The setup works fine, however, I have received the requirement to add a powerpoint attachment to the mail sent via the AF. This powerpoint is static and is only a training document for the recipient. Is it possible to add attachment from your computer to be sent out by the AF itself? I cannot add this via the data and title fields since it’s already ready and static. Thanks! BRJulia Bauer

322
julia.bauer
Level 5
kandi.naidu
Level 4
kandi.naiduLevel 4
asked in Process Analysis
How to configure input dropdown in views

Hi Team, I’m working on input dropdown where my timestamp should be convert into daily,weekly,monthly and if it is daily I need 8 hrs , for weekly 40 hrs and monthly 173 hrs in one single dropdown. How I can achieve it. Regards,Ajith Naidu.

804
julia.bauer
Level 5
Saba
Level 4
SabaLevel 4
asked in AI
Annotation

Hi everyone,I want to use the Annotation Builder, but I don’t have a unique ID.For example, the same material number exists in two different business units as you see in the picture.What’s the best way to handle this? Thanks for your help!  

694
Saba
Level 4
leonardo.spina
Level 3
leonardo.spinaLevel 3
asked in Process Analysis
Change in default display of columns within the Case Explorer

Hi team, I want to know more change the default display of columns within the Case Explorer component of Studio Views, after having added two more attributes.Best regards, Leonardo

293
Gaya Balasubramanian
Celonaut
Yannick Noubissi
Level 2
Yannick NoubissiLevel 2
asked in Process Analysis
How to filter table rows based on aggregated column values in Celonis?

Hi everyone, I’m working on an analysis in Celonis and I have a question regarding filtering table rows.In my case, one of the columns in my table displays a sum of values retrieved from the backend (e.g., SUM("SomeColumn")). I would like to exclude all rows where this sum equals zero, so they don’t appear in the final table.How can I apply such a filter directly in the table configuration or via a filter condition?Thanks in advance for your help!

261
N
Celonaut
Kamil Deren
Level 2
Kamil DerenLevel 2
asked in General Product Q&A
Active Action Flow list

Hi, I am trying to create a list of Action Flows using PyCelonis and I want to also add status if the Action Flow is currently active or not. I was trying to do it .get_action_flow(id).dict()/json()/json_dict() but there is no parameter there that would indicate if the Action Flow is activated or not.Thanks in advance for any replies :)

161
N
Celonaut
harshsh
Level 2
harshshLevel 2
posted in General Product Q&A
Trigger and Action Flow

I want to create trigger for a action flow. Im not sure how to do it, I am creating a trigger in the KM but that trigger is not showing up in the Watch Trigger module in the action flow

110
harshsh
Level 2
phil.cook
Level 3
phil.cookLevel 3
asked in Process Analysis
Identifying the First Instance of an Activity as well as Its Follow-up Activity

HelloIn a scenario where there are multiple instances of “WIP CB IP” activity, I am trying to identify the first instance along with the next activity taken by a user.  I am easily able to identify the first WIP activity (highlighted in blue) using PU_FIRST.  However, when I attempt to identify the next activity following the first WIP, I end up retrieving the activity for the 2nd WIP line (highlighted in yellow and red).   I would like to report on the activity highlighted in green.I have tried wrapping the PU_FIRST within the ACTIVITY_LEAD but the syntax failed indicating that “/IRM/IPCBITM” is not within the Activity table.  I have also attempted to use a CASE WHEN statement but that just generated two WIP lines.  I am only interested in the first instance of WIP.Thanks in advance,Phil  

220
phil.cook
Level 3
carmen.kaluz
Level 3
carmen.kaluzLevel 3
asked in Data Ingestion & Infrastructure
Use App Key for content-cli in ML workbench

Hi all,I would like to export datapools as json using content-cli in the ML workbench in order to backup them in Git. I have created an API key in my profile and used it in a python script with content-cli pull data-pool --id data-pool-id, which successfully generated a json of the datapool.However, I don't want to do this with a user-based API key but with an Application key (created under admin&settings).When I run the same command using the Application key, I get the error "error: The provided team or api key is wrong."With get_celonis(api_token=“applicationkey”, key_type="APP_KEY") however, I can see the Application key and all its permissions.Is content-cli possible with an Application key and if so, how can I use it?

353
carmen.kaluz
Level 3
christine.gentr
Level 2
christine.gentrLevel 2
asked in Process Analysis
Need Help Fixing PQL script to look for a variable direct after a wildcard search using the LIKE function

Hi,I need help fixing my PQL scriptCASE  WHEN "SHOPPING_DETAILS_DESC" LIKE '%CRIT% 1%' THEN 'Criteria 1'  WHEN "SHOPPING_DETAILS_DESC" LIKE '%CRIT% 3%' THEN 'Criteria 3'  WHEN "SHOPPING_DETAILS_DESC" LIKE '%CRIT% 5%' THEN 'Criteria 5'  ELSE NULLEND I am trying task search in a text field (Shopping_Details_Desc) for cases where ‘%CRIT%’ is identified. I would then like the code to assign a Criteria when the number ‘1’, ‘3’ or ‘5’ follow directly after the we wildcard search. I am pulling errors because there are other numbers in the text description and the code is incorrectly assigning them because it is find any any ‘1’ (as an example) that comes after ‘CRIT’ and then calling it a ‘Criteria 1’, even when it is a Criteria 3.  My issue is that sometimes our operators are miss writing the text so we are trying to capture either CRIT or CRITERIA, or anything in between - which is why I want a wild card.  I was able to write a statement in DAX to be able to look for a number assigned direc

264
christine.gentr
Level 2
julia.betzl
Level 3
julia.betzlLevel 3
asked in Process Analysis
Error message: Calculated attribute ["MARC"."COND_MBEW_COMPL_VPRSV"] cannot be used inside a FILTER because it takes filters into account.

Hi all,  I created an attribute (“MARC”.”cond_mbew_compl_vprsv”) as a boolean with the following formular:CASE WHEN(  ( "MARC"."BESKZ" = 'E' AND ( PU_FIRST("MARC",FILTER_TO_NULL ("MBEW"."VPRSV")) NOT IN ( 'S' ) OR PU_FIRST("MARC",FILTER_TO_NULL ("MBEW"."STPRS")) = 0 ))    OR  ("MARC"."BESKZ" = 'F' AND ( PU_FIRST("MARC",FILTER_TO_NULL ("MBEW"."VPRSV")) NOT IN ( 'V' ) OR PU_FIRST("MARC",FILTER_TO_NULL ("MBEW"."VERPR")) = 0)))THEN 1 ELSE 0 END Now I want filter like followed: FILTER "MARC"."cond_mbew_compl_vprsv" = 1 This does not work and I got the following error message: Calculated attribute ["MARC"."COND_MBEW_COMPL_VPRSV"] cannot be used inside a FILTER because it takes filters into account. Can you help me what I should change? Thank you. Regards

222
julia.betzl
Level 3
Saba
Level 4
SabaLevel 4
asked in General Product Q&A
Attributes in Records

Hello everyone,I’m trying to create a new Record and Attribute in the Knowledge Model, but it seems that after creating them, I can’t use them.Record: "o_celonis_Material"Attribute:pu_last( "o_celonis_Material", bind("o_celonis_StockHistory", "o_celonis_MaterialMasterPlant"."id"), left("o_celonis_MaterialMasterPlant"."id", 3) = 'p18' ) Does anyone have any idea? 

312
Saba
Level 4
Sverre Klein
Level 6
Sverre KleinLevel 6
asked in General Product Q&A
Asset Library not responsive

Hi all, I have a problem with loading the asset library, it shows the following error.Cannot read properties of undefined (reading 'children') Anyone has the same issue? Thanks!

723
janpeter.van.d
Level 8
Ushmita Patil
Level 2
Ushmita PatilLevel 2
asked in Process Analysis
Not Getting Data in Charts or Case Explorer – Shows "You don't have data yet"

I'm facing an issue where my charts and tables show the message "You don't have data yet" even though I have connected them to the data model.When I create a Case Explorer, it only shows 1 row with these columns: Case ID Number of Activities Duration In the table section of the Case Explorer, it only displays CDHDR.CASES.Can someone please help me understand why I’m not getting any data in the charts or other tables I create?Thanks in advance!

252
Ushmita Patil
Level 2
thomas.keim
Level 4
thomas.keimLevel 4
asked in Data Ingestion & Infrastructure
Usage of PQL Function QUANTITY_CONVERT

Hello Community,I need you help in using the PQL Function QUANTITY_CONVERTMy objective is simple: I want to convert the SAP Field LIPS.BTGEW to Tons (TO). The original Unit is stored in field LIPS.GEWEI.With this try I get an errorQUANTITY_CONVERT("LIPS"."BRGEW", FROM ("LIPS"."GEWEI"), TO ('TO'))A PQL error is preventing this query from executing.Syntax error near [)] after reading [QUANTITY_CONVERT("LIPS"."BRGEW", FROM ("LIPS"."GEWEI"), TO ('TO')] at line 32. Please refer to PQL documentation for available syntax. What's the problem? If I understand the docu (https://docs.celonis.com/en/quantity_convert.html) correctly, I must not provide a conversation rates table?This operator converts quantity units based on a QUANTITY_CONVERSION_RATES table, which is optionally provided by the user. If not provided by the user, a default QUANTITY_CONVERSION_RATES table will be used. Where can I see the contents of the default QUANTITY_CONVERSION_RATES table?Thanks for helpBest, Thomas 

291
thomas.keim
Level 4
NHARNIS
Level 3
NHARNISLevel 3
asked in Process Analysis
Calculate and Count First and Last Activities

Hello everyone,I'm working with classic process data: Case ID, Activities, and Timestamps.I want to list all first activities and all last activities, and count them by case. This way, I can see which activities my variants start and end with, and how many variants they cover.Ideally, I’d like this in two tables—so I can select a starting activity and see the corresponding ending activities in the other table.I’m assuming it’s fairly easy but i can not manage to do this..Kind regards, Niklas

283
NHARNIS
Level 3
douglas.souza
Level 3
douglas.souzaLevel 3
asked in Data Ingestion & Infrastructure
Filter Statments Extractions

I need to use a filter in my extraction, but the field in the table I'm bringing it from has a separate name "Date Archived" Example.When I use it like this "Date Archived" >= '2024-01-01 00:00:00', it doesn't load, I believe it's because of the space between the column name. Does anyone know how to solve this?I've tried to put the column as a parameter, but I still can't. 

505
douglas.souza
Level 3
julia.betzl
Level 3
julia.betzlLevel 3
asked in Process Analysis
Change Year in Fiscal Year in a KPI

Hello all,I used this formular to get the average time of late payment:AVG((DAYS_BETWEEN(PU_FIRST("BSEG", "_CEL_AR_ACTIVITIES"."EVENTTIME","_CEL_AR_ACTIVITIES"."ACTIVITY_EN" = 'Due Date passed'),"BSEG"."TS_AUGDT")) - <%= buffer1 %> ) This works well but when I filter on Fiscal Year the KPI is wrong because our Fiscal Year is not similar to Calendar Year. Our Fiscal Year starts always in october. How can I change my formular that the KPI is calculated for example from october 2024 til september 2025 when I selected 2025 as Fiscal Year. Thanks and best regards.

437
J
Celonaut
Akshay H
Level 3
Akshay HLevel 3
asked in Process Improvement
CCPM to OCPM

Hi All,Just wanted to ask whether there is any documentation on how to migrate existing CCPM datamodels to OCPM one.Thanks,Akshay

953
A
Celonaut
fabian.altendorfer
Level 3
fabian.altendorferLevel 3
asked in Process Analysis
Adjustments Process Explorer

Hi,Is it possible to adjust the settings of a Process Explorer on how it opens inside a view, like the zoom level or which Events are shown?Right now, there are too many events displayed in the Process Explorer, and my users need to zoom manually to see the names of the activities and their KPI values. I would like to change the initial zoom settings to a higher value or to show only the activities that don't display 0 in their primary KPI, if that's possible.Many thanks for any help, Fabian

182
fabian.altendorfer
Level 3
PhuongBHN
Level 3
PhuongBHNLevel 3
posted in General Product Q&A
Error: Extractor cannot write to temp directory during Redshift connection test "Unable to write a test file to the temporary directory '/tmp/CEL_CON_TEMP'. Please make sure that application is provided with the write permission on it and it exists."

!--startfragment>Hi everyone,I'm currently facing an issue when trying to connect from Celonis to Redshift via the Extractor.!--endfragment>  When I check the Extractor logs, I consistently get the following error:!--endfragment>!--startfragment>ERROR 66250 --- [pool-4-thread-1] c.c.c.j.c.u.status.GetDataSourceStatus   : Error during connection test --EOM--cloud.celonis.connector.client.exception.ExtractorException: Unable to write a test file to the temporary directory '/tmp/CEL_CON_TEMP'. Please make sure that application is provided with the write permission on it and it exists. To troubleshoot, I’ve already ensured that the folder exists and has correct permissions. Here's what I've done:!--endfragment>!--startfragment>   sudo mkdir -p /opt/celonis/tmp/CEL_CON_TEMP   sudo chown ubuntu:ubuntu /opt/celonis/tmp/CEL_CON_TEMP   sudo chmod 755 /opt/celonis/tmp/CEL_CON_TEMP   sudo -u ubuntu touch /tmp/CEL_CON_TEMP/test.parquet !--startfragment>The manual file creation

70
PhuongBHN
Level 3
PhuongBHN
Level 3
PhuongBHNLevel 3
posted in General Product Q&A
Uplink could not connect: 'Error while extracting response for type [class cloud.celonis.uplink.manager.UplinkDataWrapper] and content type [application/json;charset=UTF-8]'

I have tried to connect to my Redshift by Extractor Server. But I have meet the issue below when start the extractor. How can I fix this? [class cloud.celonis.uplink.manager.UplinkDataWrapper] and content type [application/json;charset=UTF-8]', waiting 3000ms before retrying --EOM--2025-06-13 02:11:40.256  INFO 22860 --- [uplink-thread-1] c.celonis.uplink.manager.UplinkManager   : Uplink could not connect: 'Error while extracting response for type [class cloud.celonis.uplink.manager.UplinkDataWrapper] and content type [application/json;charset=UTF-8]'

281
N
Celonaut

Badge Winners

VIEW ALL
Community Code of Conduct