Product Q&A

Can anyone suggest the best way to use the full capabilities of the Machine Learning workbench

Hi, I want build a POC of any process in Celonis EMS..But for that I will require dummy data. Anybody knows how should proceed ? or Can you please help me to get the dummy data.Thank you

I'm looking to understand how a customer DB contains the information required for Process Mining (case, activity, related tables) from a completely unknown system. We have access to a DBA who can provide information such as GraphML files but we do not have direct access to the DB to do reverse engineering. Is there a tool on the market that will allow us to recreate a data model from data extracted from the customer DB. We've tried spark and other tools but we really need one that can map tables and relationships (including foreign keys).Thank you

When I try to mine a process from an event log I see wrong activity in the beginning. And can't understand why is it there. As well, BPMN model is built incorrectly. I can modify it, but I don't see it in process or variant explorer in a modified way.  I use Python simulation to generate data. it simulates facility with several rooms where users can move and drink coffee. Coffee increases their heart rate. As well, the system starts displaying messages and offers users to drink water.  In the process model I get users have increased heart rate in the beginning and their moves between facilities are happening in one direction, while in reality they move randomly.  I try to understand what do I need to modify (Python code for data generation or something inside Celonis) in order to see the real model and a sphagetti diagram showing all possible users' movements and events.   

I use the attribute to control the action flow case id filtering so, in case the attribute is lost, the action flow will gather everything.

I’ve configured waterfall chart. Right now I can see the kpi values only when I hover over the bars. Is there a way I can show the KPI value on each bar? 

Can we compare dates in action flow? If yes, how?

I have to show top 3 vendors with pending balance in an email using Action flows. what PQL function can we use to sort top 3 vendors based on Amount column to apply same logic in Action flows? Basically, these values are same as if we create OLAP table and sort by Amount, but these has to build in a single KPI component as 3 KPIs.

I'm trying to add a filter to a table so I can do something similar to the search function for numeric dimensions (where I can select to filter greater than x). I haven't been able to code the filter. I want to be able to filter by Total or/and Total Canceladas >= x -NOM_SOLI: "CL_Auto_Autorizaciones"."NOM_SOLI" -Total: COUNT_TABLE("CL_Auto_Autorizaciones") -Total Canceladas: COUNT(DISTINCTCASE WHEN PROCESS EQUALS 'Cancelada' THEN "CL_Auto_Autorizaciones"."_CASE_KEY"ELSE NULLEND) -Porcentaje Canceladas: COUNT(DISTINCTCASE WHEN PROCESS EQUALS 'Cancelada' THEN "CL_Auto_Autorizaciones"."_CASE_KEY"ELSE NULLEND)/ COUNT_TABLE("CL_Auto_Autorizaciones") "CL_Auto_Autorizaciones" is the case table

Hi all, I would to show my 2 bar graph with the same time span, like next 12 month visible without moving scroll bar, even it doesn't have any data of a month. Where can I find the setting? or Can't I in celonis?

Where can I find all the reading material (ppts, pdfs) and templates provided by Celonis ?

Hello, I have the following problem when PQL query tables from my analysis (PyCelonis version: 2.5.0): After identifying the required space, package , analysis and sheet, I specify the required table:olap_table_HistoricPOs = published_sheet_OpenPR.components.find("#{Historic_POs}", search_attribute="title") ... and query the table:olap_query_HistoricPOs = olap_table_HistoricPOs.get_query()olap_query_HistoricPOs Some columns are read correctly:(name='_CASE_KEY', query='"freitextbestellung"."_CASE_KEY"')and others are not. These get a hash and a brace like this:(name='#{order_items.SUPPLIER_NR}', query='"order_items". "SUPPLIER_NR"') This incorrect naming is kept in the subsequently created dataframe:df_historic_POs = pql.DataFrame.from_pql(olap_query_HistoricPOs, data_model=data_model) and leads to an empty df in the further notebook:df_references = {}df_references['historic_POs']= df_his

Recently we decided to activate the SCIM functionality in Celonis so that user and groupsare provisioned automatically by the identity provider. Unfortunately it is not working and no connection to the Active Directory can be established and the functionality is not working. Are there any specific settings that need to be set in the Active Directory so that SCIM API can work as intendet?

 The Celonis documentation does not specify passing the proxy configuration to docker. I don't know if the way to pass it to docker is to add one more line-e PROXY_ENABLED=true \\ -e PROXY_HOST=<host>, etc. Or how it would be since it depends on how the Docker image has been mounted. 

