Skip to main content

General Product Q&A

Not sure where to post? Ask your product-related questions here and get support from the community.

  • 2,585 Topics
  • 5,927 Replies
2585 Topics
M
Level 2
manohar.sairaLevel 2
asked in General Product Q&A
Feature Request: User Creation Date in Celonis Admin & Settings Dashboard

Feature Request: User Creation Date in Celonis Admin & Settings DashboardThis request proposes adding a new feature to the Celonis Admin & Settings Dashboard that would display the User Creation Date for each account.Purpose & Benefits: Provides administrators with visibility into when a user account was created. Helps in audit readiness and compliance checks by tracking account lifecycle. Assists in troubleshooting and access reviews by correlating account age with activity. Reduces dependency on separate audit reports for basic account details. Expected Outcome:A new column/field labeled “User Creation Date” available in the Admin & Settings Dashboard, enabling administrators to quickly filter, sort, and review users based on when their accounts were provisioned.

120
M
Level 2
A Rab
Level 3
A RabLevel 3
asked in General Product Q&A
A module to stop the action flow at some point

Hi,I have an action flow with a Router module, and I want one of the branches to just end the Action Flow without going through the rest of the Modules in the Action Flow. Because I have an Aggregate module, it always continues executing from there, so I want to just stop the Action Flow at specific condition. Thanks

152
A Rab
Level 3
R
Level 3
roshan.kumar13Level 3
asked in General Product Q&A
Data model relation for two tables which are related in 1-N relation(VBAP:1 and VBRP:N).

These two tables are related in 1-N relation(VBAP:1 and VBRP:N). Also in some cases there are no entries in VBRP(AUBEL and AUP) for some entries in VBAP(VBELN and POSNR). I am creating an Olap to find all entries in VBAP (VBELN and POSNR) which does not have related data in VBRP(AUBEL and AUP) but they dont show up in olap. If i remove the VBRP columns from olap then they show up.

102
M
Level 2
lisaschneider
Level 2
lisaschneiderLevel 2
asked in General Product Q&A
Issue with PQL to adapt KPI to line chart months

Hi!I’Ve been struggling with setting up the correct PQL for visualising a KPI on a line chart showing a timeline as the formula became quite complicated. Would appreciate any help on understanding what query I need or why it is not working.  The KPI I want to display on a timeline chart is a cancellation rate. The view contains an input dropdown as a variable  ${outlier_analysis_selection_main.pql} which the dashboard should adjust to. The dimensions of the line chart are ROUND_MONTH("CASE_TABLE"."DSL_ORDER_DT").  In the line chart, I already have the overall cancellation rate.This does not adjust to any user filtering done through the dashboard, nor the selection through ${outlier_analysis_selection_main.pql}. I also have another cancellation rate line which does adjust to any user filtering done. I can therefore compare the development of the cancellation rate for whatever is selected to the overall cancellation rate. Now I want to add a line that always shows me the cancellation rat

91
janpeter.van.d
Level 8
tfaruq Rotork
Level 2
tfaruq RotorkLevel 2
asked in General Product Q&A
Past Celosphere (2023 & 2022) video on-demand no longer available ..

Hello,Im no longer able to access past Celosphere (2023 & 2022) video on-demand. I belief it used to be https://www.celonis.com/celosphere/2023/recordings/watch and https://www.celonis.com/celosphere/2022/recordings/watch respectively. Currently URL redirect to 2024. Is there any chance to watch year 2024 and 2023 past recordings? Thank you. 

50
tfaruq Rotork
Level 2
bhargav.bhima
Level 2
bhargav.bhimaLevel 2
asked in General Product Q&A
Need help with PQL filtering

Hi,What I’m trying to do is essentially pick the last but one non-automated user from the event log and pull it to object level. The previous non-automated user needs to be different from the last non-automated user.In the sample data shown below the desired output would be JANE.I’ve tried looping one PU_LAST and using it as filter for another PU_LAST but doesn't seem to be working.PU_LAST( OBJECT ,  EVENT_LOG , EVENT_LOG NOT IN (PU_LAST( OBJECT, EVENT_LOG,EVENT_LOG NOT IN (‘AUTOMATED’) ))  ,  ’AUTOMATED’).EVENT LOG ID USER 1 JACK 2 JANE 3 JOHN 4 AUTOMATED 5 JOHN  Any insights would be much appreciated.

1228
fabian.wende
Level 2
asdfg
Level 3
asdfg
posted in General Product Q&A
Celonis-support for OCEL standard

