Skip to main content

Product Q&A

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

3139 Topics
D
Level 2
davy.wangLevel 2
asked in General Product Q&A
Why no "simulate" button in package menu?

Hello,  I followed the course of process simulation step by step. created a package, then created knowledge model and selected a Data Model Variable, but I cannot see the "simulate" in the menu of this package. ​What happens? How to fix it?

00
D
Level 2
matt.witty13
Level 5
matt.witty13Level 5
asked in Process Analysis
Adding Custom Object Using Date Comparison

I've currently got a view I'm building out for some data management and want to highlight/change the background color of cells which fit the criteria for "bad values", based on dates. This is currently where my YAML lies. I've tried searching through the Celonis Documentation and haven't found anything in regards to comparing dates. I've also tried searching for YAML documentation, but I haven't found anything which satisfies what I"m looking for.

20
matt.witty13
Level 5
M
Level 2
mohammed.tanyeem.aLevel 2
asked in General Product Q&A
Hi,Can Celonis extract source/data from JIRA project and Sharepoint list?Can the user upload the data and then store it in daily files in the folder?Can Celonis send out an email with snapshot of graph or status?

Hi, Can Celonis extract source/data from JIRA project and Sharepoint list? Can the user upload the data and then store it in daily files in the folder? Can Celonis send out an email with snapshot of graph or status?

150
abhishek.chatu14
Level 7
L
Level 2
leon.wolfLevel 2
asked in General Product Q&A
How can I combine a line chart with a column chart like in the Purchase-to-pay Demo?

How can I combine a line chart with a column chart like in the Purchase-to-pay Demo?

100
abhishek.chatu14
Level 7
F
Level 3
federico.sparaLevel 3
asked in General Product Q&A
Timezone in action flow and ROUND_DAY function

Hi, I'm implementing an AF with some volumes. I query two columns:In the first column there is a date rounded by day, and the second column is the count. I noticed that the ROUND_DAY function applied to the first column is not working fine, since it keeps the timestamp, putting everything to 0 (2022-03-27T00:00:000Z). The problem is that at the 27 of march I have two dates that are the same, one with all 0 in timestamp, the other with 23 at the beginning. This is because at the 27 of march the time is changed by one hour, and it just mess everyting up the in AF. In the dashboard everything is working fine, since the ROUND_DAY function allow me to display only the date without timestamp (2022-03-27). How can I fix this in the AF?already tried:YEAR(date) || '-' || MONTH(date) || '-' || DAY(date), same as beforeformatDate function in AF: it says that the date is not a valid date. Thanks

10
abhishek.chatu14
Level 7
jorge.fonse12
Level 3
jorge.fonse12Level 3
asked in General Product Q&A
Hello everybody. I have two diffrent data pools that are extracting the same table in the replication cockpit, however there have been some mistakes in the extraction where some data is extracted to one data pool and other is not.

Do you guys know if is there a problem in extracting the same table with replication cockpit in 2 diffrent data pools at the same time?

30
dennis.pflug
Level 6
F
Level 3
federico.sparaLevel 3
asked in General Product Q&A
Questions on Histogram Component in Analysis

Hi there,I'm trying to build an histogram that shows the cycle times.Everything seems to work just fine, but when I compare the N. of occurences it doesn't match the number that I need. I read in the documentation that it uses the cases as occurences, insted I need a certain type of activity. If instead I build a column chart with the Cycle Times as dimension and occurences as KPI, numbers are correct, but I can't find a way to display the cycle times in a fancy way like the histogram, since in the column chart are displayed the single values for every instance, that I can round, but they are not the 10 ranges that I have with the histogram. I need or to customize the number of occurences in the histogram, so it can match, or customize the dimension axis of the column chart, in a way that is similar to the histogram. Thank you very much!

50
F
Level 3
abhishek.chatu14
Level 7
abhishek.chatu14Level 7
posted in Data Ingestion & Infrastructure
Hello, I wanted to understand the C4C APC storage consumption to view

Hello, I wanted to understand the C4C APC storage consumption to view The understanding is that views generally don't consume any data in Celonis or consumption is dependent on the parent. I wanted to understand if the same holds for C4C environments as we are currently noticing that all views created in C4C consume data and some consume more storage than the parent as well. 

20
abhishek.chatu14
Level 7
S
Level 2
saskia.plüstLevel 2
asked in General Product Q&A
Is it possible to set a runtime variable in an analysis? (which is currently only being set in a view)

I am setting the specified YEAR into a runtime variable in a View. Knwow I also want to set this variable from an analysis.  The KPI in the analysis comes from the Knowledge Model and references the YEAR set in runtime variable.

30
konrad.simon
Level 2
lukas.goder12
Level 3
lukas.goder12Level 3
asked in General Product Q&A
Is there something like the case explorer in views?

Is there something like the case explorer in views?

00
abhishek.chatu14
Level 7
P
Level 2
parth.daveLevel 2
asked in General Product Q&A
I have merged multiple csv files and when I am trying to load data I am getting "PREVIEW NOT AVAILABLE"I have tried joining csv file data using union and union all

70
abhishek.chatu14
Level 7
K
Level 2
karmveer.sidhuLevel 2
asked in Process Analysis
Show Custom KPI by default in Variant/Process Explorer

Hey there! Does anyone know of a way to display a custom KPI by default in the Variant or Process Explorers? Thanks, Karm

