Skip to main content

Product Q&A

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

4433 Topics
vamsimadhavg
Level 2
vamsimadhavgLevel 2
asked in Data Ingestion & Infrastructure
Need to Trigger Action Flow for Last Refresh Date

I am trying to make an action flow which gets triggered when the data load is more than a day old i.e., when the data load failed, and we are unaware of the failure. Current problem is that I am able to get the last refresh date from event log which is the MAX of the time stamp but to put a trigger to see if the MAx is more than a day old, the FILTER function in general does not allow aggregations. Is there a way out of it or any other path that can be taken to create an action flow to trigger a mail if the last refresh date is more than a day old.

472
vamsimadhavg
Level 2
vamsimadhavg
Level 2
vamsimadhavgLevel 2
asked in Process Improvement
Merge two parallel paths in action flow

Hi, I am trying to query data in Celonis module in the Action flow . However, I have requirement to split the data into two paths and then prepare a csv and then merge it back into one using a text aggregator. Is there a module that can merge paths in action flow. Or is there a way to split data based on filters and merge or append it into one file

450
vamsimadhavg
Level 2
thomas.keim
Level 5
thomas.keimLevel 5
asked in Process Analysis
New Studio: Table component "calculate share in percentages"

Hello Community,I'm currently migrating my analyses to the new views and have encountered a “problem”. I hope you can help me solve it:Within “Analysis” the table component has the function “calculate share in percentages”.Hee it is possible to calculate the percentage of a column per line, also what percentage of the total for a column a line represents.How does it work in the new views?Thank you so much for help.Best, Thomas  

1312
thomas.keim
Level 5
thomas.keim
Level 5
thomas.keimLevel 5
asked in Process Analysis
Calculate total amount of calendar weeks from date picker selection

Hello crowd,I need your swarm knowledge for this issue:I selected July + August in date picker, which is 9 calendar weeks.My objective is to calculate the average sales orders per customer per calendar week.You can see it in my screenshot. One customer per line, count of sales orders and count of calendar week where sales orders are created.The challenge is, that not every customer is ordering in every week.My question is: How do I get the total number of calendar weeks (9) from the date picker in my formula?I would like to divide the “number of orders” by the “total calendar weeks from date picker” and not by the calendar weeks in which the order was placed.Best, Thomas   

220
thomas.keim
Level 5
KenshiroYasu
Level 2
KenshiroYasuLevel 2
asked in Process Improvement
How to use a trigger with Watch Trigger

Hi, I am just learning about Trigger with Action Flow in an academy.But I am in a trouble how to use a trigger for Action Flow that I made in KM.After making this, I tried to use it but It could not be shown in a setting field.How do i solve this problem?  

1141
W
Celonaut
michael.kohlm
Level 2
michael.kohlmLevel 2
asked in Process Intelligence Graph (PI Graph)
Merging CSVs

Hello, I have received the data set I want to analyze in several CSV files (due to the row limit of 1 million rows). Now I would like to merge this split CSV data set in Celonis, but I have not found the function to do so. The data set is structured in such a way that CaseID, Activity, Timestamp and other case information are each in one line, as can be seen in the screenshot. Thank you for your help.Edit: Sorry for posting in the wrong category, it looks like it can't be changed.

552
michael.kohlm
Level 2
mateusz.dudek14
Level 7
mateusz.dudek14Level 7
posted in General Product Q&A
Hey, I wasn't logging into celopeers for some time, congrats on being first! :)

Hey, I wasn't logging into celopeers for some time, congrats on being first! :)Celonis defenitely should send you a t-shirt or something else! Thanks for engagement, probably I'll also return to helping some people here.

161
mateusz.dudek14
Level 7
lyzanne.tr24
Level 2
lyzanne.tr24Level 2
asked in Process Improvement
Sap URL creation

We are working on linking the ordernumber from Celonis to a link in SAP perferably to 4hana. Does anyone know of a way we could automatically generate such a link?

200
lyzanne.tr24
Level 2
deepak.sharm12
Level 2
deepak.sharm12Level 2
asked in Process Analysis
Send Email option in Table in View