Hi folks,what’s your thoughts about the OCEL standard for object-centric event data? Should Celonis support it and that way enable us to do ETL and keep log data outside outside the Celonis cloud, for instance in MS Azure?It would be interesting to hear if Celonis has given a thought about implementing OCEL or not.https://ocel-standard.org/1.0/

323
asdfg
Level 3
M
Level 1
michael.lenzLevel 1
asked in General Product Q&A
Action Flow: Sharepoint Online XLSX Question

I have the following problem: I would like to upload a .XLSX file into my workspace via an ActionFlow. The .XLSX file is located on SharePoint Online. I can download the file using the "Download a File" action (Microsoft SharePoint Online) in the ActionFlow. However, I'm stuck at that point. In the output, the data is in "binary" format. How do I convert it from binary back to something I can import into a workspace? I have tried many things, but I just can't find the solution. Does anyone have any advice?

894
Arnab17
Level 2
Saba
Level 4
SabaLevel 4
asked in General Product Q&A
ABAP

Hi everyone,I’m trying to convert an ABAP statement into PQL but I’m not sure how to do it.In ABAP I have:SELECT SINGLE *  FROM vbap  INTO ls_vbap WHERE vbeln = ls_vbbe-vbeln   AND posnr = ls_vbbe-posnr. I think In SQL this would look like:SELECT *FROM VBAPWHERE VBELN = :ls_vbbe_vbeln  AND POSNR = :ls_vbbe_posnrLIMIT 1; But I don’t know how to express the same logic in PQLDoes anyone have any idea?Thanks!

220
Saba
Level 4
A Rab
Level 3
A RabLevel 3
asked in General Product Q&A
Preselect dates in the date range component

Hi,I would like to select an item from a dropdown list, then have the from date and end date already marked in the date range component for that selected item, is that possible in Celonis? and how? Thanks a lot.

141
N
Celonaut
E
Level 3
ewa.aniśkLevel 3
asked in General Product Q&A
How can we apply colours to charts/process explorer/tables in Views?

How can we apply colours to charts/process explorer/tables in Views?

406
Joe-Hartzel
Level 3
karl.guent
Level 4
karl.guentLevel 4
asked in General Product Q&A
Something wierd is happening with my environment ... the labels are lost and I am seeing variable names. Is this happening to other people as well?

95
Joe-Hartzel
Level 3
mtucker10
Level 2
mtucker10Level 2
asked in General Product Q&A
How can i tell if my EMS connection has microsoft features enabled?

I’m trying to create a data connection between Celonis into Power BI. When I put the hyperlink into the ‘get data’ prompt, the navigator pane is blank (ie shows no data available).  I’m curious if I have the microsoft connection enabled. How can I check this? Important to note - I do not have analyst rights in Celonis hence why I’m attempting to import data into Power BI. 

90
mtucker10
Level 2
apurva.patha12
Level 4
apurva.patha12Level 4
posted in General Product Q&A
Limit the row level data in Pivot(New View)

Hello All,Could you help me to understand how to select recent 5 years in Pivot Table(New View). Currently i can see older data also like below.I want to limit it to last 5 years only. Please help.Regards,Apurva

293
yevhen.riabt12
Level 2
Pruthvin
Level 2
PruthvinLevel 2
asked in General Product Q&A
Custom Object Changes in OCPM

Hi All,Which one is the most optimized way in Object centric while making the changes in celonis catalogue Object. for example in Deliveryitem Object i want to make changes to CDPOS table which is celonis provided one i just want to add one more attribute to the existing one do i need to use Overwrite or copy pasting the whole code in Custom changes along with my attribute. which takes less time while executing the transformation ?Could someone help me here ?Thank you in advance 

452
Pruthvin
Level 2
apurva.patha12
Level 4
apurva.patha12Level 4
posted in General Product Q&A
Pivot in New View

Hello All,Could you help me to advise on how to classify the bucketing with the help of coloring in pivot table which is recently develop in new view. We are able to provide the color classification in Olap Table however i am afraid it is not yet possible in pivot table.Please HelpRegards,Apurva 

331
apurva.patha12
Level 4
sagar.belur
Level 2
sagar.belurLevel 2
asked in General Product Q&A
Process Adherence Manager

Hi,Is it possible to look at the list of Cases in Process Adherence Manager, just like it was in Conformance checker?  Thanks

423
sagar.belur
Level 2
roger
Level 2
rogerLevel 2
asked in General Product Q&A
Count with filter

