Skip to main content

- - Knowledge base overview
Product Updates
Groups

Welcome to the Celonis Community

5 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,184 Topics
2,547 Replies

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

1184 Topics

raman.silot14Level 4

asked in General Q&A

Getting error wrong credentials while inserting default credentials, any help?

preethi.p12Level 4

asked in General Q&A

Can we compare 2 table column in pql in casewhen statement?

Eg: casewhen table1. Column1 = table2. Column2 then 1 else 0 end. Will this give accurate result or any way we can compare 2 tables to calculate the result?

.146124559Level 1

asked in General Q&A

I have a problem with get data for trainning. I obtain error 404 page deleted. What could i do ?

.146124504Level 1

asked in General Q&A

I am not getting my badge after completing traininy

I am not getting my badge after completing traininy

.146123819Level 1

asked in General Q&A

I didn't received the mail for my badge after my completion of the chapter!Can you look into it..

I didn't received the mail for my badge after my completion of the chapter! Can you look into it..

sagarika.jain11Level 2

asked in General Q&A

Are there any Best practices for Naming conventions for: For Data Integration: Tables / Views / Extractions / Transformations, etc.

Are there any Best practices for Naming conventions for: For Data Integration: Tables / Views / Extractions / Transformations, etc.

niklas.kröniLevel 1

asked in General Q&A

Hello Peers, with the Celonis academic license I can't create on-premise extractors, while I can do it with the training licnese. Is this normal? What license would I need instead of the academic?

Hello Peers, with the Celonis academic license I can't create on-premise extractors, while I can do it with the training licnese. Is this normal? What license would I need instead of the academic?

niklas.siegmLevel 2

asked in General Q&A

Is it possible to use a CASE WHEN Statement where the condition is a comparison between a variable and a string?

