General Product Q&A

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

When I put only formula for 'no-touch' rate is shows correct value (if 1 out of 3 cases meets criteria then it returns 33%). But if I add no of activities (total: 37) it changes to 46% (calculates no of activities within case that fulfils criteria and divides by all). Any tips how to come up with no of activities (37) in column A and correct ratio per case (33%) in B? Thanks in advance for any guidelines. *** AVG( CASE  WHEN PU_COUNT("VBAP","_CEL_O2C_ACTIVITIES"."USER_TYPE","_CEL_O2C_ACTIVITIES"."USER_TYPE" IN ('A','B','C')   AND "_CEL_O2C_ACTIVITIES"."ACTIVITY_EN" IN ('X','Y','Z')) = 0    THEN 1.0  ELSE 0.0 ***Case A # of Activities No TouchA 17 yesB 10 noC 10 no 

Hi All,We have few use cases where we want to do task mining quickly and show results.What all use cases you have used Celonis task mining are there other better tools to do it

I have two log tables, Tables A and B, that are in n-type connection with my main table (the Case table), i.e., the Case table is 1: n type relation with Table A, and the same with Table B. As log tables, Table A and Table B record certain activity, whereas Table B records others. I need to identify activities that are repeated by merging the data from Tables A and B at the process analysis level. Requesting advice

Hello.I'm Ishizuka. How and where can I modify it to avoid module timeout errors? What is the cause? My guess is that the error occurred because there was so much data extracted in the "SELECT" statement of the query that it almost exceeded the one minute limit.---------------------------------------Error SummaryError details (example)

Hello everyone, I have set up an AF that sends data to our purchasers and also sends the data via a HTTP module to a Webhook: About 6.5k data rows will be submitted in the queue of the webhook AF and will be pushed to a table in the data pool every 2 minutes (300 data rows per execution). At the end of the run of the AF, the table in the data pool does not contain the same amount of data than the data (deviation to 6.5k). Hence, I was guessing that some execution did not work correctly. When looking at the executions, this was confirmed - some executions have this error message:  I tried filtering these executions by adding the BREAK module (with Filter for status code 400 - to stop the execution and store it in incomplete execution) but this does not the desired thing I wanted it to do. Did somebody else have the same issues? Thank you! Best regards,Julia Bauer

1- The AF is running quite ok, but the email is being sent a lot of times, I need to send it out just one time, not sure what is causing it. 2- I need the price to be reflected in USD currency, but when the sheet is being filled, the currency is being set to euros. Can anyone advise? thanks a lot 

Hi celopeers!I would like to know if any of you when implementing a solution using an Action Flow have used any framework to ensure its lifecycle. I mean what steps have you followed to build, test, release to production, monitor and manage the changes of an Action Flow? Thanks!

In the latest project, an OLAP table was employed, featuring distinct attributes for each individual case. Certain attributes are not universally applicable across all cases. We know that Celonis automatically inserts "-" in null values; however, we aim to modify this default value to "no information." Despite attempts using functions such as coalescence, case when is null, case when isnull(), none of these methods have proven successful. Could you kindly suggest an alternative approach? If additional details are required, please feel free to request them. Thank you for your assistance.