Product Q&A

Hello Community, today, we upgraded one of our ML Workbench to PyCelonis 2.6.Since then DEBUG informations are shown (see below). In the Jupyter Notebook we use: logging.getLogger("pycelonis").setLevel(logging.WARNING) If we execute the notebook on local computer, no DEBUG information if shown. On the other hand, if we execute it on the EMS, following DEGUB informations is shown: [2024-01-31 13:39:56] DEBUG: Request: 'POST' -> '/pql-language/api/lsp/publishDiagnostics/batch'[2024-01-31 13:39:56] DEBUG: Request: 'POST' -> '/pql-language/api/lsp/publishDiagnostics/batch'[2024-01-31 13:39:56] DEBUG: Initialize Series.[2024-01-31 13:39:56] DEBUG: Request: 'POST' -> '/pql-language/api/lsp/publishDiagnostics/batch'[2024-01-31 13:39:56] DEBUG: Initialize Series.[2024-01-31 13:39:56] DEBUG: Request: 'POST' -> '/pql-language/api/lsp/publishDiagnostics/batch'[2024-01-31 13:39:56] DEBUG: Initialize Series.[2024-

For some reason I am not able to scroll down or select the case ID. Maybe it is a UI issue?

First, I am not sure if this will make sense because I'm having a hard time describing it to myself... but looking for any guidance or hints on how to approach this... I have a multi step process where one party is responsible for the first half and another party is responsible for the second half. A simplified example is: Process Steps:New widgetWidget step 1 done (Party 1)Widget step 2 done (Party 2) I can easily create OLAP tables around specific events... ex. date widget uploaded, count, most common color1/1/24, 100, blue but I'm having a hard time anchoring different events in the process to the same date row when I'm using pull up aggregation to get the counts General Date, Count uploaded, Count where widget step 1 completed, count where widget step 2 completed1/3/24, 100, 24, 581/2/24, 80, 42, 981/1/24, 110, 120, 20 The challenge that I'm seeing is that my PQL statements for each of the columns don't relate to the same date, and I don't know how to dyna

Community FAQ: How do I join/subscribe to a Community Topic? Answer:To join/subscribe to a community topic, please follow these steps: 1. Visit our community topics from the main navigation bar.2. Click on the topic you are interested in.3. Locate the "Follow" button on the right side and click on it. Once you follow a topic, you will see two options for email notifications as shown in the screenshot below.Same applies for other topics that are not listed here. Also, feel free to follow as many topics as you want!

Hello, I'm trying to obtain the name of the user executing a skill when pressing a button. I've seen that there is a function USER_NAME(), but I don't know where I should define it for it to work correctly. Thank you very much!

Hello everyone, Is there a way for admins to delete bookmarks created by other users? We have a lot of bookmarks created by no-longer-existing users that are polluting our dashboards. Thanks in advance!

Can anyone tell me how can I change the background color of view from grey to white?

I'm in my first EMS project and it was to accompany the DATA ENGINEER activities.Unfortunately the Data Engineer was not hired and they asked me to take over and I don't know SAP BASIS. I've done the Get Data into the EMS training, but I don't know what the initial practical steps are to do to "Create sap connection in celonis ems".Does anyone have anything written from "Practical roadmap to "Create sap connection in celonis ems" to send and/or guide me?

I created action flow and now i am trying to add email module to celonis query Data module. I am unable to add email to email module as it is showing it is restricted by our company laptop, Is there any possibility or alternative to send mails.

Hi all, I am getting an error when I am extracting data in my training environment. I am attempting to extract a 200mb table from my Azure SQL database.  My data consumption is 1.74gb of 4gb. Data consumption levels had previously been exceeded on the 14/01/2023. I have attempted to upload even smaller tables and the same issue persists.Is there a quick solution to this.

In order to save APC/Space in celonis i am looking for any standard tables which can give list of columns and the size of the column by table and schema.  Also if there is a way to find out if it is used in any transformation that will be good to say it is not used anywhere and it can be dropped from the schema and table.

I have created a table within the Studio App. The table is loaded with Tasks(Created through skills) auto-assigned to Business users in Celonis. Now we would like to have a feature to select a record and click on the change assignee button, on this click we need to be presented with a list of users to whom we can reassign the record. We built an action flow to update the email but we are only able to build a text box to input email addresses, we would like to be presented with a list of users(emails) to whom the task can be reassigned. Please let us know how we can accomplish this.

... but if the total gets lost, the export doesn't make any sense anymore, because I would need to re-calculate it again outside Celonis. As the calculation is based on the combination of different attributes per month, I would need to export these attributes to Excel as well. My question is how to include the total of a Pivot table into an export to Excel? Regards & thanksTom

Community FAQ: How do I update my contact information? Answer:To update your contact information in Celopeers, please go through the following steps: 1. Click on your profile picture on the top right corner.2. From the dropdown, go to your Profile Page.3. Once there, click on the "Edit" button on the top. A prompt will appear that will allow you to change your name, title, and background information. Please leave a like if you found this helpful!

I've an issue renaming a column. When executing the code ALTER TABLE tablename RENAME COLUMN oldname TO newname; I get the error: Execution error: Incorrect syntax near 'RENAME' what is my mistake? The error appears whether i use quotes or not

Action Flows - Configure an advanced Action Flow Choose your journey 1 Configure alternative routes 2 Apply filters and conditions

Community FAQ: How do I update my password? Answer:To update your password, go through the following steps: 1. Click on your profile picture on the top right corner2. Go to My Settings from the dropdown.3. Click on the option "Change Password". A prompt will appear to provide the current password and to enter a new one twice. Please leave a like if this information was helpful!

CASE WHEN SUBSTRING ( "VBAP"."MATNR", 0, 2 ) = '60' then 'Yes' WHEN SUBSTRING ( "VBAP"."MATNR", 0, 2 ) = '64' then 'Yes' WHEN SUBSTRING ( "VBAP"."MATNR", 0, 6 ) = '647731' then 'Yes' WHEN SUBSTRING ( "VBAP"."MATNR", 0, 6 ) = '664402' then 'Yes' WHEN SUBSTRING ( "VBAP"."MATNR", 0, 6 ) = '664403' then 'Yes' WHEN SUBSTRING ( "VBAP"."MATNR", 0, 6 ) = '666161' then 'Yes' WHEN SUBSTRING ( "VBAP"."MATNR", 0, 6 ) = '666162' then 'Yes' WHEN SUBSTRING ( "VBAP"."MATNR", 0, 6 ) = '666931' then 'Yes' WHEN SUBSTRING ( "VBAP"."MATNR", 0, 6 ) = '666986' then 'Yes' WHEN SUBSTRING ( "VBAP"."MATNR", 0, 6 ) = '666987' then 'Yes' WHEN SUBSTRING ( "

This is a PQL question: - I have three THROUGHPUT calculations working (I think) - I now want to have a COUNT column next to each. But: I am counting ACTIVITIES not CASES. How can I count cases, not activities/tasks?

Hello everyone!I want to send an Action Flow weekly that displays the material numbers that qualify for an automatic ordering process (this process can be triggered by editing the material master data). Since employees might choose not to edit the master data due to various reasons, the one material number for example will show up every week in the CSV that is sent via the AF. It could be possible that this repetitive sending of material numbers that should not be automatically ordered might negatively affect the acceptance of the AF. Here's my idea: does somebody have an idea how to add a timestamp of the initial sendout of the data rows in the CSV file? So, for example, if one material number was already sent out via the AF on the 1st of January, in the next runs of the Action Flow the 1st of January will be visible in an extra column, so employees could filter it easily to the current date.  Thank you so much! BRJulia Bauer

Hi Folks, I have a use case where it would be easiest solution to use COUNT Statement within the FILTER? However it is not possible. Do you have some tips for me? Thanks. B.

Hello Community, I've created an Action Flow in Celonis which contains an UI Path Component which Adds an Item to a Queue. WHen trying to test if I can actually add an Item to a test Queue I get the error "RuntimeError [400] An organization unit is required for this action."The user I'm using has all the necessary roles and permissions to edit a queue.Where can I define the Organization Unit Id?  Also, I tried using the "Make an API Call" with the Method Post and the URL "odata/Queues/UiPathODataSvc.AddQueueItem" but it gets the same error.  I am really thankful for your help!

The load failed: Load failed. Error Message: Table "XYZ" has 7,145,120,256 rows. The current limit is 5,000,000,000 rows. 

Hi All,We are trying to implement the machine learning model Linear Regression in our ML workbench, Can anyone suggest us in what all parts of celonis will it be useful or a business use case were we can implement it successfully.