Skip to main content

General Product Q&A

Not sure where to post? Ask your product-related questions here and get support from the community.

  • 1,445 Topics
  • 3,418 Replies
1444 Topics
A
Level 1
anusha.s.m11Level 1
asked in General Product Q&A
How to connect HANA database to celonis IBC? What are the requirements or inputs required?

How to connect HANA database to celonis IBC? What are the requirements or inputs required?

00
V
Level 4
B
Level 2
bishal.agarw11Level 2
asked in General Product Q&A
How does rest API works to connect with Celonis

How does rest API works to connect with Celonis

20
joos.buijs
Level 6
.
Level 2
.146001149Level 2
asked in General Product Q&A
How can I concatenate all values of one column into one string in SQL without using STRING_AGG()?

For example: column_a "one" "two" "three" Then: STRING_AGG("column_a", ',') => "one,two,three" STRING_AGG is not available as an error message tells me. How can I perform this action then? (I am working on a Transformation in a Data Job.) (CONCAT() concatenates across columns, but I want to concatenate across rows.)

100
.
Level 2
A
Level 2
ashish.petkaLevel 2
asked in General Product Q&A
How to change activities name while creating process/variant explorer for task mining activities.

I am using Celonis Task Mining and I was trying to create a process/variant explorer tab to show task mining activities as a process map. Here I had used column "ActiveWindow" from TM_Activities table. I was trying to get a more informative name for the task mining activities to make it more presentable and easily readable. Below are the things I tried and how they did no work: Updated the values from the active window name in the table, but they were not reflected in the process/variant explorer even after a refresh or reload, or starting a new analysis Added a column to enter activity names manually, column was added in the table, but the same did not reflect when I tried to select different column dimensions in the process/variant explorer. I tried to use annotated activity column (comments) from user_interaction_event_log table. Even after selecting it as activity table, the process explorer would give error as not selected as activity table or the map created would be of rhombus s

20
janpeter.van.d
Level 8
L
Level 2
luis.piñueLevel 2
asked in General Product Q&A
Calculate throughput time in working days

Hello everyone and thanks in advance for the help. I have a little problem calculating the throughput time. I can calculate it according to the timestamps without problem but I need to calculate it removing the weekends, that is to say counting only from Monday to Friday, the working days. Is there any way to do this?

40
.
Level 4
F
Level 2
filipe.coralLevel 2
asked in General Product Q&A
Activity_Lag and Remap_Timestamps

Hi Everyone! Can you please help me? I am trying to build a KPI related to the time spent on average to perform an activity. Additionally, I have to only count the working hours (and for that, I already have a variable created named "Working Hours") To do so, i am using this formula: CASE WHEN ACTIVITY_LAG (....) = 'ABC' THEN HOURS_BETWEEN(... , ACTIVITY_LAG ( ...... )) This formula is working, but the problem is that I need to calculate only the working hours. How can I do it? I am trying to "remap_timestamps" but it is not working.. Thanks in advance

10
F
Level 2
M
Level 2
mary.hope.suson11Level 2
asked in General Product Q&A
Is it possible to send the signals of my Action Engine to certain people without access to Celonis? Do they really need to be signed up for Celonis to receive these signals?

Is it possible to send the signals of my Action Engine to certain people without access to Celonis? Do they really need to be signed up for Celonis to receive these signals?

00
janpeter.van.d
Level 8
.
Level 1
.146001195Level 1
asked in General Product Q&A
I'm trying load data from Oracle R12 EBS into the data model but getting below error.. Error message in details.

