Skip to main content

Product Q&A

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

4380 Topics
H
Level 2
hridesh.mishr11Level 2
asked in General Product Q&A
Hi Team,I am building an Action Flow to notify user and in my query data , i am getting 2 email ids coming from 2 differnet tables so how can i send an email to both of them.

Hi Team, I am building an Action Flow to notify user and in my query data , i am getting 2 email ids coming from 2 differnet tables so how can i send an email to both of them.

13
R
Level 4
natnapin.ketch
Level 2
natnapin.ketchLevel 2
asked in General Product Q&A
Is it possible to change row's color in the Table component in the View?

Is it possible to change row's color in the Table component in the View?

30
natnapin.ketch
Level 2
F
Level 3
federico.sparaLevel 3
asked in General Product Q&A
Going to new line in kpi

Hi, Is there the possibility to display a kpi in two lines? Like for example in an olap table. I've tried putting /n or CHAR(10) but it doesn't work.I'm now displaying values concatenated on the same line, like 3 days - 10 objects. Expected output:3 days10 objects Thanks!

40
abhishek.chatu14
Level 7
C
Level 3
claire.chen12Level 3
asked in General Product Q&A
Is it possible to automatically upload file to data pool using Action Flow?

Currently, my client have a list of user IDs that we update weekly and upload manually. I would like to automate this process. We are currently considering these two methods.1. PycelonisCreating a script using the Pycelonis method maybe is a good idea and I found this answer.upload parquet file and refresh data modell automatically (celopeers.com)2. Action FlowI have not looked into this in detail, but I am wondering if it is possible to use a module such as HTTP request to upload a file, for example. I would appreciate any advice you can give me on the above, especially the second one.

70
abhishek.chatu14
Level 7
denise.kruge12
Level 4
denise.kruge12Level 4
asked in General Product Q&A
Hi, how do I extend my project in the new C4C project Hub?

Hi, how do I extend my project in the new C4C project Hub?

00
denise.kruge12
Level 4
J
Level 4
jumbo.szkLevel 4
asked in General Product Q&A
I'd like to omit throughtput time between specific activity

Hi all,I'd like to know how to omit specific throughput time activity. In my process flow is A->B->C->D, for example, and the throughtput time between C to D is too long than other throughput time and it might be misleading so I'd like to omit that value. does anybody know how to do it?

20
mukesh.gupta11
Level 4
P
Level 2
pia.schneLevel 2
asked in General Product Q&A
Hi,I build an action flow which sends a KPIs as csv. The numbers have a format like 12.367 and '.' is the decimal point not thousend seperator. I need the number with 2 decimal places, means 12,36. Formatnumber, parsenumber cuts the number to 12.

Hi, I build an action flow which sends a KPIs as csv. The numbers have a format like 12.367 and '.' is the decimal point not thousend seperator. I need the number with 2 decimal places, means 12,36. Formatnumber, parsenumber cuts the number to 12.

161
abhishek.chatu14
Level 7
R
Level 3
raul.rodri12Level 3
asked in General Product Q&A
Hello When I want to connect Celonis to a Google sheet in my corporate email, Google blocks my access and says that I Celonis is trying to acces confidential information. I have configured that anyone with the link can access and it continues bl

the access. Do you know how can I remove this lock?

10
carlos.taleg11
Level 5
carol.swart
Level 2
carol.swartLevel 2
asked in Process Improvement
Hi, I am trying to filter expression based on the results of a previous data query. Can this be done ?

I have a situation were depending on the result of the Query Data (17) I need to filter on either the Inbound Branch or Outbound or either for a particular branch, for the next data query. I keep getting a Syntax error, the documentation was not helpful.Can this be done ?  

60
abhishek.chatu14
Level 7
V
Level 4
vasco.caron11Level 4
asked in General Product Q&A
Writing back to Data Pool from Action Flow

Good morning, We've set up an Action Flow that sends out an Alert under certain conditions. We're currently trying to set up a Historical log of the Alerts sent, but our JSON Bubble is set to REPLACE:  Is there any way we can change it so that it APPENDS new data to the table, instead of recreating it? Thank you in advance Best Regards,

130
abhishek.chatu14
Level 7
S
Level 4
shravya.b11Level 4
asked in 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​ 

30
abhishek.chatu14
Level 7
D
Level 1
deleted.delet27Level 1
asked in 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

60
D
Level 1
matt.witty13
Level 5
matt.witty13Level 5
asked in 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!

40
matt.witty13
Level 5
E
Level 3
erwan.bégocLevel 3
asked in 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. 

10
E
Level 3
N
Level 3
navalan.veera13Level 3
asked in 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

00
L
Level 1
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/

00
S
Level 1
A
Level 2
andrea.lópezLevel 2
asked in General Product Q&A
Filter a KPI

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.

110
J
Level 2
S
Level 3
sushmith.dechaLevel 3
asked in 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??? 

110
janpeter.van.d
Level 8
janpeter.van.d
Level 8
janpeter.van.dLevel 8
asked in 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?

100
janpeter.van.d
Level 8
P
Level 1
pinjari.mahabLevel 1
asked in General Product Q&A
Celonis academy fundamental eduskil badge

mahaboobbasha@gmail.com​

10
M
Level 1
R
Level 4
raman.silot14Level 4
asked in Process Analysis
How to use view filters in Action flow ?

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

50
janpeter.van.d
Level 8
R
Level 2
rohan.de.siLevel 2
asked in 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?

20
R
Level 2
J
Level 3
jack.everaLevel 3
asked in 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

40
J
Level 3
F
Level 2
florian.schopLevel 2
asked in 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

130
F
Level 2
M
Level 2
minakshi.malliLevel 2
asked in 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

20
S
Level 2

Badge Winners

VIEW ALL
Community Code of Conduct