Skip to main content

Product Q&A

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

4438 Topics
H
Level 1
hayfa.robba11Level 1
asked in Process Analysis
Hi, The Process Explorer does not show cases that have no data in one event log. But the Case Explorer shows it.

We have a model with four event logs. If a case has activities in three event logs and no activities in one event log, it appears in the Case Explorer but not in the Process Explorer. What could be the reason for this and how can I fix the problem? Many thanks!  PS: This problem is only in the view, not in the analysis. 

01
I
Level 1
F
Level 3
federico.sparaLevel 3
asked in General Product Q&A
Extract day of the week or holiday from datetime

Hi all, I need to filter some instances occurred on sunday and on holiday. Is there a PQL function that can help me out?Something like this:CASE WHEN DAY_OF_THE_WEEK("EVENTTIME") = 'Sunday' or HOLIDAY("EVENTTIME") = 1 THEN "ID" ELSE NULL END Thanks! EDIT: Solved the day of the week part, still missing the holiday one

91
G
Level 8
G
Level 2
gaurav.singh13Level 2
asked in General Product Q&A
How to upload data(in csv format) to studio?

How to upload data(in csv format) to studio?

153
I
Level 2
F
Level 2
fabio.gioviLevel 2
asked in General Product Q&A
Hi, I'm new to Celonis. I would like to implement a SQL transformation to delete duplicate records from a table. The idea is to have the table name as the only input to the procedure. Any suggestions? Thanks.

I was thinking of reading all the fields of the table and then performing a group by. Is this the right way?

54
G
Level 8
P
Level 1
preetham.h.mLevel 1
asked in Data Ingestion & Infrastructure
How can I merge a component filter formula and a number KPI formula to create a new KPI formula

I need to count the number of invoices which follows a process flow 'Payment after Due date passed'.

11
R
Level 4
A
Level 2
anne.molleLevel 2
asked in General Product Q&A
I'm doing a date change analysis to understand how many days a sales order delivery date is changed up or out. I have the change from and change to dates. Anyone know of a way to incorporate the day of week? Ex, changed from monday to tuesday?

I'm doing a date change analysis to understand how many days a sales order delivery date is changed up or out. I have the change from and change to dates. Anyone know of a way to incorporate the day of week? Ex, changed from monday to tuesday?

02
A
Level 2
ravi.kumar23
Level 4
ravi.kumar23Level 4
posted in Process Analysis
docs.uipath.com

Usability of MarketPlace Connectors in "REALITY" Hi Team,I have started my market place journey by installing SAP "Order to Cash" Connector. Below was my experience :1)I tried to install the app in studio but it gave multiple errors for the Data Model.2)I looked at the data model and tried understanding it. -There are no documents to understand why that data model is build in the way it is.3)I looked at standard SAP tables and tried to understand it by looking into transformation.4)Transformation does have big quereis and most of the places there is no explanation of what does those quereis mean.5)I finally reached SAP functional consultant and technical resource to help me understand the quereies.6)Currently i am working with them and reverse engineering to understand what has been provided with connector.7)Parallely i raised a ticket to Celonis support for providing comprehensive documents but they responded they do not have comprehensive document but shared the b

107
ravi.kumar23
Level 4
andres.naran12
Level 4
andres.naran12Level 4
asked in General Product Q&A
Hi team! we downloaded the procurement starter kit and the P2P S4HANA Connector. There are some KPIs that request the TCURR, TCURF, and TCURX, but there is not any transformation for these tables inside connectorDo you know how to add those tables?

Hi team! we downloaded the procurement starter kit and the P2P S4HANA Connector. There are some KPIs that request the TCURR, TCURF, and TCURX, but there is not any transformation for these tables inside connector Do you know how to add those tables?

34
andres.naran12
Level 4
R
Level 3
ramanathan.iyerLevel 3
asked in General Product Q&A
Iam trying to find out or compare RC vs Delt job vs Full Load, when to use and why

Iam trying to find out or compare RC vs Delt job vs Full Load, when to use and why

02
R
Level 3
praveen.ojha12
Level 3
praveen.ojha12Level 3
asked in General Product Q&A
How many characters are supported for naming convention for any object in Studio?For example if I am naming a ID for a KPI, how long can I keep the name? Do we have a constraint in that?

How many characters are supported for naming convention for any object in Studio? For example if I am naming a ID for a KPI, how long can I keep the name? Do we have a constraint in that?

04
H
Level 1
D
Level 2
daniel.burroLevel 2
asked in Data Ingestion & Infrastructure
How can i remove '0' counts from calc rework?

