Product Q&A

I would like to know how the "data_consumption_updated_events updates" works, since for some tables the "_CELONIS_CHANGE_DATE" is related to a very old date, and this field should show the current DateTime for each table that I want to track.  So the data consumption in the monitoring for each table is different from the one that is being generated in the custom monitoring pool. I would like to understand the reason for this.

Can i create a Conformance Ratio KPI (like on the Conformance Overview) using the conformance query

Hello,In a use case we have 4 activities where we are trying to find the throughput time between 2 events from 2 different activities tables , when we used event log merger it pops up an error message showing the row limit exceeds to 5 billion rows , though we have 6.11 million in one and 29 million in one event count (Distinct event) .

I would like to retrieve the second and third approver of the timesheet. Can you help me? I'm trying this logic, but it's not working :  PU_FIRST (    "ESSR_MIRO",   "_CEL_ESSR_ACTIVITIES"."USER_NAME",   "_CEL_EBAN_ACTIVITIES"."ACTIVITY_PT" = 'Release'   INDEX_ORDER ( "_CEL_ESSR_ACTIVITIES"."USER_NAME",       ORDER BY ( "_CEL_ESSR_ACTIVITIES"."EVENTTIME" ASC),       PARTITION BY("_CEL_ESSR_ACTIVITIES"."LBLNI" ) = 2)  

Hi everyone, we want to restrict access to users for a dashboard. Therefore we match the user_name() to an uploaded excel.  But since some users should see whole regions and others just single plants we want to adapt the dimension based on the excel input. To make it more understandable: FILTER VBAP.WERKS = (CASE WHEN EXCEL.EMAIL= USER_NAME() THEN EXCEL.WERKS) This is working fine. However making the "VBAP.WERKS-part variable doesn't work yet. (CASE WHEN EXCEL.EMAIL = USER_NAME ( ) AND ISNULL(EXCEL.WERKS) = 0 THEN EXCEL.WERKS' ELSE 'EXCEL.REGION' END) So the idea is that this also leads to: FILTER VBAP.WERKS = EXCEL.WERKS Does anyone have an idea how I have to adapt the part that chooses the dimension? Best regardsAram

I want to capture the Username of the logged person when executing the action flow. How can I achieve that?

I'm reaching the limit of the Microsoft 365 Email Send Message in Action Flow. Since Celonis does not support a service account what else I could do? Thanks in advance, 

Hi everyone! I created a action flow using webhooks custom, but when I run it, th csvs are arriving separated, I want to get all in one email, does anyone has any ideas?

Hi All, We are trying to analyze IT project approvals in the organization.Our internal customer asked us to order the columns based on the duration time.We did it by adding "SortBy" to the YAML configuration of the bar charts,Once done, the values of the number of project (second layer of 'Points') are increased.Can someone explain me the reason? How can it be resolved?Adding images before and after the change: Before: After: Count of projects increased to 4000 from 800. Values also increased. *Change marked in blue. Best regards,

May i know how to change the partner portal admins?

Hi everyone.  I'd like to know whether the "Public link" option is available to students with academic licenses. In one of the assignments for my master course I ask the students to share with me the link to the analysis(dashboard they have developed. Apparently, they are not being able to configure such public access. See below Thanks in advance!

Hello all,can you explain me why the first answer is false? I would say that it is false because when you use the MEDDPICC forumula you are just trying to confirm pain points and then you would need an executive alignment to end the phase of "qualify the opportunity" and so

I have to implement a functionality where:There is a table for my vendors with multiple line items, each line item has a Rating field which can be blank or some value.SO when I click on the Vendor code, an overlay view opens.Now on this view there is a button, clicking on which I need to perform different actions:If there is a rating for that vendor, then trigger an action flow. I have created the action flow but not the conditionIf there is no rating for that vendor, then open a message pop displaying a Text. What I need help with is, how do I put a condition on the button to check if the rating exists or not and then open the message pop up.Bros ​@Abhishek Chaturvedi​  @Dipro Banerjee​ Help! :)

Error while executing transformation Create Table: O2C_VBAP_STAGING, with id 9cad7fcb-8759-4fc6-81d0-67d45242ee78: ERROR: Relation "MAKT" does not exist

