Skip to main content

Product Q&A

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

4429 Topics
A Rab
Level 2
A RabLevel 2
asked in General Product Q&A
Preselect dates in the date range component

Hi,I would like to select an item from a dropdown list, then have the from date and end date already marked in the date range component for that selected item, is that possible in Celonis? and how? Thanks a lot.

30
A Rab
Level 2
jan.hagem
Level 3
jan.hagemLevel 3
asked in Data Ingestion & Infrastructure
Automating Data Ingestion of External Statistics (Destatis) into Celonis

Hi everyone,in our Procurement analysis we are evaluating price developments and also compare them with external reference data provided by the German Federal Statistical Office (Destatis). The data is available as CSV flat files, which we currently download and manually integrate into our data model.I was wondering:👉 Has anyone already built an automated data ingestion pipeline for this kind of use case (regularly pulling official statistics or external CSV-based sources into Celonis)?👉 If yes, what approach or tools did you use (APIs, connectors, scheduled pipelines, etc.)?Any insights or best practices would be highly appreciated!Thanks in advance 🙌

120
N
Celonaut
M
Celonaut
mateusz.miaraCelonaut
published in Process Intelligence Graph (PI Graph)
Shipped Not Invoiced App version 1.

Shipped Not Invoiced App version 1.0.0 (2023-08-01) App version now available for object-centric process mining A Shipped Not Invoiced app version that supports object-centric process mining is available now from the Celonis Marketplace. The object-centric version of the app uses the Order Management perspective that’s supplied with our object-centric data model. Before you set up the object-centric version of the app, you’ll need to load the object-centric data model with your data and validate the Order Management perspective. The app uses the objects and events that you’ve already built from your source system data and stored in the OCPM Data Pool. To get started, see Quickstart: Extract and transform your data into objects and events. To use this version of the app, you'll need a Celonis EMS subscription that includes object-centric process mining. If you can't see the Data > Objects and Events option in your Celonis environment, your team doesn't have this feature y

501
Joe-Hartzel
Level 3
E
Level 3
ewa.aniśkLevel 3
asked in General Product Q&A
How can we apply colours to charts/process explorer/tables in Views?

How can we apply colours to charts/process explorer/tables in Views?

366
Joe-Hartzel
Level 3
julia.bauer
Level 5
julia.bauerLevel 5
asked in Process Improvement
Augmented Attribute Behavior

Hello everyone, I’m using an augmented attribute  “Sendout y/n” which is based on this record identifier: EORD → Material || Plant || Supplier. This attribute is used within a dashboard and can be manually set for the default value “no” to “yes”.  In the case a user changes this combination: Material: 123456, Plant: XY, Supplier: SupplierA → 123456XYSupplierA → Sendout (Augmented Attribute): Yes, I can then use this attribute for a connected AF. Let’s say the SAP EORD table data changes → orderbook changes the record identifier would now be: Material: 123456, Plant: XY, Supplier: SupplierB → what would now happen? Would the combination 123456XYSupplierB be on Sendout: Yes? Or would the augmented attribute as it is based on the MATNR, WERKS, LIFNR know that the identifier itself changed and be by default No again? When changes occur I would need the combination 123456XYSupplierB to have the augmented attribute with: No by default. I’m assuming that this will be the case, however, I’m no

445
Joe-Hartzel
Level 3
marcelo.ferre11
Level 2
marcelo.ferre11Level 2
asked in Process Improvement
Sending data from Action Flow to Action Flow without a Webhook

Hi Team,I’m trying to send data from one Action Flow to another without using a webhook. Is that possible? Thanks in advance for your help!

80
marcelo.ferre11
Level 2
Leslie Lei
Level 2
Leslie LeiLevel 2
asked in Data Ingestion & Infrastructure
Cross tables filtering doesn't work in N to 1 to N data model

Hello Celonis users, Good day. There is no chance for me to change anything in the data model and I mainly work in PQL Editor. My goal is to use fields from N-side tables to filter data and visualize it. More details:Data model: Table A [N] → [1] Table B [1] ← [N] Table C Table A:Material code            Warehouse            Procurement type1                                  Australia                    External1                                     USA                        Own produced2                                      UK                          Own produced2                                      USA                         Others3                                   Austrialia                   External3                                       UK                          Own produced Table BMaterial code              Responsible1                                        Martin2                                         Mary3                                         Julia Table CMaterial

