Product Q&A

I want to run a Python script based on inputs from some Celonis data fields. And the output from Python script should again be included in the OLAP table built in Celonis. I have tried to see the Celonis academy resources and celonis documents already, however not able to understand how it should be integrated. (excuse the functional language to explain my query) 

So I basically need the maximum of: PU_COUNT ( DOMAIN_TABLE ( "CEL_ACTIVITIES_SF"."CASE_ID","CEL_ACTIVITIES_SF"."USER_ID"), FILTER_TO_NULL ( "CEL_ACTIVITIES_SF"."USER_ID" )) per case 

Do you know any solution to this problem?  Thank you in advance!

When one create a flag but wants to use variables in the flag PQL, is it possible to use variables? I get errors when using variables and have to convert the variables to KPI's before it works. Is that the correct approach?

My clients have recently requested i download the list of Violations arising from conformance analysis into a spreadsheet so they could provide input as to the priority of each item. Is there a way to do this

How can I effectively utilize Conformance Checker in Celonis to model processes with high variability? Hello, I am dealing with a highly complex process that presents a significant number of variants. The only data source available to me for understanding this process is an event log. This log consists of various activities that represent different actions within my process. However, these activities do not perfectly capture the underlying operations. For instance, one activity might represent multiple actions, or an activity with the same name might represent slightly different actions at different stages of the process. Unfortunately, it's the only data source I have for now. The event log reveals almost as many variances as there are cases, which complicates my analysis. My goal is to use a conformance checker to create a process model that accurately represents at least half of the cases in my data, with the aim of identifying and analyzing the remaining deviations. This analys

Hi all, I am working on a process that is not on SAP. But would still like to exclude public holidays. Is it possible to create my own TFACS table and pull it into Celonis? and if it is how should the formatting look?

How do we go about building a segregation of duties analysis in OCPM? It is more straight forward for me to think in terms of case-centric process, where at case level, we can check if there were any violations. Any help is greatly appreciated.

I’m a bit confused of when to use the ACTIVITY_TABLE() and other SAP tables when calculating the KPIs. So for example, when I want to calculate # of changes per PO item, is it correct when I use the ACTIVITY_TABLE() to count the change activities occurred or use the EKPO table and calculate the changes with indicator fields from the table. Same for other KPIs, this is just an example.  Becausesometimes I get different results (in calculating automation users/activitiesfor example) and I am not sure which is correct.

I have an aging bar chart in view which I want to see what aging is exceeding my position line limit.

I got the link to set up my Personal Training Environment but when I tried the first step: 'build analysing asset' with the guide and the software was running and cut off without doing anything.  Then I've tried to delete the account on the training environment and retried to create an environment. Then I got the notification I got already one with the link. I clicked it and got the following screen: Thank you in advance!

Hi Everyone, Want to check how do we extract the Log file for the loads we have extracted in data jobs. I have run a full load and I wanted to compare the number of rows extracted by table and time taken for each table between last load and latest load.

When I create a data exploration, it tells me that zero rows are found in my data model. However, my data model has over ten thousand rows. Has anyone else experienced this problem and knows how to fix it?

I have a table were I only want to extract last 20 days of data based on "Update" datetime column. As the parameter option has a fixed start time (default value), I am looking for an option to add a SQL in Filter Statement where it substract 20 days from current date. This is giving error "Error parsing filter:"SQL used in Filter Statement: ColumnName >= TIMESTAMPADD ('day', -20, CURRENT_TIMESTAMP AT TIME ZONE 'US/Eastern')As this is Full load extraction, I am not using "Enable Change Date Filter". I also tried the option of creating parameters and changing value in transformation but that too didn't work.Any help would be appreciated.

https://www.celonis.com/paf/">

I simply want a license for PAFnow Process mining visual - I added the app in Power BI desktop file but can't figure out how to licence it

Hola alguien de habla hispana en latinoamerica para hablar acerca de la herramienta en nuestro entorno?

Access the Order Management demo to answer this question. What statements are true for the second most common variant? A. Activity frequency shows that 404,562 cases are associated with this variant. B. Activity frequency shows that the activity Change

When I upload files to my data connections, my data pool still says that I don't have any data connections yet. How can I fix this?

Can anyone please explain what is Set Identifier? which is new option inside a data model

Here is my YAML codeid: input-box-1d9cff2d-89eb-4104-9954-e79ad9fb5b9atype: input-boxsettings:  type: number  onChange:    update:      variables:        - name: FTE_cost 

Hi everyone, I need an help: I want to indentify and calculate time between an activity 'A' and others that start with 'REC' (like image below) I'm able to identify the cases with PROCESS EQUALS: PROCESS EQUALS 'A' TO ANY TO LIKE 'REC%'but I can use the function LIKE in CALC_THROUGHPUT CALC_THROUGHPUT ( FIRST_OCCURRENCE ['A'] TO FIRST_OCCURRENCE [ 'REC%' ] , REMAP_TIMESTAMPS("Activity"."timestamp", DAYS))It gives me the warning "Target Activity "REC%" could not be found in the activity column and it doen't calculate the time.Another use I would like to make of it, is to use it inside match_process_regex, likeMATCH_PROCESS_REGEX("Activity"."activity", 'A'>> 'REC%')it gives me the same error of calc_throughput and it doesn't identify the right path. How can I solve? How can insert the LIKE function in other functions? Thanks

Hi All,Earlier I had asked a question regarding how we can save/extract a table in our EMS as a csv file in our machine learning work bench, seeing the reactions or the lack of replies I got for the topic I think it would be helpful if I explain the code that I used/found to save the file as csv in my ML workbench. from pycelonis import get_celonisimport pycelonis.pql as pqlfrom pycelonis.config import Config celonis = get_celonis()data_pool = celonis.data_integration.get_data_pools().find("Datapool name")data_model = data_pool.get_data_models().find("Datamodel name")Config.DEFAULT_DATA_MODEL = data_modeltables = data_model.get_tables()table_name = data_model.get_tables().find("Table to find out")table_columns = table_name.get_columns()df = pql.DataFrame(  {    "column1": table_columns.find("column name in the table which has to be extracted "),    "column2": table_columns.find(" column name for column 2 "),    &quot

I'm trying to add labels based on the 'EventDescription' column for task mining:However, this column doesn't appear in the dropdown menu of the 'Create Label' interface, which seems to limit the available columns for labeling: Does anyone know how to include this column or any similar unlisted columns in the labeling rules? Looking for any advice or workarounds. Thanks!

Hi Guys, I need some help, please! I need that KPI to not change with filter in my Dash APPs, for example:  KPI Global Cycle Time : 10 DAYS With filter of manager. KPI Global Cycle Time : 5 DAYS  I need that this KPI stay still. How can I make it happen?