Skip to main content

Product Q&A

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

4367 Topics
vamshi.vigne
Level 3
vamshi.vigneLevel 3
asked in Process Improvement
Can Action Flow retrieve data from a OLAP table in an Analysis?

We are working on a use case where we need to extract the data from an OLAP table and push it to another data pool. We are aware of the later part but need some inputs for the former one where we need to extract the OLAP table using action flows .

120
A
Level 3
J
Level 1
jonathon.munLevel 1
asked in Celonis Free Plan
Does the free plan include Discreet Process Simulation (modeling) and the Machine Learning Workbench?

Does the free plan include Discreet Process Simulation (modeling) and the Machine Learning Workbench?

20
mukesh.gupta11
Level 4
R
Level 4
raman.silot14Level 4
asked in Process Analysis
In Benchmarking, to apply filters using attributes in views

Is it possible to apply filter on an attribute of a record in viewsCurrently I am only able to apply filter on columns of data model 

30
R
Level 4
S
Level 3
sachin.agarwLevel 3
asked in General Product Q&A
Hi,In TryCelonis, I could see lot of Demos. But I would like to see the YAML code behind those dashboards. Please let me know how can i see them?

Hi, In TryCelonis, I could see lot of Demos. But I would like to see the YAML code behind those dashboards. Please let me know how can i see them?

102
S
Level 3
E
Level 2
elizabeth.claasLevel 2
asked in General Product Q&A
Is it possible to use the Conformance Checker on only a certain part of a process?

Is it possible to use the Conformance Checker on only a certain part of a process?

60
D
Level 3
P
Level 3
pedro.pinedLevel 3
asked in General Product Q&A
Hello,I want to do Proccess Benchmarking, I have the dropdown button created with manual values (with three dimensions), I have created the appropriate variables, but I can't filter the categories to compare.

136
P
Level 3
T
Level 1
tim.tak12Level 1
posted in Data Ingestion & Infrastructure
Help needed with a % connection path KPI

Help needed with a % connection path KPI I am trying to figure out how i can make a connection KPI which shows the path percentage of cases that passed through. now i want to see the path percentage flow from each individual Activity. exmaple: Start -->Activity A (branches pathways) ---55% for a path---> Activity B (branches Pathways) --23% for a path--> activity Z. so from each Acitivy i want to calculate how much of the (total) cases that landed there go a certain path % wise. Now i figured out by doing: COUNT (DISTINCT SOURCE ("Table"."colum")) / GLOBAL(COUNT (DISTINCT SOURCE ("Table"."colum"))) I can filter the path connections to % based on the Total amount of cases present in the dataset. This only shows me how cases % wise flow through the whole process. but not from an indivual activity.  In my mind somehow every Activity point needs to be seen as the "new" total 100% so a calculation can be made for the paths. but i

51
T
Level 1
N
Level 2
nuran.khala11Level 2
asked in General Product Q&A
Hello guys, i would like to put a drop down in my reports with the opportunity for the users to switch between light and dark mode. How do I do that? Has someone practice in this topic? Maybe a pql code or something...

Hello guys, i would like to put a drop down in my reports with the opportunity for the users to switch between light and dark mode. How do I do that? Has someone practice in this topic? Maybe a pql code or something...

12
N
Level 2
W
Level 1
weiwei.dongLevel 1
asked in General Product Q&A
What functions can Celonis achieve

What functions can Celonis achieve

01
H
Level 1
T
Level 3
teun.gilis11Level 3
asked in Process Improvement
Can action buttons related to action flows be customised?

Hi, I would like to customise the colour and add icons to action buttons created with an action flow. For actions related to skills, this is possible, see screenshot attached.  There is a preview mode like with skills, but it doesn't allow you to customise. Using the syntax for skills action in YAML also doesn't work. Who knows how to do this? Thanks,Teun

