Product Q&A

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!

Dear all, trying to establish intelligent automation by and therefore looking for Integration options between Celonis and... Blue Prism Axon Ivy Power Platform Symbio GB-Tec SMAP One LUIS Cognigy AI Any ideas, connectors or Workarounds?

I understand, that I can't use the t("xyz") notation in PQL - neither directly nor as parameter - because it's YAML. But I must assume that there is a way, because of the first sentence after the note in the documentation: Analysts can enable App Translations and provide a translation Map for user-generated content like Knowledge Models, Views, etc. This feature is a Package setting, and changes are available when published.https://docs.celonis.com/en/translating-studio-apps.html

Dear Community,  does anyone have any idea on how to create a chart in a view with running sum logic, that means for: January 24: i would like to display the sum of purchase order value of the last 12 months from Jan 23 till end December 23 February 24: the sum of purchase order value (for example) from February 23 till end january 24 March 24: the sum of purchase order value ((for example) from March 23 till end February 24 and so on for the coming months. I can imagine that i have to build the logic in the KPI itself. Furthermore, i would like also to create a chart in a view with YTD Logic: January 24: Data, like purchase order value, just from January 24February 24: Sum of purchase order value of January & February 24March 24: Sum of purchase order value of January & February & March 24...... Thank you so much!

Hi all, I just found this cool functionality in a try celonis case and would like to know how I can show and hide this filter bar. Do you know how to do this? Unfortunately this try celonis case does not show the studio area. Thanks and best regards,Sarina

When I save PQL formulas in the new Studio, they are not assigned to a record as an attribute in the Knowledge Model, but each time as a KPI.  Again, custom records and attributes are not displayed for selection in the new Studio. 

Access the Order Management demo to answer this question. What are the top three late delivery root causes by case occurrence for customer Wallenquist Organization 11746?

Hi all,I need your ideas for architecture/approach on how to trigger a Machine Learning App every time a Datamodel is loaded.More specifically if there are new rows in a specific table. The Machine Learning App itself is also adding new data (to another table) and then reloads the model again.  My initial ideas where: creating a Trigger + Action Flow.Trigger based on the table which is the input for my ML App. The Action FLow itself is similar to an offical Celonis Example which triggers the App via API.But this has following limitations: limit of 10000 which makes it tricky. Furthermore this triggers for every new row. I only want to run it once. Not thousands of times for each new row. Scheduling by time:I could also run the Action Flow or even the ML App directly via timeschedule and time it so that it is after sufficient time after my new data is fully processed.This however is more unreliable as the normal process of extracting source/Transformations/datamodel load might take long

From the below data I need,1. Total Through put time by STAGES(I have used standard KPI of Total Throughput Time formula and component Filter by STAGE, even though not getting required output) 2.Total Throughput time by TYPE(I have used standard KPI of Total Throughput Time formula and component Filter by TYPE, even though not getting required output) NOTE: Getting total time for the both scenarios after giving the Total throughput time and component filter

Hello everyone, I want to build a worklist in Celonis with exception messages that purchasers should process. New exception messages should be marked with an augmented attribute (Status: NEW). I also have another augmented attribute - Comment field. I now want to store every changes made manually (change status from e.g. NEW to in Clarification or changes in comments) into a table as this table is needed to train an AI model. Is this possible - has anyone made experience with this and is willing to share their experience? Thank you! Best regards,Julia Bauer