- - Knowledge base overview
Product Updates

Welcome to the Celonis Community

3 months ago

Home
Community
Ask the Community
General Q&A

General Q&A

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

1,159 Topics
2,511 Replies

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

1159 Topics

rob.jago12Level 1

Client Training Roadmap

Hello, Does there exist any existing documentation or external links that can be used to start a customer training roadmap? You have a client that you have engaged with C4C+. As expected, the client is excited with your findings, presentations and what Celonis can do. The client wants to go to the next step: purchase Celonis and start ramping up.. Is there any material, documentation or other that could be provided as a roadmap to the client to bring them up to speed so they could be adept at using Celonis? I suspect this would include Celonis Academy but what topics for what role? (before the Academy upgrade there was a good list of courses to take per client role but that is no more). thank you.Rob

2 years ago

sooraj.edayaLevel 3

asked in General Q&A

Sorting the Filter Selection Views

Is it possible to sort the Celonis In-built dropdowns for Filter Selections (In Component Filter) in an alphabetical order? We do have the table names sorted alphabetically but not the column names (It is shown in the order as we defined with the Data Jobs). Is there a sorting function available so that our users can easily identify the column name in case large number of columns. Thank you

2 years ago

martial.renauLevel 1

asked in General Q&A

BMC Helix

Have somebody already use Celonis with BMC Helix for process mining ?

2 years ago

.1460077856Level 2

asked in General Q&A

How to Calculate Total Amount with Multiple Filters, Each with Three Constraints?

Hello,We want to write a formula to collect the NOV amounts of the people with all two constraints, can you help? CASE WHEN "_CEL_P2P_ACTIVITIES"."USER_NAME"='X' AND ("_CEL_P2P_ACTIVITIES"."ACTIVITY_EN" = 'Submit Purchase Order') AND "_P2P_TCL_POSITIONS_V3"."eylem_sahibi_division" = 'CORPORATE LEGAL AFFAIRS'THEN KPI(NOV)WHEN "_CEL_P2P_ACTIVITIES"."USER_NAME"='Y' AND ("_CEL_P2P_ACTIVITIES"."ACTIVITY_EN" = 'Submit Purchase Order') AND "_P2P_TCL_POSITIONS_V3"."eylem_sahibi_division" = 'CORPORATE LEGAL AFFAIRS'THEN KPI(NOV)...ELSE 0END

2 years ago

ivo.steinLevel 2

asked in General Q&A

individually, the dividend and divisor are correct, but when the quotient is calculated, the result is wrong

My case: ( SUM ( CASE WHEN PU_COUNT ( "Vorgänge_mElement_xlsx_Sheet1_CASES" , "Vorgänge_mElement_xlsx_Sheet1"."Aktivitätsbezeichnung" , "Vorgänge_mElement_xlsx_Sheet1"."Aktivitätsbezeichnung" = '<%= Abbruchaktivitaet %>' AND "abgeschlossen_xlsx_Sheet1"."ABGESCHLOSSEN" = 1 ) > 0 THEN 1 END ))/( SUM ( CASE WHEN "abgeschlossen_xlsx_Sheet1"."ABGESCHLOSSEN" = 1 THEN 1 END ) ) If I only calculate the dividend, the correct value appears, also if i individually calculate the divisor. But when I try to calculate the quotient, the result is wrong. For example the dividend = 4 and the divisor = 9 the result need to be 0.444 but it appears 0.797 as result. Is that a bug by Celonis or what did I make wrong? Thank you in advance. Kind regards,Ivo

2 years ago

.1460051292Level 1

asked in General Q&A

Demo pack for Sustainability

In content.training celonis. We have demo packs for P2P and order Management , can we access similar demo packs for any Sustainability package?

2 years ago

jane.hangLevel 1

asked in General Q&A

The account type is selected as guest instead of partner when signing up. How could I change the account type?

2 years ago

mohammed.zoherLevel 2

asked in General Q&A

How to remap values in one table based on attributes on another table using PQL?

Hello, I want to create a custom dimension for the variant explorer in order to remap certain activity values to NULL. However the activities need to be remapped based on a corresponding table which holds information regarding which activities need to be remapped to NULL. For Example -> In the above images which are connected to each other in the process data model. What should basically happen is that activities A,B,D should not be changes but activity C should be remapped to NULL. Is there any way to implement this using PQL while building the analysis?

2 years ago

marco.baren11Level 3

asked in General Q&A

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!

130

2 years ago

kuni.matsuLevel 1

asked in General Q&A

I am going through Business Architect Value courses specifically in 'Guided Tours: Create Benchmarking, Dynamic Drilldown Table' and the Guided Tour, "Create Benchmarking", in the Academy icon is nowhere to be found. How can i retrieve this guid

2 years ago

mercedes.mill√Level 2

asked in General Q&A

We need to upload files of more than 1 Gb size. Is the IBC Loader that can be downloaded from GitHub recommended by Celonis?Is there any other way to upload big files?Thanks

We need to upload files of more than 1 Gb size. Is the IBC Loader that can be downloaded from GitHub recommended by Celonis? Is there any other way to upload big files? Thanks

2 years ago

ricardo.basso11Level 3

asked in General Q&A

a3ERP

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

2 years ago

.146003860Level 3

asked in General Q&A

How to calculate the % for a specific selection?