30
V
Level 3
S
Level 3
sudhanshu.kumar15Level 3
asked in Data Ingestion & Infrastructure
i want change the dimension of olap table using dropdown in views, How to display name like display name in dropdown in views

i want change the dimension of olap table using dropdown in views, How to display name like display name in dropdown in views

40
S
Level 3
J
Level 4
jumbo.szkLevel 4
asked in General Product Q&A
does celonis have something text mining module?

hi all, now iI'm looking for text mining module if celonis has. Ｉknow pycelonis but it might take time to dev so please let me know if we have reusable one. just I'd like to do word occurence analysis. i don't need so complicated one.

10
R
Celonaut
M
Level 3
matt.slocu12Level 3
asked in Data Ingestion & Infrastructure
Need help with calculating times between consecutive activities

Hi! can anyone please help me figure out the following PQL? I have cases that have a lot of the same activity.  Imagine the activity is "Walk The Dog" and there are activities with the following dates: 1/1/20231/8/20231/15/20231/25/2023 I would like a query that returns the largest number of days between consecutive events  So in this example: 1/1/2023->1/8/2023 = 7 days1/8/2023->1/15/2023 = 7 days1/15/2023-1/25/2023 = 10 days I would like the query to return '10'  I am having trouble with trying to connect the dots with the documentation on calc throughput. Not sure how to approach it. 

90
M
Level 3
S
Level 3
sudhanshu.kumar15Level 3
asked in Process Analysis
How can i apply component filter on table dimension in view, when dimension is changes using dropdown, and dimension data come from multiple table. like few dimension are coming from casetable, some from activitytable and some of them from other

How can i apply component filter on table dimension in view, when dimension is changes using dropdown, and dimension data come from multiple table. like few dimension are coming from casetable, some from activitytable and some of them from other table

120
V
Level 3
anusuya.ponnu
Level 3
anusuya.ponnuLevel 3
asked in General Product Q&A
How do we populate the benchmarking components with the default value if none is selected in the dropdown button.

I have one Main button dropdown to select dimensions(dimension 1 and dimension 2). There are two other different button dropdowns (First and Secondary Category) to retrieve values from the main Dimension for benchmarking purpose. When I select dimension 1 as main dimension and even before selecting the First Category, the process explorer and the other Single KPIs displays empty. Is there any way to populate default values even before selecting the dimensions. Please see attached for more information.

54
P
Level 3
albertjan.salom
Level 3
albertjan.salomLevel 3
asked in General Product Q&A
Setup of Celonis connection with UiPath RPA

Hi, in an action flow I try to make a connection with our UiPath RPA Orchestrator to start a job there. Because we use the on-premise version on UiPath I have to setup the connection like below. I filled in all details and I requested our IT team to whitelist all Celonis IP addresses on this webserver, but still it is not working.   Does anybody has experience with this connection or maybe has an idea what is going wrong?  Many thanks in advance!Albert-Jan

60
albertjan.salom
Level 3
W
Level 3
windu.hardiLevel 3
asked in Data Ingestion & Infrastructure
Dear All & Celonis expertI would like to get advice, on how to convert the date format DD-MM-YYYY HH:MI:SS to YYYY-MM-DD HH:MI:SS?Your advice and support is appreciated. Thank YouBest Regards,Windu

Detail:in our data model, the event time must with format YYYY-MM-DD HH:MI:SS. But my data source is DD-MM-YYYY HH:MI:SS. so this data is not available as event time. I tried to follow : https://www.vertica.com/docs/9.2.x/HTML/Content/Authoring/SQLReferenceManual/Functions/Formatting/TemplatePatternsForDateTimeFormatting.htm use query : TO_TIMESTAMP(Date_column, 'YYYY-MM-DD HH:MI:SS'); (attachment 5) but the date format is not correct as below: 0028-01-20 00:00:00 (Attachment 3) The original date is 28-01-2022 13:51:24 (as attachment 4) 

40
Z
Level 3
J
Level 2
johannes.keimLevel 2
asked in General Product Q&A
Intelligence API 403