695
Leslie Lei
Level 2
Leslie Lei
Level 2
Leslie LeiLevel 2
asked in Data Ingestion & Infrastructure
How to restrict the scope of filters

Dear Celonis users, I only know how to create a filter in KM and apply it to a table.  I would like to restrict the scope of filters, so that they will only have impact on one tab, when I put those filters in the filter bar. Is it possible to achieve this goal on Celonis web version?

40
Leslie Lei
Level 2
karl.guent
Level 4
karl.guentLevel 4
asked in General Product Q&A
Something wierd is happening with my environment ... the labels are lost and I am seeing variable names. Is this happening to other people as well?

75
Joe-Hartzel
Level 3
mtucker10
Level 2
mtucker10Level 2
asked in General Product Q&A
How can i tell if my EMS connection has microsoft features enabled?

I’m trying to create a data connection between Celonis into Power BI. When I put the hyperlink into the ‘get data’ prompt, the navigator pane is blank (ie shows no data available).  I’m curious if I have the microsoft connection enabled. How can I check this? Important to note - I do not have analyst rights in Celonis hence why I’m attempting to import data into Power BI. 

80
mtucker10
Level 2
apurva.patha12
Level 4
apurva.patha12Level 4
posted in General Product Q&A
Limit the row level data in Pivot(New View)

Hello All,Could you help me to understand how to select recent 5 years in Pivot Table(New View). Currently i can see older data also like below.I want to limit it to last 5 years only. Please help.Regards,Apurva

263
yevhen.riabt12
Level 2
bhargav.bhima
Level 2
bhargav.bhimaLevel 2
asked in General Product Q&A
Need help with PQL filtering

Hi,What I’m trying to do is essentially pick the last but one non-automated user from the event log and pull it to object level. The previous non-automated user needs to be different from the last non-automated user.In the sample data shown below the desired output would be JANE.I’ve tried looping one PU_LAST and using it as filter for another PU_LAST but doesn't seem to be working.PU_LAST( OBJECT ,  EVENT_LOG , EVENT_LOG NOT IN (PU_LAST( OBJECT, EVENT_LOG,EVENT_LOG NOT IN (‘AUTOMATED’) ))  ,  ’AUTOMATED’).EVENT LOG ID USER 1 JACK 2 JANE 3 JOHN 4 AUTOMATED 5 JOHN  Any insights would be much appreciated.

1177
Joe-Hartzel
Level 3
Iori Oshima
Level 3
Iori OshimaLevel 3
asked in Process Management
How to activate the process in Process Navigator?

Hi all, I’d like to confirm the common release process.I’m a article, and I’ve released the sub process but I couldn’t activate the process in Process Navigator. I’ve alredy checked the Permitted set and there is no permission set. What are common issues?I can’t click in Process Navigator  

262
caspar.jans
Celonaut
sunnyt
Level 2
sunnytLevel 2
asked in Process Management
BPMN model mapping with eventlog activities

My event log is too granular compared to the BPMN model. How can I  aggregate multiple small system events into one logical activity that matches my BPMN model? Is there any documentation or training on the most common challenges faced during the conformance checking with Imported BPMN model?

191
caspar.jans
Celonaut
harshini.gampa12
Level 2
harshini.gampa12Level 2
asked in Process Management
Report Generation -- Standards and Standards Chapter matrix , Process performance analysis

Hi Team,We would like to generate the Reports in Process designer i.e Standards and Standards Chapter matrix , Process performance analysis .Can you guide us how to create the above mentioned highlighted contents in report.

141
caspar.jans
Celonaut
Edwin Daniel
Celonaut
Edwin DanielCelonaut
posted in Process Improvement
Demo - Triggering an Action Flow from a table

Hello all, I'm really excited to announce a recent feature update for Action Flows. It is now possible to trigger an Action Flow directly from a table in View using the dropdown input feature.This allows users to choose an option from a predefined dropdown list when taking an action from a view. This choice is then passed on to the Action Flows as an input and therefore enables advanced human-in-the-loop use cases.  You can find further documentation here.  

1112
S
Celonaut
asdfg
Level 3
asdfg
posted in General Product Q&A
Celonis-support for OCEL standard

