Product Q&A

Is it possible to configure the ML workbench app so that users have read-only access to notebooks? In production environment, these notebooks should not be editable, but users should be able to monitor them by viewing the output of each cell.

Whai celonis infterface ? And to connect celonis Interface with client ERP system ?

Dear Celonis Community and especially Celonis developers. For those who are not up to speed, 19th April new version of studio and “Enhanced views” were released for the training environments. (https://academy.celonis.com/pages/news-and-announcements and https://academy.celonis.com/courses/studio-view-building-experience ). From what it is indicated under one of the videos, it is going to be release for public production environments on 12th May of this year.  I have went on a deep dive (well as deep as I could in such a short time) into these new features and must admit that I am deeply concerned, to the point that I want to ask is this a practical joke? A late April fools of sorts? I see that what is being implemented is not even a change or update to views, but a complete revolution. To such a degree that I am concerned about if and how will older assets work now? As the difference between old and new views are as big as it was between analyses and views when they were introduced.

What is the main differences between a validation cockpit and a process cockpit in an App or Demo? I looks like duplication to me but I am not sure if I am missing something.

Hello everyone  I am trying to perform a duplicate checking of vendor master in the machine learning module following the tutorial in the link:  https://celonis.github.io/pycelonis/1.6.0/tutorials/data_deduplication/00_Tutorial_Duplicate_Checking/ The problem i encounter is that all the libraries used in this tutorial seem to not function in the new version of Pycelonis 2.8.0   Is there any new tutorial for the data deduplication with Pycelonis ? otherwise how can i perform that using python without calling the library shown in the tutorial ?  Any help will be extremely appreciated :)  Best  Omar

Hello Celopeers, I would need your help in understanding formula similar to percentile functionality within Celonis. Preferably within Pivot table. Thanks!

Hello everyone, I have incorporated a KPI List to a View and for those KPIs shown in the list, I do not want them to be filtered with selections. In the analysis design this was possible via a check button. Where can I set this the same way in a view? Is it YAML coding? Thank you! Best regards,Julia Bauer

Hi team, I want to create a KPI to measure the proportion of items with missing routes. BUT I want the scope of my data to be filtered only on specific order types.I could add a filter on the component, but to make sure the KPI is always measured the same everywhere, I want to have the filter within the KPI calculation. I understand the below formula is not correct ('The aggregation function SUM cannot be used together with a dimension function input.') but I am struggling to find the solution. Any suggestion ? Thanks heaps CASE WHEN "VBAK"."AUART" IN ('ZCS','ZECH','ZEDI','ZCSG','ZEDC')THEN SUM (CASE WHEN "VBAP"."ROUTE" IS NULL THEN 1 ELSE NULL END)/ COUNT_TABLE ( "VBAP" )ELSE NULL END

I used the following formula: SUM(COALESCE(PU_SUM("EKPO","EKBE"."MENGE"*("EKPO"."UMREZ"/"EKPO"."UMREN"),"EKBE"."VGABE" IN ('1','7') AND "EKBE"."BEWTP" IN ('E','O') and "EKBE"."SHKZG" = 'S'),0) -COALESCE(PU_SUM("EKPO","EKBE"."MENGE"*("EKPO"."UMREZ"/"EKPO"."UMREN"),"EKBE"."VGABE" IN ('1','7') AND "EKBE"."BEWTP" IN ('E','O') and "EKBE"."SHKZG" = 'H'),0))  The KPI is aggregated at a material level and hence a CASE WHEN statement is giving me a warning. I had to use COALESCE becuase null value in the second part of the formular is making the entire value as NULL. Does this formula create rounding errors or with the existence of 29-Feb in the data? If I sele

Hi all,we've experienced an issue with an augmented attribute, couldn't figure out how to overcome it easily and hence, wanted to go back to a previously published version. However, the Publishing Date displayed seems to be completely off (displaying October 2023 instead of Friday last week etc.) and we are not sure we can rely on these previous versions now.For testing purposes we've done 2 more changes today and published - one is displayed with date April 10th, the other one correctly with today's date. => screen shot attached.Has anyone made similar experiences and, more importantly, recommendations how to overcome this, please? Thanks.Cheers, Ines Plath

Something like this: 

 I have a simple chart with a bar type for the left axis (number of cases), and a line type on the right axis for the process TPT. The thing is, my left axis goes up to 40k whilst I have a maximum of 5k cases. In other words, one of my axis is not self-adjusting correctly. I wanted to avoid using domain. This has happened before and only after edits, seems almost like a bug. Any thoughts? 

Which country is the eu-1 hosted location?

Hello guys, can you help me with this error message below? It started out of nowhere, I didn't touch this job and it started to show errors in it. I've never seen this type of error, have you ever experienced this? 

Dear Community, I hope this message finds you all in good spirits. I'm reaching out to gather insights on OpenAI's "PQL Expert", a feature available through the PRO license. Has anyone here had the opportunity to engage with this tool? I'm interested in understanding its capabilities and whether it offers significant advantages. Any shared experiences or evaluations would be highly valuable.Furthermore, I'm looking to connect with or learn about Jesse Ma. Does anyone have information regarding Jesse's affiliations, specifically if they are connected to a certain organization or perhaps directly involved with OpenAI's initiatives?Your feedback and any personal anecdotes regarding the "PQL Expert" or interactions with Jesse Ma would be greatly appreciated. Thank you for contributing to our collective knowledge and helping to foster an informed community.  Warm regards, Pablo

Has anyone tried replacing the On Premise Extractor to Celonis On Premise Client .have quite few questions

Hello everyone, can you help me please? I need to convert the field "T056P"."DATAB". Solutions can be in either PQL or SQL. But it's not returning anything. I've tried various methods such as: TIMESTAMPADD, ADD_MILLIS, ADD_SECONDS, CAST, TO_DATE, all without success. The return for the first three I mentioned was: Operator requirements are not met. Operator 'ADD_MILLIS' is not compatible with inputs of type DATE and STRING - expected DATE and INT."

UPDATE Test_Current_Year DSET Test_util=C.Test_util+C.full_Variance FROM(SELECT A.Test_util,B.full_Variance,A.Name FROM  (SELECT * FROM Test_Current_Year WHERE Month_Number=7) A JOIN(SELECT * FROM Test_Temp WHERE Month_Number=8) B ON A.Name=B.Name)  I am working on the forecasting requirement.Assume that the current month is 4 where data will not be available by applying the forecasting logic I should take last year's data into consideration like finding the variance of Apr,Mar of last year and add the variance value to the current year's Mar to fore cast as Apr data for current year..The month number should be adjusted dynamically based on the current month Example:current month=4(current year)(lastyear)Apr-Mar=variancecurrent year Mar+varince(above step)=Apr value(forecast) current month=5(current year)(lastyear)May-Apr=variancecurrent year Apr(got in previous step)+varince(above step)=May value(forecast) similarly I have to forecast till dec   

Is it possible to select objects and events so that the models correspond to the traditional Process Mining modells (single case notion..) If yes what steps are need?If not where is the limitation?

I would like a KPI with a custom title (yellow) instead of the KPI name (green). This KPI is reused multiple times and it does not make sense to have the same KPI created many times just to have the customized title (coming from the KPI name). Instead, is there a way to hide the KPI name on a KPI List component?  Thank you!!

Hello everyone, I'm currently working on a dashboard within a view. There are two points where I'm probably lacking the YAML syntax or perhaps the "functionality" is not available yet: 1) Example without data - KPI - I want to color the number (in %) in e.g. red - is this possible?2) I want to color the background of a column within an OLAP table - how is this possible in YAML? Thank you for your support! Best regardsJulia Bauer

Here is the code: ROUND_HOUR( "ITT_PRODUCTIVITY_F_SEP_UAT"."EVENTTIME" )

Was just curious that can we dynamically mention threshold value in color mapping? instead of mentioning static number. Just like in this image

In my activities table, I have cases like create incident A B C B A B Now I want to calculate the time difference between create incident and every occurrence of B. Example: (create incident and B (first occurrence), create incident and B(second occurrence), create incident and B(third occurrence)). After that, I want to calculate the overall average of these time intervals.

Hi everyone, There is a functionality within Celopeers to save posts in the "bookmarks". However, I can't find them anywhere. Does anyone know where to find the bookmarks within Celopeers? Thanks!