General Product Q&A

Hello everyone, I'm trying to set up a new DM as the P2P Data model (with join EKPO and EBAN) only makes requisition numbers visible that were already converted into an order. With a separate DM I only want to see the requisition numbers that are open and not processed yet (with some other filters from other tables). Does anyone of you already set up such a data model? I'm currently getting this error message and I have already all the keys that should provide distinct data rows.  Thanks so much! BR Julia Bauer 

In the Windows under Data Integration where I write SQL Code for Transformations I sometimes have dark mode (white font on black background) and sometimes the other way around. It seems this changed from time to time and from environment to environment.Where can I set this? How is this being influenced? Obviously being a developer I want dark mode all the time 😁

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

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)

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:

Unfortunately, we couldn't find any documentation that explains how to send the data from a .xlsx file into a param in the HTTP module, the documentation that Celonis provides only explains how to push data for a CSV file into the datapool directly. In our case, we want to send the data of the .xlsx file to Machine Learning workbench to create a table that we can send to the data pool, but we don't know how to include the data of this file into the params in the request content from the HTTP Module. Does anyone know how to do that?

Dear Pablo, Apologies for the late reply as I've lacked access to my celopeers account for the past couple of months which just today got restored (most likely through my colleague Thomas' ticket, although it seems to have been reset from scratch). Unfortunately, the issue persists although we haven't gotten any closer to the cause or a possible solution, see case 00278943. Sorry, again, for not having replied sooner. I received the emails on celopeers' behalf but literally couldn't log in at all regardless of method, nor was I able to reset my password (no mails came through). BR,Bogdan Saroi