I have a quite complex query to calculate a KPI and want to limits its result to a maximum value.  This max value is stored in a variable with an absolute value of e.g. 2.If the actual result of the KPI is higher than 2 the PQL should return 2. I set this up as an CASE WHEN but this is repetitive code which is badfor readability and maintainabilty.  Are there more consise approached possible with PQL? e.g. using a Max(KPIcode, Limit) Excels Max function works something like this. But PQL Max works only on a column. just for reference my PQL looks something like this:CASE WHEN (... 5 lines of code to calculate KPI) > <%= Limit %> THEN <%= Limit %> ELSE (... 5 lines of code to calculate KPI) END    

Hi.Is there a way to calculate the average time taken to complete an activity or event. The time would be based on the timestamp of the event in question and the event that follows. This needs to be as a KPI so that is can be applied to large event data sets EgEvent A ----Event B ----Event C |_______Event DSo the average time for Event B would be the average of Event c and Event D subtracted from event B.The ask is to display it in an OLAP table as follows: Column1 Column 2Event Name Average time taken in mins

The column chart when spit by x axis resulting in displaying booth the KPIs but the space between both bars are inconsistent throughout and also in the 4th column is the second bar stays hidden.Can somebody help out with the solution for this?

Hello!  I am looking at the documentation for Column Charts in Views and cannot find any YAML code that shows me how to plot different KPIs side by side to each other (each in a different column) and not stacked onto each other. Does anybody know how the YAML code for it would look like? Just 2 different KPIs under the same dimension X value.  Thank you very much!  Javier

Hi, I need to calculate the time between two activities that are not directly followed by each other taking an event attribute into account. Example: Calculate time between A and B where: Both activities A and B happen more than once in the processTo get the correct throughput time, we need to consider an activity attribute (e.g., campaign_id). In our case, if activity A happens three times, it will have three distinct campaign ids, so we need to match those ids with the ones in activity B. How can I implement that in Celonis? I tried using SOURCE() and TARGET() from the example in this post , but it seems it only works for directly followed by activities, so there was no data for my chart, as A is never directly followed by B in this case. Thanks a lot in advance!

My customer installed the following Apps from Marketplace and check the KPI.・SAP S/4HANA - Accounts Receivable - Working CapitalShe would like to confirm the following PQL syntax for the KPI "Actual DSO" in the KPI.Here are the three points she would like to confirm.(1) What is the formula for KPI_AR_DSO calculated for?(2) What do {p1} and {p2} represent in the formula?(3) If I understand (1) and (2), I may know what Actual DSO is calculating.It would be helpful if you could also tell me what the Actual DSO is KPI to produce.―――――◆AppsSAP S/4HANA - Accounts Receivable - Working Capital◆KPI nameActual DSO◆KPI PQLKPI("KPI_AR_DSO", <%= VAR_US_CURR_TIMEFRAME_START %>, <%= VAR_US_CURR_TIMEFRAME_END %>)KPI_AR_DSO:SUM(  CASE    -- When the date is right    WHEN PU_FIRST("<%=VAR_GS_CASE_ITEM_TABLE%>", "_CEL_AR_ACTIVITIES"."EVENTTIME", "_CEL_AR_ACTIVITIES"."ACTIVITY_EN" = '<%=VAR_ACTNAME_ENTER_IN_SAP%

Hi there!I'm just begin with Celonis and i need to show the #tasks with the last timestamp. My data model have several Case_ID with "n" tasks associated with each case_id and each task have "n" events associated to each task. Each event have a timestamp and user.I want to show the number of tasks closed by each user, setting the criteria of closed task like the last date in timestamp of all events associated to that task. I'm not suer if i've explain clear....... Thanks a lot in advance!!!!

I would like to create a dynamic date filter in Data Extraction jobs so that every time my extractions will contain the last 24 months of data. For example, on March 15, 2024, I would like to have my start date set up as March 1, 2022, for the BUDAT field

Hey Guys, Do you know how to join two pql dataframes in Celonis MLWB? The objects are of class: 'pycelonis.pql.data_frame.DataFrame'. I tried to convert them to pandas dataframes using to_pandas() but my kernel dies and restarts.

Do we have any limitation in task mining in adding number of users and does the data impact APC limits?