I have the PQL query as follows:  it returns:   How can i amend my query to remove the '0' counts for processes that do not have any rework on them? Thanks

23
mukesh.gupta11
Level 4
J
Level 3
juan.carlos.peñafLevel 3
asked in General Product Q&A
What is the best way to have a good overview of:1) activity durations2) waiting times between durationsAs far as I understood, Celonis can show me the duration between activities (waiting time). What about the activity's duration itself?

What is the best way to have a good overview of: 1) activity durations 2) waiting times between durations As far as I understood, Celonis can show me the duration between activities (waiting time). What about the activity's duration itself?

35
G
Level 8
A
Level 3
alejandro.bayonLevel 3
asked in Data Ingestion & Infrastructure
From 1:N relationship tables, if the N part is missing for the parent, an OLAP table with both tables will not show any value unless we use a pull function. Is there a way to see these records with other type of aggregation that allows filter se

We have table A (case table) and table B connected to A as 1:N relationship, 1 A has N BsWe want to show in an OLAP table A and B, and we want to aggregate SUM(B) for each A, so we can use SUM or PU_SUM. We are using SUM because we want the result of SUM(B) to be affected by filter selections. If there is A with missing values at B side we would expect to see A and NULL at the B column However we won't see anything unless we apply PU_SUM(B), and as said above, PU_SUM doesn't support filter selections so it cannot be used for this use case.Is there another way to see the A values together with NULL values at B column?

245
R
Level 4
C
Level 2
cristiane.costaLevel 2
asked in General Product Q&A
Accounts Payable Case Study Training - Why do I keep getting this run time error?

