Skip to main content

Support
Academy
Documentation
Marketplace

Resources
User Groups
Events

Create post
Login

Home
Community
Product Q&A

Product Q&A

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

Process Analysis
Process Improvement
Process Management
AI
Data Ingestion & Infrastructure
Process Intelligence Graph (PI Graph)
Celonis Free Plan
General Product Q&A

4615 Topics

shravya.b11Level 6

General Product Q&A

Action Flow - Dynamic Filters

Hi,I would like to achieve an Action Flow where an Email would be send to the corresponding users/customers based on Customer or company code column value. ( for example, Based on the Company Code Value (say A), the email should be triggered to customers belonging to A. Similarly for other company codes say B,C, etc.). How can we implement a dynamic filter for the above requirement to send mails accordingly. Currently, we are doing it manually for every company code using router. Please find the screenshot below for reference.Kindly let us know how to proceed further. Thank you in advance :) FYI : @reenu.josep12

deleted.delet27Level 2

General Product Q&A

How to fix problems with JupyterLab / ML Workbench APP theme problems

Hi, For some time nearly everyday I've got problems with my ML app. When entering that app, I can see 2 errors: 1) Failed to load the jupyterlab-git server extension<html> <head><title>502 Bad Gateway</title></head> <body> <center><h1>502 Bad Gateway</h1></center> <hr><center>nginx</center> </body> </html> 2) Error Loading ThemeStylesheet failed to load: https://XXX.celonis.cloud/ml/workbench/ea5543aa-9e2c-4923-bced-2713b6162a87/lab/api/themes/@jupyterlab/theme-dark-extension/index.css Do you have any ideas how it fix it? What's strangest, sometimes everything works just fine (Switching to Celonis EMS theme fixes CSS, then switch back to dark theme works sometimes, sometimes not). I know i can create new app, and transfer code there, but I would like to avoid that. UI after switching to Celonis EMS theme and then to Dark Theme: Best Regards,Mateusz Dudek

matt.witty13Level 10

Process Improvement

Distribution Lists in Action Flows

Hi celopeers! I've got a use case which would be made easier with the use of an internal distribution list instead of sending to leaders who then forward on the email to the necessary parties. Have you successfully implemented an action flow using a distribution list and if so, how? Thanks!

erwan.bégocLevel 4

General Product Q&A

Is it possible to compare KPI for a period outside the selected time frame

Hi Community, I would like to know whether it is at all possible to select (using the date picker) a given time frame (say 01/07/22 to 30/09/22), have the corresponding KPI calculated, and compare it for the same time frame last year (01/07/21 to 30/09/22)? Is there a way to calculate for events outside the selected time frame? we currently do this using an intricate arrangement of variables, but i wonder if there isn't a more efficient way to do this, using standard Celonis features. Thanks in advance.

navalan.veera13Level 3

General Product Q&A

For calculating overall APC storage volume in an celonis 4 on-premise system ,Do we need to consider Disk and log volume size ?

Dear Experts,As we are planning to migrate from celonis 4 on-premise to celonis ems cloud ,we are not sure how to arrive at the calculation of APC space , Can we get the details of APC consumption for all the processes under License tab in Administration panel for Celonis 4 on-premise system ? Thanks in Advance Regards,Navalan Veerapandian

andrea.lópezLevel 1

General Product Q&A

Hello, We am trying to filter an OLAP table with a KPI or from the same table. In general we want to exclude from the analysis the rows of that OLAP Table that do not match with a condition (given by a KPI, a calculus etc..). *In the example, we would like to take values 5 and 6 from the column "COUNT(BKPF)" If anoyone have the same trouble or could help me for that I would appreciate it. Than you in advance.

sushmith.dechaLevel 4

General Product Q&A

1. Celonis EMS connection with Power Bi and 2. User details

Have 2 concerns: 1. Heard from Celosphere that now celonis EMS can connect with Power Bi.. Is it live? If yes then how?? 2. Can I create a olap on how many of them are using a particular dashboard and user details???

Jan-Peter van der SteegeLevel 12

General Product Q&A

Install JDBC connector on Windows Server 2019 or 2022