Hi Community, while using Send Email action in Views table, there are 2 options:Launch default email program and Send from serverbut second option is disabled and status is ‘In Progress’ (unable to select it and proceed with this option). what’s the meaning of this? is it a permission issue or what?please check attached image as well. 

360
deepak.sharm12
Level 2
wein.nadin
Level 3
wein.nadinLevel 3
asked in Process Improvement
Hide/Unhide Tabs in new Views

Hello,  do you know if it’s possible to hide/unhide tabs in a new view as a business user in apps?  

541
S
Level 3
bennita.dutoi12
Level 4
bennita.dutoi12Level 4
asked in General Product Q&A
concatenating in data jobs

Hi Everyone. I am trying to create a table in Data Jobs, but I want two zeros infront of a number.  nothing I try works? what could the issue be? See ‘00’||”COL-1” 

80
bennita.dutoi12
Level 4
ivana.ljubi
Level 2
ivana.ljubiLevel 2
asked in General Product Q&A
Resend invitation to only pending users

Hi,is it possible to resend invitation after 14 days of unaccepted invitation, as using “Sharing invitation” task is not working. It is showing message “only user with pending status can be selected” but I selected exactly those users. Would be good if I can resend invitaiton with one click, rather than using blue button “invite new users” and type all emails again..Thanks. 

261
abhishek.chatu14
Level 7
preena.nair
Level 2
preena.nairLevel 2
posted in Process Analysis
Process order/Production order

what insights generation can be done for production order

280
preena.nair
Level 2
lukas.deeke
Level 2
lukas.deekeLevel 2
asked in Process Analysis
Filter the sequence

Hi All, I need a filter that filters out all activities where activity “A” is not first. So i only want to see all cases where the correct acitivty sequence is A → B → C → D...

191
manuel.wetze
Level 5
romayssa.bedja
Level 2
romayssa.bedjaLevel 2
asked in Process Analysis
Multiple lines in the line chart within the new view

Hello Celonis community,I’m building a new view and I need to set-up a line chart with multiple lines. Basically, calculating the same value but for different types and plotting them in differently colored lines.In the analysis set-up I used to duplicate the metric for each type and force filter within the PQL metric for the specific type. Now, with the view set-up we can plot only one line, sicne we cannot add multiple Y-axis.Is there a new way (ex. like the “hue” attribute in seaborn library for python) to do this? Or a tip workaround to be able to do it ?

1202
romayssa.bedja
Level 2
E
Level 4
e.nLevel 4
asked in General Product Q&A
Data model Error

I got the following message. but I do not know how should I solve the problem. Could you please explain the detail? Data model load failed during load to engine: Could not load data model. Load failed. Error Message: Could not execute foreign key join: there are duplicates on both sides of the specified key relationship. Table "A": key column ("E"), key ('00058B2D25244258B806'), rows 1 and 2. Table "B": key column ("E"), key ('EEE3E74B186040F48522'), rows 29 and 35. Celonis Support ID: e9012fd3-bf7c-4e59-9d7a-6b92484458a2

885
andrew.yen
Level 2
M
Level 2
maximilian.alterLevel 2
asked in General Product Q&A
Hello, Is it possible to create a PDF Report of Views?

I created an Action Flow for PDF Reporting, but can only select my Analysis. Do you have an idea how to or if it is even possible to get my view(s) automatically into a PDF File.Kind Regards, Max

574
B
Level 2
lucas.fisch12
Level 2
lucas.fisch12Level 2
asked in Process Analysis
PDF Export of View (JAB) does not work

Hi all, The Celonis module that creates PDF's in Action Flows can't find my View. The Connection seem to work with the App Key that also has the right permissions and the View is also published. I always get the error "Something went wrong while handling the request. Please contact Celonis customer support. Celonis Support ID: e9c4bdad-04c3-49ea-b834-0e2dc618323b" from the 'Analysis' dropdown within the module. Does the Module even work with the new Views (JAB) since the next Parameter I need to fill in is 'Sheets' but the new View doesn't have Sheets, it has Tabs?

644
B
Level 2
C
Level 2
carlluca.muenk11Level 2
asked in General Product Q&A
Login into Projects

