Skip to main content

Recent Discussions

55
NHARNIS
Level 2
NHARNISLevel 2
 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

10
NHARNIS
Level 2
julia.betzl
Level 2
julia.betzlLevel 2
 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.

255
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

523
A
Celonaut
Sujal GC
Level 2
Sujal GCLevel 2
 Academy Q&A
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.

845
cristina.gómez11
Celonaut
NISHI
Level 2
NISHILevel 2
 Academy Q&A
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?

643
c.santh15
Level 2
fabian.altendorfer
Level 3
fabian.altendorferLevel 3
 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

92
fabian.altendorfer
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

102
christine.gentr
Level 2
dana.diedr
Level 3
dana.diedrLevel 3
 Community Connect
Anyone need assistance?

Greetings Community, I am a Process Excellence Manager looking to obtain the Data Analyst Certification. It is recommended that anyone pursuing this certification have at least six months of practical experience with Celonis. I have completed all of the courses in the training track, and just need some hands-on experience before I take this exam. If any of you could use some assistance with different tasks in the system, please let me know. I am happy to provide any assistance for free in order to gain experience. For more information about me, please view my LinkedIn profile.  Thank you and I look forward to hearing from you!Dana Diedrich

411
Phuad Karaev
Celonaut
PhuongBHN
Level 3
PhuongBHNLevel 3
 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

30
PhuongBHN
Level 3
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!  

222
Saba
Level 4
anusree
Level 2
anusreeLevel 2
 Academy Q&A
PLEASE HELP ME TO COMPLETE MY CELONIS BUSINESS RISING STAR ASSESSMENT

HI, I wanted to complete my rising star business assessment , I have already completed 75% of the assessment but I failed my 4 attempts and now I don't know how to complete the assessment please help me 

100
anusree
Level 2
PhuongBHN
Level 3
PhuongBHNLevel 3
 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]'

101
N
Celonaut
sunnyt
Level 2
sunnytLevel 2
 Process Management
BPMN model mapping with eventlog activities

My event log is too granular compared to the BPMN model. How can I  aggregate multiple small system events into one logical activity that matches my BPMN model? Is there any documentation or training on the most common challenges faced during the conformance checking with Imported BPMN model?

100
sunnyt
Level 2
Akshay H
Level 3
Akshay HLevel 3
 Process Management
OCPM catalog transformations error

Hi team,Just wanted to check if any body has gone through this type of an error while using predefined transformations from ocpm catalog and if yes how can we resolve this. Thanks,Akshay

70
Akshay H
Level 3
Akshay H
Level 3
Akshay HLevel 3
 Process Management
OCPM Catalog

Hi All,I am trying to use OCPM catalog to build a procurement process, currently I am having 3 databases SAP ECC, S4 and ariba. The issue here is that when I am selecting the database ariba/S4 then also I am getting the option to select the transformations for only SAP ECC. Is there any way to get the s4 and ariba transformations itself for the respective databases. Thanks,Akshay

172
Akshay H
Level 3
Manikrishna
Level 2
ManikrishnaLevel 2
 Community Connect
Celonis Beginner

Hi  everyone , I am  Celonis beginner  and  fascinate to learn. It would be great to connect with all of you and would be very happy if anyone share the right approach to do well.. 

242
Manikrishna
Level 2
Mst11
Level 3
Mst11Level 3
 Process Analysis
How to Recreate Button Dropdowns in New Views

Hello everyone,I understand that the button dropdown is still not available in the new Views. Has anyone managed to recreate a similar functionality? For example in the analysis I have two button dropdowns and for each one of them I have manually inputted 5-6 categories (Local Supplier, Company Code, MSGK, PO number etc.). Each category is updating two variables (one is for the name of the column and other is PQL calculation in OLAP table). Categories from button one are updating variables in column A while the categories in button two are updating variables in column D. I need to achieve something similar in the new Views, but the documentation for the Input Dropdown isn’t entirely clear to me. Has anyone implemented this successfully? If so, how did you manage it?Thanks in advance for your help!

141
Mst11
Level 3
Mst11
Level 3
Mst11Level 3
 Process Analysis
Comments/Augmented attributes

Hello everyone,I would like to create option for users where they can leave comments. I would like for this option to be connected to a chart (let say it’s a chart showing number of blocked documents per month) and I would like to allow users to leave comments for February (number of blocked documents was really high compered to other months). But the issue is that for comments and augmented attribute identifier needs to be unique and I cannot configure it. So if someone has some idea I would be grateful.  Also in documentation they configured comments with variables but when i put variable for DOC ID (VIM_1HEAD.DOCID) and use that variable as identifier it’s not working. Any idea what should be put there? Thank you!

80
Mst11
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. 

184
W
Celonaut
abhishekbidwe
Level 2
abhishekbidweLevel 2
 General Product Q&A
Can we change Data model of an existing Knowledge model?

Can we change Data model of an existing Knowledge model? As I am trying to change the data model, I am getting Data model fail notification.

111
N
Celonaut
pablo.siege
Level 3
pablo.siegeLevel 3
 Process Intelligence Graph (PI Graph)
Generate Documentation for an OCPM Model

Hello!!Does anyone know if it is possible to generate a document with the complete documentation of an OCPM-Model (Objects, Events, Relationships (O2O & E2O) and Transformation Scripts)?Thanks and best regards,Pablo

384
pablo.siege
Level 3
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?

202
janpeter.van.d
Level 8
harshsh
Level 2
harshshLevel 2
 Data Ingestion & Infrastructure
Replication Cockpit

How do I see the replication cockpit also along with the data job. How do i set the change table and trigger for it?

261
thomas.guerr
Level 4
anusree
Level 2
anusreeLevel 2
 Academy Q&A
HELP ME TO COMPLETE MY CELONIS RISING STAR INTERNSHIP.

can anyone help me with the problem I have been trying to complete my rising star business internship but i cannot able to see all of my steps can you help me with this problem. 

181
R
Celonaut
gauri.pai11
Level 3
gauri.pai11Level 3
 Data Ingestion & Infrastructure
Data Extraction filter help

Hi team,I need help in understanding how to apply filter for KONP table in data extraction joining another table.My requirement is:1.For A018 table - I need all the records where A018.MATNR =  EKPO.MATNR.2.For KONP table, all the records from KONP table where A018.KSCHL = KONP.KSCHL If i am trying to implement 1st point in filter condition of A018 extraction as screenshot below,Data extraction fails with error : Error loading resource A017. The multi-part identifier "ts1.EKPO.MATNR" could not be bound.Can you please help in this? Thank you in advance.

71
thomas.guerr
Level 4

Badge Winners

  • Qualified to Manage Implementation Projects
    jauhar.khalihas earned the badge Qualified to Manage Implementation Projects
  • Qualified to Manage Implementation Projects
    julia.portehas earned the badge Qualified to Manage Implementation Projects
  • Qualified to Deliver Business Value with Celonis
    manali.malpahas earned the badge Qualified to Deliver Business Value with Celonis
  • Celonis Certified Data Analyst
    ihtishaam.khanhas earned the badge Celonis Certified Data Analyst
  • Qualified to Build Action Flows
    ihtishaam.khanhas earned the badge Qualified to Build Action Flows
VIEW ALL
Community Code of Conduct