When installing the JDBC extraction software, still Windows Server 2012 R2, which will be discontinued next year, is preferred (see Step 2- Setting up the SAP Extractor Service (celonis.com)). For durability reasons and company policies, we want to install in on Windows server 2019/2022. Has somebody experience with these versions and the working of the software, can we guarantee that the extractor software works on windows server 2019/2022?

pinjari.mahabLevel 1

General Product Q&A

Celonis academy fundamental eduskil badge

mahaboobbasha@gmail.com

raman.silot14Level 8

Process Analysis

How to use view filters in Action flow ?

Hy,Is there any way we can use view filters in action flow ?

rohan.de.siLevel 2

General Product Q&A

Regarding SAML JIT group provisioning, can you please clarify system behaviour:- when are existing members cleared from a group?- will SSO users remain in groups where no claim is presented?- is it possible to revert a group to manual management?

Same questions expanded:- after the first SSO user presents a claim for a group, are all existing group members removed at once?- will SSO users remain members of groups where no claim has been presented?- to revert to manual management of a group, is it enough to stop presenting that group as a SAML claim? i.e. can we immediately populate groups manually again, or some other action required first?

jack.everaLevel 3

General Product Q&A

Capture duration between two process checkpoints and categorise if over a certain threshold

For late payments, we want to calculate or capture the duration an invoice takes between two process checkpoints and if it's over an expected duration, then we tag the entry with a reason label. Example If the duration between Vendor Creates Invoice + Scan FI Document is greater than 2 days Then, add reason 'Late Submission / Missed in Inbox' into reason column We have multiple statements to add for other checkpoints but the logic is the same. Any help would be greatly appreciated Thanks

florian.schopLevel 2

General Product Q&A

PyCelonis - "500 Server Error: Internal Server Error"

Hi all,I am currently trying to import data into the ML workbench using pycelonis get_data_frame. However, I am receiving the error "500 Server Error: Internal Server Error". It seems that my instance has no permissions for POST/GET in the API. I have added all thinkable permissions to the App key, used my personal admin user key etc., unfortunately, all without success. Does anyone have any clue what the issue could be? The same set-up works perfectly fine for another Celonis instance that we have commissioned.Much appreciated and kind regards,Florian

minakshi.malliLevel 1

Data Ingestion & Infrastructure

How to calculate working hours spent for a CASE on a activity

For Ex Time spent on Deliver block activity. I am using below formulaDATEDIFF ( HH, PU_FIRST(VBAP, _CEL_O2C_ACTIVITIES.EVENTTIME, _CEL_O2C_ACTIVITIES.ACTIVITY_EN IN (Set Delivery Block, Set Default Delivery Block)),PU_FIRST(VBAP, _CEL_O2C_ACTIVITIES.EVENTTIME, _CEL_O2C_ACTIVITIES.ACTIVITY_EN IN (Remove Delivery Block)) )But this formula will consider weekend and holiday hours as well.Please let me know how to get the working hours only .I have tried below formula as well after looking at Using workdays_between without a dedicated calendar table Codes & Statements Hi guys, my problem ist actually quite simple. I want to calculate the number of workdays (monday till friday) between two given timestamps. The relevant function requires me to reference a specific calendar table from the data model. Within the data model options, however, the possiblity exists to define a custom calendar without implementing a dedicated table (simply by selecting relevant days and time windows). My

navalan.veera13Level 3

General Product Q&A

How different is Value Discovery apps that come as part of Starter kit from the Celonis Execution apps ? As value discovery comes in ems marketplace with no additional cost , Do we have separate licensing model for using Celonis Execution apps f

How different is Value Discovery apps that come as part of Starter kit from the Celonis Execution apps ? As value discovery comes in ems marketplace with no additional cost , Do we have separate licensing model for using Celonis Execution apps features ?

sarina.sommeLevel 5

General Product Q&A

Is it possible to keep the filters with an overlay in the process explorer?

Hi all, I'm currently using the overlay functionality on the process explorer. We use this feature to open a profile view which shows the process explorer in a focus mode. As you can see in the screenshot if I filter the view and open the profile view via the process explorer the profile view is not filtered. Is it possible to keep the filters from the view to the profile view via the process explorer? Thanks and kind regards,Sarina

Jan-Peter van der SteegeLevel 12

General Product Q&A

Push Dataframe via PyCelonis 2.0.0 failing