Hi folks,what’s your thoughts about the OCEL standard for object-centric event data? Should Celonis support it and that way enable us to do ETL and keep log data outside outside the Celonis cloud, for instance in MS Azure?It would be interesting to hear if Celonis has given a thought about implementing OCEL or not.https://ocel-standard.org/1.0/

322
asdfg
Level 3
nimisha.devji
Level 2
nimisha.devjiLevel 2
asked in AI
Link process copilot to read the record attributes instead of system prompt

How can I get the process copilot to use the record attributes saved on a knowledge model to search for the “output” rather than using the sample from the prompt? I have tried removing the sample from the prompt and it does not work. I have used the attributes on the knowledge input section of the process copilot as well and it also seems not to be enough.

371
N
Celonaut
andres.naran12
Level 4
andres.naran12Level 4
asked in AI
How to get component values from a view with PyCelonis

Hi everyone I have a challenge that I’m trying to figure out related to pycelonis.I’m currently trying to get the component values from a view using pycelonis. Unfortunately, I couldn’t find any information inside the documentation that can help me with this.It seems that the documentation only explains how to work with analysis or knowledge models. Does anyone know how to work with components of a view inside pycelonis?Best wishes!

17725
janpeter.van.d
Level 8
marcelo.ferre11
Level 2
marcelo.ferre11Level 2
asked in Process Analysis
How can i send a constant input to an Action Flow?

Hi Team,I’m working on creating a generic Action Flow with a writeback module. Depending on the OLAP table, I need to send different inputs to select the correct table for the writeback.

321
jan.vajse12
Level 3
Pruthvin
Level 2
PruthvinLevel 2
asked in General Product Q&A
Custom Object Changes in OCPM

Hi All,Which one is the most optimized way in Object centric while making the changes in celonis catalogue Object. for example in Deliveryitem Object i want to make changes to CDPOS table which is celonis provided one i just want to add one more attribute to the existing one do i need to use Overwrite or copy pasting the whole code in Custom changes along with my attribute. which takes less time while executing the transformation ?Could someone help me here ?Thank you in advance 

432
Pruthvin
Level 2
Chethan Shetty
Level 3
Chethan ShettyLevel 3
asked in Data Ingestion & Infrastructure
How to upload new dataset to a table

Hey, I’ve an table I hope that is being creating initially using excel import. Now that I want to update the data in the same table. Can anyone please guide me to do that. Thanks in advance RegardsChethan

632
Chethan Shetty
Level 3
apurva.patha12
Level 4
apurva.patha12Level 4
posted in General Product Q&A
Pivot in New View

Hello All,Could you help me to advise on how to classify the bucketing with the help of coloring in pivot table which is recently develop in new view. We are able to provide the color classification in Olap Table however i am afraid it is not yet possible in pivot table.Please HelpRegards,Apurva 

301
apurva.patha12
Level 4
sagar.belur
Level 2
sagar.belurLevel 2
asked in General Product Q&A
Process Adherence Manager

Hi,Is it possible to look at the list of Cases in Process Adherence Manager, just like it was in Conformance checker?  Thanks

403
sagar.belur
Level 2
roger
Level 2
rogerLevel 2
asked in General Product Q&A
Count with filter

Hi allI have a very basic question – sorry for that, I’m quite new to PQL and I cannot apply the information available online (or did not find it).I have two tables incident_CASE with column CASE_ID (1-side) and workorder_CASE with column WORKORDER_ID (n-side) (1 incident can have 1 or more workorder).How can I count the following:Number of incidents with exactly 1 workorder Number of incidents with 2 or more workorder Many thanks for your supportBestroger

641
S
Celonaut

Badge Winners

  • Qualified to Prove Celonis Value
    Pablo MChas earned the badge Qualified to Prove Celonis Value
  • Qualified to Identify and Drive Opportunities
    Pablo MChas earned the badge Qualified to Identify and Drive Opportunities
  • Celonis Certified Data Engineer
    muskan.agraw12has earned the badge Celonis Certified Data Engineer
  • Qualified to Build Analyses
    Thomas Pophas earned the badge Qualified to Build Analyses
  • Qualified to Get Data Into Celonis
    raghav.pareehas earned the badge Qualified to Get Data Into Celonis
VIEW ALL
Community Code of Conduct