- - Knowledge base overview
Product Updates

Welcome to the Celonis Community

1 month ago

Home
Community
Ask the Community

Ask the Community

Get answers to general questions and Academy-related topics from fellow users and experts.

1165 Topics

Recently active

Most replies Most views Newest first

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

paul.jones12Level 1

asked in General Q&A

I am completing a training exercise in the My Exercises Studio and it is not allowing me to get additional options when I R Click on the sheet name

2 years ago

milivoi.andraLevel 2

asked in General Q&A

Celonis_formula for documents becoming due in the next few weeksHow to create a formula?

I am trying to create a dashboard or just an olap table in which I can see the open items that will be becoming due in the next few weeks (1 to 3 weeks). My question is how to create a formula that gives me that based on today’s date (not on a fix date), as my expectation is that tomorrow a new set of invoices is displayed based on tomorrow’s date. Data Model B2Cnet due date already in the data model BSEGMERGED table https://bosch.eu-4.celonis.cloud/package-manager/ui/views/ui/assets/fe6ad3d2-c14b-4470-82bc-89f486af4559#!/documents/fe6ad3d2-c14b-4470-82bc-89f486af4559/view

2 years ago

cesar.parra12Level 1

asked in General Q&A

Looking for outbound contact center cases, for sales or collections.

Looking to improve "right party contact, conversion rate, abandon, etc."

2 years ago

anuj.sabre13Level 2

asked in General Q&A

how to find number of duplicate invoices in AP process

Hi Can someone please help with PQL script to calculate duplicate invoices

2 years ago

.1460066564Level 1

asked in General Q&A

how to register for certification program

2 years ago

hideyuki.nomurLevel 2

asked in General Q&A

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?

2 years ago

.146003860Level 3

asked in General Q&A

How to calculate the percentages for each column of a data table?

Hi, I have a data table that has 3 columns: -, 0, 1with a load of data rows below them. How do I go about calculating the total percentage for each column? I would potentially want a KPI in my dashboard that immediately tells me0 = x%1 = y%- = z% thanks,Terence

2 years ago

marco.baren11Level 3

asked in General Q&A

Order Management - Labor Productivity - Exec App: Manual Order Creation | Conexiom - reload and link data models guide is not accessible

Hi, the link "Please reload and link the data models as stated in this guide" leads to a protected google drive ressource and is therefore not available (I requested access with my gmail account, but nothing happened the last days)What needs to be done?Thanks in advance!

2 years ago

arian.musaLevel 2

asked in General Q&A

Solution Professional Exam Prep (VSCL and Discovery methods)

Hi all, First post here. Pleasure to meet you. I just finished the Solution Professional Track and would like to start taking the exam soon, but one thing striked me as curious. Except I have been missing it, VSQL was not included in the training except the "Best-Practice" module. That was like being thrown into the cold water, since I do not have a technical background. The Exam Prep mentiones SQL knowledge as prerequisite for the exam. Since the academy does not seem to provide for a course, is there anyone who could tell me the depth which is needed to pass the exam and where I could learn that (i.e. youtube)? Ideas would be appreciated. If someone is willing to do a personal exam prep and offers on fiverr or similar, feel free to shoot me a message. Best wishes

2 years ago

marco.baren11Level 3

asked in General Q&A

Where to download on-pre Agent for Data Extraction

Hi, recently, we have been registered as a partner. Where can I download the on-prem agent for the data extraction of an on-prem system? best regards

2 years ago

mohammed.zoherLevel 2

asked in General Q&A

