Product Q&A

Hi there!I've a problem using a variable in a formula of OLAP_TABLE.I've two variables (Interv_1, prueba_var1) text/replacement Type, with values:Interv_1=OTHERPrueba_var1=3 If i want to use it in a text component, with variable "prueba_var1" is OK, but if i use the Variable "Interv_1" i have a formula error. I don't understand why..... Thanks in advance    

Hi Everyone, Hope your all doing well, I want to create a table where the data stored in it will be values selected from the dropdown in the view. Please share any suggestion asap. Thanks, KANDI AJITH NAIDU.

Hi everyone, I am trying to build an OLAP Table where I need to have "Case Key" Column. The problem I have is that I need to highlight just the CASE KEY Values (distinct) for which in column "Parameter" the values are different then Null. Here is the input table: Here is how the Output Table should look like:  Any idea on what should I do to get that OLAP Table? I tried with CASE WHEN + ISNULL Functions but so far without any succes. Thank you in advance for any tips!

Hello,   I want to clear filtered selections on other sheets (Celonis EMS free plan with Process Mining)/the selection only affects a specific sheet. I have not been able to do this, any ideas?   Thank you very much.   Best regards, Pedro.

Hi,  i would like to know how is it posible to uptade a record of my database connected to Celonis by jdbc by an Action Flow. I consider that i will need a Celonis Agent, but i can´t find it. I don´t know if it is only exits for SAP. and then, which is the component i have to use on Action Flow ? Thanks in advance,Sincercely,

Hi Everyone!. I have a query. How do I transfer entire production instance data to another instance?. If possible, please let me know asap.

Good afternoon,  We have an Action View configured that has a Send Email Action Flow attached that, for each record invoice code, will send an email to a Customer with information. To this end, we have been looking for a way to preview the email, via a click for example, so that you can view the specific email being sent and possibly make any changes.   How could we achieve this?   Thank you Maicol Munevar

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?