Product Q&A

In my project, I'm experiencing an issue with PQL pull-up functions. I am utilizing pull-up functions because Level 2 and Level 3 Columns are generated based on augmented attributes (User Updated in Celonis). If I use those fields directly in the Logics, I get a common table error as we are pulling data from multiple tables.Using PU_FIRST gives me the oldest first record. Using PU_LAST gives me the latest record.I looked over the documentation, but I couldn't find any alternatives.I tried with BIND and DOMAIN Table Functionalities those are also not working. Please let me know if you have any knowledge on the aforementioned question Thanks in Advnace.

Payer: Combined Number and Name Logic- One Payer Name can have several Payer Numbers, so Table A always shows a list of Payer Numbers/Name Combinations. Table B should show only the SUM of the Costs of the Payer name. The Customer would like to have in Table A Number and Name combined in one column, Table B should always show the SUm of the above selection.  Table A: Variable: Payer Number/Name Combined Column A, Costs Colmun BTable B: Payer Name Column A, SUM Costs Column B I think the solution could be working with variables: I added two variables: Drilldown_dimensions and drilldown_text so if I select a payer both tables respond.  In Data Transformations I combined three different payer colmuns and also three different payer number colmuns to one column. So it is not possible to select only the payer_name for the selection.

Hi group! I am working on an action flow that will send a table with some information, the action flow is looking good, but it is sending separated emails, I need the full information in one table, being sent one time. The source is pointing to the query data, so not sure why is doing that..

Good afternoon, Just wondering if there was a way where I could use the variables we've set up in the Knowledge Model, inside the dashboards, for page filters, etc. Thank you!

I have 5 sheets in Analysis.When I select the dropdown value from sheet1 the data is getting filtered in all the 5 sheets.Instead of that how to apply the dropdown filter applicable to only the sheet1

Hi Celonis Team. I would like to have a meeting with Celonis representative regarding the Pricing Model. I learned "Celonis Licensing Scope and Pricing Metrics", and have questions. I work for partner, we have customers. Please advise the right contact.

How can I sort the KPI in a Pivot table in an Ascending or Descending order?

How many cases are covered by the five most common variants. A. 734,890 B. 404,562 C. 988,000

Community FAQ: How do I submit a ticket to Support? Answer:If you are a customer or a partner, you have access to Celonis Support Center in Celopeers. If Celopeers community could not answer your question or you have an issue that pertains to sensitive or confidential information/data, then you are advised to navigate to the “Support” button from the top navigation bar and click on “Support Center” to open a support ticket. Create Support Ticket: You have four options to create a support ticket.IncidentQuestionService RequestFeature Request You also have the option to view your previously submitted support tickets.

how can I change my specification to a academic cause while registering I gave partner and I cannot access to courses which is available for the academics with existing email

We used to the default throughput time template, and when attempting to filter based on a specific distribution range, the filter fails, causing the distribution to revert to its initial state.

Hello community, nice to greet you. In my project the need arose to join several columns into one. In addition I need to create a calculated field that adds the amounts that match the same description in different column, i.e. I need to add the 1223 that belong to "incomplete documentation" in the first column plus the 854 that belong to "incomplete documentation" in the second column. I have tried to make a distinct function but it does not work. Have any of you had a similar case? I hope you can help me, if more details are needed I will be happy to help.

Does BMC Helix offer any process intelligence capabilities?

I need to integrate two tables in a data model. The problem is : I create the tables distict values, but even for that the data model is failling to load. I´ve trying different ways to solve that, but not sure how to finish that up.

Hi all, is there an option to also create pop-ups when a viewer is moving with the mouse over a field or analysis? E. g. there is a button in the analysis that shows a KPI and when I am putting my mouse over the field there will show up the explanation how the KPI is calculated. I only no the functionality to create message buttons but this makes it confusing. Thanks.

Is it possible to carry the filters from one view to another view which are created on top of different knowledge models

we have 2billion records data so how much APC is required for that?

Hi all,I am sharing the relevant screenshots for the reference.The below YAML cade is written for predicted type column. Similarly for the relevant data on the other column Date I want the same color. How we can achieve this?

I want to show the year comparison in bar chart of View. For E.G.: I want to show comparison of year 2024 Vs 2023 in a bar chart (VIEW)

