Product Q&A

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

Hello everyone, Unfortunately I have a field that says something like: “A|B” or also “A|B|C” or "B|C". I don't know in advance how many different combinations there are, but I have predefined categories. Now I want to create a diagram in which I want to display the frequency of the individual elements. If I do something like: Casewhen Table1.Column Like '%A%' then 'A'when Table1.Column Like '%B%' then 'B' etc.end Then it aborts after the first occurrence and does not count the other elements. But I would like to have them all counted in each associated “pot”. Several case when statements in a row do not work, even union does not work in PQL as far as I know. With STRING_SPLIT I can cut after the “|”, but I don't know how I can then aggregate the individual occurrences again. I would also be interested to know how I can count the number of occurrences of “|” in a string Does anyone have an idea? Thank you!  

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, I want to use the button components to view KPI lists in Number / Percentage in the New View. For example, clicking button 1 will display KPIs in number and clicking button 2 will display KPIs in percentage. I know I can use enhanced variable but I'm not sure how to link them together. Any helps would be helpful!

Hello Celopeers, whats the best way to handle NULL results in PU-Functions when I need 0 if no PU results are available? Here a example how I do it today: CASE WHEN ISNULL(PU_SUM(VBAK, VBAP.KWMENG)) = 1  THEN 0 ELSE PU_SUM(VBAK, VBAP.KWMENG) END Is there a way to make it better? BR, Thomas   

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

I wanted to know a best way to extract a table from a data pool directly, I am aware of the way of extracting it from data model but rather than that I would prefer extracting it directly from the data pool.

... the person responsible does anyone know how to solve this?

I am doing conformance analysis and i want to add some process rules to be considered in the analysis. For example: If the PO is of type X, then it does not need a PR. Other PO types need a PRAnother example: for all POs in company code XXX, the activity 'Receive Order Confirmation' is not required. In the conformance sheet we can only add KPIs and add violations to allow list, but there is no option to customize these violations to focus on certain cases, or add other process rules to the analysis. I'd appreciate it if there is any way to come over this! Thanks,Nourhan

I'm dealing with an issue in Action Flow. I have a text cell within an xlsx file that needs to be parsed using regex, and this data needs to be saved into a new table. I can handle this initial part using the text parser, iterator, and array aggregator, but it results in the data being separated into operations. I have around 5k records to process and iterate through, which ends up generating more than 10k operations. What I want to do is aggregate all of these into a single file, thus avoiding the need to make 10 thousand HTTP requests. Does anyone know if this is possible?   

Hi all, I am new to Celonis and I am trying to upload the data model using excel / csv, however the time value looks different when i upload it to Celonis. Would you please help to see how can i show exactly the same time on Celonis? Thanks in advance! Time value in ExcelCelonis

Hi all! First time here, but god a question. I am running a python script (pycelonis 1.7.6) that needs to push data into a table. Everything work fine unless the data push:  datamodel.pool.create_table(df_or_path = res,table_name = 'TABLE_NAME',if_exists = 'drop',column_config=column_config)  which returns: [2024-07-23 16:26:09] INFO: Data push job status: QUEUED...[2024-07-23 16:26:14] INFO: Data push job status: QUEUED...[2024-07-23 16:26:19] INFO: Data push job status: QUEUED...[2024-07-23 16:26:25] INFO: Data push job status: QUEUED...[2024-07-23 16:26:30] INFO: Data push job status: QUEUED...[2024-07-23 16:26:35] INFO: Data push job status: QUEUED...[2024-07-23 16:26:41] INFO: Data push job status: QUEUED...[2024-07-23 16:26:46] INFO: Data push job status: QUEUED...[2024-07-23 16:26:51] INFO: Data push job status: QUEUED...[2024-07-23 16:26:57] INFO: Data push job status: QUEUED... Same functionality on another table worked flawlessly, for this specific one it queu

Hi all, I was trying to export OLAP table data to excel but couldnt find the export button, where can I enable this? Thanks!

Let's say I have two tables:  - TABLE A: User ID, many other cols. [PK is User ID] - TABLE B: User ID, many other cols. [Many lines per User ID] Is there any way I can go through each User ID in TABLE A and do in the SQL transformation something such as: Declare TABLE C for each User ID in TABLE AAppend TABLE A.User ID, TABLE A.Name in TABLE C Select * from TABLE B where TABLE B.User Id = TABLE A.User IdAppend TABLE B.User ID, TABLE B.Other Field in TABLE C The idea would be to create a table in which you can find each line in TABLE A followed by every line for that same ID in TABLE B. Sorry for the poor SQL terminology, as I am not very used to it. Thank you so much in advance.

In my studio settings and/or package settings I am missing themes creation option. How can I configure a theme/colour/logo template -> https://docs.celonis.com/en/2442167.html

Basically, delta load captures when there is any change, update, insert happens based on the Change date like CPUDT, UDATE. But when we have the ERDAT as delta filter it will just capture the new record but what will happen to the Change ? Does any one tried this or come across this senario?