Hello! I've been having trouble with my queries in the Accounts Payable Case Study Training. Specificaclly, in the section 'Transform - Add an Activity: Set or Remove Payment Block'. I've been able to insert all the other activities without any problems, but I'm stuck at this one. Here are the instructions:   Here is the codes I've tried at first: ```INSERT INTO _CEL_AP_ACTIVITIES( _CASE_KEY, _ACTIVITY_EN, _EVENTTIME, _SORTING)SELECT  BSEG.MANDT||BSEG.BUKRS||BSEG.BELNR||BSEG.GJAHR||BSEG.BUZEI AS _CASE_KEY  , CASE    WHEN CDPOS.VALUE_NEW IS NULL THEN 'Remove payment block'    WHEN CDPOS.VALUE_OLD IS NULL THEN 'Set payment block'  END AS _ACTIVITY_EN  , CAST(CDHDR.UDATE || CDHDR.UTIME AS TIMESTAMP) AS _EVENTTIME  , CASE    WHEN CDPOS.VALUE_OLD IS NULL THEN 20    WHEN CDPOS.VALUE_NEW IS NULL THEN 30  END AS _SORTINGFROM BSEG AS BSEGJOIN BKPF AS BKPF ON 1=1  AND BSEG.MANDT=BKPF.MANDT  AND BSEG.BUKRS=BKPF.BUKRS  AND BSEG.BELNR=BKPF.BELNR  AND BSEG.GJA

12
C
Level 2
pavan.bhara13
Level 3
pavan.bhara13Level 3
asked in General Product Q&A
Is there a way to select the scale to be picked in a chart in views?

so here if the count is just one then i just need to display 1 in the legend/axis. it should not show 200m, 300m.... etc. is there a way to achieve it?

62
abhishek.chatu14
Level 7
A
Level 3
aldona.potocLevel 3
asked in General Product Q&A
How to filter the newest cases on a component level?

I have calculated the date difference between last load ("Table1"."Column1") and today: DATEDIFF(dd, "Table1"."Column1", TODAY() ). I would like to apply a component filter to my OLAP table to see only the newest cases. I have tried with FILTER MIN(DATEDIFF(dd, "Table1"."Column1", TODAY() )); but no result. How should I reformulate my filter to get rid of the error I get?

26
A
Level 3
pavan.bhara13
Level 3
pavan.bhara13Level 3
asked in General Product Q&A
Is there a way to view the table structure in data integration? something like "Describe Table_Name" which returns the columns, data types details of the table passed.

Is there a way to view the table structure in data integration? something like "Describe Table_Name" which returns the columns, data types details of the table passed.

212
pavan.bhara13
Level 3
D
Level 2
daniel.burroLevel 2
asked in General Product Q&A
Single KPI - I want to count WIP cases that their latest event matches a specific activity

essentially i want to bucket cases based on where their latest event is.  what would be the best PQL clause to use in this instance?

01
abhishek.chatu14
Level 7
irfan.suria12
Level 4
irfan.suria12Level 4
asked in Data Ingestion & Infrastructure
Calculate AVG partitioned by week (WINDOW_AVG?)

Hi, I have the following use case and challenge: Use Case: Add a line as second KPI to an existing column diagram that shows the average of a KPI value for each labor week Dimension: ROUND_DAY("TABLE"."TIMESTAMP") KPI 1: COUNT("TABLE"."NUMBER" || "TABLE"."FIELD") - columns KPI 2: Show the average of KPI 1 from Monday - Friday for each week - line My attempt: WINDOW_AVG(COUNT("TABLE"."NUMBER" || "TABLE"."FIELD"), 0, 5, ORDER BY("TABLE"."TIMESTAMP"), PARTITION BY(ROUND_WEEK("TABLE"."TIMESTAMP"))) This does not work unfortunately as I can not use the COUNT within the WINDOW_AVG function. Does anyone know any alternatives?

125
irfan.suria12
Level 4
D
Level 2
d.dinesLevel 2
asked in General Product Q&A
For saving APC consumption used data, how we can delete the loaded data for certain data pool which contains several processes in it. I want to delete one process data in the data pool.

Assume the data pool contains of AP, AR and O2C three processes. I want to delete AP process data, for that I have added an activity in transformation where I have droped all the tables related to AP process data and I have executed that activity and data load has been done. But no change in studio part and APC Consumption also, data got not reduced. Is there any way to delete the data ?

287
D
Level 2
V
Level 4
vasco.caron11Level 4
asked in General Product Q&A
Augmented Attributes - Do cases in Augmented Attributes Table disappear when we remove them from our Case Table?

Good afternoon, Essentially we want to remove all 2021 Data, but we would like to keep our "Resolved History" for Use Cases in Action Views, that rely on Augmented Attributes. Would removing 2021 invoices, for example, cause us to lose all "Resolved Invoices"? How can we preserve this data? Thank you in advance! Best Regards, Vasco Carona, Solvay

93
.
Level 5
D
Level 3
deepti.gandhLevel 3
asked in General Product Q&A
Restrict data extraction to the last few years

Hi, we have a requirement to restrict extraction of purchase orders to last 2 years. We are planning to go ahead with ERDAT from EKKO table. But what about other tables like T*, CDHDR and the rest. How can we restrict data extraction in those tables? Also, How can we make EKKO as a parent table to consider the extraction of the rest of the tables based on the data from parent table like EKBE-EBELN = EKKO-EBELN?

94
D
Level 3
S
Level 1
satyajit.saman11Level 1
asked in General Product Q&A
Celonis Task Mining and Automation

Is there a way to automate the tasks captured by Celonis Task mining? I have captured desktop data/user actions for a task using Celonis Task Mining and data are loaded into EMS. After that, does Celonis provide any feature to automate (API or UI etc) those actions/tasks and run on any machine? Or need to use any RPA tool only for this automation?

11
abhishek.chatu14
Level 7
Z
Level 4
zeliha.otgözLevel 4
asked in General Product Q&A
For example, My KPI Query = SUM(Order Number)My KPI Component Filter is = FILTER NOT (ORDER TYPE = 'A') ;But; somehow I want to combine my component filter into the KPI Query?How can I do that?

For example, My KPI Query = SUM(Order Number) My KPI Component Filter is = FILTER NOT (ORDER TYPE = 'A') ; But; somehow I want to combine my component filter into the KPI Query? How can I do that?

11
G
Level 8
R
Level 3
rahul.bhat11Level 3
asked in AI
Does upgrading a workbench app in Machine learning upgrades all apps?

Hi All,I want to upgrade a single workbench app in Machine learning.I do not want to disturb any other app present in the the workbench.Is it possible to do it?Please provide any documentation if present. 

26
R
Level 3

Badge Winners

  • Qualified to Build Action Flows
    ashoka.gkhas earned the badge Qualified to Build Action Flows
  • Masterclass in Implementation
    raman.silot11has earned the badge Masterclass in Implementation
  • Celonis Certified Data Analyst
    siva.bahadhas earned the badge Celonis Certified Data Analyst
  • Qualified to Build Action Flows
    siva.bahadhas earned the badge Qualified to Build Action Flows
  • Masterclass in Implementation
    manish.singh16has earned the badge Masterclass in Implementation
VIEW ALL
Community Code of Conduct