Solved

Hi guys!I feel kind of stupid to ask this kind of question but I can’t find a way to show the current year (currenly “2026”) in a chart title or column header.In the studio it was easy:I created a variable as “static value” type and used thePQL “YEAR(TODAY())”.In my chart I added the result with a syntax like“Target Achievement (Year <%=current_year%>)” Now in the views I can’t use PQL to populate a variable.I can calculate the year in a KPI - but I can’t use that in a title or column header. What am I missing??I need this variable to be populated automatically, not hardcoded or assigned manually!Thank you guys,br Florian

Hello everyone,When a filter is applied (e.g., for a specific source system or company code), other filters still display values outside the selected scope with 0 values.Is there a way to hide these values completely instead of showing them as 0?  

Hi everybody,I’m hoping to get some help/ additional information from you.I intend to start using the Weekday calendar option in order to get more precise throughput times in Celonis Studio. I understand that, in Data - Data Integration - Data Models I need to select the respective Data Model, select the Calendar tab, toggle on the “Use calendar options” on, select “Weekday calendar and then select working day and enter start- and end-time for them.My question/concern relates to the information that times are in UTC. This could be an issue, since activity timestamps in the activity table within this model are all in AET/AEDT. How do I deal with this?I look forward to hearing from you. Thanks.Kind regards, Vladimir

Currently, I am doing the “Introduction to Studio Assets” . Everything worked fine, until now. During the creation of a process copilot, described here: https://academy.celonis.com/learn/course/introduction-to-studio-assets/introduction-to-studio-assets/introduction-to-studio-assets?client=partner&page=11 I ran into a problem.I activated the AI, started creating a process copilot (aas described in the training, see link) and finished step 1 “AI instructions”  (selecting the knowledge model and the task as described). Now I’m in step 2 “Knowledge Input”. The training says that I have to select a metric. So I clicked on “add metric” and tried desparately to select one. Now, according to the video, a list of metrics should appear. But this does not happen. I see no list of metrics and therefore I cannot select one! What can I do to finish the “Introduction to Studio Assets”?

We have extended several of the Celonis Catalog perspectives. As a result, we now have Data Model Loads for both the original perspective (e.g., perspective_celonis_AccountsPayable) and our customized version (perspective_custom_AccountsPayableExtended).For our operational use, we only need the extended version. Therefore, loading the original Celonis perspective is unnecessary. However, these automatically created Data Model Loads cannot be set to Enabled = false.Question:How can I deactivate or exclude the automatically generated Data Model Load for the standard Celonis perspective within the ocpm-data-job—without deleting the entire perspective?Any guidance or best practices would be appreciated.

Working with a dataframe activity table in Python I export the file in parquet format for efficiency reasons. However, when I load the file in Celonis it doesn't recognise the timestamp in the proper format but as a string. Can anyone tell me why this error is happening? Thank you very much. Thanks a lot.

Is it possible to embed an image (customer logo) in an Action Flow Outlook email body?I read the related topic “Action Flow-Screenshot of an analysis as image in a mail body” but that thread has been inactive for ~ 1yr and it does not appear it was successful. The Outlook module also has its own nuances to it (text body content vs html...).Thanks

We have a Celonis view with KPIs defined in the Knowledge Model. These KPIs use time-based filters with variables like datefrom and dateto inside the PQL-code.For example:"o_celonis_VendorInvoiceItem"."CreationTime" NOT BETWEEN {d '${datefrom}'} AND ADD_DAYS({d '${dateto}'}, 1)and elsewhere in the same KPI:"el_custom_SalesOrderItem"."TIMESTAMP" BETWEEN {d '${datefrom}'} AND ADD_DAYS({d '${dateto}'}, 1) When exporting this view to Excel via Action Flows, the Get Rows module lets me reference the Knowledge Model, but I cannot pass values for these variables.Using the Data Model instead allows variable injection in PQL, but then I lose access to predefined KPIs and calculated attributes, resulting in very complex, hard-to-maintain code.Question:Is there a way to dynamically set the variables of Knowledge Model KPIs when using Action Flows?

Over the Join Functionality documentation page (Join functionality (celonis.com)), when we get an 'No Common Table' error message - a detailed explanation along with the join path is explained. As I am new to the Celonis world, I wonder how to use the mentioned path to achieve the corresponding result.  Thanks in advance.

Hi everyone,we are currently restructuring our data architecture in Celonis. For each process area (P2P, AP, AR), we have separate data pools where we extract, transform, and load the respective data models.In the AP area, we already use a dedicated Central Extraction Pool, which only handles the extraction of raw tables. The actual AP data pool then receives these extracted tables and performs the transformations.Now, we want to extend this concept gradually to other areas. For example, we plan to stop extracting the CDPOS table in the Purchasing Pool and instead consume it from the Central Pool. This step-by-step migration should help us reduce redundancy and improve maintainability.However, I have a specific question regarding this setup: If I start consuming tables from the Central Pool in the Purchasing Pool (e.g., CDPOS), what happens to other tables like EKKO, which are still being extracted directly in the Purchasing Pool?Will my transformations in the Purchasing Pool use the l

Hi all,I have a question relating to “hygiene” in data pools.In my organisation we use manual data ingestion and upload files into our data pools. Over time, a large number of files and tables was added and created. I’d like to do a bit of house-keeping and remove obsolete/ unused files. How can I do that? I have analyst access.I look forward to hearing from you. Thanks.Kind regards,Vladimir