Hello all,  I keep getting a 403 error when trying to access my knowledge models via the Intelligence API. The App Key is marked as used within Celonis & authorization works.  I have set the required permissions for the App Key. I am trying to access an app that is currently hosted in our sandbox - is that the issue?  Any help would be highly appreaciated.  Best Johannes

30
J
Level 2
denise.kruge12
Level 4
denise.kruge12Level 4
asked in General Product Q&A
Good day, can someone help me with a component filter if I want to filter on a case count for a certain time for yesterday, for example what is the total cases yesterday at 15:30. Thank you

Good day, can someone help me with a component filter if I want to filter on a case count for a certain time for yesterday, for example what is the total cases yesterday at 15:30. Thank you

00
denise.kruge12
Level 4
S
Level 2
sanjayan.anandLevel 2
asked in Process Analysis
Can we use a KPI as a attribute, So we can create profile view

We are trying to build profile views for KPI's. Can we use a KPI as a record so that we can create an attribute and create a profile view?Is it possible to use multiple KPI's in a single component in a profile view?

00
K
Level 1
M
Level 2
manish.srima11Level 2
asked in General Product Q&A
Is it feasible to create variables in Skills to archive the selections' hierarchy?orDoes using augmented attributes make it possible to accomplish the same thing?Please help me with this.Appreciated and thank you

Is it feasible to create variables in Skills to archive the selections' hierarchy? or Does using augmented attributes make it possible to accomplish the same thing? Please help me with this. Appreciated and thank you

00
D
Level 1
G
Level 1
gulshan.mishr13Level 1
asked in General Product Q&A
how can we write a Pql Statement to count the total cases which passing through the Activity

how can we write a Pql Statement to count the total cases which passing through the Activity

111
Z
Level 3
S
Level 3
simone.nardiLevel 3
asked in General Product Q&A
Is it necessary to schedule Full Extractions and Transformations if I extract only the tables' relevant columns?

Good afternoon, among the best practices suggested by Celonis, there are: Scheduling Full Loads if delta loads are not possible or if source tables' metadata are changed frequently (i.e., a column is added or deleted).Extracting only the relevant columns of the source tables (i..e, those actually used in the transformations). If the relevant columns can't be deleted or changed in the source systems (because, for instance, they are crucial for the business and it would be a disaster to change them for the data recovery!), why should I schedule full extractions to consider metadata changes? Shouldn't I launch them only manually when columns need to be added to the extracted tables? Moreover, if the answer is in the documentation, could you share the link? Thanks and regards,Simone

42
S
Level 3
sarina.somme
Level 3
sarina.sommeLevel 3
asked in General Product Q&A
Is it possible to execute a skill with a kpi value?

Hi all,  I would like to execute a skill with two variables. Is it possible to set the value of one variable with a kpi from the knowledge model? Thanks and kind regards,Sarina

00
R
Celonaut
M
Level 1
mihály.jász11Level 1
asked in General Product Q&A
We would like to connect to SAP Succes Factor but we don't realy know anything about this system. Is there anyone who has some previous experience about this system? Is this an oracle or some kind of other Database? How to connect to it with Celonis?

We would like to connect to SAP Succes Factor but we don't realy know anything about this system. Is there anyone who has some previous experience about this system? Is this an oracle or some kind of other Database? How to connect to it with Celonis?

00
R
Celonaut

Badge Winners

  • First Post
    harshshhas earned the badge First Post
  • Qualified to Build Analyses
    Namit Singhhas earned the badge Qualified to Build Analyses
  • Qualified to Write PQL Queries
    yuri.fujimhas earned the badge Qualified to Write PQL Queries
  • Celonis Certified Data Engineer
    vijay.v14has earned the badge Celonis Certified Data Engineer
  • Qualified to Get Data Into Celonis
    vijay.v14has earned the badge Qualified to Get Data Into Celonis
VIEW ALL
Community Code of Conduct