Product Q&A

IN specfic analysis the activity selection is not working, the list of activities is blank. How can I enadble it?

We are trying to build a dashboard to calculate throughput time between two activities. Create SO Item with no block ( ')First Delivery Block (ZX) We are using the following PQL query is returning no values. Can you please guide us whether the pql query is correct? AVG (DAYS_BETWEEN( PU_FIRST(VBAP, _CEL_O2C_ACTIVITIES.EVENTTIME, _CEL_O2C_ACTIVITIES.ACTIVITY_EN = <%= start_activity_SO %> AND _CEL_O2C_ACTIVITIES.CHANGED_FROM = '), PU_LAST(VBAP, _CEL_O2C_ACTIVITIES.EVENTTIME, _CEL_O2C_ACTIVITIES.ACTIVITY_EN = <%= change_dev_block %> AND _CEL_O2C_ACTIVITIES.CHANGED_TO = ZG) ))

Hi, In the AP process, is it possible to do a search with all references that contained a space ? EX : DATA Reference number 12345 $5 1 2345 $10 23 451 $5 I would like to see only reference number with a space thanks in advance Thanks in advance. Audrey

Hi, a fairly basic question from a new user I expect! Im currently carrying out the Implementation Professional training. When I Execute an extraction it seems to stack a new data set on top of the first. My initial response was to make the Execution a Full Load rather than a Delta Load, but when I ran this, it ran for 2.5 hours without finishing and I had to close it down. Can anyone provide advice on next steps? Thanks! Dan

Hi, I am trying to show the number of cases devided by variants of process using following dimension and KPIs. Dimension DISTINCT (VARIANT("_CEL_MM_ACTIVITIES"."ACTIVITY_JA")) ACTIVITY_JA contains the name of activities KPIs COUNT_TABLE("_CEL_MM_ACTIVITIES_CASES") Only the Bar Chart is refused to show the result showing following error. OLAP and other types of graphics elements show successfully what I want. I believe the code is pretty simple, I cannot understand why the code does not work only in the Bar Chart. I have tried following things already, fyi; writing without DISTINCTwriting with SHORTENDcounting other things e.g. ACTIVITIES Please let me know should you require additional information concerning this issue. Best

Hello, I am quite new to Celonis, so perhaps this is a stupid question. I am investigating a process with a lot of different activities and a huge number of variants. To make some sense of it all, I am grouping a lot of the activities. However, whenever I close the analysis and reopen it later, the group definitions are gone and I have to redo all the work. Is there a way to save the activity groups? Thanks for the support!

Hello, I have a table to aggregated values that we are trying to bucket within a dropdown. Currently when we bucket the values it filters on the line item level, but we want to filter on the aggregated value level. When we try to use a sum within our case when statement we get an error Aggregation dimension sum cannot be used together with a dimension input {AC0AD37E-4292-4773-A85D-4272482940D6}.png990187 20.2 KB {637ABF08-9E0E-4217-80FE-44EDFEA9D10D}.png802297 38.1 KB

Dear all, I have connected two table via a key, example Table 1 T1.Banf T1.Pos T1.Wert 123 10 X 124 10 Y Table 2 T2.Banf T2.Pos T1.Wert 123 10 X 124 10 Y 1235 10 Key: Banf, Pos In Table 2 I show the values of Field Wert from Table 1. For Banf 123 and 124 it works as the key is working. For 1235 it does not work. The whole case is not visible. I want to show the case, just the value of T1.Wert should be empty or any text like no value. How ist that possible? With CASE WHEN ISNULL it did not work. Many thx and br Daniel

I am getting the error while creating the below KPI. Here KPI ABC_A/B/C is calculated KPI which uses SUM function. CASE WHEN KPI(ABC Categorization by Reporting Currency) = A THEN KPI(ABC_A) WHEN KPI(ABC Categorization by Reporting Currency) = B THEN KPI(ABC_B) WHEN KPI(ABC Categorization by Reporting Currency) = C THEN KPI(ABC_C) ELSE Vendor with no spend END

Dear process miners, I am playing with P2P process and I have PR item as case ID. When I am trying to create conformance ratio as a KPI in the transformation center, I am not sure whether I should BADAT field in the EBAN table or Eventtime field in the activity table. Does anyone know? Kind regards, Meyi

In this particular case I want to select one of the flags and the selection will filter the process explorer for some activities

Where can I find details about this, please?  Thanks,Maarten

Hey,I want to access some system parameters like logged in users language and last successful dataload. Is there any possibility to do that?Kind regardsAlex

