Home > Success Hub > Get Learning
Dive into training materials and grow your knowledge with our expert-led content
Join our free online training platform
Follow learning paths designed for your role
Elevate your skills guided by expert trainers
Stand out in the crowd. Get #CelonisCertified
Using PQL in the VBFA table, I need to combine the date and time into a single timestamp.Both the ERDAT (date) and ERZET (time) fields are formatted as complete timestamps in our data model.I succeeded by converting both fields to strings, combining them, then converting the combined string back to a date.TO_DATE(TO_STRING ("VBFA"."ERDAT" , FORMAT ( '%Y-%m-%d' ) )||' '||TO_STRING("VBFA"."ERZET", format ('%H:%M:%S')), FORMAT ( '%Y-%m-%d %H:%M:%S' ) )Is there a more direct approach I could use to obtain the same result? The conversion to string seems unnecessary.Thank you.
Hey, I’m beginner in Celonis and started my learning. I wanted to know Can we build a user form which helps me to collect the data from user and store it designated table. I also have set of rules for forms like show this field if user in particular role or make the field editable only if certain condition matches with current logged in user otherwise just keep it as read only and so on. Can this be achievable in celonis. Looking forward for response. Note: Pease share screenshot how it will look if you have anything sharable in this forum. Thanks & RegardsChethan Shetty
On July 8th we held the 4th Celonis HR Community hosted by our DACH customer Deutsche Bahn in Frankfurt: 20 customers from 10 different accounts (e.g. Schwarz, DB, DHL, Zeiss, Telekom, Enervie, Knauf) 3 deep dive breakout sessions 2 customer impulses from Pablo Wirth, Deutsche Bahn and Max Schmidt, DHLIn total the Celonis HR Community includes now more than 80 managers and experts from over 20 companies, it continues to grow and is establishing itself as a strong user group. Next meeting: Celosphere November 4-5 in Munich.Special shoutout to Philip Weuste, Panajotis Sirtmatsis and Moritz Pietig for leading the event and continuously driving the community.
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
I would like to understand how we can leverage Celonis functionalities to identify duplicate invoices or vendors. What are the different approaches available in Celonis to achieve this
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.
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
Dear Celonis Community,Processes have come a long way, and the next phase is already taking shape.Join us for a live webinar on Wednesday, July 16 at 11 AM CEST, The evolution of processes, with Wil van der Aalst, the Godfather of process mining, and Rudy Kuhn, process expert and evangelist. In this 45-minute session, you will learn about:• The evolution of processes from analog to digital, automated, orchestrated, and autonomous• How process mining has advanced visibility and action• The role of processes in making AI relevant and effective• What comes next for processes, process mining, and Process Intelligence There will also be a live Q&A so you can ask your questions directly. 👉 Register here to join us live on July 16.We look forward to seeing you there.
PROCESS DESIGNER and PROCESS NAVIGATOR - Single Sign-On PROCESS NAVIGATOR - Chat button removed from details modal STUDIO Attribute filter uses Knowledge Model STUDIO Event count tab added to Event Explorer component STUDIO Icon mapping added to Tables and KPI lists STUDIO Visual enhancements to Views TASK MINING Create Business Events by adding business context to captured user activities [Private Preview]COMING SOONProcess Designer enhancements by September. Data Integration IP Address Updates on eu-2, eu-3, jp-1, uk-1, and us-2 realms. Ensure your system IP allowlists include the latest Celonis IPs, and remove specific older IPs by September 17, 2025. Decommissioning of selected API & Application Keys before December 31, 2025. PROCESS DESIGNER and PROCESS NAVIGATOR - Single Sign-On You can now configure Single Sign-On (SSO) in Celonis Process Management. Users with the Administrator role can choose from SAML or OIDC based SSO. For existing customers, note that this featu
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
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!
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.
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!
Already have an account? Login
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
Sorry, we're still checking this file's contents to make sure it's safe to download. Please try again in a few minutes.
Sorry, our virus scanner detected that this file isn't safe to download.
