Skip to main content

Product Q&A

Ask questions and get answers about Celonis products from experts and peers.

4436 Topics
J
Level 2
juan.gomez12Level 2
asked in General Product Q&A
Error in formula using variable

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    

163
janpeter.van.d
Level 8
kandi.naidu
Level 4
kandi.naiduLevel 4
asked in General Product Q&A
I have query, How I can create a table where values should be select from the dropdown in views (when I select specific or multiple values in dropdown used in views)

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.

203
janpeter.van.d
Level 8
J
Level 4
joyce.cardo12Level 4
asked in Data Ingestion & Infrastructure
Hi everyone! I am trying to create a dropdown selection on a column, to chose from "Yes" "No" but I am not able to, not sure why.. I created an augmented attribute and put the possible values, but the dropdown is not working.. Does anyone have a

74
janpeter.van.d
Level 8
J
Level 2
jenea.mdLevel 2
asked in Data Ingestion & Infrastructure
How to get Distinct Case Key with values different than 0?

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!

64
J
Level 2
P
Level 3
pedro.pinedLevel 3
posted in Data Ingestion & Infrastructure
Hello,

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.

23
carlos.taleg11
Level 5
enrique.sanch13
Level 3
enrique.sanch13Level 3
asked in Data Ingestion & Infrastructure
Celonis Agent for JDCB bbdd

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,

24
enrique.sanch13
Level 3
kandi.naidu
Level 4
kandi.naiduLevel 4
asked in General Product Q&A
Hi Everyone!.I have a query. How do I transfer entire production instance data to another instance?.If possible, please let me know asap.

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

173
kandi.naidu
Level 4
M
Level 2
maicol.munevLevel 2
asked in General Product Q&A
Preview email (in action views) before sending email

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

61
janpeter.van.d
Level 8
andres.naran12
Level 4
andres.naran12Level 4
asked in General Product Q&A
Hi everyone! I have a question regarding Data Consumption Monitoring. I have some tables that run every day and I'm able to see that change in the Monitoring. But when I enable the custom Monitoring Pool, I can see that those tables are not bein

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.

47
janpeter.van.d
Level 8
L
Level 3
louis.forst12Level 3
asked in General Product Q&A
Can i create a Conformance Ratio KPI (like on the Conformance Overview) using the conformance query

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

157
janpeter.van.d
Level 8
S
Level 2
sankalp.malagLevel 2
asked in General Product Q&A
Throughput time between 2 events from 2 different activities.

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) .

181
janpeter.van.d
Level 8
D
Level 4
douglas.henriLevel 4
asked in General Product Q&A
Approvers

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)  

32
janpeter.van.d
Level 8
A
Level 3
aram.wLevel 3
asked in Data Ingestion & Infrastructure
Variable Filter Dimension

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

21
janpeter.van.d
Level 8
S
Level 2
saivishalreddy.gurijLevel 2
asked in Process Improvement
I want to capture the Username of the logged person when executing the action flow. How can I achieve that?

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

573
mateusz.dudek14
Level 7
F
Level 1
fabio.mitsuLevel 1
asked in General Product Q&A
Hi everyone!Is there any work around for Microsoft 365 Email Send Message Action Flow reaching the mailboxConcurrency limit?

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, 

332
mateusz.dudek14
Level 7
J
Level 4
joyce.cardo12Level 4
asked in General Product Q&A
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 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?

21
D
Level 1
itay.tarab
Level 3
itay.tarabLevel 3
asked in General Product Q&A
SoryBy is changing the values!

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,

04
itay.tarab
Level 3
M
Level 1
muhamad.zaki.abdulLevel 1
asked in General Product Q&A
May i know how to change the partner portal admins?

May i know how to change the partner portal admins?

31
V
Celonaut
J
Level 2
juan.manuel.varaLevel 2
asked in General Product Q&A
"Public link" option for students

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!

43
J
Level 2
C
Level 3
chiara.vozzeLevel 3
asked in General Product Q&A
Identify and Drive Opportunities

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

32
Sverre Klein
Level 6
S
Level 2
sanchit.khann11Level 2
posted in Process Analysis
I have to implement a functionality where:

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! :)

93
abhishek.chatu14
Level 7
itay.tarab
Level 3
itay.tarabLevel 3
asked in General Product Q&A
We have connected one of our SAP system to Celonis with the O2C extractor provided by Celonis.We managed to execute the extractions in full load but when we are trying to execute the transformations in full load we are running into the next failure:

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

134
itay.tarab
Level 3
manuel.wetze
Level 5
manuel.wetzeLevel 5
asked in General Product Q&A
PQL function to get maximum of two values (similar to Excels MAX function) to make a upper limit.

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    

123
manuel.wetze
Level 5
Z
Level 2
zaakir.essopLevel 2
asked in General Product Q&A
Average time per activity/event

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

1357
D
Level 4
S
Level 2
somrithran.sekarLevel 2
asked in General Product Q&A
Inconsistent spaces in Column chart in Views

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?

12
D
Level 4

Badge Winners

  • Masterclass in Implementation
    alvaro.illanhas earned the badge Masterclass in Implementation
  • Masterclass in Implementation
    WR_SNhas earned the badge Masterclass in Implementation
  • Masterclass in Implementation
    menka.krishhas earned the badge Masterclass in Implementation
  • Masterclass in Implementation
    Namit Singhhas earned the badge Masterclass in Implementation
  • Masterclass in Implementation
    suresh.jassahas earned the badge Masterclass in Implementation
VIEW ALL
Community Code of Conduct