30
konrad.simon
Level 2
I
Level 3
indra.mehta11Level 3
asked in Process Improvement
SQL Server connection issue in Action flow.

Hello Team, I am not able to connect SQL Server in Action Flows.I am getting this error getaddrinfo ENOTFOUND I would appreciate if you can help me out.

00
I
Level 3
L
Level 2
lizzie.willi12Level 2
asked in General Product Q&A
Who is the head of support please?

I've had a ticket outstanding since September, all responses are just we will get back to you. Also says I can track in Community but there are no tickets listed there.

10
D
Level 1
G
Level 2
gabriella.koopmLevel 2
asked in Data Ingestion & Infrastructure
Hi,I would like to count the cases which have a certain activity. (not the same as activity count) If they have the activity 40 times per case I want only to count them as 1 per case. Does anyone have a suggestion? Thank you in advance

The standard ratio count does not work because it takes into account the activities and not the cases.I have tried: filter count (which does not work because it counts activity and not the cases)I tried multiple PU_count and PU_count_distinct (also did not work)I have tried case when (activity = "XX") then count (cases) else 0. (But this is not allowed in Celonis)

10
M
Level 3
V
Level 1
venkata.vara.prasad.nallaLevel 1
asked in Data Ingestion & Infrastructure
How to find descriptions for oracle ERP tables ?

Hi Team, can you please help if there is away to find Descriptions for oracle tables like Leanx for SAP. Thanks,Venkat N

10
M
Level 3
A
Level 2
anoop.singh.rajpuLevel 2
asked in Data Ingestion & Infrastructure
How to switch between the Data source for an existing connection

We have a celonis instance which as established connection with a SAP testing sandbox. I want to know if we build a data model and then the Analysis using this data currently and later want to use the SAP Production instance data for these analysis, then what steps we need repeat. Does it involve lot of changes OR I can simply go and just update the data source URL (Host and port) in the connections. Please help.

00
V
Level 1
F
Level 3
fynn.reindLevel 3
asked in General Product Q&A
Converting duration (integer) to date format (hh:mm)

Hello everyone,I am currently trying to convert a duration of minutes (integer) into the datetime format (hh:mm). Like this: 60 --> 01:00120 --> 02:00150 --> 02:30 Is this somehow possible within PQL? I looked up a few answers online, but they often include functions that seem to be not supported by PQL.

100
F
Level 3
V
Level 2
vamshi.vignesh.d13Level 2
asked in Process Analysis
Changes done studio are getting reflected in Apps except one KPI (No error being displayed!)

We are facing an issue in Views in studio where all the changes made in views gets reflected in apps except a single KPI. This KPI displays total order value and uses a variable(named currency) in the package settings which will automatically update KPI based on the input valueEg: if the variable(currency) is given a value 'USD' then in the views the total order value will be updated with respect to USD exchange rate. When the variable is changed in studio under package setting to whatever currency, it gets reflected in the views when we refresh in the studio. Whereas, when we try to publish it the KPI value does not get updated and remains with the old value. Any possible error that could have taken place here or is this some kind of bug?

80
V
Level 1
michael.chung
Level 2
michael.chungLevel 2
asked in General Product Q&A
I am building an OLAP table for cases. Cases have multiple users over time. I added a Max Activity time KPI. and want to list the corresponding User and Activity. I only need one Max Activity time per case, not all activity times.

Adding the User and Activity dimensions shows all Activity and Users per case.How can I filter for only one Max Activity time per case row? Thank you

10
V
Level 1
P
Level 2
parth.daveLevel 2
asked in Data Ingestion & Infrastructure
I am trying to create data model with multiple csv file. I am looking to merge those file within celonis using any available transformation and use the combine data to cary out process mining

I have tried using PQL transformation but again when I go to process model, mark each file as activity file and then do data load, it is loading multiple file individually. What I can do to combine all this files into one data model and then carry out process mining.

10
D
Level 1
J
Level 2
jake.hutchLevel 2
asked in General Product Q&A
Is there a way to add a vertical line to a chart in an analysis that signifies a "go-live" or a specific point in time? This is needed to help track KPIs before and after a specific go-live or other milestone.

Is there a way to add a vertical line to a chart in an analysis that signifies a "go-live" or a specific point in time? This is needed to help track KPIs before and after a specific go-live or other milestone.

90
J
Level 2
sree.c
Level 4
sree.cLevel 4
asked in General Product Q&A
Any option to export all transformations from data job to downloads?

Any option to export all transformations from data job to downloads?

140
sree.c
Level 4
T
Level 2
thomas.wittLevel 2
asked in General Product Q&A
I have added a new table as a datasheet but Celonis does not recognise the column labels. However, this has already worked with another spreadsheet that is formatted in exactly the same way. What could be the reason for this?

I have added a new table as a datasheet but Celonis does not recognise the column labels. However, this has already worked with another spreadsheet that is formatted in exactly the same way. What could be the reason for this?

00
T
Level 2
sree.c
Level 4
sree.cLevel 4
asked in Data Ingestion & Infrastructure
can a Delta load be configured based on string column instead of changing date field

can a Delta load be configured based on string column instead of changing date field

40
G
Level 8

Badge winners

Show all badges
Terms & Conditions

ANY QUESTION?

Talk to an expert
FAQs
Contact us

MORE CELONIS

Academy arrow_outward
Documentation arrow_outward
Support Center 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