Skip to main content

Product Q&A

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

4373 Topics
S
Level 2
shubhanshu.vaibh12Level 2
asked in General Product Q&A
Hi All, Is it possible to deploy the Celonis - process mining in such a way that the data does not leave the client premises. If yes then How?

Hi All, Is it possible to deploy the Celonis - process mining in such a way that the data does not leave the client premises. If yes then How?

10
S
Level 2
E
Level 4
e.nLevel 4
asked in General Product Q&A
Question on PyChart

I want to create a pie chart on the Celonis dashboard that counts the number of values in the columns I have added to the OLAPTable. how do I set the DEMENTION and KPI respectively?

11
I
Level 1
.
Level 4
.146192833Level 4
asked in Data Ingestion & Infrastructure
Unable to add Lineplot

Dear Experts, I am attaching snapshots for my query , Basically I have to create Lineplot with X axis being month at which Non compliance occured and Y axis being Total Non Complianced cases. But even though i tried all permutations and combinations , Line plot is unable to appear and all the time green dots are appearing. I request your assistance   

00
I
Level 1
J
Level 2
josep.cunquLevel 2
posted in AI
Hi all,

Hi all,has anyone had problems when triggering a Jupyter Notebook from an Action Flow? I cannot even trigger the template provided in the educational page. It is puzzling because the POST requests succeeds with code 200 - so I assume that all required fields are correctly filled - yet the Notebook is not executed, it does not produce any output. I have tried to move the Notebook across folders and apps, to no avail. Anyone else had the same problem? Attached is the POST output (maybe the problem is that the ML notebook is QUEUED? but how would I solve it anyways?).

00
J
Level 2
R
Level 3
rodrigo.vianaLevel 3
asked in General Product Q&A
How to filter an olap table to only show positive results os a difference between columns(explanation bellow)

Hello all, im trying to compare the sales between last week and the weekly average of the last 6 weeks in several materials. For this I wrote the following code for the kpi:(material is set as dimension)(there is a component filter that limits the data to the last 6 weeks as well)round ( ( ( 7 * SUM ( "VBAP"."NTGEW" ) / 43 ) / 1000 ) - ( ( SUM ( Case When "VBAP"."ERDAT" > ADD_DAYS ( TODAY ( ) , - 9 ) THEN "VBAP"."NTGEW" else 0 end ) ) / 1000 ) , 2) However, in the OLAP I only want to see the materials where this difference is positive so I tried to do a filter where:FILTER "Material" IN (CASE WHEN "DIfference code above" > 0 THEN MATERIAL ELSE NULL END) But I get an error message saying that I cannot use the SUM aggregator in Filter. Does anyone know how to solve this ?

71
G
Level 8
salma.zeped
Level 4
salma.zepedLevel 4
asked in General Product Q&A
How to use SUBSTRING with a FLOAT value?

I need to take the first 8 values of a column to obtain the creation DATE. Then I need to take the remaining values for the TIME. I will then cast them as Date and Time for creating the EVENTTIME. The code below should have worked, but since it is a FLOAT data type I receive an error message on the Output. Code:SELECT ERSDA,ERSDA_TMSTP,SUBSTRING(ERSDA_TMSTP,0,8) AS "INFO1", SUBSTRING(ERSDA_TMSTP,9,4) AS "INFO2" FROM MCH1  Output:Execution error: ERROR: Function catalog.substring(float, int, int) does not exist, or permission is denied for catalog.substring(float, int, int)

10
salma.zeped
Level 4
sree.c
Level 4
sree.cLevel 4
asked in General Product Q&A
How to convert KPI value to constant? Also, this constant should be insensitive to filters.

How to convert KPI value to constant? Also, this constant should be insensitive to filters.

90
J
Level 2
dany.moual11
Level 3
dany.moual11Level 3
asked in General Product Q&A
Self join a table to get a 1:N relationship and compare a KPI value within a dimension

