Solved

I have the following PQL Code and it is working. TABLE (COUNT( "AP_BSEG"."ZTERM" ),"AP_BSEG"."ZTERM");How am i able to get the Max value from it? So overall the expression should give me the name of the most frequent value in this table column

I have the following PQL Code and it is working. TABLE (COUNT( "AP_BSEG"."ZTERM" ),"AP_BSEG"."ZTERM"); How am i able to get the Max value from it? So overall the expression should give me the name of the most frequent value in this table column

303

asked in Process Analysis

raman.silot14Level 8

Custom KPIs in Conformance

HelloI was doing this exercise of adding custom KPIs in conformance, and I am not able to get that at one place it is showing 78% and on the conformance it is showing 65.79%. What is actually going on here?

262

.14601241Level 3

Hi Guys,i get the following error when using the PU_Max pql expression:"Syntax error near [PU_MAX] after reading [] at line 1. " The Expression is:" PU_MAX ( "_CEL_AP_ACTIVITIES","AP_BSEG"."ZTERM", [COUNT] );"

Where is the Problem in my expression and where can i find documentation that isn't blocked by Celonis firewall? When i try to open the celonis. help website i get blocked by the firewall no matter from what and where i try to access the website. Every help is much appreciated, thank you!

181

asked in Process Analysis

raman.silot14Level 8

dotted line vs solid line in Variant Explorer

What does dotted lines depict in a Variant Explorer?

335

ricardo.basso11Level 4

Task Mining Screenshots

After TM installation and data capture (including screenshots) I tried to visualize the Screenshots and follow all the steps for the configuration but screenshots arent apearing.,

252

asked in Process Improvement

.1460088470Level 2

My action flow does not run after I set the automatic scheduling

336

asked in Data Ingestion & Infrastructure

alex.timm11Level 3

Applying filter to KPI calculation

Hello everyone,here is my case: I am using SAP table CRMD_ORDERADM_H as case table. I am using PU_SUM to have an OLAP table column with the sum of CRMD_ORDERADM_I.NET_VALUE grouped by CRMD_ORDERADM_I.HEADER (case id). I am using a dropdown to filter for CRMD_ORDERADM_I.ORDERED_PROD. It works in so far that the table only shows cases, where at least one item has the selected PROD, but the sum stays the same.I would like the filter to be applied to the sum.In case you are not familiar with SAP tables - I added a mock up of what I am trying to do.Have you got any ideas how I could accomplish that?Thanks in advance!

633

jaikishan.pandy11Level 3

What are the different types of Extractor in Celonis?

442

asked in Data Ingestion & Infrastructure

lukas.goder12Level 5

Component Filter: Show only cases from last month

Hi, I want to apply a component filter to an OLAP table. The table initially contains only the case key and the event time. The filter should ensure that only the cases from the last month are displayed. I find the date of the last case with MAX("_CEL_O2C_ACTIVITIES". "EVENTTIME"). Then I subtract one month with ADD_MONTHS(MAX("_CEL_O2C_ACTIVITIES". "EVENTTIME"), -1). Up to this point everything works. If I then set FILTER "_CEL_O2C_ACTIVITIES". "EVENTTIME" > ADD_MONTHS(MAX("_CEL_O2C_ACTIVITIES". "EVENTTIME"), -1) as the component filter, it tells me of course that you can't apply a MAX function in the filter. Is there a way to solve the problem anyway? Thanks a lot! Many greetingsLukas

1094

asked in Data Ingestion & Infrastructure

satoshi.omach12Level 4

Would you know that there is a issue with the S/4 HANA connector?

Hi Team, The following problem was not solved, so when I tried using the connector for ECC, I was able to extract the data. https://www.celopeers.com/s/question/0D507000012uUWHCA2/how-to-resolve-errors-when-extract-tables-sap-connector Would you know that there is something issue with the S/4 HANA connector? Best Regards,Omachi Satoshi

181

e.nLevel 6

change column chart settings

I'm creating the column chart and I'd like to change the intervals between numbers on the vertical axis. Could you please tell me the way?

323

.14600103626Level 8

How can I show KPIs specific for a period and Same KPI from the beginning till now , side by side in same sheet

I am building an analysis.I have a period Filter :( YYYY-MM ) format.While I choose a Period I get to see KPIs specific to that period , but the requirement is , even if I select a specific period, same KPI should show me 2 different values , 1. For the specific period choses 2. KPI value since beginning till date , it should ignore the Period filter value chosen. These two Same KPIs to be placed side by side on the same screen. Can we do this ? If yes, then How ?RegardsAyan

583

ömer.petekLevel 7

Extraction of an Empty Table

