Skip to main content

Product Q&A

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

3156 Topics
D
Level 3
daniel.diers12Level 3
asked in Process Analysis
No common parent: Solution with Pullup possible?

Hi all, I have the following issue: I have 2 tables Table1: articlenumber, Table2: articlenumber, I have no key defined in data model due to other reasons. Is it possible to define the key in the analysis, e.g. by using the pullup function so use both tables together (e.g. to find out how many articles are in table1 but not in table 2? Many thanks and br Daniel

20
J
Level 1
J
Level 3
joão.francLevel 3
asked in Process Analysis
Bug with table horizontal scroling

Hi, Im getting a graphical bug where a table with horizontal scrolling in a fixed width sheet wont scroll to the end. Here is what it looks like. Untitled picture918358 6.82 KB Does anybody have a solution?

00
J
Level 1
.
Level 1
.14600915Level 1
asked in Process Analysis
How to filter column data with regex

Hello, I am trying to filter observations in particular column which begins with SYS or ENG while counting (Number KPI). How can I do it with Celonis? I have read about MATCH_PROCESS_REGEX, but did not quite get it. Please help

140
J
Level 1
A
Level 1
arnold.kinzeLevel 1
asked in Data Ingestion & Infrastructure
Convert to parquet failed. The following chunks could not be processed:

Hello, Celonis community and team, this is our first C4C project. We have provided the client with a Celonis ABAP-Skript and used the SAP ABAP Output Uploader. In the third stage Processing, some of the 86 SAP tables could not be processed. The following issues arise for the respective tables: EINA: Convert to parquet failed. The following chunks could not be processed: EINA_1_20201203_155035.csv, EINA_1_20201203_154720.csv, EINA_0_20201203_155035.csv, EINA_0_20201203_154720.csv EINE: Convert to parquet failed. The following chunks could not be processed: EINE_1_20201203_155048.csv, EINE_0_20201203_154734.csv, EINE_0_20201203_155048.csv MARC: Convert to parquet failed. The following chunk could not be processed: MARC_2_20201204_080156.csv MSEG: Convert to parquet failed. The following chunk could not be processed: MSEG_93_20201204_102543.csv T023UT: Job failed T16FE: Job failed What could be the reasons for these issues? The tables incurring the error Convert to parquet failed. The fol

10
J
Level 1
A
Level 3
aram.wLevel 3
asked in General Product Q&A
How exactly does the standard date picker work?

Hello everyone, I'm currently wondering how the date picker exactly filters the dates within the P2P process. Since: "_CEL_P2P_ACTIVITIES"."EVENTTIME" refers to several activities for a single purchase order item, does it "cut off" PO's that have a single activity outside the defined range?  Let's say I filter only for the 1st of September and a single PO has 3 activities: one on 31st of August, one on the 1st of September and another one on the 2nd of September. Would the date picker then consider this order because a single activity lies within the specified time period or cut it off because one or more activities are out of the defined scope? Either way feels I little bit inaccurate.  Another question: How would I have to adapt the date picker to see only PO's for which the "Record Goods Receipt" lies between the specified time period? Thank you in advance and best regardsAram

10
A
Level 3
V
Level 4
vivek.mLevel 4
asked in AI
ML Dataset example to try with Celonis?

Hi All, Am currently working on ML. Can I get the sample Dataset for the ServiceNow or SAP Applications ? Br/VM

20
V
Level 4
L
Level 2
latife.atalaLevel 2
asked in AI
ML Suite Samples

Hello, All. We were working on the examples that once you published your ML suite website. Such as, Anomaly Detection, Duplicate Payments, Root Cause Analysis However, yesterday when I visit the website I couldnt find the samples. Coul you please let me know where can I find them? Since we are trying to adapt those logics into our P2P and AP processes. Thank you! Latife

20
S
Level 1
N
Level 1
nabaa.refaiLevel 1
asked in AI
Python API: Find and replace field names within an analysis

Hi, is there a way we can use the python API to find and replace field names specified in PQL within an analysis? For example, Im linking an existing analysis to a new data model and some of the field names differ slightly e.g. BSEG.TS_AUGDT is now BSEG.AUGDT. Is there a way I can easily update the PQL to use the new fieldname definition via the API without having to update manually via the front end?

00
S
Level 1
A
Level 2
amruth.mudda11Level 2
asked in AI
PQL Query Celonis ML

Hi Team , Is there any simple way to write a PQL query for select * from table name in celonis ML for get_data_frame(query). As of now we need to add all the column names separately one after the other PQLColumns(). Any suggestions would be helpful. Thank you Amruth

100
S
Level 1
M
Level 1
milos.markoLevel 1
asked in AI
On time delivery, feature recommender issue

Dear Team, I try to perform a on time delivery machine learning technique with the *cel11920939 217 KB *" but I receive error on my data set. I wanted to ask is there a tutorial on how should we do whole procedure, for example I tried to import tables connected with foreign key, but I do not know is that proper connection, is the data set I am using proper (it has activity name, timestamp, index etc) should I try to execute it in training.celonis.cloud or it does not play any role. Please if you have datasets you could share with me or whole tutorial of on time delivery and not just in .ipynb file, I am getting KeyError: Model Setup 5/5 (see picture) Best regards Milos Markovic WU Vienna

40
S
Level 1
T
Level 1
theresa.wettiLevel 1
asked in AI
Long loading time for opening empty app in ML workbench

Dear team,is it normal that it takes more than 20 min to open an (empty, newly created) app (smallest memory, storage and CPU limit). If not, what might be the reason? Thank you very much in advance.

00
S
Level 1
D
Level 2
daniel.lopez13Level 2
asked in General Product Q&A
IN specfic analysis the activity selection is not working, the list of activities is blank.How can I enadble it?

IN specfic analysis the activity selection is not working, the list of activities is blank. How can I enadble it?

30
D
Level 2
.
Level 2
.14600929Level 2
asked in Process Analysis
Throughput Time between Null to First Set Delivery Block

We are trying to build a dashboard to calculate throughput time between two activities. Create SO Item with no block ( ')First Delivery Block (ZX) We are using the following PQL query is returning no values. Can you please guide us whether the pql query is correct? AVG (DAYS_BETWEEN( PU_FIRST(VBAP, _CEL_O2C_ACTIVITIES.EVENTTIME, _CEL_O2C_ACTIVITIES.ACTIVITY_EN = <%= start_activity_SO %> AND _CEL_O2C_ACTIVITIES.CHANGED_FROM = '), PU_LAST(VBAP, _CEL_O2C_ACTIVITIES.EVENTTIME, _CEL_O2C_ACTIVITIES.ACTIVITY_EN = <%= change_dev_block %> AND _CEL_O2C_ACTIVITIES.CHANGED_TO = ZG) ))