How to schedule an action flow to trigger on a particular day? we are not using knowledge model.

Dear all, I would like to use Action flows to push an excel file (xslx) to Celonis using Action Flows.  Use Case: Excel file is received via email and up until now manualy uploaded to a data pool. I am successful in accessing this email, downloading the excel file.  I am following this tutorial to learn how to push a CSV file to a data pool. Create and Push CSV to Data Integration (celonis.com) However, it does not work for XSLX files for me. I changed the file type already to "XLSX" and "EXCEL". Error is: "something went wrong while handling the request. Please contact Celonis customer support. Celonis Support ID" I also tried to find a module that would help me translate an excel to CSV but could not found anything. Thank you,Gregor

Documentation of conditional filters Hi @mentor.vucit​ , I just came across your answer (link) and I am wondering where I can find the documentation of conditional filters? They seem very powerful but I can't find any of this in the celonis documentation. BR,Florian 

This is how is set in the documentation:  and this is how I set the module: 

Team, I am using Content CLI to Pull and Push assets between different EMS. Is there a way to overwrite only one asset when pushing to a different EMS? I can see there is an option to overwrite packages with "--overwrite", but we want to push only one asset multiple times. Best regards!

Hi, i want to create in Open Order View (Open Order Processing) a Dropdown List where i can select a ORDER_ITEM Record which sets the X-Axis on a Graph. My problem is that it doesnt accept the variable as an axis, but if i use the record itself it works

Hi Team,We are working on reviewing our landscape with respect to Celonis best practices.Currently we have multiple data pools and extracting data from multiple connections.In many cases we can have a situation where:1)Getting data from same connection but using extracted data for different data models.2)Getting data from different connections and combining extracted for single data models.3)Often times buiness requirement for same process may vary for different units and they would want to see different views / analysis / actions for them in those case how the data pool should be structured. Are already there best practices along these lines with pros and cons?

Dear Celopeers, We have an SAP On-Prem extractor which make RFC calls with multiple SAP systems within our organization. We want to now add a new connection/SAP System but the connection has to be SNC. We already have the instructions for setting up SNC, but the question is Is it possible to use the same extractor and configure so that only one system needs an SNC and others work without those server certificates? Or If we want to add a new connection/system with SNC setupeither we must have the server certificates imported for all the existing systems or we we should have a separate extractor with SNC?  How does this work? To clarify, only system 3 in the picture needs an SNC. 

In one system I have two processes with two number logics. First one is called S_ID and shows Process A ("From Receiving Technical data to releasing technical data for invoicing". 2nd one is called "L_ID" and shows process B "Creating data set to invoice sent"  If data has status 4 in the system, the data has been transformed from process a to process b and every s_id is combined with a L_id.  I checked with a table if ir possible to see status4, s_id and L-id in one table and cheked in the source system if the data is correct- it is.  In the Data model I created two activity tables and zwo cases tables, one with S_ID logic, the other one with L_id logic.  The last step should be to combine the data so the customer is able to see the whole process from receiveing the technical data to invoice sent.  I tried it with this script, and I know it is not correct yet:  case when"TableS_id"."STATUS"= 4then Bind("TableS_id", PU_first(&

Hi all, I'd like to calculate through put time of workday, I have a table that contains holiday. I found something workday setting but I'm not quite sure how that is work. If anybody know something like this, please give me advice. Thanks

I am trying to extract the date from a string. the date comes after '-'. The challenge is that there can be more than one instance of '- '.So, tried to find the '-'followed by a space and '/'after 3characterString sample: $$$$$ $$$$$$$: $$~$$$$ - $$$$ $$$$$$$$ $$$ $$$ ~$$$$ $$$$$$$$ $$/$$/$$$$ - 07/01/2022 $$$:$ $$$:$ $$$:$.$ ( i want to extract the date after the second '- ') Code I used:(code gives me error)CASE WHENMATCH_PROCESS_REGEX ( column, '.*- .{3,}/' )=1THEN TO_DATE(RTRIM(RIGHT(STRING_SPLIT (column, '- ' , 0),11)),FORMAT ( '%d/%m/%Y'))ELSE NULLEND Thanks In Advance