Skip to main content

Product Q&A

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

4407 Topics
indra.mehta11
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.

30
indra.mehta11
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)

20
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
Celonaut
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.

180
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
Celonaut
M
Level 3
marco.baren11Level 3
asked in General Product Q&A
Analysis Sheet and those capabilities deprecated? Recent demos do not use them while legacy demos did

Hi. When I take a look at the recent demos I can see that - despite of the certification tracks - they seem to avoid the use of the analysis capabilities. Most of the time, Views are used. What is the intention of this strategy? Actually, I considered the Variant Explorer as extremely useful. The recent demos make no use of it for example. Someone there who can clarify? Thanks in advance!Marco

30
V
Celonaut
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
Celonaut
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.

110
J
Level 2
D
Level 2
dominik.becke11Level 2
asked in General Product Q&A
Creating a total for non-unique values

Hi, i want to build an OLAP-Table with the following columns: VKONT (contract account), BETRH (amount) and FAEDN (net due Date). How can i sum up BETRH in the Table, when there are different results for BETRH and FAEDN for each VKONT? Thanks! Dominik

20
dennis.pflug
Level 6
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?

190
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

50
G
Level 8
L
Level 2
leon.wolfLevel 2
asked in General Product Q&A
Is it possible to upload updated data in the same Analysis? And if yes, how do I do it?Thanks in advance.

Is it possible to upload updated data in the same Analysis? And if yes, how do I do it? Thanks in advance.

20
D
Level 1
M
Level 1
michael.cuadrLevel 1
asked in General Product Q&A
{"reference":"0f97b195-d66c-4dec-ade7-15c8ed9f99d0","message":"Something went wrong while handling the request. Please contact Celonis customer support. Celonis Support ID: 0f97b195-d66c-4dec-ade7-15c8ed9f99d0","shortMessage":"Celonis Support ID

Problem with badge

30
dennis.pflug
Level 6
C
Level 3
chakradhar.pokalLevel 3
asked in General Product Q&A
Hi, After Celonis got updated, i could not find Celonis demos link. I need for sustainability. Could any one provide demo gallery link for sustainability

Hi, After Celonis got updated, i could not find Celonis demos link. I need for sustainability. Could any one provide demo gallery link for sustainability

00
dennis.pflug
Level 6
T
Level 2
tejakumar.dudekLevel 2
asked in General Product Q&A
Hi sir, i am Tejakumar Dudekula. I am trying to open the modules but it not showing sor. I think because of i made a mistake in registration process. Now what is the solution sir.

Hi sir, i am Tejakumar Dudekula. I am trying to open the modules but it not showing sor. I think because of i made a mistake in registration process. Now what is the solution sir.

00
D
Level 1
P
Level 2
purszki.sándoLevel 2
asked in Process Analysis
Storing the value of a KPI in View variable

Hi!I would like to store the value of a KPI in view variable. Is it possible?The value of the kpi can be visible in textbox with placeholder. it is ok.But I would like to refer to the value of the KPI on the secondary axis as a target line to be reached. (rule type chart, value attribute) I cannot use Field attribute, because of table structure. chart component & variable yaml code target is stored in augmented attribute, because target is different for each objects. km yaml:it is working in text box, but not working in chart. Many thanks.Sanyi  

100
abhishek.chatu14
Level 7
A
Level 3
alexander.alexaLevel 3
asked in Process Analysis
Count cases with condition

Dear Team. I need to calculate count of cases with condition. Condition is, when case appeared in the period from 0 to 10 days. I gave an example of the calculation below, but unfortunately I cant be sure that it is correct. Please, read and give a feedback. CASE WHEN AVG (DAYS_BETWEEN(SOURCE (DB_EVENTS.EVENT_SDTS, CALC_CROP(FIRST_OCCURRENCE[MY_EVENTS1] TO LAST_OCCURRENCE[MY_EVENTS2], CASE WHEN DB_EVENTS.EVENT_NAME LIKE Event_1% THEN MY_EVENTS1 WHEN DB_EVENTS.EVENT_NAME LIKE Event_2% THEN MY_EVENTS2 ELSE DB_EVENTS.EVENT_NAME END), FIRST_OCCURRENCE TO LAST_OCCURRENCE ), TARGET(DB_EVENTS.EVENT_SDTS) ))>0 AND AVG (DAYS_BETWEEN(SOURCE (DB_EVENTS.EVENT_SDTS, CALC_CROP(FIRST_OCCURRENCE[MY_EVENTS1] TO LAST_OCCURRENCE[MY_EVENTS2], CASE WHEN DB_EVENTS.EVENT_NAME LIKE Event_1% THEN MY_EVENTS1 WHEN DB_EVENTS.EVENT_NAME LIKE Event_2% THEN MY_EVENTS2 ELSE DB_EVENTS.EVENT_NAME END), FIRST_OCCURRENCE TO LAST_OCCURRENCE ), TARGET(DB_EVENTS.EVENT_SDTS) ))<10 THEN COUNT_TABLE(DB_CASES) ELSE NULL E

180
D
Level 2
denise.kruge12
Level 4
denise.kruge12Level 4
asked in General Product Q&A
Good day,Has someone worked with an IMPORTS process using TradeCloud, where invoices are posted in SAP? I have the complete TradeCloud files but for SAP only the table where invoices are posted in SAP.

Good day, Has someone worked with an IMPORTS process using TradeCloud, where invoices are posted in SAP? I have the complete TradeCloud files but for SAP only the table where invoices are posted in SAP.

30
D
Level 1
J
Level 2
jaroslav.kocicLevel 2
asked in General Product Q&A
Where can I find Revert to Base KM functionality in Extension Knowledge model?https://docs.celonis.com/en/knowledge-model.htmlHow it works in practice and where I can find it?

40
J
Level 2
andré.tafur
Level 4
andré.tafurLevel 4
asked in General Product Q&A
Vertical (axis Y) position line in a chart from Process Analytics/Analysis

Hi everyone, I am trying to create a scatter pot with 2 position lines, one on the x-axis and one on the y-axis. I have created the horizontal line on the chart but have not been able to create the vertical line. Does anyone have any suggestions please? Thanks for your help.

60
andré.tafur
Level 4
J
Level 4
jumbo.szkLevel 4
asked in General Product Q&A
Do we have something way to ex/inport my analysis and KM to other environment?

Hi all, I would like to know how we have ex/inport my template dashboard and knowledge model to other environment. Please let me how to do it or reason we can't if it is not able to do. I checked my environment options and find something export option but not found import. Thanks and regards,

50
andré.tafur
Level 4

Badge Winners

  • Celonis Certified Data Engineer
    afif.shihahas earned the badge Celonis Certified Data Engineer
  • Masterclass in Implementation
    itone.yokoy13has earned the badge Masterclass in Implementation
  • Solution Creation Expert
    tobias.fehre12has earned the badge Solution Creation Expert
  • Qualified to Write PQL Queries
    tobias.fehre12has earned the badge Qualified to Write PQL Queries
  • Qualified to Manage Implementation Projects
    tobias.fehre12has earned the badge Qualified to Manage Implementation Projects
VIEW ALL
Community Code of Conduct