Product Q&A

How to uninstall Celonis agent without leaving data

We are trying to only display invoices that are currently in verification and then calculate how long its been in verification for, but we cant find a suitable function for it.  Any help would be greatly appreciated

Is ROUND_MONTH("PurchLines"."CREATEDON_MST") the norm to use when creating trend analysis (Chart)? I am getting unexpected results when I use that as a dimension when I am just trying to determine the number of Open PO's by month.

In the given data tables below -  I used the statement - 'PU_SUM ( DOMAIN_TABLE ( “Chapters”.” Title”, “Book_Author_Mapping”.” Book ID” ), “Chapters”.” Number of Pages” )' Here I have a couple of questions in understanding the functionality:- If the Domain Table is formed based on the specified column/tables - To which Specified Table will the Damon Table be linked to? - as both the tables 'Chapters and Book_Author_Mapping' have an N:1 relationship with other tables?Will the Domain table link to the 'specified tables - Chapters; Book_Author_Mapping' based on the Table we mention in the SourceTable?Column field of PU_X Functions -i.e. “Chapters”.” Number of Pages” in this case ?'  Thanks in Advance. Kind regardsAbhinav

Hi there,I would like to pull an OLAP table component out one analysis sheet into the ML bench If I try this way by ID it works:components = sheet.componentscomponent = components.find_by_id('Component_ID_Here') But I would like to import the table by name as the component ID might change.So I tried this but it does not work.:components = sheet.componentscomponent = components.find('Table_Title_Here') Hope you can give me a hint. Best,Conny

Why, in Industry Wheels Charts, some processes are in bold and others no? What does it mean? Thanks

Hello.I was wondering, is the ability to set alerts from SmartSensor no longer available?The official site has a screenshot of SmartSensor with the CreateAlert option, but the option does not exist on the actual EMS. https://docs.celonis.com/en/create-alerts.html

Hi All,I wanted to share an issue with you guys regarding the ML app we had in our server in which the app was automatically changing it's python package versions despite of whatever desired versions of python packages we install. Then we figured out that if the ML app had a file named virtual environments and in it's metadata if the versions are already set , no matter what ever desired versions of python packages we install it automatically changes it's version to the one mentioned in the metadata of that virtual environment. The reason for this is that the workbenches where virtual environments were used usually become corrupted and inaccessible. Files will not be recoverable if a workbench is corrupted.  The only way of resolving this issue is creating a new ML app and backing up the files in the current workbench (Excluding the virtual environments) and restoring them to a new workbench. This will ensure your data is protected from possible corruption. For more inf

How many cases are covered by the five most common variants.

FILTER ANALYSIS VIA ACTION ENGINE ACTION FILTER "BKPF"."BELNR"=${Document Number} ERROR:Operator requirements are not met. Comparison operator = (equal) does not support comparing column ["BKPF".BELNR"] of type [STRING] with constant of type [CONST_INT]

Hi all,  I'd like to find where can i add the subscription setting when I failed my data job.I haven't activate data job alerts setting but some of user getting the mail notification. (It might be user private setting but I cant find it.) Thx

We are working on a use case where we need to extract the data from an OLAP table and push it to another data pool. We are aware of the later part but need some inputs for the former one where we need to extract the OLAP table using action flows .

Does the free plan include Discreet Process Simulation (modeling) and the Machine Learning Workbench?

Is it possible to apply filter on an attribute of a record in viewsCurrently I am only able to apply filter on columns of data model 

Hi, In TryCelonis, I could see lot of Demos. But I would like to see the YAML code behind those dashboards. Please let me know how can i see them?

Is it possible to use the Conformance Checker on only a certain part of a process?

Help needed with a % connection path KPI I am trying to figure out how i can make a connection KPI which shows the path percentage of cases that passed through. now i want to see the path percentage flow from each individual Activity. exmaple: Start -->Activity A (branches pathways) ---55% for a path---> Activity B (branches Pathways) --23% for a path--> activity Z. so from each Acitivy i want to calculate how much of the (total) cases that landed there go a certain path % wise. Now i figured out by doing: COUNT (DISTINCT SOURCE ("Table"."colum")) / GLOBAL(COUNT (DISTINCT SOURCE ("Table"."colum"))) I can filter the path connections to % based on the Total amount of cases present in the dataset. This only shows me how cases % wise flow through the whole process. but not from an indivual activity.  In my mind somehow every Activity point needs to be seen as the "new" total 100% so a calculation can be made for the paths. but i

Hello guys, i would like to put a drop down in my reports with the opportunity for the users to switch between light and dark mode. How do I do that? Has someone practice in this topic? Maybe a pql code or something...

What functions can Celonis achieve

Hi, I would like to customise the colour and add icons to action buttons created with an action flow. For actions related to skills, this is possible, see screenshot attached.  There is a preview mode like with skills, but it doesn't allow you to customise. Using the syntax for skills action in YAML also doesn't work. Who knows how to do this? Thanks,Teun

i want change the dimension of olap table using dropdown in views, How to display name like display name in dropdown in views

hi all, now iI'm looking for text mining module if celonis has. Ｉknow pycelonis but it might take time to dev so please let me know if we have reusable one. just I'd like to do word occurence analysis. i don't need so complicated one.

Hi! can anyone please help me figure out the following PQL? I have cases that have a lot of the same activity.  Imagine the activity is "Walk The Dog" and there are activities with the following dates: 1/1/20231/8/20231/15/20231/25/2023 I would like a query that returns the largest number of days between consecutive events  So in this example: 1/1/2023->1/8/2023 = 7 days1/8/2023->1/15/2023 = 7 days1/15/2023-1/25/2023 = 10 days I would like the query to return '10'  I am having trouble with trying to connect the dots with the documentation on calc throughput. Not sure how to approach it. 

How can i apply component filter on table dimension in view, when dimension is changes using dropdown, and dimension data come from multiple table. like few dimension are coming from casetable, some from activitytable and some of them from other table