Hello , I would like to implement a KPI showing the relationship within the element of a dimension (B) for each fixed element of a first dimension A and display it as shown below: A | B | B (again) | KPI X | 2001|  2002 | 5 X | 2001| 2003 | 2 X | 2002| 2001 | 100 X | 2002| 2003 | 2..... Y | 2001| 2002 | 50 Y | 2001| 2003 | 25 Y | 2002| 2002 | 20 Y | 2002|  2003 | 25 ...The aim is to be able to determine for each dimension in A, and a given fixed dimension in B, which other dimension within B is very different in terms of KPI value. Any idea about how to inplement something like this using PQL? Thanks for your help 

52
dany.moual11
Level 3
V
Level 1
vi.taLevel 1
asked in General Product Q&A
Dear team,I tried to upload a .csv file but it failed. At step "Select Sheet", the context of CSV file was not displayed in Configure. Therefore, could you please support me to fix the issue?

00
S
Level 4
G
Level 3
giulia.cogliLevel 3
asked in Process Analysis
Hello, I've found this script in order to specify a calendar under my analysis, but I do not know where to add it in order to be applied to all my widgets analysis.

My goal is to specify a detailed work window for throughtput time calculation.  Thank you in advance, Giulia 

00
S
Level 4
milan.eric
Level 3
milan.ericLevel 3
asked in General Product Q&A
No Layoutoptions for Pivot-tables?

Hello everyone,  I am stumbling accross layout problem right now when working with tables in Celonis. I wanted to make a Pivot-table but I need to update the Layouts to see the full name infront... Normal tables have this: While Pivot-tables don´t have any Layoutoptions:  What am I not seeing? This is quite disappointing since I feel like that should be implemented. I need it in this case, since the text is long, and the same until the very end of the text which is not readable. Same for all the other columns who could be way smaller for my taste.  Any way to fix that or does Celonis not support this? If there is no way to do it, can I somehow make Celonis aware of this issue? It seems like something minor, but it should be implemented simply due to the fact that normal tables have it. Thanks!   

00
S
Level 4
tushar.konde
Level 3
tushar.kondeLevel 3
asked in General Product Q&A
what all pre_built connectors available in celonis? Is there SAP Success Factor pre-built connector available in celonis? if not how can we connect with celonis

what all pre_built connectors available in celonis? Is there SAP Success Factor pre-built connector available in celonis? if not how can we connect with celonis

00
S
Level 4
F
Level 3
fynn.reindLevel 3
asked in General Product Q&A
Is it possible to export a LOADED data model to another team/EMS environment?

I am currently creating a Best Practice Celonis EMS with Analyses/Views from different teams. Since I haven't found a way to export loaded data models (data models that already contain the specific data) all my Analyses throw errors.  Exporting Data Pools is possible. I already did that. The problem is that I cannot re-run the Data Jobs in the Data Pool to create a new loaded Data Model because I don't have access to the previously used source data. Any help is appreciated! P.S.: I am also a little bit familiar with the Celonis Data API. Maybe Pycelonis offers some functionalities?

80
S
Level 4
A
Level 2
andras.perjeLevel 2
asked in General Product Q&A
Hello Celopeers, I'd like to group activities by user name, event time, and activity name before counting them.

I'd like to better understand the actual manual work involved by executing a certain activity. In my company, there are activities that are executed as "batch jobs". This means that we can execute the same activity across several line items. In this case, even though it only required one manual execution, it's counted as one across several line items adding up to several "manual" activities. To find a better estimate of the actual manual effort for each activity, I'd like to group them by user name, event time, and activity name.  Can anyone help me crack this nut? Thank you in advance for your help!

12
A
Level 2
D
Level 1
dimitrios.hatziLevel 1
asked in General Product Q&A
How do integrate Celonis and ServiceNow?

Hello everyone. I am looking for anyone who might have achieved integration between Celonis and ServiceNow. The documentation provided - in my view - is not clear. What I have achieved so far:Created a user - basic authenticationCreated a custom roleAdded the rest_service, soap_query, custom role to the userCreated the ACL for the sys_db_object and incident table (filtering on the assignment group) and attached the custom role.Successfully connected between celonis and ServiceNow However, I receive the following error message when a full load is executed:  Any insights or help as to what is missing? FYI - i am no Celonis administrator - anything Celonis related tasks, I have someone within my team that is executing those Celonis tasks. Thank you.

