Product Q&A

I see that there can be more than one activity table in a data modelAre there any examples on how to use this feature and the impact when creating variant components or process explorer in the analyses?I have a need for more than one activity table.Just pointing me toward the right document (detailed) or training module is enough for me to understand when and how to use that. Thanks

Access the Order Management demo to answer this question. How many cases are covered by the five most common variants. A. 734,890 B. 988,000 C. 404,562

I need to split the column by a separator in to multiple columns and then unpivot them to rows.

How to upload files in SFTP bucket created during Storage Manager Set up?

One of my project is having CRM data connection and client migrating the source, they are going to store the data in CDP Cloud.I couldn't found anything related to CDP in Celonis documentation.Is there any Prebuilt apps available in Celonis, if not what to do? please help.

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

Hey Celopeers, I want to create a Table within a View wihich contains 4 columns. One Column is the Dimension Column (Gives 15 Rows). In one column the numer of invoices for the current month are counted. In the other column the number of invoices from the previous month and in the last column the number of invoices for the month before last.  The user want to have the coulmn names in the format "YYYY/MM" and the column names should be dynamic, so that in the new month the column names are updated automatically. We are using the Knowledge Model - View Technology and no analysis. I also thought of using a chart diagramm, but the users require a table. I tried some things, but nothing worked. So if somebody knows about how to create dynamic columns I would be very thankful for your help :D  

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...