Skip to main content

Product Q&A

Ask questions and get answers about Celonis products from experts and peers.

4436 Topics
M
Level 1
muhammad.kashi14Level 1
posted in General Product Q&A
Community FAQ: How do I update my password?

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!

00
M
Level 1
J
Level 4
joyce.cardo12Level 4
asked in General Product Q&A
Hi everyone! I am trying to create a case when where it will say 'Yes' or 'No' depending on the conditions. But it´s not taking any actions, not sure why..

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 ( "

02
janpeter.van.d
Level 8
karl.guent
Level 4
karl.guentLevel 4
asked in General Product Q&A
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?

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?

1815
Sverre Klein
Level 6
julia.bauer
Level 5
julia.bauerLevel 5
asked in General Product Q&A
Adding a timestamp to data rows in a CSV file that is sent out via an Action Flow

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

113
julia.bauer
Level 5
bunyod.sap
Level 4
bunyod.sapLevel 4
asked in General Product Q&A
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.

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.

124
bunyod.sap
Level 4
B
Level 1
bernardo.gomesLevel 1
asked in General Product Q&A
UI Path Action Flow Add an Item to a Queue with error "RuntimeError [400] An organization unit is required for this action."

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!

71
Sverre Klein
Level 6
richa.patel
Level 2
richa.patelLevel 2
asked in General Product Q&A
While loading the data model, I am getting the below error message. Could you help me with increasing the limit or any other alternative?

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

152
mukesh.gupta11
Level 4
A
Level 4
akshay.haridLevel 4
posted in General Product Q&A
Hi All,

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.

101
mukesh.gupta11
Level 4
S
Level 3
stefan.grossLevel 3
asked in Data Ingestion & Infrastructure
O2C Process Data Model Setup

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

742
E
Level 2
S
Level 3
sam.weyel11Level 3
asked in Process Analysis
Is there a way to Export a Knowledge Model into a consumable and editable document?

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

1411
floris.kwaks
Level 2
richa.patel
Level 2
richa.patelLevel 2
asked in General Product Q&A
I loaded a data model and it got successfully loaded as well with warning : "The join between table "ABC" and table "XYZ" did not find any matching rows. Please check your join definition and your data".

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

192
dennis.pflug
Level 6
A
Level 1
ankita.jayanLevel 1
asked in General Product Q&A
Even after being added to a team, the dashboard created by my team is not getting updated on my profile.

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

12
dennis.pflug
Level 6
S
Level 1
sanskar.betag12Level 1
asked in General Product Q&A
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.

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.

151
D
Level 1
K
Level 1
kirti.shriv11Level 1
asked in General Product Q&A
During Process Mining fundamentals module "Use selection view" I am not getting complete status after submission of review.

23
Sverre Klein
Level 6
M
Level 1
matias.pinto12Level 1
asked in General Product Q&A
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.

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.

31
andré.tafur
Level 4
pablo.messa11
Level 3
pablo.messa11Level 3
asked in AI
Return value of api_request changed?

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

142
pablo.messa11
Level 3
A
Level 2
alice.sansoLevel 2
asked in Data Ingestion & Infrastructure
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?

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?

64
A
Level 2
H
Level 1
harshitha.jkLevel 1
asked in General Product Q&A
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

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.

11
H
Level 1
A
Level 1
adrian.eljas13Level 1
asked in General Product Q&A
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?

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?

41
Sverre Klein
Level 6
enrique.sanch13
Level 3
enrique.sanch13Level 3
posted in Data Ingestion & Infrastructure
www.linkedin.com

(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/   

00
enrique.sanch13
Level 3
K
Level 2
kleber.cazot12Level 2
asked in General Product Q&A
What standard does Celonis use for JSON calls via API?

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

31
H
Level 1
L
Level 3
louis.forst12Level 3
asked in General Product Q&A
Can i create a Conformance Ratio KPI (like on the Conformance Overview) using the conformance query

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

21
K
Level 1
kandi.naidu
Level 4
kandi.naiduLevel 4
asked in General Product Q&A
While searching data pool id in ML workbench i'm getting PyCelonisNotFoundError Object not found .

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. 

45
D
Level 4
V
Level 2
vaishnavi.rao11Level 2
asked in General Product Q&A
I am trying to obtain the second to last date in a column with dates. I am using the below PQL ; where should I indicate that it has to pull up 2nd to last date?

 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 

51
D
Level 4
C
Level 3
chiara.vozzeLevel 3
asked in General Product Q&A
Issues with Asset Libray

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

288
andré.tafur
Level 4

Badge Winners

  • Masterclass in Implementation
    WR_SNhas earned the badge Masterclass in Implementation
  • Masterclass in Implementation
    menka.krishhas earned the badge Masterclass in Implementation
  • Masterclass in Implementation
    Namit Singhhas earned the badge Masterclass in Implementation
  • Masterclass in Implementation
    suresh.jassahas earned the badge Masterclass in Implementation
  • First Post
    tfaruq Rotorkhas earned the badge First Post
VIEW ALL
Community Code of Conduct