Skip to main content

Product Q&A

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

4408 Topics
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

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

30
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

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

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

30
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

20
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?

460
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, 

280
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?

20
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,

00
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?

20
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!

30
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

20
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

110
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    

100
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

1230
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?

10
D
Level 4
javier.desar
Level 3
javier.desarLevel 3
asked in General Product Q&A
Bar Chart Component in Views - Multiple KPIs without stacking under same X value.

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

110
S
Level 2
J
Level 2
joão.macieLevel 2
asked in Process Analysis
Time between two activities based on activity attribute

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!

140
S
Level 2
A
Level 1
akihiro.nishi13Level 1
asked in General Product Q&A
Confirm the PQL syntax for the KPI "Actual DSO" in the KPI.

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%

70
A
Level 1
J
Level 2
juan.gomez12Level 2
asked in General Product Q&A
# tasks by last date Events

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

40
J
Level 2
A
Level 2
andrzej.komor11Level 2
asked in General Product Q&A
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 B

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

780
A
Level 2
kunal.gupta12
Level 2
kunal.gupta12Level 2
asked in General Product Q&A
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.

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.

70
manuel.wetze
Level 5
sree.c
Level 4
sree.cLevel 4
asked in General Product Q&A
Do we have any limitation in task mining in adding number of users and does the data impact APC limits?

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

10
sree.c
Level 4

Badge Winners

VIEW ALL
Community Code of Conduct