Product Q&A

I'm trying to use Celonis provided pre-configured demo application in TryCelonis. During the creation of data pool, it asked to create Data connection. From the list of available connections there is one connection named as 'SAP Demo'. Is this build in connector to connect with demo data related to SAP? When i tired to use this connection, it pre populated connection details like Host, client, systemNumber and user id. In order to complete connection, it need password and i'm not able to find it anywhere in any documentation. I'm not sure it is correct approach and i'm making correction assumption about 'SAP Demo' data connection.I'm trying to setup an environment from demo data without creating actual connector with SAP. Is this possible? if I do not specify data connection, then i'm unable to get 'Data model' object from PyCelonis for the analysis that is using that data model. Any help shall be greatly appreciated.

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

Hi, I am interested in two particular sequences A->B->C and A->C that may have none or multiple occurrences within one case (A ,B and C are activities and the connexion "->" is not necessarily direct).  Important: The activity A is always followed (directly or not) by the activity C. That means that I can't have A->A->C or A->C->C, but I may have A->C->A->C. I would like to calculate two KPIs:KPI1: Average TPT between A and B when I am in a A->B->C sequence,KPI2: Average TPT between A and C when I am in a A->C sequence. For instance: Let's say I want to calculate KPI1, and one of my cases is:  Start >> ... >> A1 >> C1 >>... >> A2 >> ... >> B1 >> C2 >> ...>> B2 >> ... >> A3 >> B3 >> C3 >> ... >> End. For that case, the result should be ( (tB1-tA2) + (tB3-tA3) )/2 (with t- being the timestamp) I tried the following, but it seems to

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

The screenshot with the red circles is filtered on Avg throughput time and the screenshot with blue circle is filtered on median throughput time. If you some up the values in the explorer (Example: Red circle image:- 4 + 20 + 13 = 37) it is not equal to the median red circled day of 66.5 . Th difference also exists when I filter on median throughput time. Any suggestions?

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

Hello Community, Refering to [1.0.0 / User Management & Permissions] on help.celonis.de I have " 5 new users" (created via python) , now i want to add it to existing group using python. user = User.create_new(Dummy1, fname, lname, email@abc.com, password123) user = User.create_new(Dummy2, fname, lname, email@abc.com, password123) user = User.create_new(Dummy3, fname, lname, email@abc.com, password123) user = User.create_new(Dummy4, fname, lname, email@abc.com, password123) user = User.create_new(Dummy4, fname, lname, email@abc.com, password123) I already have existing 2 user groups , i.e Viewers , Analysts Now I want to Assign user Dummy 1 and Dummy 2 to Group Analysts and I want to Assign user Dummy 3, Dummy 4 and Dummy 5 to Group Viewers :- like below Groups User Analyst Dummy 1 Analyst Dummy 2 Viewers Dummy 3 Viewers Dummy 4 Viewers Dummy 5 Now If I try to assign the user to the Group using group.add_user(user) However , how to I assign my existing Group

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

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? Unfortunately Celonis only suggests a TFACS table? Which table structure would be advisable? Ma

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? Unfortunately Celonis only suggests a TFACS table? Which table structure would be advisable? Ma

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, users can experience the power of the Celonis Studio without breaking out a credit card. Launching Quickstarts gives organizations

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?