General Product Q&A

Hi all, i am trying to build a table and profile view that is similar to the ones that are shown in the celonis demos (table from celonis demo)(profile view from celonis demo) What I am trying to show is some root causes for the bottlenecks in the process and when user clicks on the category, a detailed analysis will be displayed  But im still struggling with the first step which is how do i get to display those bottlenecks in the table, do i need to create a new table just to store those 'inefficiencies'?  Thanks for your help in advance!

Hi, Can anyone help me with the pql code to BIND to connect the Eventime of the creation of a purchase order and the release date of a requisiton? I don´t get the logic of BIND yet

Hello everyone, I'm intending to send out data to stakeholders (numerous documents to a stakeholder - n:1 relation). I'm using the query module, csv module and the microsoft outlook module to implement it like this. Therefore, the documents will be aggregated on the basis of a stakeholder - this file will be sent out. However, per document, internally, there could be different employees assigned/responsible for those documents. Is it possible to put them into the CC of the mail (sending out to one stakeholder but numerous internal employees that should be notified - 1:n)?  Thank you so much! Best regardsJulia Bauer

I tried this system. The first module gets all the data from the table to be checked, stores it in an array and then uses the if operator with the contains function to verify the data (CASE_ID) doesn't exist in the array, but this system doesn't work. I end up with duplicates every time because the if function always returns 0.

is not working for me, I'm not sure why? Do I have to keep in mind which using it or are there any conditions to use it?

may I know what is the definition of case selected on top left of the analysis and how can it be determined?

Hello everyone,  I am using Throughput time search to get the time between 2 activities excluding weekend days and I got the values. I wanted to verify this, so I calculated these data through an OLAP table and the data are the same for each individual case.  The problem is that the average number for a set of data is different.  I chose 4 cases in the OLAP table together and I noticed that the graph selected 6 cases or more and that is why the graph gives different total avg.  Can someone advise about the possible cause here so I can deepened on the graph since it is much easier and faster in the analysis Thanks    

Hi, I would like to set up a connection with an Azure data lake consisting of same parquet files. Does anyone know which data connection to make and with which settings?

Hi, my one data model is failing with this error: The Data Model Load experienced an issue loading to the PQL Engine. Celonis Support ID: b9be2416-8fc9-4d33-a121-0e8fa013da32 Is there a problem in Celonis or in my data model?

I am curious as to what types of organizations use Celonis and what IT support you have in place to be able to get clean data. I took a course as a student, but there is no way my organization could ever support this software and we are fortune 500.

Do the application keys for Outlook have a limit of emails they can send out? If not, what else can be the reason for this error: [429] Application is over its MailboxConcurrency limit?

In PQL, how do you concatenate a single quotation in a string? I am trying to generate a column of SQL input, e.g., value=to_date('date_value' , 'MM/DD/YYYY'). I need to concat a single quote on the front/back of the date_value.

Hi Everyone - We normally use LEANX to help us navigate the SAP tables with their attributes. Is there similar websites / information tables for Syspro and Infor that we can use to help us navigate through Syspro and Infor tables easier.

How to push CSV files into Celonis from Automation Anywhere, where to find the JOB ID?

I am trying to upload my excel file with date and time to run the event log / process mining. The date and time format in the excel file is yyyy-mm-dd hh:mm:ss but Celonis does not recognise this and is calling it out as the wrong data format type?

Hi Community, I am working on augmented attribute in new Studio experience. There is a requirement that business wants to track the user who made a change to the augmented attribute. As each augmented attribute has it's own table in the data model, I am using the Changed By attribute in the view but it shows some alphanumeric value (some coded output and not an existing user).  I tried adding additional attribute with the name USER_EMAIL in augmented table where it uses USER_NAME() as PQL formula. It does show correct user email in preview of record in KM but when I try adding same column in view it throws error "PQL Error - A PQL error is preventing this query from executing.COLUMN_REFERENCE: Column with name ["user_email"] cannot be found on table [<data model table>_AUG_<Augmented Attribute Name>]." Is there a way to get correct username from augmented table into the view?Any help would be appreciated.  My BestHamood 

Ex, In try celonis , 'IT Service Mgmt Ticketing (EN)' Demo is there. I would like to recreate this in my own Celonis environment / Analysis and gets my hands dirty. where do I get the same data used for this ITSM ?

Hey, is it possible to have two date picker on one view. One date picker is supporting one table and the other date picker the second table? I want to compare different times with each other to see the difference... Maybe you can help me

The error message states: "Data Export not enabled or missing permissions. Please check permissions or contact Celonis customer support."As an admin, I have verified that all permissions are correctly set. I'm not sure how to proceed from here. Has anyone encountered a similar issue or can provide some guidance on resolving this error? Any help would be greatly appreciated.Thank you!the error output : ---------------------------------------------------------------------------PyCelonisPermissionError Traceback (most recent call last)File ~/.local/lib/python3.8/site-packages/pycelonis/ems/data_integration/data_model.py:430, in DataModel.create_data_export(self, query, export_type, query_environment) 429 try:--> 430 data_export_transport = IntegrationService.post_api_v1_compute_data_model_id_export_query( 431 self.client, self.id, data_export_request 432 ) 433 except PyCelonisPermissionError as e: File ~/.local/lib/python3.8/si

Hi, when I tried to use variable in views, and it turned out with error "Runtime variable Error. The variable Duplicate key detected: <objname>. Please make sure that this variable is defined." However, my view turns out to be blank for all the components. Even in the Edit mode, unable to launch the PQL editor again. Can anyone please advise what can be done to fix this? Thanks.

Hi Celopeers, How to pair activities..? I have activities like A, B, C, D & E and I have Process flow for Case_ID 1 as ABCDBCE and 2 as ACD. I want to pair activities(C to D or C to E) case_ID wise. The output should will be 2(CD,CE) and 1(CD).

We have a global date filter for filtering out dates. Now we want to create case explorer that should have the global filter on. If the global filter is on it dont show all the events that is not in the date filter. any ideas how I can exclude the global filter for 1 view  

Hi all,  In one of our Studio Views, some components are not loading. We see the error message: 'The component contains a large amount of data. Loading may cause the browser to crash'. It is just a KPI-bar component that worked properly before, but after we did some additional checks in between to set the scope of the cases correctly, it is not loading anymore.  My question is, what are the limits before such error messages pops up, or are there any best practices to solve this easily (for instance, a max number of nested KPIs or max number of rows?). This would help us in solving the issue.  Best regards,Jan-peter  

I'm using a dimension which is based on KPI which contains different tables IDs (e.g: matnr from marc, ebeln from ekpo...) I´m trying to use this dimension whit a KPI (inventory on hand). This KPI is formed the following way: COALESCE(  PU_LAST(    "MARC"    , "STOCK_HISTORY"."VALU_LBKUM_CON"    , ORDER BY "STOCK_HISTORY"."EVENTTIME" ASC  ) -- Ascending order is considered. Hence the result is the last eventtime (and therefore most recent) in the table per Material || Plant.  ,0.0).It is giving me a problem of common table, but I thought that by stablising MARC as the common table with pu_last it would work, as it is working with other KPIs made the same way.Hope somebody can help me here, thanks