Hi all, Using the updated PyCelonis version 2.0.0, I'm unable to push Pandas dataframes en parquet files towards the data pool. In the feedback, it states that it cannot be parsed towards a parquet file, but when I do this via Pandas (pandas.to_parquet()), this works without any problem. Are people facing similar problems? Best regards,Jan-peter

thomas.boehmLevel 1

General Product Q&A

Calculate average cost in PQL

HI, I want to calculate average cost for manual tasks using zwo variables, one for average time needed for a manual task (AVG_TIME_PER_MAN_TASK) and one for average cost for manual task per Minute (AVG_COST_PER_MAN_MIN). In the activities table we added a flag "automated" 1/0, if the task ist automated (1) oder manual (0). Now I want to count all the manual task (= e.g. 500'000) and calculate them with the variables ( * AVG_COST_PER_MAN_MIN * AVG_TIME_PER_MAN_TASK.I've made a filter with all manual tasksThen I tried to calculate the whole effort in Minutes with this PQL but it didn't work.The Variable was defined as Textfield with Value and the component is a number field COUNT("_cel_eclaim_activities"."_activity_long") * TO_FLOAT(<%= LABR_DURATION_PER_MANUAL_TASK %>)

olivier.grailLevel 2

General Product Q&A

Percent stacked barHello, do you know if it is possible, with Studio, to have percent stacked bar graphs?Thanks

Percent stacked bar Hello, do you know if it is possible, with Studio, to have percent stacked bar graphs? Thanks

raman.silot14Level 8

Process Analysis

Add dynamic bar graph in outlook

Hy,There is a requirement of sending dynamic graph of data through mailSo is there any way of sending graphs through action flow or skill or any other possible way ?

sarina.sommeLevel 5

General Product Q&A

Hi all,is it possible to block another user from deleting my comment in the commenting component for views? And can I block the comment function as long as no specific order number has been selected?Thanks :)

Hi all, is it possible to block another user from deleting my comment in the commenting component for views? And can I block the comment function as long as no specific order number has been selected? Thanks :)

andres.naran12Level 8

General Product Q&A

Hello everyone, wanted to know if there's any way to merge a data model from one data pool with another data model that is located in a different data pool?

Hello everyone, wanted to know if there's any way to merge a data model from one data pool with another data model that is located in a different data pool?

.14600835Level 5

Process Improvement

Section Access Control

Hello Experts,Is this possible to implement section access control for EMS data models?e.g. we have a process data model and other assets linked to this dm.We want to restrict business users using case field let's say company code.So users belonging to specific company codes can access only respective codes data.This feature is available on on-prem but couldn't find similar on EMS.

denise.kruge12Level 7

General Product Q&A

Hi, I am trying to find out how to receive an email when my connector is down, I don't see it under Admin & Settings and Notifications. Can someone guide me on where it is?Thank you

Hi, I am trying to find out how to receive an email when my connector is down, I don't see it under Admin & Settings and Notifications. Can someone guide me on where it is? Thank you

t.kLevel 0

General Product Q&A

Hi,I would like to know how to make the case explorer data exportable.

Hi, I would like to know how to make the case explorer data exportable.

Show more activity

Badge Winners

kay.kaspehas earned the badge Qualified Value Realization Expert
kay.kaspehas earned the badge Qualified to Manage Change and Scale Adoption
Thanh Duonghas earned the badge Qualified Technical Expert
Thanh Duonghas earned the badge Qualified to Build Action Flows
kay.kaspehas earned the badge Qualified to Deliver Business Value with Celonis

Powered by Gainsight

Community Code of Conduct Accessibility statement

More Celonis

Celonis.comarrow_outward Academyarrow_outward Supportarrow_outward Documentationarrow_outward Marketplacearrow_outward

Any Questions?

Talk to an expertarrow_outward Supportarrow_outward FAQsarrow_outward Glossaryarrow_outward

Follow Us

Xarrow_outward LinkedInarrow_outward YouTubearrow_outward Facebookarrow_outward Instagramarrow_outward TikTokarrow_outward

flag Loading…

Trust Center Imprint Disclaimer Privacy Notice Cookies Notice Terms & Conditions

Sign up

Already have an account? Login

Login with SSO

Celonaut Login Celonis ID Login

Login to the community

No account yet? Create an account

Login with SSO

Celonaut Login Celonis ID Login

Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.

Enter your e-mail address

Back to overview