- - Knowledge base overview
Product Updates

Welcome to the Celonis Community

2 months ago

Home
Community
Product Q&A

Product Q&A

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

3045 Topics

Most replies

Most views

Newest first

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

3 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.

3 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?

3 months ago

siddhant.koseLevel 1

asked in General Product Q&A

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

3 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'

3 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!

3 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?

3 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

3 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.

3 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 (

100

3 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.

3 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.

3 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

3 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.

3 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!

3 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

3 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

110

3 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?

3 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

3 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.

3 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.

3 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

3 months ago

margaret.daven12Level 3

posted in General Product Q&A

Automatically handle source system data issues for object-centric process mining (2024-08-22)

Automatically handle source system data issues for object-centric process mining (2024-08-22) When you enable a process from the Celonis catalog, you can now choose to skip missing data from your source system. If you enable this feature for a data connection, we'll handle these issues:If your source system data is missing columns that the Celonis object types and event types require, we'll skip over them. Your objects and events will be created with null values in these fields.If your source system data has data types for required columns that don't match those expected by the Celonis object types and event types, we'll cast them to match the expected data types, and use that in your objects and events. You can activate the feature when you create a new connection or at any time afterwards. We’ve disabled it by default for your existing data connections, but you can activate it for them if you need it. Skipping missing data lets your transformations run with errors, so

3 months ago

margaret.daven12Level 3

posted in General Product Q&A

Optionally extract non-populated columns with Oracle Fusion BICC Extractor (2024-08-22)

Optionally extract non-populated columns with Oracle Fusion BICC Extractor (2024-08-22) The Oracle Fusion BICC Extractor didn't previously extract columns marked in the metadata as "isPopulate": false (non-populated columns). You can now choose to extract these as well by selecting the new extraction parameter Include Optional Columns during column configuration. When you do, we'll add the optional columns to the display and include them in the extraction by default. This can add a lot of extra columns, so we recommend you also select Customize Column Selection, then go through the updated list of columns and uncheck any that you don't want for your business case. For the extractor instructions, see Oracle Fusion Cloud BICC. The BICC Extractor is in Limited Availability status. To get access as an early adopter, ask your Celonis point of contact.

3 months ago

margaret.daven12Level 3

posted in General Product Q&A

Create object types and their transformations from source system tables for object-centric process mining (2024-08-21)

Create object types and their transformations from source system tables for object-centric process mining (2024-08-21) Instead of modeling an object type from scratch, you can now choose to create it based on a table in your source system, with columns from the table becoming attributes of the object type. When you use this method, we'll create a preview of the object type where you can select which columns you do and don't want to turn into attributes. You can rename the object and its attributes (by default we use the table and column names). You can also add extra attributes for data in your table or outside it. When you've finished, we'll create the object type, and you can choose to also have us autogenerate the SQL transformation scripts for it. The autogenerated transformation contains the SQL statements that you'll need to populate the object type’s attributes with the data from your source system table. You'll need to add SQL statements to identify the

3 months ago

Page 5 / 122

Badge winners

anton.schmihas earned the badge Value Assessment Expert
anton.schmihas earned the badge Qualified to Prove Celonis Value
omar.alminhas earned the badge Value Realization Expert
omar.alminhas earned the badge Qualified to Manage Change and Scale Adoption
diego.zacarhas earned the badge Celonis Technical Expert

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