Product Q&A

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

We need to use a PU function where we want to pull up to a key stored in the same table as where we want to do the SUM over (in our case): PU_SUM(DOMAIN_TABLE('table1'.'key1'),'table1'.'field1') However, key1 occurs multiple times in the table, resulting in the sum of field1 being repeated for each occurrence. How can we only get a result once per key? We tried adding DISTINCT but that didn't work...

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

Dear all, I tried to use the backup_content function for Knowledge Models, so that I can store the YAML Code for worst case szenarios (package gets accidentially deleted). I am able to access the Spaces/Packages/Knowledge Models via .content but for backup_content it says the follwoing:AttributeError: 'KnowledgeModel' object has no attribute 'backup_content' Which components are enabled for backup_content?

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

In our Datamodel every activity can additionally get multiple (0..n) labels. Due to the nature of 0..n relations this cannot be done via activity attributes as we don't know the nessessary amount of columns in forehand. That's why these labels (strings) are stored in a seperate table. Foreign Key is the unique activity ID.  I know how to filter/flag cases with the MATCH_PROCESS function. Here we use the nodenames or another string column, but the column is always part of the activity table. Now I want to do something like:Give me all cases where an activity with the associated label "Greeting" is directily followed by an activity with the associated label "Error". Is it possible to filter cases based on the labels that are stored in a seperate table? 

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

Update: Snap has evolved. Enter the Celonis Free Plan.   The TL;DRNow you can try out advanced EMS capabilities — including the world’s #1 process mining technology and Action Flows — for free. Yup, you heard that right. A no-cost version of the Celonis Execution Management System is more than just “on the horizon.” It has arrived. Snap teams will be updated automatically and all of the Snap data will be automatically uploaded to the new platform, so no sweat there. The Celonis Free Plan — at its core — is just a new and improved version of Snap with more EMS features. And the best part? We’ll keep adding more and more of these features as we develop the customer experience. Questions? Send an email to m.giraud@celonis.com Keep reading to go a little deeper into the new components at the heart of the Celonis Free Plan.  -- StudioWith the Celonis Free Plan, us

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

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

Feature request - shading lines in tables, similar to tables in Excel maybe we have overlooked this - would there be a chance to get the option to shade lines in tables alternating between shaded and white so that you can easily see in which line you are (having a frozen left column)

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 au

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?

What all options do we have in celonis to export our analyzed process ? (ex - csv, excel, bpm)

Hi all, I'm currently enrolling Celonis Summer School and I have no experience on PQL neither SQL languages, so I please ask your help. I am trying to write something like a "SUM IF" expression. Basically, when column "_APX_WDCRP_CASES_csv"."ORDER_DATE_MET" = 0, I want to sum "_APX_WDCRP_CASES_csv"."ORDERED_QUANTITY" values.  I already tried to mix CASE WHEN function with SUM but I was not succeeded. I also searched for other functions related with aggregation but could not find one that applied. Many thanks!Guilherme Luz

Hi together, We are facing an issue with the data load since 9th April. We cannot load data from SAP HANA databases anymore. Everything worked till 8.4. We have these issues in different teams (all on eu-1) and for different SAP HANA databases from different hosters. Therefore, it seems that something changed with the driver within Celonis EMS. Error: Unexpected error when creating database connection: Cannot load JDBC driver class 'com.sap.db.jdbc.Driver'(see attachment) Any ideas? Thanks in advance,Clemens

I established the connection with service now.When i tried to install the service request management but i got error sys_audit table is not present.so I check in Extraction part to extract the sys_audit table but i dont have the table.

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.