- - Knowledge base overview
Product Updates

Welcome to the Celonis Community

2 months ago

Home
Community
Product Q&A
General Product Q&A

General Product Q&A

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

1,423 Topics
3,364 Replies

When you subscribe we will email you when there is a new topic in this category

1423 Topics

Most replies

Most views

Newest first

.14600871Level 2

posted in General Product Q&A

TPT

Hi, How can I customize the he Throughput-Time-Search element in Celonis 4.5? - In the attached picture (TPT) the intervals for each bar is consistently 14 hrs. Can I change this to e.g. 50 hrs per bar? - Thanks.

3 years ago

florian.mrkviLevel 4

asked in General Product Q&A

Is it possible to upload 2 seperate csv files for the activity table?

As soon as our CSV file for the activity table exceeds the filesize of 4GB Celonis is throwing an error and I suppose this is due to the filesize.I cannot reduce the dataset any more so I hope there might be a way to upload 2 seperate files and join them together within Celonis. Unfortunately I can't find such a function anywhere. Or maybe there is another way to bring big activity tables to Celonis without a database connection? Would that work in IBC? I work On-Prem 4.6.0-RELEASE_2babc1e_20200831_0915

3 years ago

mohamed.ruzli.mohamLevel 3

asked in General Product Q&A

Why is my filter option only applying to half of the table?

I have a table in the 'Filter_Option' attachment that is filtered based on a client and it shows different values with relation to no.of cases and amounts based on different periods in days. I have a further drilldown option when you click the orange button which directs you to the `Drill_Down` attachment But, even though the client filter is global it only applies to half of the table. I observed this when I added up the red circles which is reflected in the drill_down attachment

3 years ago

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?

3 years ago

bishal.agarw11Level 2

asked in General Product Q&A

How does rest API works to connect with Celonis

3 years ago

.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.)

3 years ago

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 analysisAdded 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 rho

3 years ago

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?

3 years ago

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'THENHOURS_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

3 years ago

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?

3 years ago

.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 &

3 years ago

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

3 years ago

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?

3 years ago

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.

3 years ago

Anonymous

asked in General Product Q&A

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

3 years ago

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?

3 years ago

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 ?

3 years ago

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

3 years ago

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!

3 years ago

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

3 years ago

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 UplinkIn there are two fields:App KeyAgent Name These aren’t mentioned in the Docs. Are these specific to my Celonis team or to the SAP installation?

3 years ago

.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!

3 years ago

.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?

3 years ago

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_COUNTHow would I go by converting each value in 'Column_2' to a percentage amount?

3 years ago

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

3 years ago

Page 56 / 57

Badge winners

anton.schmihas earned the badge Qualified to Identify and Drive Opportunities
kunal.baner11has earned the badge Qualified to Build Action Flows
mariko.doihas earned the badge Value Realization Expert
mariko.doihas earned the badge Qualified to Manage Implementation Projects
mariko.doihas earned the badge Qualified to Create and Deliver Demos

Show all badges

Terms & Conditions

Sign up

Already have an account? Login

Login with SSO

Celonaut Login Celonis ID Login

Login to the community

Login with SSO

Celonaut Login Celonis ID Login

Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.

Enter your e-mail address

Back to overview

Scanning file for viruses.

Sorry, we're still checking this file's contents to make sure it's safe to download. Please try again in a few minutes.

This file cannot be downloaded

Sorry, our virus scanner detected that this file isn't safe to download.

ANY QUESTION?

Talk to an expert

FAQs

MORE CELONIS

Academy arrow_outward

Documentation arrow_outward

Support Center arrow_outward

Partner Portal arrow_outward

Marketplace arrow_outward

CHECK US IN

YouTube

Instagram

Facebook