Success Hub
Product Updates
Groups

Welcome to the Celonis Community

6 months ago

Home
Overview
Ask the Community
General Q&A

General Q&A

Can't find what you're looking for? Ask it here!

1,198 Topics
2,563 Replies

When you subscribe we will email you when there is a new topic in this category

1198 Topics

preethi.p12Level 4

I want to know how many activities occurred for each group

I have a category table, table2 and Activity tablerelation is category(N) - table2(1) - Activity(N)in a bar chart, I want to show group from category table and count of activities for each group. I’m getting no common table error while configuring a component.how to fix this for a relationship N:1:N

1 year ago

preethi.p12Level 4

asked in General Q&A

Based on onClick of a KPI list component, the remaining components in a View like charts and tables should change It’s data accordingly

I’m using Knowledge models & Views for this requirement.I’m trying to create use the option as shown in the attached image file.I’m able to add onClick to the Kpi list component in view,but not understanding how this can be used to update a different component.Thank you

1 year ago

rebeca.padil12Level 3

asked in General Q&A

In an OLAP Table, I have as Dimension a tracking number to UPS. Is it possible to add a Link from each row of the OLAP Table that would take me to the UPS site and track that specific Tracker ID?

1 year ago

subhankar.ghosh12Level 2

asked in General Q&A

I am trying to find potential use cases on general accounting and bank reconciliation process/intercompany transactions. Any help on this?

1 year ago

ole.buhlLevel 3

asked in General Q&A

Create an action flow that sends inividual emails to material Managers.Dear all, I have an SAP Table in Celonis that look like the one in the attachmet. It has the rows "Material Manager" "Date" "STOCK Level" and "Material number"

I know want o create an Action Flow that sends an individual Email to each Material Manager (Note that there could be over 50). The Email should contain the following information:If a material of the MM has a negative stock or the stock becomes negative in the future the Email should contain this number togehter with the first date date where this happens and the corresponding stock. If this is true for multipe Material numbers they should all be in one Mail. Examples how the Output should look like are also in the Excel-Attachment. To get the first negative values I tried using fomulas analog to this one because it workes in a view but it does not seem to work in the query-node in the action flow. "PU_FIRST (DOMAIN_TABLE("Material Number"),"Stock","Stock"< 0)" Also I havent found a way how to create individual aggregated email for each Material Manager Does somebody have an idea how to solve this?

1 year ago

sourya.nayak13Level 2

asked in General Q&A

How to evaluate Celonis as the Solution for business use cases

I am curious to know “how to objectively evaluate Celonis as a solution” for process analytics and process mining. Is there any best practice / a checklist to assess the long-term viability of using Celonis for each new business use case? I am able to create awareness around the basic differentiations between Data Analytics and Process Mining, but I'm not sure what factors to consider to make a quantitative assessment for wider education and evangelization. Expectation management around the solution should be handled with objectively. Seeking some ideas here from the wider users.

1 year ago

thymios.nakasLevel 2

asked in General Q&A

Is there any generic presentation of Celonis for internal use?

Hello, we are going to make a short presentation (approx. 15 min) of Celonis to our executives (including CEO) who have no previous knowledge. The purpose is to give them a general overview of the potential and the benefits of a partnership. So we need a somewhat short presentation (considering the time will be only 15mins) describing the basic functionalities the benefits we will have as a partner and the impact it will have on the end customer. We are already working on a presentation but we have limited time and we don't want to leave something important outside. So is there any existing presentation of Celonis used in such cases. P.S. I don't know if this is the right place for this question, in any case thank you in advance. Best, Thymios

1 year ago

milan.ericLevel 3

asked in General Q&A

Looking for examples of (advanced) PQL-functions in real Use Cases

Hello everyone, are there any advanced use cases (Material management, P2P-Cockpit, whatever, ...) where one can simply see advanced PQL-functions in action? (For free)I am struggling with advanced PQL-Functions (Nested PU-and BIND-Functions, Domain_Tables, ...) and the learning curve is quite harsh without any actual real world help and examples. Especially Material Flow Management. Like e.g. Analysises about current stock, stock evaluation (future arriving orders vs future used material), stock over time (Stock + Arrived orders - Reserved material for production) etc. The idea behind such things is in my head. But the actual functions to combine the data accross multiple tables is still really advanced. I´d love to see some examples somewhere. I dont know if Celonis provides something like that? I feel like a lot of stuff is kind of behind paywalls (Consulting firms).

1 year ago

e.nLevel 4

asked in General Q&A

The difference between a custom process and a regular process

I see the word custom process in Celonis Academy, what is a custom process? For example, is importing the add-on SAP into Celonis a custom process?

1 year ago

gareth.johnLevel 2

asked in General Q&A

Hi Celopeers,Can anyone help with a filter function to select all cases in a 12 month period leading up to a specific date?So like all cases in the 12 months to 30th April 2023?

Hi Celopeers, Can anyone help with a filter function to select all cases in a 12 month period leading up to a specific date? So like all cases in the 12 months to 30th April 2023?

1 year ago

e.nLevel 4

asked in General Q&A

SAP ABAP Report

I want to create an ABAP report to extract data, where do I start?

1 year ago

douglas.henriLevel 4

asked in General Q&A

Filter a case when condition

