Skip to main content

Unanswered Questions

39
shane.proct
Level 3
shane.proctLevel 3
 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.

50
shane.proct
Level 3
Pembatalan Adakami
Level 2
Pembatalan AdakamiLevel 2
 Process Analysis
Panduan cara membatalkan pinjaman AdaKami

Anda dapat menghubungu layanan pelanggan AdaKami melalui nomor (0857) 57062533. Sampaikan alasan anda ingin membatalkan pinjaman. berikan data lengkap sebagaimana yang di minta pihak AdaKami, ikuti intruksi dari petugas layanan pelanggan.

60
Pembatalan Adakami
Level 2
julia.bauer
Level 5
julia.bauerLevel 5
 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

132
julia.bauer
Level 5
Saba
Level 4
SabaLevel 4
 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!  

414
Saba
Level 4
Saravanavel
Level 2
SaravanavelLevel 2
 Celonis Academy Group
Celonis Certificate Exam, not able to complete the exam, start button is not visible "The website encountered an unexpected error. Try again later"

Celonis Certificate Exam, not able to complete the exam, start button is not visible "The website encountered an unexpected error. Try again later". Please help to fix this issue and proceed for exam.

251
Nicole Wendler
Celonaut
Yannick Noubissi
Level 2
Yannick NoubissiLevel 2
 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!

91
N
Celonaut
Kamil Deren
Level 2
Kamil DerenLevel 2
 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 :)

131
N
Celonaut
phil.cook
Level 3
phil.cookLevel 3
 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  

170
phil.cook
Level 3
harshini.gampa12
Level 2
harshini.gampa12Level 2
 Process Management
Report Generation -- Standards and Standards Chapter matrix , Process performance analysis

Hi Team,We would like to generate the Reports in Process designer i.e Standards and Standards Chapter matrix , Process performance analysis .Can you guide us how to create the above mentioned highlighted contents in report.

40
harshini.gampa12
Level 2
gayathri
Level 3
gayathriLevel 3
 Community Connect
Request to Swap First and Last Name on Profile – Urgent & No Response from Support

Hello Celonis Community Team,I’m reaching out regarding an important update I need on my Celonis profile. I would like to swap my first and last name – currently, they are displayed in reverse order.Despite emailing support three times over the past few weeks, I haven’t received any response. This update is crucial for my certifications and professional visibility. I kindly request your assistance in getting this corrected at the earliest.Please let me know if any additional information is required from my end. I appreciate your help and look forward to a quick resolution.Thank you,[Gayathri Vanam ][vanamgayathri13@gmail.com]

484
cristina.gómez11
Celonaut
carmen.kaluz
Level 3
carmen.kaluzLevel 3
 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?

293
carmen.kaluz
Level 3
christine.gentr
Level 2
christine.gentrLevel 2
 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

214
christine.gentr
Level 2
emilia.stepi
Level 2
emilia.stepiLevel 2
 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

211
S
Celonaut
julia.betzl
Level 3
julia.betzlLevel 3
 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

182
julia.betzl
Level 3
Saba
Level 4
SabaLevel 4
 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? 

212
Saba
Level 4
Sverre Klein
Level 6
Sverre KleinLevel 6
 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!

563
janpeter.van.d
Level 8
Kusum Bhadoria
Level 2
Kusum BhadoriaLevel 2
 Celonis Academy Group
Academic Process Mining Fundamentals

I have completed my course track “Process Mining Fundamentals” but the course badge is not received yet. I have attached the image that I completed proof of that track. What can i do for solving this issue?I have already registered my issue on "Contact Academy Support Team" but there is no solution yet

171
cristina.gómez11
Celonaut
Ushmita Patil
Level 2
Ushmita PatilLevel 2
 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!

202
Ushmita Patil
Level 2
thomas.keim
Level 4
thomas.keimLevel 4
 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 

251
thomas.keim
Level 4
NHARNIS
Level 3
NHARNISLevel 3
 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

193
NHARNIS
Level 3
douglas.souza
Level 3
douglas.souzaLevel 3
 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. 

285
douglas.souza
Level 3
julia.betzl
Level 3
julia.betzlLevel 3
 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.

407
J
Celonaut
Akshay H
Level 3
Akshay HLevel 3
 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

753
A
Celonaut
Sujal GC
Level 2
Sujal GCLevel 2
 Celonis Academy Group
rising star - business assessment

I have not completed my celonis rising star assessment as I have taken the assessment 2 times now the assessment is not opening. it was mentioned that i get the another 2 attempts after 2 days but it did not opening till now even after 5 days. please help me to get my extra attempts.

915
cristina.gómez11
Celonaut
NISHI
Level 2
NISHILevel 2
 Celonis Academy Group
I failed rising star business assessment attempt 2 time but fail both time then after 2 days i came back see there is not refill again then what i should do?

I failed rising star business assessment attempt 2 time but fail both time then after 2 days i came back see there is not refill again then what i should do?

693
c.santh15
Level 2

Badge Winners

VIEW ALL
Community Code of Conduct