Hi team, I am trying to do a usage-statistics datamodel in the front end using the Access_logging with python . I had got a folder of access_logs before i started developement. But now i need the updated versions of access logs for this usage statistics datamodel. Does someone know where this is stored or how we can access for a perticular server? Thanks in advance. image1037258 17.9 KB

Hello, I am trying to use the demo P2P data as a pandas dataframe throught the ML Workbench. Following the documentation : from pycelonis import get_celonis login = { celonis_url : url api_token : token } celonis = get_celonis(**login) out pycelonis: Login successful! Hello vasilis <pycelonis.api.IBC at 0x7f6cb9719340> celonis.workspaces out <Workspace, id 0036fb70-61e7-4e8e-92d3-4aeac9d563bd, name Purchase To Pay Demo Analysis> Then when i try to find the analysis i get " No result found for id : xxx" analysis = celonis.analyses.find(0036fb70-61e7-4e8e-92d3-4aeac9d563bd) Any hints how to get the OLAP table of the P2P demo data to a pandas dataframe?

Dear all, Is there any way to migrate a data model from Celonis 4 to IBC using pycelonis? Otherwise is there any method to convert a data model object to data frame to use the function push_table? Thank you in advance

Hi all, I have a big problem. I have several CSV/xlsx-filles uploaded as tables to my data model. When I try to delete one table (e.g. in data model under Tables) I click in Edit and then Remove table. After done that the table is gone, but ca. 10-12 seconds later the table comes back, magic. If I click it several times, sometimes the table is gone then. At the buttom of the Tables list there are then created several new tables like that Auswahl_Delta.xlsx_0_0_0_2_0_1_0_0_0_0_0_2 What can I do to solve that? What is going wrong? Please help me. Thx and br Daniel

In our company we use Unit4 Business World for our transactional services (OtC, RtR, PtP). Is there any experience within the community with connecting real time to the Unit4 Business World database?

We want to make a connection to a Mendix platform which is hosted in the Mendix on AWS from our EMS. The Mendex documentation shows that the following endpoints are possible: Soap Rest Odata Is there anybody who has done this already?

On top of the analysis we see the total number of cases that went through P2P -> AP.When there are multiple case tables why tool is considering AP_BSEG case table for its total volume of cases? 

Hi, Everyone. Is there any way to give access to some users just for Team Settings and Configuration purposes? At my company the IT teams are responsible for making applications work but dont have access to the information in them. In fact different teams are responsible for different tasks like user configuration, permission configuration or server configuration. So, what would be nice was some kind of CONFIGURATION role where I, as ADMIN, could decide which users can do what, under the Team Settings menus (could be different permissions for each submenu), but nothing else. Thank you. Joaquim

Hi Task Mining Experts,  Question :During Testing Task Mining on Sandbox, I have added few users and facing data limitation. It is related to table rows count and the standard issue. Error Message :Data model load failed during table export: Data model tables: user_interaction_event_log contain more rows than the allowed maximum per table of 10000. Please reduce the number of rows. Any inputs to increase the rows count more than 10000 ? RegardsVivek M

Task Mining members, I am facing 2 issues for the past couple of days, would be helpful if you can suggest a solution. 1) While trying to create a quickstart project with template, after entering the name of task mining project, I get error that "Project cannot be created because it fails to connect servers" and I had been trying this for couple of days now facing the same issue. 2) Another issue is, I tried to create a project with blank template and completed tasks capture and screenshots caputre using task mining client, and it shows upload successful. But when I go to data model, it shows no data uploaded and then when I try to do force upload from cache or complete force upload, it gives errorMessage :Data model load failed during table export: Data model tables could not be exported: user_interaction_event_log It will be a great help if someone can provide a resolution to this issues.

Hi, Task mining experts I have tried to create a Task Mining project, and I had several issues:-"New Project with template" it is not working: see attached screenshot-When I create a "New Blank Project", after following the instructions to download and setup the "Task Mining client" using the "Configuration" utility, everything seems to be ok, but the client seems to fail when uploadind data to the server, because I can't see no data non analysis its automatically created. I have checked in my PC that the screenshots and parquet file are created. I have even checked using different PCs as clients, as you can see in the attached "Users and Invite" screenshot. The client without errors seems not to be able to upload data...and even worse, Im not able to see the errors reported by the other client "oscar.vinan".-The celonis snap server seems not to detect the chrome plugin I have installed. Could you so kindly please help or

Is there any system tables in Celonis we can check, for example, in Oracle, we have all_objects, user_tables such kind of tables we can have an overview understanding for one DB