Hello,We have an AR project and I have installed Data jobs from the EMS store. It got some errors. I looked up logs and found out it is about KNB5. AR_KNB5 view was not even being created because it says no relation of KNB5. I looked at ECC and saw that KNB5 table is empty. Does empty tables are not being extracted ?

252

antoine.leducLevel 4

HelloIs it possible to create a KPI with a filter on it ? For exemple : A KPI who's showing the % of invoice paid late and when we click on it, it creates a filter on all dashboards

Hello Is it possible to create a KPI with a filter on it ? For exemple : A KPI who's showing the % of invoice paid late and when we click on it, it creates a filter on all dashboards

231

mayank.mudgaLevel 1

"403 Forbidden (nginx)" error while opening an ML app.

I have recently started working in Celonis and exploring the Machine Learning module. When I created an app and now trying to open it, it shows "403 Forbidden (nginx)" error. Snapshot attached. What can be the possible reason?

323

aram.wLevel 2

Problems with the escape character ("\\")

Hi, Celonis doesn't seem to like the escape character ("\\") when filtering graphs for product texts so tried to just replace it with the following formular: REPLACE("VBAP"."MATNR_TEXT",'\\', '-') However, I get the attached error message. Best regardsAram

281

connor.manthLevel 4

Is there a way to show the transformation center chart within an analysis or a Studio View?

I would like to keep a KPI analysis and transformation center chart on the same page. Is it possible to have some sort of iFrame, or view to transformation center in the Analyses? Or perhaps a Studio View?

183

asked in Process Analysis

ariana.hibbaLevel 1

Can you right-justify content in a Table component in a View?

We had a request to align content in certain columns to the right in a Table component in a View. Is there a way to specify that the content in a specific column should be right justified? Thanks in advance.

302

.14600117678Level 0

I would like create a single KPI that uses a conditional count. This KPI should display the count of the number of cases within a process that has a duration < 60 days between two specific events.

261

marco.baren11Level 5

Using custom KPIs in Process Explorer View not possible?

Hi,adding custom KPI such as "Automation Rate" can by done in the Process Explorer of an Analysis. But this option is not available in the Process Explorer within a View. Is this by purpose? If yes, what's the intention behind it? I would like to show a low automation rate in order to use ML to automate incoming orders. Thanks!

633

so.yahatLevel 2

How to use LIKE in CALC_THROUGHPUT

Hi Community,I have a question : I'd like to use LIKE operator in CALC_THROUGHPUT function like this.---FILTER (CALC_THROUGHPUT(LAST_OCCURRENCE[LIKE 'A_%']TO FIRST_OCCURRENCE[LIKE 'B_%'],REMAP_TIMESTAMPS("TABLE"."TIME_STAMP", DAYS))) <= 7 /* only within 7 days duration.*/---but this doesn't work and I found the page* that is similar to my question.This page is helpful, but in my case, the first half of the first argument(LAST_OCCURRENCE[LIKE 'A_%']) requires LIKE operator as well. Please let me know if you have any ideas.Thanks.*Reference : https://www.celopeers.com/s/question/0D50700000GC6lJCAT/using-ldquolikerdquo-in-process-functions-as-calcthroughput?t=1645409602164

697

ricardo.basso11Level 4

a3ERP

Hi all! Anybody knows or have information if there is a connector for a3ERP?

101

sooraj.edayaLevel 6

Data Reload Status Logs

I want to create an alert which sends e-mail to a group of recipients when the Data Load is successful. Is it possible to trigger an alert directly from Celonis? I can subscribe to a data pool to get alerts on reload failure but not when It is successful. In addition Is it possible to get the Log history of the reloads for analysis?

242

hideyuki.nomurLevel 2

How can I get JDBC_Extractor_Package.zip?

I want download 2022-01-13-JDBC_Extractor_Package.zip to verify connection with onpremised system. I tried download this URL, but I get only downlaod.html.https://academic-*****.eu-2.celonis.cloud/help/display/CIBC/Downloads+and+Version+HistoryHow can I get JDBC_Extractor_Package.zip?

177

kavitha.linga12Level 0

Is it possible to get the load script filter which gives the same result as this selection? ie. process flows through 'Deputation letter generated'

Hi everyone, I need to use load script filter for some pages in which the process has to be flow to this step 'Deputation letter generated'. I had tried, FILTER PROCESS EQUALS '<%=activity_name%>'FILTER ISNULL(PU_LAST("Table_name",ROUND_DAY("Activity_Table"."EVENT_TIME"),"Activity_Table"."ACTIVITY"='Deputation Letter Generated')) = 0; But it is not working. Kindly help me to solve this please

121