I've been experiencing a recurring issue with the sign-in process for both my Bentley and ABB projects. I often get the same error message, and while clearing cookies and history sometimes helps, it doesn’t always solve the problem.Has anyone else encountered this? Any suggestions for a more permanent fix, or is there someone specific I should reach out to for support?

20
C
Level 2
manuel.wetze
Level 5
manuel.wetzeLevel 5
asked in Process Analysis
Conformance Checker (Analysis) Problems with parallel arcs

Hi all,I encountered some problems with the Conformance Checker Sheet in the Analysis.I did model a BPMN model and its rather simple but has some AND parallel arcs as illustrated below.In natural language “A,B,C has to be finished before D starts,but the A->B arc and C can happen independently of each other”.In the Overview I can now see Violations like:A is followed by C B is followed by C C is followed by DAll of which I would consider allowed in the sense of the model. Of course I can manually whitelist all of the violations, but this is rather high maintenance and distributes the single point of truth which should be the model. For me it is about understanding if this is a limitation of the Conformance Checker.Did anyone experienced something similar and solved it?Or is my model wrong? 

512
manuel.wetze
Level 5
maxime.psbpm
Level 3
maxime.psbpmLevel 3
asked in General Product Q&A
Service Request Management connector (for ServuceNow)

Hello,As a new user of Celonis, I wanted to check if it's normal that some process connectors, such as the Service Request Management connector (for ServiceNow), don’t come with out-of-the-box applications. In such cases, is it up to us to build our own package from the ground up?

252
maxime.psbpm
Level 3
Kalex
Level 2
KalexLevel 2
asked in Process Analysis
Median Throughput with conditions

Hi everyone! I am trying to built a Celonis query where I calculate the median time in a process between the Event “DRAFT” and the Event “FINAL”. I would like to additionally get the median value only for one country (e.g. Norway (NO).I have the following query which seems to work without a country condition:MEDIAN( PU_MEDIAN( DOMAIN_TABLE("ACTIVITY_TABLE."ProcessId"), CALC_THROUGHPUT( FIRST_OCCURRENCE['DRAFT'] TO FIRST_OCCURRENCE['FINAL'], REMAP_TIMESTAMPS( "ACTIVITY_TABLE"."TIMESTAMP", hours ) ) ))Now I have problems adding the country condition which would be found in the column ACTIVITY_TABLE.”country”. Maybe I have been starring at the query for too long :D. How do I add it? Best regardsAlex

340
Kalex
Level 2
julien.mayer
Level 2
julien.mayerLevel 2
asked in Process Intelligence Graph (PI Graph)
Is anyone else experiencing EXTREMELY slow OCPM?

Everything I’m doing on my OCPM projects (saving and previewing transformations, publishing, running data jobs, loading data models) is taking an obscene amount of time. I’m talking 2+ hours for something that used to take minutes…Is anyone else experiencing this?

210
julien.mayer
Level 2
P
Level 2
pierre.aless12Level 2
asked in General Product Q&A
Are we able to extract the user adoption via Pycelonis from a specific team?

Hello all, I would like to know if it's possible to extract the user adoption data/login history from the Platform Adoption View via Pycelonis 2.0.1 (I have the CSV export feature enabled, btw).  I'm trying to navigate to the specific object, but I can't even reach the Admin & Settings panel. Thanks in advance for any help.

185
marcel.kelle12
Celonaut
sree.c
Level 4
sree.cLevel 4
asked in AI
Hello All, Is it possible to push user adoption table to a data model?

Tried with Python script to extract table from the web page, however it didn't work.

2410
marcel.kelle12
Celonaut

Badge Winners

  • First Post
    lisaschneiderhas earned the badge First Post
  • Value Realization Expert
    Pablo MChas earned the badge Value Realization Expert
  • Qualified to Deliver Business Value with Celonis
    Pablo MChas earned the badge Qualified to Deliver Business Value with Celonis
  • First Post
    maxim.vnouthas earned the badge First Post
  • Celonis Certified Data Analyst
    akmal.farhahas earned the badge Celonis Certified Data Analyst
VIEW ALL
Community Code of Conduct