Product Q&A

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.

Dear all, just out of curiosity. In the O2C Template data model the tables VBRP and LIPS are joined to the VBFA and then to VBAP. We are doing this in the transformation and join VBRK,LIPS directly to VBAP. image711316 16 KB What are the advantages of including VBFA in the process model? PQL Coding, Performance, Thanks & Br P.S.: Dont consider this question high priority

Is there a way to Export a Knowledge Model into a consumable and editable document?

Could you please explain what exactly is happening here. does that mean that for the mentioned tables complete data is not loaded?

Even after being added to a team, the dashboard created by my team is not getting updated on my profile.

Complete the statement. When creating a pie chart in Celonis, … A. ... at least two KPIs need to be selected. B. ... an endless amount of KPIs can be selected. C. ... only one KPI can be selected.

Hi, i want to make a button that connects dashbaord information (data got from KPIs) to an external URL , but i can only use variables. So, i want to know if is possible to use this data (KPIs) into my URL button.

Hello all,we are still using PyCelonis 1.7 and we figured out that since yesterday the response of the function "api_request" has been changed.Before we got a list / dict or string. Since yesterday we get a request.model.response object. Have you noticed that? Are you also having issues with your api_request calls? Our current workaround was to get the "text" of the response object. Like: resp.text instead of: resp

I'm working with views and I'd like to show a chart only when a runtime varible has specific value. How can I do that?

We are plotting Dpo vs payment date and have a requirement to display the data of the selected time period in the chart. But we are not able to do it. We did try using dropdowns but only selected date data is displayed and not the period between the days.

How can I copy bookmarks from one analysis to another? We keep around 200 bookmarks shared across multiple users. All of these should now be migrated into a different dashboard inside another package. Is there any official method for such task?

(Senior) IT Consultant Celonis Projects Inetum. Spain. Location: Spain - RemoteDescription: Process Mining Celonis Consultant.  You will work on various processes such as public administration procedures, banking processes, insurance processes, procurement processes... All certified candidates will be evaluated to fit any of the required positions based on their experience. Apply here https://www.linkedin.com/jobs/view/3803667401/   

Hi, Can you help us with a question, please? What standard does Celonis use for JSON calls via API? RAW or X-www-form-urlencoded? Could you cite examples of these configurations within Action Flows? Thanks

Can i create a Conformance Ratio KPI (like on the Conformance Overview) using the conformance query

Hi Everyone, I'm trying to create a table using ML workbench by using this code  pool = celonis.data_integration.get_data_pool(id_ = pool_id) pool.create_table( df = input_table,         table_name = table_name,         drop_if_exists = True,         force = True,        )While running this i'm getting PycelonisNotFoundError for my instance. Here is the attached screenshot for reference. 

 CASE WHEN (ROUND_DAY("PAYMENT_TABLE"."Payment registered date")) < PU_MAX(DOMAIN_TABLE("PAYMENT_TABLE"."CG Key"), "PAYMENT_TABLE"."Payment registered date", ROUND_DAY("PAYMENT_TABLE"."Payment registered date") IS NOT NULL)THEN ROUND_DAY("PAYMENT_TABLE"."Payment registered date") ELSE NULL END 

Hello, I have been facing some issues accessing the Asset Library. I fill in with my credentials but messages like this appear: "You do not have access to the Apex class named 'qsydFileExplorerController'." Can anyone tell me why and how to solve it? Thanks