Hi, I am currently using this code: SUM("Sheet1"."Column1".'1' / SUM("Sheet1"."Column1") and I am essentially trying to find out how many 1s, 2s, and '-' there are, in the form of a percentage. I tried doing "Sheet1"."Column1".'1' so specific which value I am trying to calculate but I don;t think the code is correct? Thanks,Terence

2 years ago

.1460057128Level 3

asked in General Q&A

Pie Chart Dimensions Issue

In my current UseCase i do have the following issue: I have five transporters. Each of the them transports 5 packages.Therefore i do have 25 rows in my table. I also have the time when the packages need to be delivered and when the transporter delivered them. I want my pie-chart to show how many transporters delevered their entire load of packages on time and how many did deliver at least one package to late.

2 years ago

matthias.eislLevel 1

asked in General Q&A

Export KPI to Share

Hello, is there an easy way to automatically export singe KPIs from an analysis to a shared folder? Data type is not important. KR, Matthias

2 years ago

EBrozioLevel 2

posted in General Q&A

Ready to seize unlimited opportunities?

Ready to seize unlimited opportunities? Visit the EMS Store from your EMS team and discover the different new Apps, Extractors, Connectors, Action Flows added every week we are offering to our global customer base made by Celonis and Partners. Visit the EMS Store or find your team. Recently Added: Payment Behavior Advanced:Incoming invoices that are paid too early or paying dunning charges for invoices that are paid too late can lead to a considerable decrease of the liquidity. The analysis of the payment behavior and the optimization of payment based on this analysis is therefore essential for liquidity management. With this app you can analyze your Payment Blocks, see where you are not taking advantage of Cash Discounts and avoid losses due to Early/Late Payments.SAP ECC O2C Customer Scorecard Advanced:The Customer Scorecard App provides an easy way to gain an overview on the performance of important insights regarding a specific customer as well as KPIs of the own company performanc

2 years ago

.1460066609Level 2

asked in General Q&A

Are there Use Cases focused within the health care industry?

2 years ago

thomas.boehmLevel 2

asked in General Q&A

Could it be, that the Download data does not correspond exactly to the training examples anymore?

e.g. Last Question about number of connections for the concurrency matters data does not correspond

2 years ago

anant.sharmLevel 2

asked in General Q&A

I have cleared my Celonis Implementation Professional certification. How do I get the complete certificate/bage?

2 years ago

xuegang.yuLevel 3

asked in General Q&A

Solution Professional Exam_Demo

Hi all,May I ask for the examination of Solution Professional, we need to submit a Demo for the last test of the certification, right? Is the Demo created by myself? And have to record my screen and explanation on the Demo, then submit the Video file to the system？Thanks and Best regards

2 years ago

athira.p.rLevel 1

asked in General Q&A

How to take Celonis App Creator certification. Can someone please explain the training tracks for that? I couldn't find anything related to app creator in their academy.

I'm a developer and I want to learn about the coding aspects of celonis rather than the analyst courses. Can any of the celopeers please suggest to me the courses for that? Thanks in advance😄

2 years ago

dinesh.reddy.alimiLevel 1

asked in General Q&A

Our jobs are running on SSMS. So we are planning to trigger Data model on Celonis after the job is completed using a shell script. I would Like to know if this is possible? Or if there is any other way to trigger the Data model after our job is done?

2 years ago

khaled.aliLevel 1

asked in General Q&A

Dears,Please, I need further information, documentations, or materials that illustrates how Celonis could help in Master data consolidation, Testing and the other areas throughout the migration? (I attached a screenshot that refers to my question)

We have a high interest and demand in the market to use & implement Celonis for helping the clients in migrating to S/4HANA. I reviewed the frictionless system migration (S/4HANA) webinar. it was useful and insightful, it also showed how Celonis can support their clients throughout the different migration phases. As stated, in the design phase that Celonis can help in Master data consolidation, Testing, and data transformation. but unfortunately, it wasn’t stated exactly in details how can Celonis help throughout the migration in the previously mentioned areas. Thanks in advance.

2 years ago

.1460095367Level 1

asked in General Q&A

Do we have cases for Planning & Budgeting Process in Finance?

2 years ago

.146004076Level 2

asked in General Q&A

Conformance Sheet: Editing the Process model:What if an 'activity' is okay to add to the model but this 'activity'' can for different cases happen at different times in the process. What is the logic/strategy behind this? So where to place it then?

2 years ago

Page 38 / 47

Badge winners

bruno.carva11has earned the badge Qualified to Build Action Flows
bruno.carva11has earned the badge Qualified to Build Views
bruno.carva11has earned the badge Qualified to Build Analyses
rohit.shukl12has earned the badge Solution Creation Expert
charlie.rigbyhas earned the badge Qualified to Write PQL Queries

Show all badges

Terms & Conditions

Sign up

Already have an account? Login

Login with SSO

Celonaut Login Celonis ID Login

Login to the community

Login with SSO

Celonaut Login Celonis ID Login

Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.

Enter your e-mail address

Back to overview

Scanning file for viruses.

Sorry, we're still checking this file's contents to make sure it's safe to download. Please try again in a few minutes.

This file cannot be downloaded

Sorry, our virus scanner detected that this file isn't safe to download.

ANY QUESTION?

Talk to an expert

FAQs

MORE CELONIS

Academy arrow_outward

Documentation arrow_outward

Support Center arrow_outward

Partner Portal arrow_outward

Marketplace arrow_outward

CHECK US IN

YouTube

Instagram

Facebook