Skip to main content

Product Q&A

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

3101 Topics
mathijs.lende12
Level 2
mathijs.lende12Level 2
asked in General Product Q&A
How to migrate a table using the pql.DataFrame function with dollar sign "$" in the column names.

We want to migrate a table from a data model where the table column names have dollar signs ($) in the name. When we try to migrate the table we get a column not found error on those columns that have a dollar sign in the name. Is there a way to encode or otherwise provide the column names to the pql.DataFrame function such that it can use columns with $ signs?

00
H
Level 1
J
Level 4
jumbo.szkLevel 4
asked in General Product Q&A
Question about SQL filtering datetime with time

Hi expert, I'm not quite good at SQL and I have a question about SQL. In my case, I would like to filter activity table with event time with its only time(hh:mm:ss). Does anybody let me know how to do that in Celonis data integration task?

00
J
Level 4
P
Level 4
parvathi.choudLevel 4
asked in General Product Q&A
Newly created KPI's are not appearing in the "Get Rows" module of the Action flows.

Hello Team,While creating Action flow, by using Get rows Celonis module. After selecting appropriate Knowledge model only few KPI's are shown, recently created KPI are not shown. How can I access newly created KPI?Thank you in advance.

70
P
Level 4
G
Level 1
gagan.agrawLevel 1
asked in General Product Q&A
I am not able to sort the amount in celonis dashboard in Descending order. It always shows in ascending order. How can I show it in descending order

Here the amount is still in ascending order even after sorting it as descending.

30
L
Level 1
A
Level 3
abhinav.singa11Level 3
asked in Data Ingestion & Infrastructure
How to convert seconds to the date format (DD-MM-YYYY)?Also what could be the reason for having the same 'PU_median time' value for all the cases in the data set?

Hallo Team, I have been using the P2P dataset provided by the academy.  Had used the following statement to calculate the PU_median according to each case - PU_Median("LFA1", "_CEL_P2P_ACTIVITIES_EN"."EVENTTIME").  I have diffculties understanding the outcome (in pic attached) - Why do I get the PU_Median time calculated in seconds format?How can I convert the O/P format in seconds to DD-MM-YYYY ? - Had tried using {t } function, but it was an failureEven though there are different time stamps for each case wrt to activity - why do I get the same median time (1245079800000) for all the cases?  Can any I detail it . Thanks in advance.

50
A
Level 3
B
Level 3
bhupendra.singh.thakuLevel 3
asked in General Product Q&A
Can any provide a sample Table-ABAP-Configuration.xlsx file

Can any provide a sample Table-ABAP-Configuration.xlsx file

20
L
Level 1
D
Level 1
deleted.delet27Level 1
asked in General Product Q&A
Referencig mutliple recipients (TO/CC) in outlook AF module