131
V
Celonaut
D
Level 4
douglas.henriLevel 4
asked in General Product Q&A
KPI-CARD

 Hey guys, I would like to transform the access user in Celonis (user.celonis@outlook.com) into just the name. Example: User Celonis I looked in the PQL documentation but I couldn't find it.I looked in the PQL documentation but I couldn't find it.

02
D
Level 4
C
Level 3
christoph.schus12Level 3
posted in AI
Hello all,

Hello all, I would like to send an xlsx file as an e-mail attachment. The file is generated by a Python script in ML Workbench. Due to the formatting of the xlsx file, it is not possible to load this file into the data model without further ado. Is it still possible to send the file automatically, e.g. via an action flow or skill?  Best regardsChristoph 

32
G
Level 8
kailash.potha12
Level 5
kailash.potha12Level 5
asked in General Product Q&A
Is there any way to download PDF report on views? ( Action Flow or Skill)

Is there any way to download PDF report on views? ( Action Flow or Skill)

60
kailash.potha12
Level 5
S
Level 1
sheryl.ngLevel 1
posted in Data Ingestion & Infrastructure
Hi,

Hi,  I have stumbled upon an warning message that states "The join between table "_CEL_P2P_CASES_6" and table "_CEL_P2P_ACTIVITIES_6" did not find any matching rows."  Prior to this warning message, I have assigned the activities and case table respectively as well as assigned their foreign key, "Case_ID".  Is there a way to fix this error message?

21
abhishek.chatu14
Level 7
V
Level 1
vinicius.franc11Level 1
posted in Process Analysis
Attached 1

Action Flow to Update a Augument Attribute Error: Validation failed for 1 parameter I would like get an Augument Attributes from an Excel file using an Action Flow. So, I tried the following steps: 1. Creating a record called “Clientes Comercial” and created a Augument Attribute called “Gestor” in the Knowledge Model. Attached 1 – Record: “Clientes Comercial” Attached 2 – Augument Attribute: “Gestor” 2. Creating an action flow called “carga executivo e adm de vendas”:2.a. Creating a of Microsoft 365 Excel component - List Worksheet Rows and set it to get the data in a sharepoint address. Attached 3 - Microsoft 365 Excel component - List Worksheet Rows2.b. Creating a Celonis Component – Update Augumented Attribute and set to update Attached 4 - Celonis Component – Update Augumented 3. When I run the action flow, I got the following error: Validation failed for 1 parameter(s). Attached 5 - Validation failed for 1 parameter(s)But both, Excel value and Augumented Attributed was

30
V
Level 1
F
Level 3
federico.sparaLevel 3
asked in General Product Q&A
Get activities linked to given activity

Hi, I need to create a table with the infos related to activities linked to a given activity.It's like a Process Explorer but in table form, where the user selects an activity and the table provides infos (name and other columns) related to the activities linked to the selected one. Is there a PQL statement that allows me to do so?

00
S
Level 4
Q
Level 1
qiuyu.renLevel 1
asked in General Product Q&A
For Power BI, I've failed to find any information about how to do it.

For Power BI, I've failed to find any information about how to do it.

60
abhishek.chatu14
Level 7
S
Level 1
sapna.goyalLevel 1
asked in General Product Q&A
How can we get access to Training Analytics Tab in Celonis?

How can we get access to Training Analytics Tab in Celonis?

01
L
Level 1
N
Level 2
niharika.jainLevel 2
asked in General Product Q&A
How can I schedule a Action Flow?

How can I schedule a Action Flow?

70
N
Level 2
E
Level 4
e.nLevel 4
asked in General Product Q&A
Training Environment

In the Celonis Academy training environment, there is no configuration screen for scheduling event triggers. Is it possible to check in the training environment?

21
D
Level 1

Badge Winners

  • Celonis Technical Expert
    RebotileMhas earned the badge Celonis Technical Expert
  • Qualified to Get Data Into Celonis
    RebotileMhas earned the badge Qualified to Get Data Into Celonis
  • First Post
    Manikrishnahas earned the badge First Post
  • Celonis Technical Expert
    richard.matthhas earned the badge Celonis Technical Expert
  • Qualified to Write PQL Queries
    richard.matthhas earned the badge Qualified to Write PQL Queries
VIEW ALL
Community Code of Conduct