General Product Q&A

We need to connect Celonis to SAP CCS, but we don't know if the SAP ECC Connector can be use.

Execution error: ERROR: Join [("27473006-d9c3-4d0c-8e36-7c4690ec4574_e04e1e0b-30e2-426d-ab63-bb9f5b0e5f2a".USR02 x "27473006-d9c3-4d0c-8e36-7c4690ec4574_e04e1e0b-30e2-426d-ab63-bb9f5b0e5f2a".CDHDR) using USR02_v1_b0 and previous join (PATH ID: 7)] inner partition did not fit in memory; value [100,BATCH]

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

Please see the attached video to grasp the issue.

How does rest API works to connect with Celonis

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

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

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?

How do I calculate the working days between two activities with a work calendar from a non SAP system? Hello community, I am having difficulties calculating the number of working days between two activities. As I do not have SAP connected to Celonis, I want to connect a work calendar using another table. I have added an additional table with the following structure. It is linked to the time stamp of the cases. Now I want to sum up the flags of all days between the two activities. However, I only get the timestamps of the activities from the added table (This means I always get two as a result).  I have assumed that this could be due to the link via the timestamps of the two tables. Does anyone have an idea how I could solve this problem or how I can do the calculation in PQL? Basically, I would be interested to know if it is at all possible to integrate a work calendar with a non SAP system? Unfortunately Celonis only suggests a TFACS table? Which table structure would be advisable? Ma

I have attached 2 screenshots of the same variant explorer, but filtered with case frequency and activity frequency. I wanted to know why the numbers on the process map do not change when these filters are switched

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

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?

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 &

This one is so obvious I know I'm just not seeing something! But how do I copy a well formed Analysis from Process Analytics and make it available in Business Views?

Hello all, I'm enrolling Celonis Summer School and almost in the end of the analysis I noticed that I made mistake at the beggining while uploading "_APX_WDCRP_CASES.csv. Basically in "event collection" »» "File uploads" »» "Decimal Operator", I didn't change "." to "," and so the program is not recognizing the numbers as decimals.  As I'm having my first steps with Celonis, can anyone let me know if this is possible to fix without need of making the analysis from scratch?? Thank you for your kind.Guilherme Luz

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

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?

Can any one help me to solve this issue? 

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

I have a global date filter which pretty much is selection between a date period (Eg: - 01/01/2021 - 01/31/2021). This filter applies to my entire analysis when selected. However, I have an OLAP table where the columns are built upon formulas which include the use of DOMAIN_TABLE

I have an OLAP table that is sorted by # of days (in screenshot named first). But I am trying to produced the same table, but in the format represented in the screenshot labelled as second.  Essentially I want the tables sorted from lowest to highest # of days and also removed the NULL (-) values associated with each client. I have rewritten the queries for each column to support PU functions and was planning to use a DOMAIN_TABLE for this purpose, but when I use the DOMAIN_TABLE within the component filter to remove nulls when ISNULL(...)=1 it still remains the same as first

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

Looking for connecting Celonis EMS to DuckCreek Insurance platform... Is there a API library or connector available?

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