20
K
Level 1
A
Level 3
audrey.nober11Level 3
asked in Process Analysis
Search space in the reference (AP Process)

Hi, In the AP process, is it possible to do a search with all references that contained a space ? EX : DATA Reference number 12345 $5 1 2345 $10 23 451 $5 I would like to see only reference number with a space thanks in advance Thanks in advance. Audrey

00
K
Level 1
.
Level 2
.14600931Level 2
asked in Process Analysis
Executing Data Job duplicates data

Hi, a fairly basic question from a new user I expect! Im currently carrying out the Implementation Professional training. When I Execute an extraction it seems to stack a new data set on top of the first. My initial response was to make the Execution a Full Load rather than a Delta Load, but when I ran this, it ran for 2.5 hours without finishing and I had to close it down. Can anyone provide advice on next steps? Thanks! Dan

30
K
Level 1
T
Level 3
tomoki.tsuneLevel 3
asked in Process Analysis
Only Bar Chart failed to show the number of cases by process variants

Hi, I am trying to show the number of cases devided by variants of process using following dimension and KPIs. Dimension DISTINCT (VARIANT("_CEL_MM_ACTIVITIES"."ACTIVITY_JA")) ACTIVITY_JA contains the name of activities KPIs COUNT_TABLE("_CEL_MM_ACTIVITIES_CASES") Only the Bar Chart is refused to show the result showing following error. OLAP and other types of graphics elements show successfully what I want. I believe the code is pretty simple, I cannot understand why the code does not work only in the Bar Chart. I have tried following things already, fyi; writing without DISTINCTwriting with SHORTENDcounting other things e.g. ACTIVITIES Please let me know should you require additional information concerning this issue. Best

10
K
Level 1
F
Level 1
flor.allaeLevel 1
asked in Process Analysis
Save activity groups