I have a use case where I need to create separate views for different business functions using the core process data. Is there any way I can built an analysis just that for each view I am able to exclude certain activities (filter them out of th

2 years ago

ömer.petekLevel 4

asked in General Q&A

KPI Help

Hello,I need a Help on a KPI about OTC . I want to calculate time by hours between,(Cases which goes through "Lead Status Set To: Open" and does not go throught "Lead Status Set To : Assigned".) and current time. Or can you say what is wrong with my code ? HOURS_BETWEEN ( CASE WHEN MATCH_ACTIVITIES ( NODE [ 'Activity Status Set To: Open' ] ) and NOT MATCH_ACTIVITIES ( NODE [ 'Activity Status Set To: Assigned' ] ) THEN "ACTIVITIES"."EVENTTIME" ELSE -TODAY ( ) END , TODAY ( ))

2 years ago

anne.molleLevel 2

posted in General Q&A

Hi everyone, looking for advice from Celonis customers.

Hi everyone, looking for advice from Celonis customers. How did you work with your internal IT team to grant permissions to allow Action Flow emails using a company email address? I've got a functional ID set up with a mailbox to manage security. My internal IT group is struggling to understand what to do. Appreciate how you navigated this with your IT group. Thanks!

2 years ago

ömer.petekLevel 4

asked in General Q&A

How to check if a variable is null ?

Hello,I am preparing an automation sheet on studio and I need a KPI like, if a user type is not selected calculate ratio as activities done by "B,C,S" type user divided by all activitiesBut if a user type is selected calculate ratio as activities done by user which selected user type divided by AGAIN all activities. So, If I use simple dropdown it filters all activities and my numerator is also filtered with my denominator but I don't want this.furthermore, I tried to use dropdown button and write selection to a variable. So I could control KPI formula and I could calculate however I want but, I cant choose how to control if a user type is selected or not. I am trying to control is variable NULL or not. is My way wrong ? I can do it neither on code either nor visual editor. Here is a SS to explain myself. Any help will be appretiated.Best Regards.

2 years ago

prasanth.r16Level 1

asked in General Q&A

Am getting syntax error while using the formula

Formula : COUNT(DISTINCT CASE WHEN KPI(TAT) < <%=SLA%> THEN "PurchasingExample_Test_csv_CASES"."CASE ID" ELSE NULL END) Error : Syntax error near [THEN] after reading [ TABLE (COUNT(DISTINCT CASE WHEN KPI(TAT) &lt; ] at line 1. Please refer to PQL documentation for available syntax.

2 years ago

vaishali.pawar11Level 1

asked in General Q&A

Can we calculate throughput time without rework/change activities

Hi,We are trying to create a deep dive analysis for calculating throughput time. Is there a possibility to calculate TPT without Rework/Change activities? We tried to do it with the help of component filter where we attempted to use the NOT_IN operator in order to ignore rework activities. Is this the right way or does Celonis support any special PQL query for this. Suggestions, ideas would be highly appreciated

2 years ago

.146003860Level 3

asked in General Q&A

How to calculate the difference between two dates in a table?

Hi, Currently I am using this formula: AVG(CALC_THROUGHPUT(CASE_START TO LAST_OCCURRENCE['<%= Activity %>'], REMAP_TIMESTAMPS("DATA_(7)_csv"."COMPLETION_DATE", DAYS))) This formula works well, however I would prefer if I could actually calculate the dates between two columns, rather than just from one column. Something like this: Start Date - Completion Date Example : Thanks,Terence

2 years ago

enrico.pugli12Level 3

asked in General Q&A

Case count against an attribute

Hello everyone,I am asking for support here for an application that I would like to do.I have a CASE TABLE in which calls to a call center are recorded. Each line represents a received call.The goal is to count the Recallers, i.e. those numbers that call several times in the period considered, and their frequency.In other words, I would like to see how many people call twice, thrice, four times, etc.I made a drawing to make better understood in which I recorded 9 calls made from 4 different numbers: I want to put them in a table or graph that shows me that there are 2 numbers that called 2 times, one number that called 4 times and a number only once. (I don't care about the phone number, I put up numbers just to show what I have available and what I want). Could anyone help me set up a component with PQL? Thanks

2 years ago

julio.luna11Level 1

asked in General Q&A

What is needed to perform an Analysis based on legacy systems that are developed in java and using sql. what is needed in Celonis".. what is the best approach?

Currently the IT landscape is based on Legacys no ERP or Market solution. This company decided years ago to develop all their technology and now are facing obsolescence and process issues and difficult to improve as there is no documentation, etc. The discovery process for an improvement project takes a lot of time and we want to improve the discovery process.

2 years ago

Page 39 / 47

Badge winners

laura.walku11has earned the badge Celonis Certified Data Engineer
alessio.vasinhas earned the badge Celonis Technical Expert
alessio.vasinhas earned the badge Qualified to Build Action Flows
eric.gring11has earned the badge Qualified to Manage Implementation Projects
pranav.prashant.pattehas earned the badge Celonis Technical Expert

Show all badges

Terms & Conditions

Sign up

Already have an account? Login

Login with SSO

Login to the community

Login with SSO

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