Hello,  Anyone knows how to reference array without keys (1. Value A2. Value B)or just a string ("Value A, Value B) in a outlook recipients module? I've tried several approaches but nothing seems to be working properly. I do not want to send multiple emails to single recipient (1 mail = 1 recipient). I want to send 1 email to multiple people in both "TO" and "CC" fields. It's improtant as we've got dynamic recipients list. Usually I end up with one of two errors: or  Best Regard,Mateusz Dudek 

30
L
Level 1
A
Level 3
antoine.leducLevel 3
asked in Process Analysis
How modify the maximum execution timesout in Action Flow ?

Hello guys,I'm trying to find a solution to modify the maximum execution timesout in one of my Action Flow, it stops before all data are transfer in one of my google sheet file. Do you have an idea ? Thanks !

00
S
Level 1
vamshi.vigne
Level 3
vamshi.vigneLevel 3
asked in Process Improvement
Action Flow Error

We have built an Action Flow to capture daily stats from an analysis and store it in a SharePoint. When we try to execute this Action flow manually, it does not give an error and works properly but when scheduled, it gives the below error. "Function 'getResponseBody' finished with error! Script execution timed out after 10000ms." How to mitigate this?

40
S
Level 1
H
Level 3
himanshu.sharm16Level 3
asked in General Product Q&A
Throughput Time calculation for multiple cases

Hi everyone, i got following activity table structure:Item ID (case ID), Activity (activity), Timestamp (timestamp), Item position ID One Item ID can have multiple Item Position IDs; so 1:n relationship. Some activities tend to repeat themselves for each distinct Item Position ID, example: Item 1, Activity A, 08.08.2023 10:00, -Item 1, Activity B, 08.08.2023 10:01, ItemPosition 11Item 1, Activity C, 08.08.2023 10:02, ItemPosition 11Item 1, Activity B, 08.08.2023 10:03, ItemPosition 12Item 1, Activity C, 08.08.2023 10:06, ItemPosition 12Item 1, Activity D, 08.08.2023 10:07, - I want following throughput time calculation to be considered for each Item Position ID, which i am not able to generate.   CALC_THROUGHPUT (  FIRST_OCCURRENCE [ 'Activity B' ]  TO  FIRST_OCCURRENCE [ 'Activity C' ] ,   REMAP_TIMESTAMPS ( "Activity_Sheet"."TIMESTAMP" , MINUTES ))  Output expected:ItemPosition 11, 1 min.ItemPosition 12, 3 min. Generally i would create 2 activity l

00
S
Level 1
A
Level 3
abhinav.singa11Level 3
asked in Data Ingestion & Infrastructure
Can you please guide me - what is the next step we need to proceed when get the error message 'No Common Table', along with the 'Path defined in the error message?

Over the Join Functionality documentation page (Join functionality (celonis.com)), when we get an 'No Common Table' error message - a detailed explanation along with the join path is explained. As I am new to the Celonis world, I wonder how to use the mentioned path to achieve the corresponding result.  Thanks in advance.

260
A
Level 3
R
Level 4
rahul.bhat13Level 4
asked in Process Analysis
How do i get the bar chart with Grouped by buckets for dates in views

Hi All,Im trying to find the count of throughput time in buckets in views. The histogram are the way to go but in views they only accomodate integer and floats but not dates. Im trying to come up with it in Chart but unable to.Please let me know if someone has any idea.

140
janpeter.van.d
Level 8
T
Level 3
teun.gilis11Level 3
asked in Process Improvement
How to make automation skill input optional?

Hi, Does anyone know how to make an input for an automation skill optional?The option is greyed out for me. I would like to be able to trigger a skill using an action without having to fill fields if they are empty. Thanks!Teun

00
L
Level 1
D
Level 2
dimitar.lazar12Level 2
asked in Process Analysis
Generate documentation for knowledge models

The documentation feature in Process-Analytics (https://docs.celonis.com/en/export-technical-documentation.html) is a great one to keep track of the logic developed and is of great use for developers and business users. Is there something similar in Studio fpr knowledge models?

00
janpeter.van.d
Level 8
A
Level 3
alejandro.bayonLevel 3
asked in Data Ingestion & Infrastructure
How can I use a KPI that is defined in the knowledge model in an action flow Query Data module?

Hello, I open this question that was already asked by another user 5 months ago and not answered from Celonis. Moreover, I'm not allowed to comment or ask for update on that post if the post is older than 30 days. I would like to query data in an Action Flow from the Knowledge Model and not from the Data Model. Currently I have an Action Flow connected to a Data Model and I have modules like Tools (set multiple variables) replicating the same KPIs I have in the Knowledge Model. If I need to update a KPI in the Knowledge Model I have to remember to update it as well in the action flow, this causes high maintenance and possibility of error. This feature is critical since one of the main goals of using Studio is the centralization of KPI definitions into a single source of truth, the knowledge model. If you have any update on this topic I'd appreciate if you can share it with the community. Thanks. BRAlejandro 

200
janpeter.van.d
Level 8
C
Level 3
chaitra.shett12Level 3
asked in General Product Q&A
How to force load empty csv/xls files using pycelonis? Its a client requirement

How to force load empty csv/xls files using pycelonis? Its a client requirement

00
R
Level 2
M
Celonaut
mateusz.miaraCelonaut
published in Process Intelligence Graph
Starter Kit version for object-centric process mining (2023-07-18)

Starter Kit version for object-centric process mining (2023-07-18) An Accounts Payable Starter Kit version that supports object-centric process mining is available now from the Celonis Marketplace. The object-centric Accounts Payable Starter Kit version 1.0.0 uses the Accounts Payable perspective that’s supplied with our object-centric data model, or a custom Accounts Payable perspective that you have created in your team. Before you set up the object-centric version of the Starter Kit, you’ll need to load the object-centric data model with your data and validate the Accounts Payable perspective. The Starter Kit uses the objects and events that you’ve already built from your source system data and stored in the OCPM Data Pool. To get started, see Quickstart: Extract and transform your data into objects and events. To use this version of the Starter Kit, you'll need a Celonis EMS subscription that includes object-centric process mining. If you can't see the Data > Objects and

250
M
Celonaut
M
Level 2
mauricio.herreLevel 2
asked in General Product Q&A
Hi everyone! I am trying to set up triggers on my sanbox enviroment but It does not has that.. Does anyone know why?

Hi everyone! I am trying to set up triggers on my sanbox enviroment but It does not has that.. Does anyone know why?

00
R
Level 2
.
Level 4
.146192833Level 4
asked in Data Ingestion & Infrastructure
Network diagram for user approvals

Dear Experts , I have P2P activity logs and i have users column along with it infront of activity who executed it. Is it possible to create a network diagram using network explorer with each node being users along with value of transactions they are executing ? Can you advise ?

10
R
Level 2
泰
Level 1
泰志.田中Level 1
asked in General Product Q&A
コンポーネントのアクティビティエクスプローラーで検索されるアクティビティを固定したいです。通常の状態だとアクティビティエクスプローラーのアクティビティを選択しても、パッケージを移動すると値がリセットされてしまいます…

コンポーネントのアクティビティエクスプローラーで検索されるアクティビティを固定したいです。 通常の状態だとアクティビティエクスプローラーのアクティビティを選択しても、パッケージを移動すると値がリセットされてしまいます…

20
R
Level 2
D
Level 3
deepti.gandhLevel 3
asked in General Product Q&A
Hello everyone,We want to use Business Objectives view from Value Discovery APP(Order Management Starter Kit). We are only interested to bring the below highlighted one from Business objectives view into our new view created in this package.

Hence we would like to delete the rest of the components in Business View.But Delete option is not available for them. (We tried copying Business view into another and delete the other components to keep only Execution gap list(Inefficiencies)) Please advise. Regards,Deepti

00
R
Level 2
K
Level 2
kihyun.kim12Level 2
asked in Data Ingestion & Infrastructure
Is there a way to define dimension to only include activities that occurred before/upto specific activities?

I want to define the dimension so it includes activities in 2 conditions, that only has occurred before specific activities (ideally defined by LIKE "string%") OR upto specific activites. However, what I found so far for cropping methods (e.g. crop to null) requires specific name of the activity and doesn't allow LIKE predicate. Is there a way to crop activities to anything before specific condition / first_occ of specific condtion?

00
K
Level 2
kailash.potha12
Level 5
kailash.potha12Level 5
asked in General Product Q&A
How to apply Line break in KPI List for each KPI..?

How to apply Line break in KPI List for each KPI..?

30
kailash.potha12
Level 5
A
Level 1
armz.agbuy12Level 1
asked in Data Ingestion & Infrastructure
need to compare each of the the Part Name under Ticket.Id 123456 if any of them are the same in Ticket.Id 345691

need to compare each of the the Part Name under Ticket.Id 123456 if any of them are the same in Ticket.Id 345691 and in the Ticket table (in the same row as the Ticket.Id) the list of Part names also found in the succeeding Ticket.Id Ticket TableTicket.Id Event time123456 8-Jul345691 9-Jul Parts tableTicket.Id Part Name123456 PartName1123456 PartName2123456 PartName3345691 PartName1345691 PartName3

00
A
Level 1
R
Level 4
rahul.bhat13Level 4
asked in Process Analysis
How get a Breakdown in the table?

Hi All,Im trying to get a breakdown in a table at the top by defining a Custom object, but im not able to adapt it in the table.Below is the screenshot from Market place where they have done something similar,but im not able to replicate it.

40
R
Level 4

Badge winners

  • Celonis Technical Expert
    ewa.aniskhas earned the badge Celonis Technical Expert
  • Qualified to Build Views
    ewa.aniskhas earned the badge Qualified to Build Views
  • Qualified to Get Data Into Celonis
    ewa.aniskhas earned the badge Qualified to Get Data Into Celonis
  • Solution Creation Expert
    ewa.aniskhas earned the badge Solution Creation Expert
  • Qualified to Build Action Flows
    ewa.aniskhas earned the badge Qualified to Build Action Flows
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