Skip to main content

Product Q&A

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

3147 Topics
P
Level 3
pavan.abburLevel 3
asked in Process Analysis
Customizing activities displayed in Variant Explorer

I have a process which has tens of activities and 10000 variants with no major contributors. Because the process is not standardized even the top 100 variants only contribute to 23% of cases. So, I need to expand the number of variants I consider but this keeps adding more activities associated with each of the variants because of which reading the graph becomes harder. What I would like to do is basically customize the graph in the variant explorer for e.g. by filtering or hiding or grouping activities and also hide some connections between activities based on the case count so that it is easy to read.

30
P
Level 3
S
Level 3
sayan.chakr12Level 3
asked in General Product Q&A
I am trying to access transformation scripts from ML worbench with pycelonis 2.6 . But i am not able to fetch SQL scripts from transformation jobs which belongs to a template with visibility type protected. How to open the protected from task te

I am trying to access transformation scripts from ML worbench with pycelonis 2.6 . But i am not able to fetch SQL scripts from transformation jobs which belongs to a template with visibility type protected. How to open the protected from task templates?

10
S
Level 3
V
Level 2
vidar.oeenLevel 2
asked in Process Analysis
Process Explorer indicates incorrect throughput time

From the table it can be seen that the throughput time from first occurrence of "Send Purchase Order" to first occurrence of "Record Goods Receipt" is 14 days. This is confirmed by the calculation also. Still the Process Explorer indicates 5 days for the same case. Any idea for the "error" in the Process Explorer (there are no component filter enabled in the process explorer)?

00
V
Level 2
A
Level 3
abhinav.singa11Level 3
asked in Data Ingestion & Infrastructure
What does "{d '1970-01-02' } " refer to? What is returned as O/P in the PQL statement - REMAP_TIMESTAMPS ( {d '1970-01-02' } , DAYS ) ?

REMAP_TIMESTAMPS (celonis.com)

20
A
Level 3
S
Level 2
sharana.basava.patilLevel 2
asked in General Product Q&A
how can we push the OLAP from one instance to another instance without having to replicate the logic written on the back of the olap in action flow.

how can we push the OLAP from one instance to another instance without having to replicate the logic written on the back of the olap in action flow.

00
abhishek.chatu14
Level 7
javier.desar
Level 3
javier.desarLevel 3
asked in General Product Q&A
Difference between Attribute Lists and KPI Lists?

Hi everyone, I am building a View, where I want to list some KPIs from my Knowledge Model on top of a table. For that purpose, I first chose an Attribute List, as I see in the documentation that it can take KPIs as Input. Then I tried a KPI List instead, with the same KPIs from the Knowledge Model, and I noticed that the numbers displayed in each KPI are considerably different, when I use one component or the other. (I checked it and the numbers on the KPI List are right, and differ greatly from those in the Attribute List). Does anybody know what the cause of this discrepancy might be? How do Attribute Lists function overall? When should I use them? I was not able to find further information about that in the docs. Thank you very much! Javier

70
javier.desar
Level 3
khairus.solih
Level 2
khairus.solihLevel 2
asked in General Product Q&A
Hi All,I have a PQL formula that is getting an average value of a data, but it is showing different value in KPI List view and Table View.

Both views are using the same PQL formula which is getting the average value of a data and no filters were applied in the views.

50
S
Level 3
karol.trzci12
Level 3
karol.trzci12Level 3
asked in General Product Q&A
Issues when extracting from CDPOS table.

Hi, I'm trying to extract some additional data from CDPOS table using extraction that is separate from our main one. However, it doesn't seem to start to extract. Log shows that job was released to SAP but it won't start actually extracting anything. Does any one have any ideas what might cause it? Could maybe adding something to FIlters help? Thanks, Karol

90
S
Level 3
J
Level 4
jumbo.szkLevel 4
asked in General Product Q&A
Is there any table data cash in celonis?

Hi all, I have a question about Celonis table data. I have deleted around 20GB useless data via drop table SQL because our Celonis server reached to data volume limit 10 hour ago, but Celonis data volume bar in license setting doesn't move... Does anybody know how or when the data consumption will be updated? Regards,