Hello, I am quite new to Celonis, so perhaps this is a stupid question. I am investigating a process with a lot of different activities and a huge number of variants. To make some sense of it all, I am grouping a lot of the activities. However, whenever I close the analysis and reopen it later, the group definitions are gone and I have to redo all the work. Is there a way to save the activity groups? Thanks for the support!

00
K
Level 1
.
Level 2
.14600953Level 2
asked in Process Analysis
Aggregate Value Bucketing Across Levels

Hello, I have a table to aggregated values that we are trying to bucket within a dropdown. Currently when we bucket the values it filters on the line item level, but we want to filter on the aggregated value level. When we try to use a sum within our case when statement we get an error Aggregation dimension sum cannot be used together with a dimension input {AC0AD37E-4292-4773-A85D-4272482940D6}.png990187 20.2 KB {637ABF08-9E0E-4217-80FE-44EDFEA9D10D}.png802297 38.1 KB

40
K
Level 1
D
Level 3
daniel.diers12Level 3
asked in Process Analysis
Show values although there is noch key connection

Dear all, I have connected two table via a key, example Table 1 T1.Banf T1.Pos T1.Wert 123 10 X 124 10 Y Table 2 T2.Banf T2.Pos T1.Wert 123 10 X 124 10 Y 1235 10 Key: Banf, Pos In Table 2 I show the values of Field Wert from Table 1. For Banf 123 and 124 it works as the key is working. For 1235 it does not work. The whole case is not visible. I want to show the case, just the value of T1.Wert should be empty or any text like no value. How ist that possible? With CASE WHEN ISNULL it did not work. Many thx and br Daniel

00
K
Level 1
.
Level 2
.14600949Level 2
asked in Process Analysis
The aggregation function SUM cannot be used with a dimension function input. PLease check there are no aggregations and dimensions used together as function inputs

I am getting the error while creating the below KPI. Here KPI ABC_A/B/C is calculated KPI which uses SUM function. CASE WHEN KPI(ABC Categorization by Reporting Currency) = A THEN KPI(ABC_A) WHEN KPI(ABC Categorization by Reporting Currency) = B THEN KPI(ABC_B) WHEN KPI(ABC Categorization by Reporting Currency) = C THEN KPI(ABC_C) ELSE Vendor with no spend END

300
K
Level 1
mengfei.yi
Level 1
mengfei.yiLevel 1
asked in Process Analysis
What should be the time dimension of conformance checking

Dear process miners, I am playing with P2P process and I have PR item as case ID. When I am trying to create conformance ratio as a KPI in the transformation center, I am not sure whether I should BADAT field in the EBAN table or Eventtime field in the activity table. Does anyone know? Kind regards, Meyi

20
K
Level 1
E
Level 1
eleonora.jimenLevel 1
asked in Process Analysis
Is there a way to filter the process explorer based on the selection made on the execution-gaps object or to get the current filter on the view to set the filter for the process explorer.

In this particular case I want to select one of the flags and the selection will filter the process explorer for some activities

210
K
Level 1
M
Level 3
maarten.de.vrLevel 3
asked in Process Analysis
Do Execution Apps built in Studio support mobile?

Where can I find details about this, please?  Thanks,Maarten

40
K
Level 1
A
Level 3
alexander.grafLevel 3
asked in Data Ingestion & Infrastructure
Howto: Access system parameters

Hey,I want to access some system parameters like logged in users language and last successful dataload. Is there any possibility to do that?Kind regardsAlex

00
J
Level 1
R
Level 3
rahul.bhat11Level 3
asked in AI
Access logs from front end

Hi team, I am trying to do a usage-statistics datamodel in the front end using the Access_logging with python . I had got a folder of access_logs before i started developement. But now i need the updated versions of access logs for this usage statistics datamodel. Does someone know where this is stored or how we can access for a perticular server? Thanks in advance. image1037258 17.9 KB

10
J
Level 1

Badge winners

  • Celonis Certified Data Analyst
    federica.mohas earned the badge Celonis Certified Data Analyst
  • Qualified to Build Action Flows
    rose.guptahas earned the badge Qualified to Build Action Flows
  • Qualified to Manage Implementation Projects
    katarzyna.olechhas earned the badge Qualified to Manage Implementation Projects
  • Qualified to Create and Deliver Demos
    schahram.hamrahas earned the badge Qualified to Create and Deliver Demos
  • First Post
    jan.mölichas earned the badge First Post
VIEW ALL
Community Code of Conduct