Skip to main content

Unanswered Questions

21
lisaschneider
Level 2
lisaschneiderLevel 2
 General Product Q&A
Issue with PQL to adapt KPI to line chart months

Hi!I’Ve been struggling with setting up the correct PQL for visualising a KPI on a line chart showing a timeline as the formula became quite complicated. Would appreciate any help on understanding what query I need or why it is not working.  The KPI I want to display on a timeline chart is a cancellation rate. The view contains an input dropdown as a variable  ${outlier_analysis_selection_main.pql} which the dashboard should adjust to. The dimensions of the line chart are ROUND_MONTH("CASE_TABLE"."DSL_ORDER_DT").  In the line chart, I already have the overall cancellation rate.This does not adjust to any user filtering done through the dashboard, nor the selection through ${outlier_analysis_selection_main.pql}. I also have another cancellation rate line which does adjust to any user filtering done. I can therefore compare the development of the cancellation rate for whatever is selected to the overall cancellation rate. Now I want to add a line that always shows me the cancellation rat

00
lisaschneider
Level 2
M
Level 2
maxim.vnoutLevel 2
 Celonis Free Plan
Celonis license

Hello,I reached out through the Celonis contact form, but I’m looking to speak directly with someone regarding licensing. Specifically, I’d like to know whether it’s possible to obtain a license and what the pricing options are.Could someone point me in the right direction?Thank you,Max

10
M
Level 2
Leslie Lei
Level 3
Leslie LeiLevel 3
 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

746
joaocarlos.macie
Level 3
Maurits de Vries
Level 2
Maurits de VriesLevel 2
 Process Analysis
How can I create a table from the following code?

I have the following lines of code for which I would like to create a table in which we see the total amount of transaction codes, another column with total amount of transaction codes per company code and the amount of transaction codes as a percentage of the total transaction codes, per company code.In the back end I have managed to write these codes, however, because of a lack of the 'Over' function I can't seem to be able to make it work in the front end. These are the codes in question that are currently working in the transformation scripts ( back-end ):select TRANSACTION_CODE,ACTIVITY_EN,Company_code,Count(TRANSACTION_CODE) as count_tcode,SUM(count(TRANSACTION_CODE)) OVER(PARTITION BY Company_code) AS total_per_Company_code,ROUND((count(TRANSACTION_CODE) * 100.0 / NULLIF(total_per_bukrs, 0)), 2) AS percentage_per_Company_codeFROM _CEL_AP_ACTIVITIESGroup by TRANSACTION_CODE,ACTIVITY_EN,Company_codeHow would you go about creating a PQL script that could tackle these lines of code

90
Maurits de Vries
Level 2
pavan.bhara13
Level 3
pavan.bhara13Level 3
 Data Ingestion & Infrastructure
Microsoft Entra authentication

Hey everyone! Has anyone tried using the Microsoft Entra authentication to create a connection between Microsoft SQL and Celonis? (https://docs.celonis.com/en/connecting-to-microsoft-sql.html#UUID-9e582e53-55d8-d3e9-7b6c-1e122f4219d9_section-idm4544307539120034248385337057)We are trying to enable this and Celonis Help source documentation we stumbled upon provides how an Entra authentication works (https://learn.microsoft.com/en-us/sql/connect/jdbc/connecting-using-azure-active-directory-authentication?view=sql-server-ver16) but we miss the steps on how do we set it up in Celonis directly. Any insights on the actual setup would be very much appreciated. TIA! Good day! 

80
pavan.bhara13
Level 3
A Rab
Level 2
A RabLevel 2
 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.

121
N
Celonaut
Leslie Lei
Level 3
Leslie LeiLevel 3
 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?

162
Leslie Lei
Level 3
jan.hagem
Level 3
jan.hagemLevel 3
 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 🙌

150
N
Celonaut
E
Level 3
ewa.aniśkLevel 3
 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?

396
Joe-Hartzel
Level 3
julia.bauer
Level 5
julia.bauerLevel 5
 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
 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!

100
marcelo.ferre11
Level 2
mtucker10
Level 2
mtucker10Level 2
 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. 

90
mtucker10
Level 2
bhargav.bhima
Level 2
bhargav.bhimaLevel 2
 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.

1187
Joe-Hartzel
Level 3
Iori Oshima
Level 3
Iori OshimaLevel 3
 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  

272
caspar.jans
Celonaut
sunnyt
Level 2
sunnytLevel 2
 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
 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
nimisha.devji
Level 2
nimisha.devjiLevel 2
 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
marcelo.ferre11
Level 2
marcelo.ferre11Level 2
 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.

341
jan.vajse12
Level 3
Pruthvin
Level 2
PruthvinLevel 2
 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
 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
sagar.belur
Level 2
sagar.belurLevel 2
 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

Badge Winners

VIEW ALL
Community Code of Conduct