00
J
Level 4
G
Level 3
giulia.cogliLevel 3
asked in General Product Q&A
Hello! Am I able to run a Conformance analysis in Studio by using more than one process model?

For example, let's say I'm analysing the conformance of my Incident management flow, but I need to distinguish per Service since I have different steps to be performed based on the type of the request. Can I set a specific process model per Service? Thank you in advance! Giulia

50
G
Level 3
F
Level 3
femke.van.dLevel 3
asked in General Product Q&A
After a connection with SAP ECC is made and the optimal execution order is calculated, the extraction is "queued" for several hours before it start extracting the first table. Has anyone had encountered the same issue before and knows how to han

After a connection with SAP ECC is made and the optimal execution order is calculated, the extraction is "queued" for several hours before it start extracting the first table. Has anyone had encountered the same issue before and knows how to handle this?

10
F
Level 3
T
Level 3
tobias.boehm12Level 3
posted in Process Analysis
Hello Sunny,

Hello Sunny, in case you're still looking for a solution to insert a embedded-view depending on a variable-value. I haven't heard back from Celonis yet but here's what i found: This will embedd the view with key 'embed-test-source' when the variable-value is 1 and vice versa 'embed-test-source-alternate' when the value is 2. Of course applicable to many more alternative views and conditions.

11
S
Level 4
V
Level 4
vasco.caron11Level 4
asked in General Product Q&A
Write Data to Table Skill Execution from Action Flow

Good morning, I'm trying to use the Write Data to Table Skill from an Action Flow, but I keep getting this error: As you can see in the INPUT section, the action flow is providing the required Data to the Skill, so I do not understand what is going on..? The skill itself is quite simple, with a Manual Sensor asking for User Input for Table Name, Column Name and Column Value And the Write Data to Table action is configured as follows, ensuring correct Data Types: When I query my database, the column is indeed a Float Data Type: So I am lost as to what is going on, can you please provide some support ASAP? Thank you very much!

100
V
Level 4
P
Level 4
preethi.p13Level 4
asked in General Product Q&A
Where to find the details of each configuration option/ action details for a Skill

I’m able to see how we can use Create PDF action, Email by Celonis and 1 or 2 others. Can anyone share the link where I can get more details in specific to each action in a Skill

00
M
Level 3
S
Level 3
sudhanshu.kumar15Level 3
asked in Process Analysis
COLUMN CHART IN VIEWS

Hi, is there any way to plot two column chart side by side in single chart in views. Example:

20
P
Level 4
G
Level 3
gerald.dunnLevel 3
asked in Data Ingestion & Infrastructure
Simultaneous timestamps treated as sequential, not parallel?

How would I expect this data to be visualised. Would it be as four parallel tasks or in sequence in record order. Does process mining support a parallel split? Case,Task,Time 1,x,01/01/2023 00:00:00 1,y,01/01/2023 00:00:00 1,z,01/01/2023 00:00:00 1,a,01/01/2023 00:00:00

00
S
Level 4
R
Level 4
rahul.bhat13Level 4
asked in Process Analysis
How to get the line chart on top of Bar chart

Hi Team, I am trying to get a line chart on top of bar chart but the bar in many cases are superimposing on line. So how can i get it on top/front? Adding the chart for reference

30
R
Level 4
.
Level 5
.146004200Level 5
asked in General Product Q&A
How to convert a string to a datetime format with milli seconds?

I would like to convert a string to a datetime format with the following formula: TO_DATE('2018-01-03 00:00:00.', FORMAT('%Y-%m-%d %H:%M:%S')) However, this is limited to accepting seconds as the finest gradient of formating according to the documentation. Is anyone aware of a %... Identifier for milliseconds? A workaround that works for me is: ADD_MILLIS ( TO_DATE('2018-01-03 00:00:00.', FORMAT('%Y-%m-%d %H:%M:%S')), 100) Though being a lot less elegant and I would have to split a column into its milliseconds and subsequently join them again. A native solution would be the preferred option. Kind Regards, Maurits