I want to create a filter of an ELSE inside my condition. The ELSE 'Área Não Aderente'. Below script. I want to bring only the data from this ELSE, which would be the opposite of my condition below. CASE WHEN ("EKKO"."BSART" LIKE 'Y%' OR "EKKO"."BSART" LIKE 'PE' OR ("EKKO"."BSART" LIKE 'Z%' AND "EKKO"."BSART" NOT IN ('ZCG','ZPM', 'ZCAT'))) AND ("EKKO"."EKGRP" LIKE 'I%' OR "EKKO"."EKGRP" IN_LIKE ('%1I','%2I','%3I','%4I','%5I','%6I','%7I','%8I','%9I') OR "EKKO"."EKGRP" LIKE 'A%' OR "EKKO"."EKGRP" LIKE '01A') THEN -- Pedido por Área CASE WHEN PU_COUNT("EKKO", "EKPO"."MATNR", "EKPO"."MATNR" IN_LIKE (

1 year ago

douglas.henriLevel 4

asked in General Q&A

A filter that doesn't bring me the current month

I need to filter documents by taking the current month. Ex.: Filter documents from the year 2023 taking the month of MAY(Current)

1 year ago

douglas.henriLevel 4

asked in General Q&A

Filter case when (ELSE)

180

1 year ago

aman.singh.dograLevel 2

asked in General Q&A

is there any way, if we can freeze one column on OLAP table and put filters on rest of the columns on the same table??

1 year ago

douglas.henriLevel 4

asked in General Q&A

Filter without current month.

I need a filter that doesn't bring me the documents of the current month.

1 year ago

krzysztof.rafaLevel 2

asked in General Q&A

How to select multiple elements in order to copy those?

Does anyone know how to select multiple elements in order to copy those?I tried with holding Shift or Control but I am not able to select multiple compononets (in order to copy them to the other tab). There is an option to select and copy all components to other tab, but I need to only copy some of those in bulk. Maybe I am missing something? Bets regards,Krzysztof Rafa

1 year ago

.146192833Level 4

asked in General Q&A

Process mining research journals

Dear Experts, Can you advise me if there are websites to read recent process mining researches contributed by major experts of world. ?

1 year ago

volker.ziesLevel 2

asked in General Q&A

How can I get access to the shipping emissions reduction app (developed with climatiq) for a demo with a client?

This app does not feature as an app in the app store, but it is fully integrated into Celonis.

1 year ago

karol.trzci11Level 2

asked in General Q&A

How do I check detailed information on my SAP on-prem extractor?

Hi, I was looking through Celonis documentation but I cannot find the information were to find detailed Extractor Info. Uplink Integrations in Admin & Settings show only the connector version without details, while I'm looking for something like that: Thanks.

1 year ago

academic.allia11Level 1

posted in General Q&A

Process Mining Business Value Architect (m/f/d) or

Process Mining Business Value Architect (m/f/d) orProcess Mining Data Engineer (f/m/d)Siemens HealthineersDescription: As a Process Mining Business Value Architect and as a Process Mining Data Engineer, you are part of the center of excellence for business intelligence front-end tools at Siemens Healthineers IT. In your role as Business Value Architect, you are responsible for the communication and value creation for and with the business and will develop process mining analyses and conduct changes. In your role as Data Engineer, you are responsible for the back end of the process mining platforms and enablement of process mining solutions. (Check out the full description following the links) Apply here:Process Mining Business Value Architect (m/f/d) - Hybrid (Remote/Office):Warsaw, Mazowieckie, PolandSao Paulo-SP, São Paulo, BrazilKosice, Kosicky kraj, SlovakiaProcess Mining Data Engineer (f/m/d) - Hybrid (Remote/Office):Warsaw, Mazowieckie, PolandSao Paulo-SP, São Paulo, BrazilKosic

1 year ago

.146192833Level 4

asked in General Q&A

Dear experts , I came across use case on retail promotion , I saw that the table /POSDW/TMPRO keeps the track of only last change made. How can i supplement this table to trace all the changes made on promot , I mean table info ?

1 year ago

sachin.agarwLevel 3

asked in General Q&A

Columns to be used to find Duplicate Invoices and Duplicate Payments

Hi,I have been asked to find Duplicate Invoices per day and Duplicate Payments per d in P2P. Can anyone please let me know the Columns to be used to find these two KPIs? Will this work? Dup.Invoices --> RBKP table - > Count of all PK columns / No of days in activity tableDup.Payment --> BKPF table - > Count of all PK columns / No of days in activity table

1 year ago

sachin.agarwLevel 3

asked in General Q&A

logic to find the 'Touch Rate' KPI IN P2P

In P2P, what is the logic to find the 'Touch Rate' KPI and also what are all the activities or Fields to be used?

1 year ago

gaser.nassaLevel 1

asked in General Q&A

Does celonis save the information of my processes internally? And am I allowed to use screenshots of the diagrams in my bachelor's thesis without fear of plagiarism?

1 year ago

Page 24 / 48

Badge winners

peter.wagne12has earned the badge Celonis Certified Data Analyst
marius.englehas earned the badge Value Realization Expert
marius.englehas earned the badge Qualified to Create and Deliver Demos
marius.englehas earned the badge Qualified to Manage Change and Scale Adoption
marius.englehas earned the badge Qualified to Deliver Business Value with Celonis