- - Knowledge base overview
Product Updates
Groups

Welcome to the Celonis Community

5 months ago

Home
Community
Product Q&A

Product Q&A

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

3097 Topics

Most replies

Most views

Newest first

stephan.koschLevel 2

asked in General Product Q&A

Line Break in Tables

Hello everyone, have you thought about integrating line breaks into Tables of the new views? Can you please give us a brief update on this.Thank youStephan

181

1 day ago

filkiLevel 2

asked in Process Analysis

Send mail from Celonis in Action Flow

Hello,I’m new to Celonis, currently trying to estabilish Action Flow that sends PDF reports.Is it possible to send “Email from Celonis” from Skill in Action Flow?RegardsFilip Kin

272

1 day ago

thomas.keimLevel 3

asked in General Product Q&A

Check if a Variable (New Views) is null

Hello Community,how can I check if a variable from the new views is NULL? My challenge is to not use an filter in a PU_FUNCTION when the variable is empty.Variable: VAR_CONDITION_FILTERExample Value with multiple selection: ‘Y001’, ‘Y020’, ‘Y300’I want to use the variable in a PU_SUM Filter statement like in this way.PU_SUM("VTTK", "FREIGHT"."FREIGHT_CONVERTED", CASE WHEN '${var_condition_filter}' IS NOT NULL THEN "FREIGHT"."CONDITION" IN (${var_condition_filter}) END )But this don’t work. Error:A PQL error is preventing this query from executing.Syntax error near [IN] after reading [PU_SUM("VTTK", "FREIGHT"."FREIGHT_CONVERTED", CASE WHEN '${var_conditon_filter}' IS NOT NULL THEN "FREIGHT"."CONDITION" ] at line 9. Please refer to PQL documentation for available syntax. This here works, but I need the check if the variable is empty to avoid errors and to avoid that users has to select all the possible values.PU_SUM("VTTK", "FREIGHT"."FREIGHT_CONVERTED", "FREIGHT"."CONDITION" IN (${var_c

140

1 day ago

janpeter.van.dLevel 8

asked in Process Intelligence Graph

Disappearing Tasks when switching between 'test' and 'production' Object Centric Data Modle

Hi all, We have installed the ‘Open Order Processing App’ on an Object Centric Data Model (OCDM), and using the latest version, built in the Enhanced Studio. The app was installed on the ‘Test’ OCDM, and in the Tasks Management view, you see all the predefined tasks (we added ‘Approval Block’ ourselves). See screenshot below. When we update the OCDM of the Knowledge Model where the triggers are in, and publish the asset, all tasks disappear (I’ve added the approval hold again manually): This is in some way logical, since the triggers for the tasks are linked to a data model and not to a knowledge model. However, it’s quite disturbing, because switching from Test and Production OCDMs then include that you have different tasks, which is hard to maintain. My question to you is:Are there any workarounds that you know of to move all tasks from one data model to the other, without having to install the entire app again on a different data model? Thanks in advance,JP

2 days ago

harshini.gampa12Level 2

asked in Process Intelligence Graph

How do we merge two objects into one object ?

In OCPM , How do we merge two objects into one object ?

212

2 days ago

omar.elmouLevel 3

posted in Process Analysis

How to make selections

Hi fellow Celonis user,For some reason i cant make use of selections ( at the top). In the screenshot below you can see that this option is not available. Also i can't change this in the general settings. Hope someone can help out. Thanks!

293

3 days ago

carmen.kaluzLevel 2

asked in General Product Q&A

How can I use the List Items - Microsoft SharePoint Online in Action Flow module to read records that exceed the limit of 3500?

Hey everyone, I have created an Action Flow with the List Items - Microsoft SharePoint Online module to read data from a SharePoint site that contains more than 3500 records.I wanted to know if there is any way to read records from SharePoint that exceed the limit of 3500 and how to configure this (e.g. using the Repeater module) ?

613

3 days ago

tasneem.mukad11Level 2

asked in Process Management

Celonis Live data link in CPM(Symbio)

Hi, does anyone know how to configure the live data link to Celonis in CPM? the instructions on the support page don't seem to work

3 days ago

Iori OshimaLevel 2

asked in Process Management

The difference of the words between Facet and Repository and Attribute

Hi all, I’ve learned the cource of “Celonis Process Management (CPM)”, but I don’t understand meanings some words well. I can understand Category Core Process, Main Process, Support Process Main Process, Sub Process But I can’t understandFacet Repository Attribute (Attribute group) StereotypesI would like to clearfyWhen or Where to use What is the main concept they are connected to If there are any words which help me understand, feel free to add some words & concepts. Ref01. Welcome to Business Process Management > Learning the vocabulary [12:00] > Repository Objects and Facets [03:00]https://academy.celonis.com/learn/course/symbio-kickstarter/welcome-to-business-process-management/learning-the-vocabulary-1200?client=customer-panorama&page=3&query=facet

3 days ago

PhuongBHNLevel 2

asked in Data Ingestion & Infrastructure

How to connect S3 without using access key?

I need to create a connection from Celonis - Data Integration to AWS S3 without using an access key, as our policy requires password rotation every 90 days, and I prefer to avoid manual updates. Do you have any suggestions on how to achieve this?

4 days ago

nicolas.kazekLevel 2

asked in General Product Q&A

Restrict Scope of People for Task Assignment

Hi,we are looking for an option to restrict the dropdown of an “Asignee” component to a selected number of persons. Currently the dropdown shows ALL persons / groups in our tenant (see example below): Is it possible to restrict the dropdown to display only pre-defined users or user groups? If so, how can this be achieved?BR,

243

4 days ago

roman.stolzLevel 2

asked in Process Analysis

Time between same activity for different cases

Hey,I have an activity that every case has to go through. I would like to know how long the time is between each case. (This is interesting for me because only 1 case can go through the activity at a time and we want to analyze the “empty” time).Does anyone have an idea how to calculate this?Thanks for helping!

292

4 days ago

Juan PalenciaLevel 2

asked in Data Ingestion & Infrastructure

How to Reduce Data Job Execution Time for Large Volumes (e.g., 824M Rows) in SAP Saturn?

Hi Celonis Community, I’m working on optimizing data jobs in Celonis Data Integration for a client with an extremely heavy SAP system (Saturn). Our data jobs currently take around 1.5 hours to process, and the client wants to reduce this to 0.5 hours. Despite optimizing SQL queries (e.g., early filtering, minimizing joins) and disabling unnecessary objects, the massive data volume seems to be the main bottleneck. Here are some examples of the volumes we’re handling: - SalesOrderScheduleLine Transformation: 119M rows in CDPOS, 59M in CDHDR, cost of 24M.- CreditMemoItem Transformation: 123M in VBAP, 824M in VBFA, 178M in VBRP, cost of 83M.- CustomerInvoice Transformation: Similar volumes, 824M in VBFA, 178M in VBRP, cost of 83M. We’ve explored strategies like incremental loads and partitioning, but the sheer volume from Saturn (e.g., 824M rows in VBFA) still slows us down. I found in the documentation that the Payment Term Checker slows with 100M+ invoices, suggesting infrastructure migh

5 days ago

bennita.dutoi12Level 4

asked in Process Analysis

Filter showing all data in a range but one item is 0

Good dayI want to add a filter to this table that shows only the Functional locations (first column) where one of the Material_IDs has a Physical count of 0. Then it must show all the Materials for that Functional location even if its not 0. So the criteria is 1 or more of the materials in the Functional location must be 0 then that functional locational with its other materials should be shown. Below is an example in yellow: Both functional locations A-IAA-BO4-225-HEC-008’s material id must be shown here since one of them is 0. How can I do that?

131

5 days ago

Andreas SieblerLevel 2

asked in General Product Q&A

Array aggregator can't read two bundles from Get Row module

Hi everyone, I have a question regarding Action Flow. I use a Get Rows module and get two bundles as a Output. Once I wanna use the two bundles in a further module within the Action Flow, I cannot select any of my columns I defined in my Get Rows module. The only columns I can select is “Total number of bundles”, “Bundle order position”, “undefined”. I haven’t found any documentation or similar issues in the community. If anybody has an idea how I can select my defined columns highly welcome to respond. Thank youAndreas

141

5 days ago

PhuongBHNLevel 2

asked in Process Analysis

The aggregation function MAX cannot be used together with a dimension function input. Please check that there are no aggregations and dimensions used together as function inputs

I would like to create a KPI to count the cases of the previous month do a dropdown but I keep getting a message that "The aggregation function MAX cannot be used together with a dimension function input. Please check that there are no aggregations and dimensions used together as function inputs.” .Have you got idea how to do it?MY pql: COUNT( DISTINCT CASE WHEN ROUND_MONTH("EKKO"."AEDAT") = MAX(ROUND_MONTH("EKKO"."AEDAT"))THEN "EKKO"."MANDT"END)

142

5 days ago

HafsaLevel 2

asked in Data Ingestion & Infrastructure

Preview not available "data model load" -

Hello, I'm working on connecting serviceNow to Celonis, I did Task Extraction (OK) → Task Transformation (OK) and when I loaded data it works (loaded rows OK), but when I press "set as activity table" it gives me the message : "Preview not available". A table preview is currently not available. The cause may be due to a missing data pool or connectivity issues” without columns to select “Case ID”, “brief description”, “date”.I need to know why the columns are not showing up in views (after transformation task) but showing up in the original tables….for information: I tested the data in task extraction, task transformation and loaded data model and they contain all data of the views. I also execute data job for all, but the columns still don't appear.Thank you in advance for your help,

453

9 days ago

kiranmayi.kadimLevel 2

asked in General Product Q&A

facing issue while creating dropdown

Hi Team,I am facing issue while creating dropdown, I have used below PQL QueryCASE WHENRUNNING_TOTAL(SUM("PO_LINE_ITEM"."NET_VALUE_LINE_ITEM_IN_REPORTING_CURRENCY")) /GLOBAL(SUM("PO_LINE_ITEM"."NET_VALUE_LINE_ITEM_IN_REPORTING_CURRENCY")) <= 0.8 THEN 'Top 20% Vendors' ELSE 'Remaining Vendors'ENDwhile using this query in the dropdown i am getting only one option either 'Top 20% Vendors' or 'Remaining Vendors' but i want both the options in the dropdown. So pls kindly revert ASAP.Thanks,Kiranmayi

335

9 days ago

Iori OshimaLevel 2

asked in Process Management

What should I learn next?

Hi all,I’m a beginner of Celonis. I belong to process office department, I’m in charge of CPM.I’ve done the 5 learning contents “Celonis Process Management (CPM)”. What should I learn next effectively?It seems that there are the cource which is “Your journey”, so I think this is effective for me.

292

9 days ago

anusuya.ponnuLevel 3

asked in General Product Q&A

Does Celonis have prebuilt apps for Tax reconciliation based on General Ledgers

Hi Team, Has anyone built solution for Tax reconciliation analysis based on General Ledgers for Indirect Tax. We are trying to automate tax reconciliation which will have analysis basis documents types, credit, debits for each GL account. Any suggestion on the SAP tables, logic are welcome.

443

10 days ago

utkarsh.rasto11Level 2

asked in AI

Option to schedule ML Notebooks not appearing

I am unable to get the option to schedule a notebook in my ML workbench.Does it require admin access to get the option? Documentation says to have a valid executable file, which I have. Any code to be written in the notebook to make it eligible for scheduling?

384

11 days ago

marietta.kallaLevel 2

asked in Data Ingestion & Infrastructure

Data Model load failed

Hi everyone,I received the following error message during the last few data uploads:The load failed: Load failed. Error Message: Could not execute foreign key join: there are duplicates on both sides of the specified key relationship. Table "PM_AFRU": key columns ("MANDT", "AUFPL", "APLZL"), key ('100', '1016228353', '00000001'), rows 0 and 1. Table "AFVC": key columns ("MANDT", "AUFPL", "APLZL"), key ('100', '1018097598', '00000001'), rows 1603274 and 1608762.Everything was working fine about a year ago, and I have checked the table relationships—they are correct. What could be the issue?Can anyone help?THX, M

192

11 days ago

prekLevel 2

asked in Process Analysis

Data integration - Extractions and Transformations

I would like to create a use case to analyse the throughput times of finished goods flow from one warehouse to another.Unfortunately, there are no pre-existing data connectors available for this particular use where i would be especially looking into goods issue and goods receipt.I did go through the celonis academy trainings but the trainings were basic and i cannot seem to apply what i learnt in the trainings to my use case.Does anybody have any help/ leads?Best RegardsKenny

524

12 days ago

herique.sarmeLevel 3

asked in Data Ingestion & Infrastructure

Every Excel module in Action flow stopped working, help

Out of the blue, every single Excel module in Action Flows has stopped working. Has anyone gone through something similar recently? Has any announcement on this topic been done by Celonis?The screenshot of the error is meant to help better understand the issue as it seems to be a simple ‘access’ problem, but every account that’s been used within those modules has the same issue and all of then started at the same time, so it feels something structural is going on…Either way, if anyone has some insight on this it would be greatly appreciated! Thanks!

252

15 days ago

sivasakthi.dhandLevel 3

asked in Process Intelligence Graph

OCPM Event Sort Order

I have built process maps using OCPM. When event timestamps are equal for more than one activity, the events are sequenced based on alphabetical order of event names in process explorer. This is misleading and does not make sense as it is supposed to be in the sequence of sort order.Is there a way to configure sorting order based on sort column when events timestamp are equal?

845

16 days ago

Page 1 / 124

Badge winners

javier.garci11has earned the badge Qualified to Create and Deliver Demos
javier.garci11has earned the badge Qualified to Deliver Business Value with Celonis
javier.garci11has earned the badge Qualified to Manage Change and Scale Adoption
rushikesh.chava11has earned the badge Qualified to Get Data Into Celonis
himanshu.mitta11has earned the badge Qualified to Build Action Flows