Hi everyone, We have several ABC Classifications that we need to implement in Celonis and I’m simply curious:Why is the ABC classification resulting in a 1, 2, 3 ranking? I’m ending up having to convert to string and remap the values for each classification so that it makes sense for the users and while it’s not a huge issue, I think it would be easier if the function just resulted in A, B, C directly. Is it for efficiency by using integers?  Or does this allow for some further analysis that I’m not seeing at the moment maybe? Best regards,Benjamin

Hello everyone, 👋I’m building an overlay view to show case details, using number as a variable.Currently, the overlay view has a predefined filter like this:FILTER "sc_req_item"."number" = '${number}'; However, I’d like to make the overlay more dynamic — for example, use another variable ${case_table} to replace "sc_req_item" (or even "sc_req_item"."number") so that the same detail view can work for multiple case types, such as Requests, Request Items, and Tasks. Has anyone successfully used a variable for table or column names in a FILTER statement (or found another way to make one detail page work dynamically across multiple case tables)?Any insights or workarounds would be really appreciated! 🙏 Thanks!BR,Xiangxiang

Hello everyone, I’m trying to use Action Flow to trigger chained data jobs, meaning job A is executed, once it’s done job B is executed, once it’s done job C is executed. Ideally, I would like to launch Data Model Schedule from Action Flow, but I’m only able to launch data jobs and load data model. What I’ve done so far is: 1. Creating json file with all my jobs ID (A,B,C) - Parse Json Module2. Creating a POST request using API Celonis Key, to access data pool and launch jobs, load data model -    HTTP Make a request Module3. Using Iterator module to repeat step 2 for all job IDThe issue I’m facing is, job A need to be completed before launching job B and same for job B and C (this is what I’m calling chained data jobs). Configuring a Sleep in the iterator loop greater than the running time of my jobs is working, but not optimized. My question is: Do you know if there is a way to trigger chained data jobs in Action Flow, meaning triggering Data Model Schedule or launching several jobs

Hi everyone I have a challenge that I’m trying to figure out related to pycelonis.I’m currently trying to get the component values from a view using pycelonis. Unfortunately, I couldn’t find any information inside the documentation that can help me with this.It seems that the documentation only explains how to work with analysis or knowledge models. Does anyone know how to work with components of a view inside pycelonis?Best wishes!

Hi allI have a very basic question – sorry for that, I’m quite new to PQL and I cannot apply the information available online (or did not find it).I have two tables incident_CASE with column CASE_ID (1-side) and workorder_CASE with column WORKORDER_ID (n-side) (1 incident can have 1 or more workorder).How can I count the following:Number of incidents with exactly 1 workorder Number of incidents with 2 or more workorder Many thanks for your supportBestroger

Hi together, I'm working with legacy views and can't manage to pass the value of an augmented attribute of type date to a variable to use it as parameter for KPIs. The record containing the augmented attribute  - id: CM_MONTHS    identifier:      id: id      displayName: Id      pql: '"CM_MONTHS"."MONTH"'    attributes: []    newAttributes: []    augmentedAttributes:      - id: late_creation_deadline_date        displayName: "Late Creation: deadline date"        possibleValues: []        columnType: DATE        format: "%Y-%m-%d"        housekeeping: false        type: AUGMENTED_ATTRIBUTE    flags: []    priorities: []    triggers: []    businessRules: []    type: RECORD    origin: PACKAGE The component to update the augmented attribute  type: table  settings:    data:      columns:        - id: 3486adcd-a996-49a5-97e0-af17da07e9af          field: CM_MONTHS.MONTH          order: 100        - id: 10c08937-649f-48a0-88fe-929d3107e824          field: CM_MONTHS.AUGMENTED_late_creation_dead

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.

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

Hi Everyone, In year 2022, I have gone through two certifications Implementation professional and solution professional, today when I tried to find these two certification I am not able to see it not training track and not in section called certification, in certification section only two certificates are shown, Data Analyst and Data Engineer. can someone please help to understand what is exactly have happened

Hello,I’m an independent consultant specializing in process optimization and based in the Netherlands. I often help clients adopt and integrate new tools to improve efficiency and am very interested in Celonis.I’m curious if there are opportunities for independent consultants like me to partner with Celonis. Specifically, I’d like to know if the partner program supports using the platform with clients and possibly providing training on the software.Could someone provide more details about the possibilities and requirements for such a collaboration?Thanks in advance!

Is it possible to use a KPI in a text box like in Legacy Views? I currently use this to display the last data refresh date of the use case in Legacy Views, but this option isn't available in New Views. Has anyone tried using any other component ?

There is a case I want to solve, see below. I have a solution I would apply if I had classical programming language + RDBMS, but I'm not sure how to implement this in celonis or whether there is another solution. Could you please help? The case I want to solve is sending email notifications to users via action flow in case there are missing invoice receipts.For each missing invoice receipt there is a notification type that can be chosen with their own subjects, body text, etc., for instance:If the date1 >= today + 7 days then group 1.If the date1 >= today + 14days then group 2.If the due date >= today - 7 days then group 3. One possible solution would be to keep the history of the sent emails in some table and join it to the missing invoice receipts data to filter out the emails for each new iteration of sending - so that we don't send some letters twice if we already sent them.E.g. if we had sent the email of type for invoice receipt no. 12345 yesterday, we don't

I'm encountering a persistent error in the View: "Failed to auto save the View. Please save your changes manually." Even when I attempt to save the changes manually, the View does not get saved, and none of the modifications to the UI are being retained. Is anyone getting the same issue? what could be the possible resolution?