- - Knowledge base overview
Product Updates

Welcome to the Celonis Community

1 month ago

Home
Community
Product Q&A

Product Q&A

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

3023 Topics

Recently active

Most replies Most views Newest first

chanyut.boonkLevel 1

asked in General Product Q&A

Dear Celonis Experts,Is there a way to change the language of the activity names in the "Case Explorer" from German to English? Although I have changed the Celonis system language to English, the activities are still displayed in German. BR Chanyut

2 months ago

shubham.gupta20Level 2

posted in Process Analysis

what is the difference between action view and a normal view ? How can we create action view ? Can someone explain the steps

2 months ago

rithu.kaLevel 2

asked in General Product Q&A

how to change the nanme

2 months ago

nitish.kumar23Level 1

asked in Process Improvement

I want to create an action flow, when I filter the data into the views, according to the filter data action flow triggers and send only the filtered value.

2 months ago

muskan.singh11Level 1

asked in General Product Q&A

I have created a custom extractor to Extract Success Factors Data using Basic Authentication. When I am generating response, I either get no response or incorrect response for datetime columns. Has anyone faced this before?

2 months ago

siddhant.koseLevel 1

asked in General Product Q&A

Permissions required to read excel fill from SharePoint to celonis ML workbench?

2 months ago

arturo.orteg11Level 3

asked in General Product Q&A

I would like to define a process to do some calculations (activity_lead, pu_first)

