Skip to main content

Product Q&A

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

4364 Topics
carmen.kaluz
Level 3
carmen.kaluzLevel 3
asked in Process Improvement
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) ?  

743
abhishek.chatu14
Level 7
tasneem.mukad11
Level 2
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

211
abhishek.chatu14
Level 7
PhuongBHN
Level 3
PhuongBHNLevel 3
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?

90
PhuongBHN
Level 3
nicolas.kazek
Level 2
nicolas.kazekLevel 2
asked in Process Improvement
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,

253
janpeter.van.d
Level 8
douglas.souza
Level 3
douglas.souzaLevel 3
asked in Process Intelligence Graph (PI Graph)
Cycle Time OCPM

How do I calculate the Cycle time in OCPM, when my process starts in one object and ends in another?I tried PU functions + bind but I didn't get good results. If anyone can help me I'd be grateful.

242
abhishek.chatu14
Level 7
roman.stolz
Level 2
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!

342
abhishek.chatu14
Level 7
leonardo.spina
Level 3
leonardo.spinaLevel 3
posted in Process Intelligence Graph (PI Graph)
Consistency in Studio Views - no visible errors for the user

Hi all,What are your methods to crosscheck all information is correct in a Studio View?Using Variables and the Knowledge Model is a very important practice, when changing formulae in the KM, then the components automatically update.However, when using a KPI from the KM is not possible, how do you ensure consistency throughout different tabs? How do you guarantee to the users that they won’t find any misalignments or mistakes?Is there a specific methodology at hand, besides suggesting a manual check tab-by-tab?Thank you for your guidelines.

50
leonardo.spina
Level 3
Juan Palencia
Level 2
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

70
Juan Palencia
Level 2
bennita.dutoi12
Level 4
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?  

161
bennita.dutoi12
Level 4
Andreas Siebler
Level 2
Andreas SieblerLevel 2
asked in Process Improvement
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

151
Andreas Siebler
Level 2
PhuongBHN
Level 3
PhuongBHNLevel 3
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)

1102
PhuongBHN
Level 3
Hafsa
Level 2
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,

623
abhishek.chatu14
Level 7
kiranmayi.kadim
Level 2
kiranmayi.kadimLevel 2
asked in Data Ingestion & Infrastructure
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

395
kiranmayi.kadim
Level 2
Iori Oshima
Level 3
Iori OshimaLevel 3
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.

622
Iori Oshima
Level 3
PhuongBHN
Level 3
PhuongBHNLevel 3
asked in Process Analysis
Updating a Variable in Celonis Studio when Date Filter Changes

Hello everyone,I am facing an issue while working with Celonis Studio. I have created a variable as follows:YEAR(ADD_MONTHS(ROUND_MONTH(MAX("view_meviy"."timestamp")), -1)) ||MONTH(ADD_MONTHS(ROUND_MONTH(MAX("view_meviy"."timestamp")), -1))Now, I want this variable to respond to the date filter in my report. Specifically, I want the variable to update its value to reflect the previous month based on the selected date in the filter.I would appreciate any assistance and guidance from the community on how to properly set this up.

150
PhuongBHN
Level 3
kandi.naidu
Level 4
kandi.naiduLevel 4
asked in Process Analysis
How to configure input dropdown in views

Hi Team, I’m working on input dropdown where my timestamp should be convert into daily,weekly,monthly and if it is daily I need 8 hrs , for weekly 40 hrs and monthly 173 hrs in one single dropdown. How I can achieve it. Regards,Ajith Naidu.

343
abhishek.chatu14
Level 7
anusuya.ponnu
Level 3
anusuya.ponnuLevel 3
asked in Process Analysis
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.

583
S
Level 3
manuel.wetze
Level 5
manuel.wetzeLevel 5
asked in Process Analysis
Filtered Cases: Ring Chart-> Pie-Chart Update ?

Hi all,I was wondering about a minor style change of the platform I noticed yesterday.Next to all the applied filters where there is the a small visual indicating how many cases (in % and absolut by hovering over it) are currently selected. This was for a long time a Ring chart. Suddenly it became a pie chart yesterday. Introducing the added problem, that the % number in the middle is poorly visible if the background is split in half into darkblue/light grey by the pie cutting trough it.For a colleague of mine the change was already present yesterday. For me only today.I haven’t about any release plans about this and am wondering about it.My Question is if I as an Analyst can influence that or if it is tied to the user account, of if it is just a given by the platform and we have to accept it. 

101
abhishek.chatu14
Level 7
utkarsh.rasto11
Level 2
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?  

414
A
Celonaut
marietta.kalla
Level 2
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

392
marietta.kalla
Level 2
prek
Level 2
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

694
prek
Level 2
ayush.gupta11
Level 2
ayush.gupta11Level 2
asked in Data Ingestion & Infrastructure
Getting Error while trying use domain table function for two different tables

HI Team,I have One table which has Vehicle ID and other Table which has PartDetails. I want to count claim number from this but both columns are coming from different tables. When I tried using this with DOMAIN TABLE it is giving me following error message:-Pull-Up-function could not be executed. PU_COUNT_DISTINCT: Cannot execute PU-function on tables [<DOMAIN_TABLE ( "O_CUSTOM_CLAIM"."VEHICLE_ID" , "O_CUSTOM_CLAIMLINEDETAILS"."PVTXT" )>] and ["o_custom_Claim"], since they do not have a 1:N relationship. You might want to make use of the BIND function. Join path: [DOMAIN_TABLE ( "O_CUSTOM_CLAIM"."VEHICLE_ID" , "O_CUSTOM_CLAIMLINEDETAILS"."PVTXT" )]1 --> N[o_custom_ClaimLineDetails]N <-- 1[o_custom_ClaimLines]N <-- 1[o_custom_Claim]. For more information on the join path, search for "Join functionality" in PQL documentation.Can anyone assist?

373
abhishek.chatu14
Level 7
mateusz.skurz
Level 2
mateusz.skurzLevel 2
asked in Process Analysis
How to open a filter bar from the view that was opened in overlay?

Hi all,In my View analysis I added the filters into the ‘Show Filter Bar’ that resided on the right side of the view. However, once the same view is opened in overlay, the ‘Show Filter Bar’ is not visible - hence I have no access to the filters.  Is there a way to include a Filter Bar into a view opened in overlay? Thanks and kind regards,Mateusz

341
abhishek.chatu14
Level 7
herique.sarme
Level 3
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! 

272
abhishek.chatu14
Level 7
douglas.souza
Level 3
douglas.souzaLevel 3
asked in Process Improvement
Action Flow partial result http

Hello celonauts, I have a question. I'm creating an action flow that will access an API, but it needs to generate a token and then go to access. In the first step, I generate my token, but it comes composed. I would like to get only the part that brings the token: Example{"token_type":"Bearer","expires_in":3599,"ext_expires_in":3599,"access_token": "value-token"}.I need to get only the "value-token" part after the "access_token":Is there any way I can do a spit or something like that? I don't know how to get out the other side.  

522
douglas.souza
Level 3

Badge Winners

  • Celonis Certified Data Engineer
    thabiso.nalanhas earned the badge Celonis Certified Data Engineer
  • Celonis Certified Data Engineer
    niranjan.ravi11has earned the badge Celonis Certified Data Engineer
  • Celonis Certified Data Engineer
    noyal.rajan11has earned the badge Celonis Certified Data Engineer
  • Celonis Certified Data Engineer
    mahima.panthas earned the badge Celonis Certified Data Engineer
  • Celonis Certified Data Engineer
    zach.linghas earned the badge Celonis Certified Data Engineer
VIEW ALL
Community Code of Conduct