Data model load failed during load to engine: Could not load data model. Load failed. Error Message: Error while joining table 'AP_HOLDS_ALL' with table '_CASE_TABLE_ORACLE'. Data type of column 'INVOICE_ID' doesn't match data type of column 'INVOICE_ID'. Error while joining table '_CASE_TABLE_ORACLE' with table 'AP_PAYMENT_SCHEDULES_ALL'. Data type of column 'INVOICE_ID' doesn't match data type of column 'INVOICE_ID'. Error while joining table 'AP_SUPPLIERS' with table '_CASE_TABLE_ORACLE'. Data type of column 'VENDOR_ID' doesn't match data type of column 'VENDOR_ID'. Error while joining table '_CASE_TABLE_ORACLE' with table '_CEL_AP_ACTIVITIES_ORACLE'. Data type of column 'INVOICE_ID' doesn't match data type of column '_CASE_KEY'. Could not execute foreign key join: there are duplicates on both sides of the specified key relationship. Table "_CASE_TABLE_ORACLE": key column ("INVOICE_ID"), key (8089730), rows 0 and 1. Table "AP_INVOICE_LINES_ALL": key column ("INVOICE_ID"), key (81335

50
.
Level 1
A
Level 1
alex.medin11Level 1
asked in General Product Q&A
Extraction fails with Cannot create PoolableConnectionFactory (Database 'X-X-X-X-X-X' is unavailable. It is undergoing LOAD TRANSACTION

Hi everyone, I have a connection to a Sybase ASE database and extracts configured that work correctly, however on certain occasions these fail with the following error: "The data source configuration is invalid Unexpected error when creating database connection: Cannot create PoolableConnectionFactory (Database 'X-X-X-X-X-X' is unavailable. It is undergoing LOAD TRANSACTION." ) My client has declared that this data source is a replica of the production database, which is updated every 5 minutes, during this update that is carried out at the transactional level, the connections are blocked, but this lasts only a few microseconds. I would like your feeedback, to know alternatives that can help me, so that the configured extractions can support this scenario, since the whole process of updating and creating the Celonis data model stops. I unsuccessfully searched for some configuration that would allow me automatically failed extracts to have the ability to retry to run. I appreciate your

00
A
Level 1
Q
Level 2
quintin.nel11Level 2
asked in General Product Q&A
Is it possible to add the ability to customize the formula used for the Cycle time on the Variant Explorer?

In the Variant Explorer (Process Analytics), the Cycle Time shown on the different Variants uses Throughput time from first activity to Last activity. Currently, there is no way to enhance the KPI to filter certain activities, like Date Markers (ie Due Date Passed). Is it possible to add the ability to customize the formula used for the Cycle time on the Variant Explorer?

00
Q
Level 2
A
Anonymous
asked in General Product Q&A
How can I use Union on PQL to combine data from two tables?

I want to combine data from two tables on the frontend using PQL query. Not sure how to do it.

70
A
A
Anonymous
asked in General Product Q&A
Can the Celonis EMS authenticate to an On-Prem Active Directory?

Can the Celonis EMS authenticate to an On-Prem Active Directory?

00
D
Level 1
P
Level 2
pawan.dihiyLevel 2
asked in General Product Q&A
How can we connect Celonis to SAP BW/4HANA

Please mention the way to connect. Is there a connector available ? Can we create a custom connector?

90
P
Level 2
K
Level 3
khurram.shahz11Level 3
asked in General Product Q&A
Good day all, Is there any way to block skill steps in way that next step should only be executed when current finishes ?

I have a skill that add data table, run ML script that update some other tabls and reload the data modal but updates on other table are not persisted in data modal. My assumption is that action engine do not wait for ML script to complete rather it just start it and move to subsequent steps. Any thoughts, suggestions on this scenerio ?

00
K
Level 3
S
Level 2
sarah.barne12Level 2
asked in General Product Q&A
PU_FIRST question

Please see the screenshot showing sample data, we want to show waste transfer movements which go out of a source storage unit (Movement type 319) to a destination (Movement type 0) and then return. I can make the PU function work well when there is one waste movement however there are many times that the stock is moved out and back, and out and back and I can't make Celonis line up the 2nd out and back movements

40
S
Level 2
E
Level 2
eike.wellmLevel 2
asked in General Product Q&A
Hello everyone,iam wondering if there is any way to sort the entries in a button drop down?i.e. when loading dates, displaying the most recent dates first instead of the oldes dates.Many thanks!

Hello everyone, iam wondering if there is any way to sort the entries in a button drop down? i.e. when loading dates, displaying the most recent dates first instead of the oldes dates. Many thanks!

00
joos.buijs
Level 6
M
Level 3
mohamed.ruzli.mohamLevel 3
asked in General Product Q&A
Results from formula stored in a variable is not reflecting in my analysis?

I have a formula stored in a variable that is giving me an accurate result of what I need to get when I check via static value based on a date filter I am putting in. However, when I pull it to my OLAP table it is showing me another value even though the same date filter is applied? Example: 83000 is stored in <%=Var_1%>. When I apply the date filter is changes to 17000 (which is correct), but when I try to store the same value as a KPI in my OLAP table it still shows 83000

00
M
Level 3
T
Level 1
todd.palmeLevel 1
asked in General Product Q&A
In the SAP Extractor installation what are the App Key and Agent Name fields?

I followed the SAP Extractor documentation. It is very helpful and detailed. However, there is one thing I noticed isn’t mentioned: While installing the SAP Extractor there is a screen: Configure the Agent Uplink In there are two fields: App Key Agent Name These aren’t mentioned in the Docs. Are these specific to my Celonis team or to the SAP installation?

20
J
Level 2
.
Level 4
.146001171Level 4
asked in General Product Q&A
What kind of algorithms does Process Analytics use for discovery and conformance?

As we know, Process Mining has the tremendous advantage of providing an objective and realistic view on the processes, as opposed to the traditional BPM analysis, which is very dependent on human judgement and prone to bias. However, building a process model from an event log is not a straightforward task. It requires an algorithm, and algorithms are based on assumptions have to somehow deal with things like noise. Conformance checking can also be done in different ways. Therefore, to better understand my results, I would be very interested in learning the algorithms used by Celonis. Thanks!

40
.
Level 4
.
Level 2
.146001165Level 2
asked in General Product Q&A
Search for spezific Activity

Hello all, I'm looking for a way to search for certain activities without having to show all the variations and then read over them with my eye. An example from P2P process: I search "Delete Purchase Order Item". But I don't know from which variant it becomes visible in the explorer. How can I search/find something like that?

10
.
Level 4
M
Level 3
mohamed.ruzli.mohamLevel 3
asked in General Product Q&A
How can I convert values received from PU_COUNT to percentages?

Based on the example table below: I am getting the values in 'Column_2' by using PU_COUNT How would I go by converting each value in 'Column_2' to a percentage amount?

20
.
Level 4
U
Level 3
ugurcan.aydem13Level 3
asked in General Product Q&A
Scheduling Studio Skills

Hello everyone, I wonder that when I create a skill with Manual Sensor, can i schedule trigger of this skill ? For example I want to trigger this skill once in a month automatically . If I can't is there any differenw way to do that Thank you

20
U
Level 3
Z
Level 2
zeynep.dirik12Level 2
asked in General Product Q&A
Is it possible to use SQL Procedure in data transformations? If not, is it on the roadmap? Thanks!

Is it possible to use SQL Procedure in data transformations? If not, is it on the roadmap? Thanks!

10
Z
Level 2
A
Anonymous
asked in General Product Q&A
ServiceNow Connector for IT Service Management - Incident Management - Data model load failed

Hello. I'm currently testing the ServiceNow Connector for IT Service Management - Incident Management. Unfortunately, the model cannot be loaded: Data model load failed during table export: Data model tables: _CEL_INC_ACTIVITIES, sys_user_group, BACKLOG, incident contain more rows than the allowed maximum per table of 0. Please reduce the number of rows. The data jobs ran errorless. Any idea what is wrong? Best regards, Heiko

10
A
R
Level 2
remington.roger11Level 2
asked in General Product Q&A
Removing an activity from an analysis

Hi!! I'm interested in filtering an activity out of an analysis. When I try to filter out the activity from the attribute selection, the activity still shows in the Process Explorer. Is there a way to do a crop selection type filter in the load script?

20
R
Level 2

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