Hello everyone, I'm trying to calculate wit PQL different metrics like the Number of cases which flow through a certain process with specified activities . I'm using activity_lead and pu_first for that. For example (this is the PIZZA CASE): SUM( CASE WHEN PU_FIRST("CASE_TABLE", "EVENT_TABLE"."ACTIVITY_EN") = 'Order by phone' AND ACTIVITY_LEAD("EVENT_TABLE"."ACTIVITY_EN", 1) = 'Start preparing pizza' AND ACTIVITY_LEAD("EVENT_TABLE"."ACTIVITY_EN", 2) = 'Start baking pizza' AND ACTIVITY_LEAD("EVENT_TABLE"."ACTIVITY_EN", 3) = 'Baking pizza ready' AND ACTIVITY_LEAD("EVENT_TABLE"."ACTIVITY_EN", 4) = 'Plan route' AND ACTIVITY_LEAD("EVENT_TABLE"."ACTIVITY_EN", 5) = 'Departure pizza' AND ACTIVITY_LEAD("EVENT_TABLE"."ACTIVITY_EN", 6) = 'Pizza arrives at customer'

2 months ago

arturo.orteg11Level 3

asked in General Product Q&A

kpi in knowledge model

Hello everyone.I'm having some trouble trying to understand how this kpi works. KPI(PURCHASING_LEAD_TIME_MARC_PU_AVG_PARAMETERIZED,${SSL_TIMEFRAME_VARIABLE},0) PURCHASING_LEAD_TIME_MARC_PU_AVG_PARAMETERIZED--> this is another kpi in KM which I have figured how it works. My problem is that I do not know how the other part (,${SSL_TIMEFRAME_VARIABLE},0) is exactly affecting the result of the main KPI. Hope someone can give me a hand here. Thank you all!

2 months ago

lucas.fisch12Level 2

asked in Process Analysis

Action Flow Filter not working

Hi all,I have an Action Flow where I use the Get Rows Module to get KPI Value from the KM. Then I use the Separator and do a filter on the on side to track if KPI1 > KPI2. But it doesn't work because the KPI values are somehow formatted as <text>. How can I do the numeric filter on the KPI's?

2 months ago

niklas.birnbLevel 2

asked in General Product Q&A

How to change the language of courses? I am new to Celonis and I'm doing the kickstarter course, whereas the should be a green dropdown menu to change the language of the course, but there is none. And the old method with rescheduling also doesn

2 months ago

shikha.puri11Level 1

asked in General Product Q&A

Are there selection views available in Views?

I was not able to find selection views functionality in Views which is present in Analysis and which helps very well in slicing and dicing the data.

2 months ago

marcel.klinkLevel 1

asked in Data Ingestion & Infrastructure

How can I sum up the days where a target date is between 2 date fields. The summation should happen per day. A more detailed description can be found in the details.

I have a “Case Table” table. This has 2 columns “Case ID” and “Target date”. I also have a 2 table “Horizon” with 3 columns “Case ID”, “Start date” and “End date”. The relationship between the tables is as follows: “Case Table” N : 1 "Horizon". The primary key is “Case ID” Target with the help of a PQL:I want to build a graph where on the X axis are the days and on the Y axis are the number of target dates.If the “target date” from the “Case Table” is between the “start date” (exclusive) and “end date” (inclusive) from the “Horizon” table, it should be counted. Example (The case ID of both tables is the same “Case ID” = 1): Target date = 20.09.2024Start date = 18.09.2024End date = 22.09.2024 Result:X axis: 17.09.2024; Y axis: 0X axis: 18.09.2024; Y axis: 0X axis: 19.09.2024; Y axis: 1X axis: 20.09.2024; Y axis: 1X axis: 21.09.2024; Y axis: 1X axis: 22.09.2024; Y axis: 1X axis: 23.09.2024; Y axis: 0 A 1 is added for all days where the target date lies between the start date (

2 months ago

shubham.gupta20Level 2

posted in Process Analysis

I have number of files in pdf/word format.

I have number of files in pdf/word format. These are POD/BOL for an individual lineitem. I want to create a new column called as attachment where these files such as POD/BOL are available as hyperlink. Fileformat is in InvoiceNumber_BOL.pdf or InvoiceNumber_POD.docx . Is there a way to automatically attach the document to a particular line item and show as hyperlink.

2 months ago

raman.silot11Level 2

asked in Process Improvement

Action flow tracking

Hey, I can see that we have alert subscription option for action flows. But can we get the error information somewhere for each email sent ? I am currently working on creating an action flow tracker, for which I want to track and visualise the number of emails sent with each action flow stream and what error that action flow stream faced that too. Let me know if any ideas for the same. Thank You

2 months ago

kailash.potha12Level 5

asked in General Product Q&A

Adding Custom object to perspective

I am trying to add Custom object to the perspective without linking it to any object. Similar to currency conversion object. Table/Object that i am trying to add is TFACS for Workday Calendar, But result in below error.

2 months ago

parvathi.choudLevel 4

asked in General Product Q&A

I have merged two files paid invoices and unpaid invoices into one main case table, now in data model, when im assigning case table to activity table it showing error as Could not execute foreign key join: there are duplicates on both sides of

2 months ago

Anonymous

asked in General Product Q&A

I need to know if anyone out here is using an inexpensive OCR solution to extract data - e.g. from invoices -- and load into Celonis.asap.

I was under the impression that Task Mining has this capability and, EEK, I found out differently just days before closing this deal. Please answer quickly as I need an answer tomorrow, if possible. If you can give me maybe the cost per invoice, that would help.

2 months ago

thomas.mcconLevel 1

posted in Process Analysis

Hi all,

Hi all, Question related to variables and images. The Image component works with a http URL as the input; I am attempting with not much luck to make this image interactive with input dropdown filters which are linked to a variable. Then editing in the YAML editor to insert a case when statement that would point towards a different image URL depending on the selection. As mentioned I'm not having much luck on this and wondered if this was possible or anyone has dealt with this before? Thanks in advance!

2 months ago

richanda.wrighLevel 3

asked in General Product Q&A

Hello All, I want to check of the fourth character in a phone number and make sure it's / and also make sure the 8 character is a dash - How would I do that? Example 314/789-9696

2 months ago

sewhui.samLevel 2

asked in Process Analysis

Stacked column and line graph

Hi, As title, in the new view, can you create a stacked column and line graph? Can it be implemented into components? Best RegardsSew

2 months ago

richanda.wrighLevel 3

asked in General Product Q&A

PQL - I am trying to find duplicate phone numbers within my table. Does anyone know how I can write this PQL?

2 months ago

kailash.potha12Level 5

asked in Process Intelligence Graph

Creation of Custom Attributes / Filters

Hi Community, I am trying to Identify the Cases PRs without PO (And POs Without PR) in my OCPM Procurement Perspective, But i am not able to add a filter, I tried it through Activity and Attribute selection but it is not working (Giving no Values when I Select a Blank PO / PR). The idea here is to select the Backlogs ( PRs without PO ) and Deviation (POs Without PR), If anyone explored this part in OCPM give me suggestion how i can resolve this.. This i am trying it through PO Item Object and PR Item Object. Attaching Few screenshots below Without Selection Selection of Blank PRs Selection of Blank POs

2 months ago

parvathi.choudLevel 4

asked in General Product Q&A

How can I Merge the 2 tables (Paid invoices and Unpaid invoices) to one main case table. After uploading the above files.

2 months ago

margaret.daven12Level 3

posted in General Product Q&A

Automatic tailoring of PQL queries using Static PQL checks (2024-08-28)

Automatic tailoring of PQL queries using Static PQL checks (2024-08-28) You can now write PQL queries that run based on the outcome of one or more data model conditions, such as the data type of a column or the existence of match list elements in comparison operators. Before your query is run, Static PQL dynamically checks some properties of your data model and modifies or cancels your PQL query depending on the outcome of these checks. This lets you define business applications that can be used with a range of different data models, helping drive standardization. For more information, see Static PQL functions.

2 months ago

margaret.daven12Level 3

posted in General Product Q&A

Create templates for your object-centric transformations (2024-08-27)

Create templates for your object-centric transformations (2024-08-27) You can now set up a template containing an SQL query, and use it to create the transformations for many similar object types or event types. Templates are especially useful if you are modeling multiple flavors of the same event (for example, delivery dispatch by different shipping methods), or if you are transforming data from multiple data sources to create the same objects or events. When you're creating a transformation for an object type or event type, you'll now get the choice to use one of your transformation templates. There's a new Templates tab in the Transformations area of the Objects and Events environment, where you can create, edit, rename, and delete your transformation templates. You can also see the transformation instances that you've created using each template. The list of transformations in the Transformations tab tells you if a transformation was created from a template, and you

2 months ago

Page 4 / 121

Badge winners

el.mostafa.janahhas earned the badge Celonis Certified Data Analyst
jumbo.szkhas earned the badge Masterclass in Implementation
makun.sharmhas earned the badge Masterclass in Implementation
yuya.sasathas earned the badge Masterclass in Implementation
isabella.pau11has earned the badge Celonis Certified Data Engineer

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