Skip to main content

Product Q&A

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

3156 Topics
S
Level 1
sanya.mohsiLevel 1
posted in Celonis Free Plan
www.celonis.com

Join us for our next Introduction to Celonis Snap webinar on May 25th at 4pm CEST/ 10am EDT! We will cover Process Mining fundamentals, show you how to upload and analyze your data with our various Quickstarts and you will have the opportunity to ask questions.  Sign up at: https://www.celonis.com/webinar/celonis/introduction-to-celonis-snap/

00
S
Level 1
S
Level 1
sanya.mohsiLevel 1
posted in Celonis Free Plan
lms.celonis.com

New to process mining? Sign up for our free, hands-on Snap Training and become a Process Mining expert in no time! We will guide you through everything you need to know about uploading and analyzing your data in Snap. Register at: https://lms.celonis.com/

10
S
Level 1
.
Level 4
.14600833Level 4
asked in Data Ingestion & Infrastructure
Building up cathegories with NULL values

Hi everyone, i am trying to create cathegories for my pie chart. The categories would describe the Value of the "Case" based on payments (can be NULL) and the rest of the reserves 8also can be NULL) for the Case. I have started with the following description of the Categories:(CASE WHEN (  ("CEL_SHUK_CASES"."ZAHLUNGEN" + "CEL_SHUK_CASES"."RESTRESERVEN")>=0 AND ("CEL_SHUK_CASES"."ZAHLUNGEN" + "CEL_SHUK_CASES"."RESTRESERVEN") <1000  OR   (("CEL_SHUK_CASES"."ZAHLUNGEN") IS NULL AND ("CEL_SHUK_CASES"."RESTRESERVEN")>=0 AND ("CEL_SHUK_CASES"."RESTRESERVEN")<1000)  OR   (("CEL_SHUK_CASES"."RESTRESERVEN") IS NULL AND ("CEL_SHUK_CASES"."ZAHLUNGEN")>=0 AND ("CEL_SHUK_CASES"."ZAHLUNGEN")<1000)  OR   (("CEL_SHUK_CASES"."RESTRESERVEN") IS NULL AND (&quot

10
.
Level 4
C
Level 2
christian.vialeLevel 2
asked in Data Ingestion & Infrastructure
CALC_THROUGHPUT between activity and "now"

Hi, I want to calculate the throughput time between a certain activity and "now"; ideally speaking I'd like to do a query like this one that is forbidden: CALC_THROUGHPUT(FIRST_OCCURRENCE['activity name'] TO TODAY(), REMAP_TIMESTAMPS("ACTIVITIES"."ACTIVITY_START", DAYS)) How can I resolve this? Thanks a lot

100
C
Level 2
C
Level 1
cristóbal.muñozLevel 1
posted in General Product Q&A
Hi.

Hi. I'm starting with Celonis and I was wondering if any of you guys have any suggestions of filters in AP, Cash Discounts that can show the customer the discounts for early payments that he is missing.

00
C
Level 1
V
Level 1
vishal.yadav11Level 1
asked in Data Ingestion & Infrastructure
Hi guys, We are trying to connect Ariba with Celonis IBC to extract Supplier Contracts related data. Now we were able to test connection successfully, but while creating the data extraction task we are not able to see any tables to extract.

Hi guys, We are trying to connect Ariba with Celonis IBC to extract Supplier Contracts related data. Now we were able to test connection successfully, but while creating the data extraction task we are not able to see any tables to extract.

00
A
Level 1
P
Level 4
paul.velthLevel 4
asked in Process Analysis
Export KPIs automatically to Google Drive

Hello, I was wondering whether it is possible to automatically export the KPIs as they are being displayed in Celonis. This either in the form of CSV data, or in the form of a image. The best would be if you can store this CSV or image directly in a Google Drive. Thanks for any advice. Paul

10
A
Level 2
A
Level 2
alberto.genov11Level 2
posted in General Product Q&A
Where I can find Celonis installation document? What's the servers architecture to setup for an on premise installation?

Where I can find Celonis installation document? What's the servers architecture to setup for an on premise installation?

32
D
Celonaut
M
Level 2
malini.nathaLevel 2
asked in Data Ingestion & Infrastructure
Applying Filter on join Table

Hello Community, I am a new member, learning Celonis. while doing the exercises(I am following a PDF document) I got the following error when trying to apply filter on join table. Error parsing filter: CDHDR.UDATE >= 01.06.2014 caused by: Lexical error at line 1, column 16. Encountered: \\u2018 (8216), after : The following is the statment i gave: CDHDR.UDATE >= 01.06.2014 Could anyone please help me to rectify this. Thank you, Malini

00
A
Level 1
M
Level 2
mel.schic11Level 2
asked in Data Ingestion & Infrastructure
Aggregation to two dimensions

Hi,I am looking for a PQL code to solve the following.We have data for multiple dimension over a period of time. I would like to get the data aggregated on one dimension per month.All the data is within one table.|Dim1|Dim2|Dim3| Month | KPI ||----|-----|-----|------|---|| A    | X1   | Y1   | Jan-21 | 300 || A    | X2   | Y2   | Jan-21 | 200 || A    | X3   | Y3   | Jan-21 | 400 || A    | X1   | Y1   | Feb-21 | 200 || A    | X2   | Y2   | Feb-21 | 100 || A    | X3   | Y3   | Feb-21 | 500 || B    | X1   | Y1   | Jan-21 | 300 || B    | X2   | Y2   | Jan-21 | 200 || B    | X3   | Y3   | Jan-21 | 400 || B    | X1   | Y1   | Feb-21 | 200 || B    | X2   | Y2   | Feb-21 | 300 || B    | X3   | Y3   | Feb-21 | 500 | What I would like to get is.jan-21feb-21diff.A900800-100B900100200 I have been trying with the domain table and PU functions but I was not able to make it work.Thank you

30
W
Level 1
.
Level 2
.14600921Level 2
asked in Process Analysis
Jumping to SAP sales order from Celonis

Dear All, I remember linking SAP CRM URL to Celonis so from detailed Tab, I can jump to the transaction in URL. I dont find the steps to do that. Can someone help here? Thanks

70
M
Level 1
T
Level 1
teodora.lataLevel 1
posted in Process Analysis
www.celonis.com

Let's talk about Creating a Single Source of Truth for Business Knowledge, such as KPIs, with Knowledge Models 💫 💫   If you haven't watched the Celosphere Basecamp Session you can still attend today 15.04 or watch the recording after the event https://www.celonis.com/celosphere-2021  

01
M
Level 1
.
Level 4
.14600775Level 4
asked in Data Ingestion & Infrastructure
Extractors for on-prem 4.5

Hello community, I have a question regarding on-prem Celonis extractors. When you say extractors are they similar to the data base connections as shown below. Or does this apply to something different? If so, what is the difference? Thanks, Anna

00
B
Level 2
M
Level 1
michael.sodamLevel 1
posted in Process Analysis
www.celonis.com

Celosphere Basecamp Session Discussion - Content Management: Your company requires advanced version management with different people reviewing changes on apps, KPIs etc? Let us know what you think about integrating your Studio content with the Content-CLI in a git repository (e.g. GitHub). (Basecamp sessions are live today) https://www.celonis.com/celosphere-agenda/

10
M
Level 1
P
Level 1
peter.ruchaLevel 1
posted in Data Ingestion & Infrastructure
WELCOME to our new TASK MINING discussion group.

WELCOME to our new TASK MINING discussion group. @andreas.plien11​ , our Celonis Senior Product Manager and the community is here the answer questions and share best practices.

10
P
Level 1
P
Level 1
peter.ruchaLevel 1
posted in Celonis Free Plan
www.celonis.com

New Webinar Introduction to Celonis Snap coming up April 19th 2021 | 4PM CEST/ 10 AM EST https://www.celonis.com/webinar/celonis/introduction-to-celonis-snap/  

00
P
Level 1
EBrozio
Level 2
EBrozioLevel 2
posted in Data Ingestion & Infrastructure
events.bizzabo.com

Hi Celopeers, We will run three PQL-related sessions at Celosphere 2021: Thu Apr 15, 9:25 AM - 9:50 AM GMT +2   (25 Min)PQL: Become a PQL Power User with a New Assistive Editor Thu Apr 15, 9:25 AM - 9:50 AM GMT +2   (25 Min)Performance: Learn How to Optimize KPI Calculations to Scale Thu Apr 15, 9:25 AM - 9:50 AM GMT +2   (25 Min)Multi-Event Log: Analyze Multiple Integrated Processes in a Single View Sign up here! 

70
EBrozio
Level 2
EBrozio
Level 2
EBrozioLevel 2
posted in Data Ingestion & Infrastructure
www.celonis.com

Did you know that the Celonis Process Query Language (PQL) turned 5 in February?

00
EBrozio
Level 2
A
Level 3
audrey.nober11Level 3
asked in Process Analysis
Conformance Casc (%)

Hi, I did a test about the Conformance analysis in Celonis. How does the conforming cases (%) are calculated ? I created a process like this : image1076124 9.2 KB And that are the process for a specific case (NO ALLOWLISTED) : image280788 19.7 KB The system say that the conformance cases (%) is 100% : But is not the true I dont understand thanks in advance. Audrey

00
A
Level 3
A
Level 2
aditi.tandoLevel 2
asked in Data Ingestion & Infrastructure
Get text component from Machine learning script

Is there any way to get the value of text components or variables defined inside process analytics sheet from machine learning script.Similar action for OLAP table is possible as mentioned in the below documentation:https://celonis.github.io/pycelonis/notebooks/01_Pulling_data.htmlHow can we perform the same for text components or variables?

00
janpeter.van.d
Level 8
.
Level 3
.14600843Level 3
asked in Data Ingestion & Infrastructure
Filter specific value in specific column

My activity table is having three columns ACTIVITY_EN, CHNAGED_FROM, and CHANGED_TO. Now I want to filter all cases which are ever passed through the Cancelled value in CHANGED_TO or CHANGED_FROM column. How can I filter these cases?

20
.
Level 3
steven.bernd
Level 3
steven.berndLevel 3
asked in Data Ingestion & Infrastructure
Delete the whole receipt

Hello everybody,I have the following problem. I hope you can help.I would like to use the component filter to hide the documents that have a clearing document.I have no idea for the formula.When I FILTER BSEG. AUGBL = then it only deletes the line for me, but not the entire receipt.Was a formula turned into a formula?Do I have to take GJAHR into account with the formula? Because the document in 2021 does not yet have a clearing document and should not be deleted.image779124 2.89 KBGREETINGS

00
D
Level 2
L
Level 2
luis.carra11Level 2
asked in Celonis Free Plan
Problem uploading a SAP AP file to Snap

Hi all, I have a problem uploading the BKPF.CSV file to SAP AP using the Quickstart option of SNAP. The file was generated with the extractor requested to the SNAP tech team. The message is: "The file cannot be matched to any of the required tables. Please make sure that the file name starts with the table name"SNAP_ticket_130414.pdf (288.9 KB) Attached is a file with screen captures Any hint? Thanks for your help. Luis

00
Erin Ndrio
Celonaut
mukesh.gupta11
Level 4
mukesh.gupta11Level 4
asked in Data Ingestion & Infrastructure
Select top 3 cases

Hi, I want to select SUM of the top 3 cases based on their count in the single component KPI.I am using the INDEX_ORDER function to get index of each row, but when I apply the filter on analysis the count doesnt get changed. I assume it INDEX_ORDER is performing static in nature. How can I make it to dynamic. RegardsMukesh

00
mukesh.gupta11
Level 4
A
Level 2
aditi.tandoLevel 2
asked in Data Ingestion & Infrastructure
Pull data from process analytics to ML script

I want to create a dashboard where user can input the data and on clicking the submit button the input provoded by user should go to machine learning script where the values are being used in the code.Is this possible with celonis? Please provide any documentation/code related to it.

00
A
Level 2

Badge winners

  • Qualified to Deliver Business Value with Celonis
    silvia.cr¿orhas earned the badge Qualified to Deliver Business Value with Celonis
  • Qualified to Build Views
    michael.ryan11has earned the badge Qualified to Build Views
  • 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
VIEW ALL
Community Code of Conduct