Skip to main content

Ask the Community

Get answers to general questions and Academy-related topics from fellow users and experts.

1253 Topics
A
Level 1
adrian.eljas13Level 1
asked in General Q&A
How can I copy bookmarks from one analysis to another? We keep around 200 bookmarks shared across multiple users. All of these should now be migrated into a different dashboard inside another package. Is there any official method for such task?

How can I copy bookmarks from one analysis to another? We keep around 200 bookmarks shared across multiple users. All of these should now be migrated into a different dashboard inside another package. Is there any official method for such task?

30
Sverre Klein
Level 6
K
Level 2
kleber.cazot12Level 2
asked in General Q&A
What standard does Celonis use for JSON calls via API?

Hi, Can you help us with a question, please? What standard does Celonis use for JSON calls via API? RAW or X-www-form-urlencoded? Could you cite examples of these configurations within Action Flows? Thanks

20
H
Level 1
C
Level 3
chiara.vozzeLevel 3
asked in General Q&A
Issues with Asset Libray

Hello, I have been facing some issues accessing the Asset Library. I fill in with my credentials but messages like this appear: "You do not have access to the Apex class named 'qsydFileExplorerController'." Can anyone tell me why and how to solve it? Thanks

40
andré.tafur
Level 4
J
Level 2
juan.gomez12Level 2
asked in General 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    

90
janpeter.van.d
Level 8
S
Level 2
sankalp.malagLevel 2
asked in General 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) .

140
janpeter.van.d
Level 8
D
Level 4
douglas.henriLevel 4
asked in General 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
J
Level 4
joyce.cardo12Level 4
asked in General 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?

10
D
Level 1
itay.tarab
Level 3
itay.tarabLevel 3
asked in General 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 Q&A
May i know how to change the partner portal admins?

May i know how to change the partner portal admins?

20
V
Level 1
J
Level 2
juan.manuel.varaLevel 2
asked in General 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 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

00
Sverre Klein
Level 6
manuel.wetze
Level 5
manuel.wetzeLevel 5
asked in General 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    

60
manuel.wetze
Level 5
Z
Level 2
zaakir.essopLevel 2
asked in General 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

600
D
Level 4
J
Level 2
juan.gomez12Level 2
asked in General 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!!!!

10
J
Level 2
A
Level 2
andrzej.komor11Level 2
asked in General 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

450
A
Level 2
V
Level 1
viswanadham.maniLevel 1
asked in General Q&A
I completed my rising star technical assessment but didn't received my badge can any one plus help

   

50
D
Level 4
S
Level 3
samuel.delmo12Level 3
asked in General Q&A
Does Someone know how change the witdh of the histograms bar in views?

Hi, I know the doc says that you can suggest the width but i can't change anything. I can't undertant why sometimes i get something like this And others something like this 

20
D
Level 4
A
Level 1
anirudh.kLevel 1
asked in General Q&A
Need help with registering opportunity in partner portal to enable signing NDA (Non Disclosure Agreement) between our clients & Celonis.

We are planning to work with one of our customers to show case Celonis dashboards that we have created.  We need to get a NDA signed between our customer and Celonis, after which we can use their data for Celonis Dashboards. Upon reaching out to our Partner Manager, he provided us with the process that firstly involved registering the opportunity in partner portal (https://www.celopeers.com/s/partner-register-opportunity) and provide the customer name and contact person. When we tried registering we are getting the attached error, can you guide us on how to register the customer in the portal ?

60
D
Level 1
enrico.pugli12
Level 3
enrico.pugli12Level 3
asked in General Q&A
Calculate time between two activities without a third being in between

Hello everyone,I should create two KPIs: average times between two activities.1) the first one between activity A and activity B, in cases where activity C is not between these two activities2) the second between activity A and activity C, in cases where activity B is not between these two activities. So in a nutshell: the time between activity A and activity B, when the latter comes before C, and the time between activity A and activity C, when the latter comes before B.I leave a diagram to explain better.When there are only A and C without B, or only A and B without C it is very easy, but I cannot create when there are all 3. Can you help me? Thanks 

110
enrico.pugli12
Level 3
F
Level 2
felix.schilLevel 2
asked in General Q&A
Hey, I am looking for a way to load the tables inside a DataJob in a specific order. Do you know any solutions?

Hey, I am looking for a way to load the tables inside a DataJob in a specific order. Do you know any solutions?

00
F
Level 2
julia.bauer
Level 5
julia.bauerLevel 5
asked in General Q&A
Change material master data with SAP Action Flow Module

Hello everyone, can anyone share experiences with the SAP Action Flow module? As of right now, this seems quite risky as while testing the AF direct changes in SAP are made (when only having a productive environment EMS). In our case, I want to change material master data if several conditions are met. Thanks so much! BRJulia Bauer

100
julia.bauer
Level 5
T
Level 2
tom.buett11Level 2
asked in General Q&A
Hey, i recently tried TryCelonis and I was wondering what the percentage (KPI) related to the activities in accordance to on-time-delivery actually means. In the Talk Track, Celonis says, it effects the OTD-Rate by 62% e.g. How do they know?

... I mean, how can they compute this? First I was thinking 62% of those cases relatetd to that activity are on-time. But that would make sense with the rest of the analysis. I want to give a demo to a customer, but I'm concerned he asks that question and I have to admit Ito him that I dont know.

30
T
Level 2
V
Level 2
venkatesh.thotaLevel 2
asked in General Q&A
sir can anyone please help i didn't get my reattempts so please help me

sir can anyone please help i didn't get my reattempts so please help me

10
M
Level 1
T
Level 1
thanushree.m12Level 1
asked in General Q&A
How to collect badge

How to collect badge

20
M
Level 1
H
Level 2
hemamadhuri.mutyaLevel 2
asked in General Q&A
I am unable to get a reattempt. Kindly help me getting reattempts to complete my certification.

I am unable to get a reattempt. Kindly help me getting reattempts to complete my certification.

10
V
Level 2

Badge winners

  • Celonis Certified Data Engineer
    aparna.ajith11has earned the badge Celonis Certified Data Engineer
  • Qualified to Build Analyses
    suganya.balakhas earned the badge Qualified to Build Analyses
  • Qualified to Build Action Flows
    suganya.balakhas earned the badge Qualified to Build Action Flows
  • Celonis Certified Data Analyst
    vijay.v14has earned the badge Celonis Certified Data Analyst
  • Qualified to Build Analyses
    maria.bodnahas earned the badge Qualified to Build Analyses
Show all badges
Terms & Conditions

ANY QUESTION?

Talk to an expert
FAQs
Contact us

MORE CELONIS

Academy arrow_outward
Documentation arrow_outward
Support Portal arrow_outward
Partner Portal arrow_outward
Marketplace arrow_outward

CHECK US IN

LinkedIn
YouTube
Instagram
Facebook
Imprint
Disclaimer
Privacy Notice
Cookie Notice
Terms and Conditions
Celonis © 2025