Hi all, my Question is: is it possible to use a CASE WHEN Statement where the condition is a comparison between a variable and a string?Like:CASE WHEN <%=variable%> = 'value' THEN ... I work in Celonis Studio with PQL and created a variable in the Variables Section. What I want to do is filter a chart component depending on what timespan (hour, day...) I selected in a button drop down. Here is a code snippet:CASE WHEN <%=timespan_picker%> = 'HOUR' THENROUND_<%=timespan_picker%>(PU_FIRST (DOMAIN_TABLE... When I try it like this I get an Error which says: Table not found Thanks for your helpN.

.1460057128Level 3

asked in General Q&A

How to get the correct avg values for following scenario?

Hello everyone, the uploaded picture shows my current problem. I need to transform an inputtable to get to the correct avg values as my output.

martín.rodríLevel 2

asked in General Q&A

Hello peers. I need help trying to debug an Analysis for a skill.

A skill is being used to extract information from an Analysis via a Jupyter notebook. When executing said notebook, I get the error seen in the picture below:I've been checking the components filters and sheet/analysis load scripts and can't seem to find anything. What really bothers me is the "FILTER" seen alone in the first line. Any help would be appreciated, thanks peers!

sarra.mdimaLevel 1

asked in General Q&A

following the guided tour of create benchmarking and adding a component filter to a process explorer I received this error !Syntax error near [=] after reading [Filter "LFA1"."NAME1"]at line 1. Please refer to PQL documentation for available syn

I followed the guided tour steps properly and created the correct variables. PS: I need a solution in order to continue the guided tour

fynn.reindLevel 3

asked in General Q&A

Replacing null values in column with value from cell above in Data Jobs

Is there a way to replace the null values with the cell values from above in Data Jobs (e.g. first null with 01/01/2016)? I was thinking about the Window Lag function. However, this function seems not to be supported in Data Jobs (SQL Vertica).

martín.rodríLevel 2

asked in General Q&A

Hello peers. I'm trying to create an OLAP table that contains in one row the sum of a column from another OLAP table. Does anyone have any suggestions on how to proceed?

I'm currently counting the amount of times a given Sales Order goes through a specific Activity in my process flow. I've managed to do this in two ways, the first one is by doing a standard PU_SUM, where the source is my activity table and the target table is the common table; the second one is by using the function CALC_REWORK on my activity table and a filter. In a secondary step, I need to add (in a different OLAP Table) the total amount of times SO's from a given branch have gone through said Activity. What this means in simple terms is that I need to sum the column from the first OLAP table where I counted the amount of times an SO went through this Activity.One big problem is that my data model does not have a Table at branch level, the highest level my model has is SO Header, making the grouping by branch part difficult to say the least. Does anyone have any suggestions? Thanks!

arunjit.das12Level 3

asked in General Q&A

Rework Activity Formula with Process time user input

We are trying to figure out a way to calculate process time (user inputs) for a particular case where any activity has featured more than once i.e. Rework. Normally, we would calculate throughput time but in this case, we are gathering the relative information like process time for individual activity and then checking if there are any rework activities for a particular case. Currently the query that is created is calculating the process time for all activities, however we want it to calculate only the activities which has happened more than once. Any kind of help is appreciated. Query: SUM(CASE WHEN PROCESS NOT EQUALS 'Cancel Invoice' THEN CASE WHEN PU_COUNT ( "BSEG", "_CEL_AR_ACTIVITIES"."ACTIVITY_EN" ) <> PU_COUNT_DISTINCT ( "BSEG", "_CEL_AR_ACTIVITIES"."ACTIVITY_EN") THEN CASE WHEN PU_COUNT ( DOMAIN_TABLE ( "_CEL_AR_ACTIVITIES"."_CASE_KEY"), "_CEL_AR_ACTI

.146004063Level 1

posted in General Q&A

Hi Sara, Good Day!!Regarding celopeers partner access as I am not able to access celopeer partner portal getting below error raised a ticket also 00162801. Please check the error screenshot and help accordingly.

.146004076Level 2

asked in General Q&A

Hi Celopeers, I want to put 2 different tables in one CSV/Excel file is this possible? (now I created two different CSV file for each table but it would be nice to have those 2 tables in the same CSV file on 2 different tabs/sheetsThanks!

.146104154Level 2

asked in General Q&A

What is 'Converted' about NETWR_CONVERTED

Is it USD to EURO? Other way around?

vaibhav.mahad12Level 2

asked in General Q&A

I wanted to seek help on following pointers as I am trying to built use case for Task Mining ?

How to use Celonis predefined template apart from workforce productivity like Task documentation ? How to access it ? As I am not able to locate it in MarketplaceI enabled screenshots while recording but I am not able to locate them in analysis. can anyone pls help navigating ?How do you create Task maps / PDDs here. can anyone pls help with steps ? Thanks in advance

.146004319Level 4

asked in General Q&A

Signal-ID on Action Engine can't work with a specific column

Hello all. I tried to filter the column "Year-Month" but the problem is that there is a warning. I also checked if there is an error in my PQL coding, so I copied the code to the process engine and checked all the columns below separately. No errors. Anyone has an idea how to solve this? The code for year-month is: YEAR(MAX(_CEL_P2P_ACTIVITIES._CELONIS_CHANGE_DATE)) || '-' || MONTH(MAX(_CEL_P2P_ACTIVITIES._CELONIS_CHANGE_DATE)) Another problem is that if I use "year-month" as a treshold my signals don't show. If i take the filter off, I see all signals. Thank you all.

preethi.p12Level 4

asked in General Q&A

How to calculate median for this ask. Requirement: Casetable count for a specific activity per document type?

How to calculate median for this ask. Requirement: Casetable count for a specific activity per document type?

.14611432Level 1

asked in General Q&A

Error Celonis-Cloud (my Team)

Hello everybody.Two weeks ago I signed up for Training-Celonis-Cloud to successfully perform the exercises. Since yesterday I have not been able to access to the system (the log error is "Email or password are incorrect.". Although the credentials are correct).I tried to re-enter the new password with the "Forgot password" function but the error persists. Do you know the reason? Thanks.

jay.ogayoLevel 2

asked in General Q&A

Hi,Im new to Celonis and currently doing trainings in the academy. However most guided tours are not working. Is this normal? How do I fix it? I'm using google chrome as browser. tyia.

Hi, Im new to Celonis and currently doing trainings in the academy. However most guided tours are not working. Is this normal? How do I fix it? I'm using google chrome as browser. tyia.

preethi.p12Level 4

asked in General Q&A

Is there any way to cascade in button dropdown for benchmarking

I want to benchmark/compare based on vendor, country and city. Is there any way I can get that in a single bitton dropdown instead of using 3 different button dropdowns. I want to achieve this in cascade, like if I select vendor I should see the option to select country and city values. Thank you

anuraag.pandeLevel 2

asked in General Q&A

Is there a use case highlighting the process of analyzing ServiceNow ticket dump?Kindly help :)

Is there a use case highlighting the process of analyzing ServiceNow ticket dump? Kindly help :)

vivek.mLevel 4

asked in General Q&A

Has anyone replicated the usecases of Process Simulation in your Sandbox/Test system ? Am finding issue while generating Simulation assets using KM.Any inputs or link to explore the fully functional Process Simulation cases ?

Has anyone replicated the usecases of Process Simulation in your Sandbox/Test system ? Am finding issue while generating Simulation assets using KM. Any inputs or link to explore the fully functional Process Simulation cases ?

1
...
30
31
32
33
34
35
36
...
48

Page 33 / 48

Badge winners

niels.holzhas earned the badge Solution Creation Expert
niels.holzhas earned the badge Qualified to Get Data Into Celonis
sharon.josep13has earned the badge First Post
parvathi.choudhas earned the badge Celonis Certified Data Engineer
anna.temel12has earned the badge Qualified to Deliver Business Value with Celonis

Show all badges

Powered by Gainsight

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.

OK

This file cannot be downloaded

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

OK

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

LinkedIn

YouTube

Instagram

Facebook

Terms and Conditions

Celonis © 2025