Hi allI have a very basic question – sorry for that, I’m quite new to PQL and I cannot apply the information available online (or did not find it).I have two tables incident_CASE with column CASE_ID (1-side) and workorder_CASE with column WORKORDER_ID (n-side) (1 incident can have 1 or more workorder).How can I count the following:Number of incidents with exactly 1 workorder Number of incidents with 2 or more workorder Many thanks for your supportBestroger

661
S
Celonaut
jagjeet.singh12
Level 2
jagjeet.singh12Level 2
asked in General Product Q&A
Duplicate Vendor/ Invoice Identifier

I would like to understand how we can leverage Celonis functionalities to identify duplicate invoices or vendors. What are the different approaches available in Celonis to achieve this

221
asdfg
Level 3
herique.sarme
Level 3
herique.sarmeLevel 3
asked in General Product Q&A
IML function error in Get Rows action flow trigger

Every ‘Get Row’ module suddenly stopped working, all at the same time… Has anyone ever seem this error message before? What does it mean? How can I prevent it from happening again? Error: Cannot initialize the scenario because of the reason 'Failed to compile IML function 'functionToDeleteSecond'. Unexpected identifier 'is''  

271
N
Celonaut
S
Level 1
satoko.ogawa11Level 1
posted in General Product Q&A
www.celonis.com

12月23日（金）に11月9日と10日にドイツで開催されたCelosphereの内容について、ダイジェスト版として日本後のRecap Webinarを実施します。日本語でCelosphereの内容をご案内させていただきますので、ぜひ、奮ってご参加ください。また、このWebinarはパートナー様だけでなく、お客さまもご参加いただけるWebinarです。​​https://www.celonis.com/jp/webinar/the-best-of-celosphere-japan/

141
Y
Celonaut
manuel.wetze
Level 5
manuel.wetzeLevel 5
asked in General Product Q&A
How to analyze User behaviour within Views for UX improvement?

Dear all,I was wondering if there are any approaches on how to measure how endusers are actually using the dashboards. With the purpose of improving usability.Does anyone have any approach on how to do this within the platform or by any workarounds on logs or even third party tools? Do you have any other appraoch to determine what the user really needs? Example key question would be:Which views get accessed how often?Which tabs get viewed how often?Which filters get used?Context: Naturally when developing custom dashboards you are implementing a lot of small requirements and end up always adding more functionally and therefore complexity. To have an aggregated analysis on how the users navigate a series of linked dashboards would help to remove less frequent used parts. 

282
S
Celonaut
J
Level 2
jacob.visse14Level 2
asked in General Product Q&A
I am using the " target=_"blank" statement in a text button to open a new tab with a link to Celonis documentation. But it opens in the same tab as my analyses. How to solve this?

Below an example of the code I am usingFor detailed information go to Celonis info page:<a href="https://docs.celonis.com/en/process-ai.html"target=_"blank"> Process AI</a>

245
milan.eric
Level 3
A Rab
Level 3
A RabLevel 3
asked in General Product Q&A
Executing Data Model Schedule from Action Flow

Hi,Do you know if there is a way to execute an already exist Schedule in the Data Model from the Action flow. I have an Action Flow that updates some fields in the source system, and I want the data jobs (extraction, transformations, and data model load) to be executed as the last step of the Action Flow, so the updates will be available in the dashboard as well. Thanks.

341
julia.bauer
Level 5
andres.naran12
Level 4
andres.naran12Level 4
asked in General Product Q&A
Send messages through Google chat

Hi everyone, I have an issue that I would like to share in case anyone knows how to solve it.I’m currently looking for a way to send messages to multiple end users by Google Chat. I don’t want to send messages to a group, but instead to end users. I noticed that Celonis provides a module called "Inject Message Into Room", but I need the webhook URL from each user. Additionally, I cannot send messages bigger than 4096 characters.Does anyone know if there is another module where I can use just the email address from users to send a message through Google Chat to each one of them, and change the length of the message body limitation, since there are some messages that might exceed the 4096 characters.Thanks! 

60
andres.naran12
Level 4

Badge Winners

  • Qualified to Build Views
    Pablo MChas earned the badge Qualified to Build Views
  • Qualified to Build Views
    amanpreet.sethihas earned the badge Qualified to Build Views
  • Qualified to Build Analyses
    pandiri.ravishas earned the badge Qualified to Build Analyses
  • Celonis Technical Expert
    Marlijnhas earned the badge Celonis Technical Expert
  • Qualified to Write PQL Queries
    Marlijnhas earned the badge Qualified to Write PQL Queries
VIEW ALL
Community Code of Conduct