Rebalancing 2024: Supply Chain Agility with End-to-End Visibility Hello Celopeers! In recent years, external shocks like pandemic, trade blockades, inflation, and shift in interest rates have caused disruptions that have swung inventory levels from one extreme to another. As we anticipate the rebound effect, 2024 promises a recalibration—a pivotal year for enterprises in the pursuit of lasting agility. Prioritisation and Responsiveness:Supply chain agility involves two vital capabilities: early problem identification and the speed and efficiency of the reaction. With technologies like Object-Centric Process Mining (OCPM) and the End-to-End Lead Times App, Celonis eliminates inefficient and manual reporting while providing tailored insights instantly so that enterprises can swiftly prioritise and execute actions. Celonis in Action:German manufacturer Freudenberg exemplifies enterprise agility by gaining end-to-end transparency with Celonis. “Celonis makes material shortages more transpa

We are currently migrating from Celonis 4.7 on premise to the cloud EMS. I have certain 'old' pyCelonis scripts that I would like to run against our local Celonis instance. I'm currently using pyCelonis 1.2.8, which is of course greatly outdated and which I would like to upgrade. However, as of 1.6.0 (where the docs start) I don't see any mentioning of connecting to an on premise instance. Before I start to trial-and-error update, I hope someone here would be able to help me pinpoint to which version I can update without issues. Does anyone have any experience with this???

Community FAQ: What functionalities are available in the editor? Answer:When you ask a question or share an update via a post, you have the following functionalities available to you:Text Editing: Utilise features like bold, italic, emojis, etc.Tagging Members: Mention others using "@" for direct communication.Image Upload: Enhance your posts by uploading images.Tags: Increase the visibility of your question or post by adding the relevant tags.File Attachment: Easily attach up to 10 files through the attach-file icon at the bottom left corner of the editor.Video Integration: Easily include video links in your post for a preview from various domains. You can even play YouTube videos right within the post!Please leave a like if you found this helpful!

Hi there, I have the following table:  We got for every part diffrent timestamps with a specific work done there. I would like to calculate the date between the installation and removal date. The problem ist, that for one part there can be historical data with multiple removals and installtions (like you see in 'Y'). Here I would like to calculate the difference by taking the installtion data followed by the date of the next removal.  I tried the Lead Function: DATEDIFF(DD, (Lead ( ('DATE'), ORDER BY ('DATE' DESC), PARTITION BY ('PART', 'WORK'),1)),  (DATE) ) The problem here is that this function calculates only the days between the removals.Do you guys have any idea how I can get the dates between the installation and removals dates? Thank you and best regards!

Hey everyone, I keep on struggling solving issues on Celonis and not being able to find questions related to my topic here on this website or online in general. Often quite "basic" questions or at least advanced ones where others probably were also stuck at that problem. Celopeers is really great but we all know the downsides of forums. Just look at the SAP documentation and help online. It is really hard to get things done efficiently. Programming languages have Discords, other forums and community hubs. Celonis is, compared to a programming language, obviously way smaller (community wise). But is there anything else similiar to Celopeers or e.g. a simple discord server for Celonis? Or any interest in creating such thing for faster and easier connections among celonis users. Including an easier way to help others and learn. I just dont want Celonis to be SAP 2.0 in terms of knowledge transfer.    

Hello Celopeers.  I have a variable that is a list based on a dropdown component.The end result looks something like this:'0014','0191','0311' Now I want to pull a specific value from this variable.Problem is, that any function calling it is either pulling only the first value, or doesn't really give me the value I need (in this case a second or third value) Examples I tried already:1.Input:<%= VARIABLE%> Output: 0014 2.Input: RIGHT(<%= VARIABLE%>,4)Output: Error, Operator 'RIGHT' requires 2 inputs but 4 were provided. 3.Input: CONCAT(<%= VARIABLE%>)Output: 001401910311 4.While combining the RIGHT or LEFT with CONCAT might be able to be helpful enough with some tweaks if the variables had all the same length, they have varying length. some being 4 characters long, some up to 14.Input: RIGHT(CONCAT(<%= VARIABLE%>),4)Output: 0311 Therefore is there some way to call specific value from the list like in Python it would be: Input: