Skip to main content

Product Q&A

Ask questions and get answers about Celonis products from experts and peers.

4409 Topics
emiel.van.n14
Level 3
emiel.van.n14Level 3
asked in General Product Q&A
Calculate the amount of handover moments within a case and also calculate an average for all cases.

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?

30
emiel.van.n14
Level 3
A
Level 4
akshay.haridLevel 4
asked in AI
Is it suggested to make a backup workbench or a new workbench ? If our current workbench is corrupted.

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

60
B
Celonaut
C
Level 2
christian.ocampLevel 2
asked in General Product Q&A
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.

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.

120
C
Level 2
julia.bauer
Level 5
julia.bauerLevel 5
asked in General Product Q&A
Maximum skill status poll limit exceeded. - What does this error message mean? I use the "Execute Process Automation Skill" to writeback the output of the action flow in a separate table (for tracking purposes).Thank you!BR

110
mateusz.dudek14
Level 7
S
Level 1
suhail.mallLevel 1
asked in Process Intelligence Graph (PI Graph)
In OCPM, how do you populate Objects with data from multiple source systems?

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

580
R
Celonaut
K
Level 1
krystyna.nygaLevel 1
asked in Process Improvement
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

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?

00
mateusz.dudek14
Level 7
B
Level 3
bhupendra.singh.thakuLevel 3
asked in General Product Q&A
Team,I used ABAP script to extract data from SAP s4/HANA system and extracted data.While execution of the transformation script: Add Activity: Record Goods IssueERROR: Column VBFA_GI.ERDAT does not exit.

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

270
B
Level 3
junwei.chai
Level 3
junwei.chaiLevel 3
asked in General Product Q&A
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.

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.

00
V
Celonaut
ミ
Level 1
ミントアン.ファムLevel 1
asked in General Product Q&A
Full loads performed successfully but Delta loads failed?

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,

170
V
Celonaut
S
Level 3
sudhanshu.kumar15Level 3
asked in Data Ingestion & Infrastructure
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

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

10
mateusz.dudek14
Level 7
A
Level 4
akshay.haridLevel 4
asked in General Product Q&A
Can anyone suggest the best way to use the full capabilities of the Machine Learning workbench

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

70
A
Level 4
C
Level 1
chetan.sakhaLevel 1
asked in General Product Q&A
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

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

20
mateusz.dudek14
Level 7
frederick.coutr12
Level 3
frederick.coutr12Level 3
asked in General Product Q&A
How to do reverse engineering o na customer DB to understand where the data is ?

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

10
mateusz.dudek14
Level 7
A
Level 1
artur.krask12Level 1
asked in Data Ingestion & Infrastructure
Is it possible to have a timestamp based process model? By this I mean seeing process steps in time as they happened in reality and were recorded in eventlog.

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.   

10
marcin.konop13
Level 3
J
Level 2
jose.carlos.alfon12Level 2
asked in Process Improvement
I have an Augmented attribute created and in there I update the execution date of a specific action flow. My question is, does this value "Execution date augmented attribute" kept in the Knowledge model despite data loads ?

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.

40
J
Level 2
P
Level 4
preethi.p13Level 4
asked in General Product Q&A
Can we add data labels to waterfall chart?

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? 

90
P
Level 4
A
Level 2
akash.suhag11Level 2
asked in General Product Q&A
Can we compare dates in action flow? If yes, how?

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

20
K
Level 1
mallik.koruk11
Level 3
mallik.koruk11Level 3
asked in General Product Q&A
PQL logic to show Second Highest Vendor Name based on the sorting of Amount in a single KPI?

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.

20
G
Level 8
M
Level 2
miguel.moraLevel 2
asked in General Product Q&A
Can I search values for KPIs in a table?

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

10
G
Level 8
J
Level 4
jumbo.szkLevel 4
asked in General Product Q&A
Can we show next 12 month in my bar graph?

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?

00
K
Level 1
.
Level 1
.14626201Level 1
asked in General Product Q&A
Where can I find all the reading material (ppts, pdfs) and templates provided by Celonis ?

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

50
M
Level 1
C
Level 3
conny.brintLevel 3
asked in AI
PQL query fail

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

100
C
Level 3
R
Level 2
rosen.spartLevel 2
asked in General Product Q&A
SCIM connection to AD not working properly.

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?

30
L
Level 1
enrique.sanch13
Level 3
enrique.sanch13Level 3
asked in Data Ingestion & Infrastructure
How can you pass the proxy configuration to a dockerized extractor?

 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. 

20
R
Celonaut
A
Level 2
akash.suhag11Level 2
asked in General Product Q&A
How to schedule an action flow to trigger on a particular day?we are not using knowledge model.

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

460
A
Level 2

Badge Winners

VIEW ALL
Community Code of Conduct