Product Q&A

I saw there is not a option for that, so I am trying make one. I want a chart with the most common variant but i don't know how transform the list of variants in a list with the most common variant.  I was trying to filter the variants making this KPI that permit "filter" with a second KPI .CASE WHEN COUNT(VARIANT ("BD_ACTIVITIES"."QUEUE"))> 186 THEN 1 ELSE 0 ENDThe secon KPI:Case WHEN KPI("variant_most_common") = 1 THEN KPI("PROCESS_VARIANTS__BD_ACTIVITIES__QUEUE") ELSE 'OTHER' ENDBut it gives me this error : The aggregation function COUNT cannot be used together with a dimension function input. Please check that there are no aggregations and dimensions used together as function inputs.Right now i don't have more ideas to can continue. I dont know if someone could help me.  

Is there any workaround to assign a default value for package runtime variables?

I want to check if the delivery date is less or equal to today's date + 42 days - WHEN TO_DATE("EKES"."EINDT", FORMAT ('%d-%m-%Y))

Hi Community, I want to visualize the amount of handover moments within a case and also calculate an average for all cases. We have multiple tables but the most relevant are of course the case table (incl. Case_Key, Case_ID) and the activity table (activities, Case_Key, Case_ID, USER_ID). The USER_ID contains the relevant info I want to use for defining the handovers but I can't seem to pull it off. Any tips?

Is it suggested to make a backup workbench or a new workbench ? If our current workbench is corrupted.

In an action flow, is there a way to merge PDF's created with the "Create PDF Report" app? I need to create PDF's from different Analyses and send an email as a combined file.

For the case for parallel processes (the same data is spread across multiple connections).  For CCPM, you would write a Data Job for each source system and then merge all case, activity, and data tables. Would you simply create multiple transformation scripts for each Object (one script per source system)?  Thanks

I set up a signal in Action Engine, but I receive only a maili with link to the Signal Lists, and I want to have a table with results straight in the email, without the need for cliking the link. Where I can set it up? Please help me, if somebody knows?

Please clarify why column ERDAT is not included in standard ABAP script but it is selected in standard transport script.  1)     Add Activity: Record Goods Issue-- ERROR: Column VBFA_GI.ERDAT does not exist.  CAST("VBFA_GI"."ERDAT" AS DATE) + CAST("VBFA_GI"."ERZET" AS TIME) AS "EVENTTIME"                                  INSERT INTO "_CEL_AR_VBFA_ACTIVITIES FROM VBAK, VBFA, LIPS, LIKP, VBFA, VBFA, VBRP, VBRK, AR_BKPF_BSEG, USR02, MATDOC Table Name(VBFA): Sales Document FlowERDAT: Date on Which Record Was Created              ERZET: Entry time

in Case Explorer the details for column "Created By" is displaying username, but I want to display it as this case is an automated but not by user. How should I change the way it display? Appreciate any guidance.

Hi expert, I have a question regarding Delta loads. I've been using a data connection from AWS RedShift to Celonis. Before performing both the full loads and delta loads, I copy the target table, rename, and re-tied to perform Full loads and Delta loads. The full load consistently succeeds, but the delta load encounters issues. Here's the error message for the a_size_result table:Datatype of the column size_l changed from FLOAT to STRING.Table won't be delta loaded. Please perform a full load instead.When I reviewed the delta load log, I noticed that there was a change in the metadata for the 'ds_if_scm$_CELONIS_a_size_result' table.After full loads the data, I checked the data type in RedShift (String) and the Celonis Data Pool (Varchar). Could an expert please explain why this error occurs during delta loads? Thanks,

I push data in celonis using data push api (python methods), but column width of some of the is so high that it is showing entire content . is there any way to increase the column with from 80 to 240 in data push api methods

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