00
.
Level 5
jonas.schei12
Level 3
jonas.schei12Level 3
asked in Data Ingestion & Infrastructure
Abbreviated Number with same number of decimals?

Dear all, I would like to have the same number of decimals for different abbreviated key figures. With ".3s" I can only define the total number of digits, but I would like to define the number of decimal places for an abbreviated number. With ".3s" -> 8.07k .... 17.0k but I want: 8.07k ... 17.01k Thanks in advance! Best, Jonas

50
S
Level 4
B
Level 3
bhavya.r11Level 3
asked in General Product Q&A
FILTER MATCH_ACTIVITIES ( "<your activity table>"."<your activity column>" , NODE [ 'Clear Invoice' ] ) = 0;For the above filter, i would like to use the AND function and include both of the activities for filtering the data.

FILTER MATCH_ACTIVITIES ( ""."" , NODE [ 'Clear Invoice' ] ) = 0; For the above filter, i would like to use the AND function and include both of the activities for filtering the data.

60
S
Level 4
manuel.wetze
Level 5
manuel.wetzeLevel 5
asked in General Product Q&A
Inside of Knowledge Model KPI definitions I would like to create an parameterized "abstract" base KPI Formula. Is there a way to "hide" a KPI of knowledgemodel to be used in anything else outside ? Similar to private variables/methods?

My plan is to have one "generalized abstract" KPI which in turn is being called in a parameterized way by a number of different other KPIs. So that I only have to define the PQL once but can use the KPI directly in Frontend I however would like to hide said "abstract" KPI when Knowledge Model is being used, as it should only be used. Is there some kind of parameter that can be set in YAML definition of an KPI that makes it "private" ?

00
S
Level 4
michaela.gebha
Level 3
michaela.gebhaLevel 3
asked in Process Analysis
Create sheet / component filter to include completed order items only

Dear Community, For the KPIs in our O2C process we have created some dashboards, but would like to have only order items included that are fully processed, e.g. where the invoice is cleared. I currently do this by using an activity selection in the filter which is not very practical. Is it possible to have this as a component or sheet filter and how can I do it? Thanks for your help and please excuse this beginner question. Regards, Michaela

20
B
Level 3
A
Level 3
ayushi.ade12Level 3
asked in Process Improvement
Is there any option wherein we can attach/send a chart(it can be OLAP,column chart,pie chart) in email with Action Flow or Skills?

Is there any option wherein we can attach/send a chart(it can be OLAP,column chart,pie chart) in email with Action Flow or Skills?

70
matt.witty13
Level 5
J
Level 3
joão.francLevel 3
asked in General Product Q&A
When creating a Display rule the option avatarColor is not working?

HI, I've tried: avatarColor: Crimson avatarColor: "#DC143C" avatarColor: DC143C But nothing changes. What is the correct sintax? Example: customAttributes: - comparator: EQUAL value: 3 style: avatar: true iconPosition: ONLY_ICON avatarColor: "#DC143C" Best, João

00
S
Level 4
florian.mrkvi
Level 4
florian.mrkviLevel 4
asked in Process Analysis
Custom generated Column (Attribute) in Knowledge Model is not showing up in Studio

Hi, in my knowledge model I have defined a new column on an existing table. When I buid a view on top of that model I can see the additional column in the table and can use it like every other column. When I use the knowledge model as the base for a studio analysis the column is not showing up. Did I miss something?

30
florian.mrkvi
Level 4

Badge winners

  • Qualified to Build Analyses
    rafael.amanthas earned the badge Qualified to Build Analyses
  • Qualified to Write PQL Queries
    tasavhas earned the badge Qualified to Write PQL Queries
  • Qualified to Build Action Flows
    tasavhas earned the badge Qualified to Build Action Flows
  • Celonis Technical Expert
    pavankumar.palaghas earned the badge Celonis Technical Expert
  • Qualified to Build Views
    pavankumar.palaghas earned the badge Qualified to Build Views
Show all badges
Terms & Conditions

ANY QUESTION?

Talk to an expert
FAQs
Contact us

MORE CELONIS

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