Skip to main content

Product Q&A

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

4364 Topics
sivasakthi.dhand
Level 3
sivasakthi.dhandLevel 3
asked in Process Intelligence Graph (PI 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?

1225
abhishek.chatu14
Level 7
kandi.naidu
Level 4
kandi.naiduLevel 4
asked in Process Analysis
How to write pql for this tables.

Hi Team, I am trying to create a column chart where I am using  2 tables custody and activity_table .However I am end up with no common table error. The joining in the datamodel as follows:custody(N) ← MCA_CA_ID_NEW(1) → Line_table(N) ← Head_table(1) → Activity_table(N).How I can write the pql statement for this .  

350
kandi.naidu
Level 4
utkarsh.rasto11
Level 2
utkarsh.rasto11Level 2
asked in Process Analysis
How to create OLAP Tables with sub-categories?

As evident from the above image, there are further sub categories in the metrics column. Can we create an OLAP table in similar fashion? 

441
abhishek.chatu14
Level 7
Mst11
Level 3
Mst11Level 3
asked in Process Analysis
Changing the color of the textbox

Hi, in the legacy view there was possible to change background color of textbox, buttons etc. but I cannot find a way how to do it within the new views. I tried to do it through the YAML but it’s not working. So if someone has an idea it would be awesome!

681
abhishek.chatu14
Level 7
milan.eric
Level 3
milan.ericLevel 3
asked in Process Improvement
ActionFlow: Update Augmented Attribute

Hello, I am trying to create an ActionFlow for updating augmented attributes but its keeps giving me errors. The operation failed with an error. 400: Failed to update augmented attribute. Failed to query engine to map identifier from one value to separated columns. Unknown query engine failure I created an augmented attrobute in legacy views with a unique identifier. Now in the ActionFlow I do all my selections with the correct identifier:   And I get the correct result in the input: But it doesnt update the augmented attribute due to the error: As you can see the identifier is the same. What am I doing wrong here?

811
yevhen.riabt12
Level 2
bennita.dutoi12
Level 4
bennita.dutoi12Level 4
asked in Process Analysis
KPI's with filters

Hi everyone I need to add 3 kpi’s together (new views) each with their own filters. Here is an example of one. How can I add these KPIs together without having to build these filters into my PQL. If you save the  KPI it does not save the filters with it. Can I maybe let it write to a variable with the filters? Or is the only way building the filters into the PQL with Case when or PU function?  

380
bennita.dutoi12
Level 4
prasanth.raja
Level 2
prasanth.rajaLevel 2
asked in Data Ingestion & Infrastructure
N:1:N connection fix

I am trying to retrieve a count of a specific column based on a **CASE WHEN** condition using PQL. However, I am encountering the following error:   *"A PQL error is preventing this query from executing. No common table could be found. The tables ["LINK"] and ["JS_PGT_Resolved"] are connected, but have no common table. This means that they do not have a direct (or indirect) 1:N or N:1 relationship. Join path: [LINK]N <-- 1![SUPPORTCASE]!1 --> N[JS_PGT_Resolved]. For more information on the join path, search for 'Join functionality' in PQL documentation."*   I would appreciate any guidance on how to resolve this issue. Thank you! 

972
prasanth.raja
Level 2
robin.pagte
Level 2
robin.pagteLevel 2
asked in Data Ingestion & Infrastructure
Use pyCelonis to back up entire datapool

Hi,I was wondering the following: I want to export my entire data pool (extraction, transformations and data models) using the pyCelonis API. I have been trying to code it myself but there doesn't seem to be a straight forward way to do it. I was wondering if any of you have been using this method and can help me find the right code to use.  The use case is to back up our work once per day. A very nice to have would be an additional script to use the exported data pools to automatically recreate the back-upped work.  In other words: Run script > back up written to files > run script > recreate celonis environment in case of total loss of data

310
robin.pagte
Level 2
shaif
Level 3
shaifLevel 3
asked in Data Ingestion & Infrastructure
Amazon connectivity best practices

Dear Experts, If there is decision to be made in terms of best practices on connectivity to S3  , could you comment on option 1 : connecting S3 bucket directly which contains source tables option 2 : transforming data from S3 using databricks converting into activity and case tables and placing it to seperate bucket and then data shared with celonis ? Thanks, Shaif 

90
shaif
Level 3
bunyod.sap
Level 4
bunyod.sapLevel 4
asked in Process Analysis
Dropdown Filter in New Views

Dear all, I have in one view two OLAP tables(with complex calculations and predefined conditions) for which I want to create independent dropdown filters. The reason for that is that one should be filtered based on date type “received entries” and the other one based on date type “processed entries”. I was wondering if you maybe came across such an issue or if you have maybe some tips & tricks or solution for me? In advance thanks for your help. Best, Bunyod

394
bunyod.sap
Level 4
rishabh.agrawal
Level 2
rishabh.agrawalLevel 2
asked in Data Ingestion & Infrastructure
Delta Extraction

Hey all looking for some insights whether this will work or not if I want a previous years data e.g ( I have 2023-2025 data in CDHDR but I also want 2022 ) can I change the UDATE filter from ( 2023 to NOW ) to ( 2022 to NOW) and disable the change date check  and do a DELTA load to only extract fresh records that are not present in celonis ( even if it’s from the previous year of already ingested data )

441
kailash.potha12
Level 5
kandi.naidu
Level 4
kandi.naiduLevel 4
asked in General Product Q&A
Is there any way to implement custom objects in new view

I want to create an Aging/Market custom objects so my graph can be change based on dropdown I will select. let say If you select Aging then aging should be applied on the chart.  How to implement in new views?

374
kailash.potha12
Level 5
kailash.potha12
Level 5
kailash.potha12Level 5
asked in Process Analysis
Excel Or CSV Exports

Hello,Is there an effective method to restrict exports to specific users or groups of users in Old Views?

280
kailash.potha12
Level 5
wojciech.brol
Level 2
wojciech.brolLevel 2
asked in Data Ingestion & Infrastructure
How to use Action Flow to convert a CSV file to XLSX?

Hi,I'm trying to create an Action Flow that allows me to convert a CSV file to XLSX and then send it via email.Current Flow:The user enters their email in the application view and clicks the "Send Email" button.A webhook retrieves the data. We then use Celonis Get Rows to fetch data for a specific Account ID (one Account ID may have more than one document).   The data from Get Rows is added to a CSV file.Expected Solution:Instead of saving the data to CSV, I would like to:Aggregate the data differently, e.g., fetch it from another HTTP output or webhook. Use ML Workbench in Celonis to convert the JSON format to XLSX. Then send the XLSX file back to Action Flow to attach it to the email.Question:Is it possible to implement such a solution? Or is there a simpler way to generate an XLSX file as an output?

1253
wojciech.brol
Level 2
shaif
Level 3
shaifLevel 3
asked in Process Analysis
Doubt on OCPM process explorer - Not all objects appearing in process explorer

Dear Experts , I have a doubt here, on what logic does the objects appear on scroll bar in Process explorer like shown in snapshots attached. Are they dependent on number of objects i defined or events or relationships ?   

554
shaif
Level 3
omar.elmou
Level 3
omar.elmouLevel 3
asked in Process Analysis
Throughput calculation

Dear i am puzzled that the calculated throughput time in Celonis is different from the source (excel) data. For example order  O4892 has a throughput time of 12 minutes (according to the raw data in Excel). However the output in Celonis is 1M (1 month?). . Could you please assist by advising on this difference.Below you can see a screenshot of the data set and output in Celonis.Many thanks!     

482
omar.elmou
Level 3
david.stefa13
Level 3
david.stefa13Level 3
asked in Process Analysis
Action Flow - Microsoft Outlook 365 Question re CSV attachment plus Queried data available

I have successfully set up an Action Flow to output my Celonis Query in an Outlook 365 email. I use The Celonis Query Data module  → CSV module (create CSV) → Tools module to compose a String for the CSV file to be inserted as a file attachment in Outlook → MS 365 Email Outlook module to Create and Send an email. (see image below).This all works great and we filter to output specific customer data. Today, we manually fill in the customer email contact info.However, we would like to use the Customer Contact data from the Query (name/email_address) to automatically populate the MS 365 Email Recipient. I have observed that the Tools module is limiting what data flows into the Outlook module and within the Outlook module I do not have access to all of the individual Data values from the Celonis Query.When I remove the Tools module, all of the Celonis Query Data module data is readily available for use in the Microsoft 365 Email Outlook module. (but I don’t have the CSV file formatted the w

765
jan.tran
Level 3
D
Level 3
deepti.gandhLevel 3
asked in General Product Q&A
Excel file with Activity definitions and the conditions

Hi, Came across the below slide in Partner asset library but couldn't find any file in the below format. Can you please let us know where to find activity definitions for a particular process along with the conditions used. Thanks.Regards,Deepti

105
Adam Smith
Level 2
M
Level 2
madhava.pemmaLevel 2
asked in Data Ingestion & Infrastructure
Mapping of Celonis Activities with SAP activities

Can anyone has this mapping information?I would like to see the list that shows the mapping of Celonis activities (eg: AP process) to SAP tables.Like while calculating the clear invoice steps which tables, timestamps are used in SAP. Similarly for other activities. This will be a good reference document to begin with and help to customize the activities in Celonis if we need to do so.Appreciate your inputs here.

142
Adam Smith
Level 2
rebeca.ruipé
Level 2
rebeca.ruipéLevel 2
asked in Process Analysis
extract data from Datapool without updating the Data Model in an Action Flow

Hello, How can I extract data from a field from a datapool table without updating the Data Model in an Action Flow?Is it Possible? Thanks

181
matt.witty13
Level 5
Nikhil
Level 2
NikhilLevel 2
asked in Process Improvement
Automating the process of e-filing

Can I automate the process of doing UCC e-filing on a state website through setting up an Action flow or any other fearure present in Celonis?

130
Nikhil
Level 2
sunil.rai12
Level 2
sunil.rai12Level 2
asked in Process Intelligence Graph (PI Graph)
The Data Model Load experienced an issue with the Data Pipeline Orchestrator

Hi All,I’ve following error message when trying to reload the OCPM data model: The Data Model Load experienced an issue with the Data Pipeline Orchestrator. Celonis Support ID: 22950f46-9f10-46af-96de-887c2e2d81a5 Does anyone know what could be the issue here? Thanks,Sunil

362
sunil.rai12
Level 2
K
Level 1
kartic.rawatLevel 1
asked in General Product Q&A
Hi, I am not able to finish the Exercise - Push Flat Data via ML Workbench and Exercise - Push Nested Data via AWS CLI as in both the cases even though I am doing all the steps correctly still it is giving me S3 file upload error.

Hi, I am not able to finish the Exercise - Push Flat Data via ML Workbench and Exercise - Push Nested Data via AWS CLI as in both the cases even though I am doing all the steps correctly still it is giving me S3 file upload error.

172
chijioke.okonk
Level 2
shaif
Level 3
shaifLevel 3
asked in Data Ingestion & Infrastructure
Oracle EBS Tables for ORder to cash and Inventory

Dear all , Is there a handy reference for Oracle EBS tables related to procurement , order management and inventory for process mining ? 

60
shaif
Level 3
jan.tran
Level 3
jan.tranLevel 3
asked in AI
Does anyone have experience with Process CoPilot (and the built-in Python Tool)?

Hi all,I want to use the Process CoPilot with the built-in python tool in order to execute ad hoc calculations.https://docs.celonis.com/en/tool-activation.html#UUID-3c37cb75-0631-254f-a5b1-1a70ffd8d5f4_UUID-5523d1d0-d4b7-e2d3-4ebe-f999dffd6357and https://docs.celonis.com/en/tool-activation.html#UUID-3c37cb75-0631-254f-a5b1-1a70ffd8d5f4_UUID-b801ca95-08b6-fe38-c5c5-89bffe3f22aaI don’t understand the examples...My question:HOW can I implement this? HOW is the data going to be accessed and loaded in order to generate a dataframe? The examples in the docs don’t help me at all … Why is a df generated from a “KPI”? There is no relation between “get_data” output and the “code” …  HOW should I use get_data and python? HOW do these tools interact?Thank you in advance and best regardsJan  

380
jan.tran
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