Skip to main content

Unanswered Questions

24
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.

806
S
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.

151
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.

151
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 

122
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

212
Chethan Shetty
Level 3
Leslie Lei
Level 2
Leslie LeiLevel 2
 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

434
joaocarlos.macie
Level 3
sneha
Level 3
snehaLevel 3
 Celonis Academy Group
process mining digital badge

hey,i completed the whole module in process mining but didnt recevied my certificateplz help me in solving this problem mail id :- snehachanna1125@gmail.com,thank you,sneha.

322
Nicole Wendler
Celonaut
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

283
sagar.belur
Level 2
roger
Level 2
rogerLevel 2
 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

411
S
Celonaut
TheoM
Level 2
TheoMLevel 2
 Celonis Free Plan
How do I access the Celonis Free Plan platform ?

Hello, I’ve registered today to access the Celonis Free Plan demo platform (with demo data, etc), but I can’t seem to find the link needed to get to it. I’ve tried using https://id.celonis.cloud/ but it only gets me to a User Management screen. Thank you

71
S
Celonaut
michael.hamme13
Level 2
michael.hamme13Level 2
 Data Ingestion & Infrastructure
Connect MongoDB – Database Type Issue

Hi everyone,I’m trying to connect MongoDB to Celonis. At first, I assumed that I’d need to use a custom JDBC driver (based on a thread that I’ve read here and the Celonis documentation).However, when I reached the step to select the “Database Type” in the connector, I couldn’t find a fitting option for MongoDB.Has anyone successfully set this up?Should I use a specific Database Type in this case? Or is there another workaround to get MongoDB connected?Thanks for any tips or guidance! 

161
janpeter.van.d
Level 8
R
Level 2
raluca.wurziLevel 2
 Process Improvement
Scripts for Infor-ERP system

Dear Celopeers, We already extracted the relevant tables from the customers system. Nevertheless, as the cutsomer is using Infor, we are lacking the expertise with this software.Are there any scripts available which we can use in order to facilitate the next steps? Thank you! Kind regardsRaluca

82
janpeter.van.d
Level 8
kazuki.sugiy12
Level 2
kazuki.sugiy12Level 2
 Data Ingestion & Infrastructure
Silent Installation and execution of Task Mining

Hi, we’re planning to use task mining for one of our customers.Would it be possible to install a desktop application on employees’ laptops without them noticing?Also, once the application has been installed, can it be run silently so that employees are not aware that they are being monitored?

131
julia.bauer
Level 5
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

284
julia.bauer
Level 5
jagjeet.singh12
Level 2
jagjeet.singh12Level 2
 General Product Q&A
Duplicate Vendor/ Invoice Identifier

I would like to understand how we can leverage Celonis functionalities to identify duplicate invoices or vendors. What are the different approaches available in Celonis to achieve this

101
asdfg
Level 3
Robin Böhler
Level 2
Robin BöhlerLevel 2
 Process Analysis
Capturing User Filters in Action Flow for Excel Export

We are currently looking for a way to capture the filters applied by a user and include them, along with data from tables, in an Excel export triggered by an Action Flow.However, we are currently unable to access or retrieve the filter information within the flow.Has anyone developed an approach or working solution for this scenario? Any help or guidance would be greatly appreciated.

222
Robin Böhler
Level 2
mukesh.gupta11
Level 4
mukesh.gupta11Level 4
 Data Ingestion & Infrastructure
Does anyone have the steps to do the data integration with the Dynamics 365 for order to cash process?

Does anyone have the steps to do the data integration with the Dynamics 365 for order to cash process?

23
asdfg
Level 3
herique.sarme
Level 3
herique.sarmeLevel 3
 General Product Q&A
IML function error in Get Rows action flow trigger

Every ‘Get Row’ module suddenly stopped working, all at the same time… Has anyone ever seem this error message before? What does it mean? How can I prevent it from happening again? Error: Cannot initialize the scenario because of the reason 'Failed to compile IML function 'functionToDeleteSecond'. Unexpected identifier 'is''  

161
N
Celonaut
SHASHANK
Level 2
SHASHANKLevel 2
 Celonis Free Plan
Request for Re-attempt of Rising Star Program Business Assessment

Unfortunately, despite my strong dedication to completing the program successfully, I have encountered some challenges that prevented me from obtaining the certification. My first attempt at the business assessment was disrupted due to an unexpected technical issue during the exam, which caused me to lose that opportunity. In my second attempt, I unfortunately did not pass the test. As a result, I currently remain uncertified, which is disheartening given the effort I have invested throughout the program.WHAT SHOULD I DO NOW ?

342
Sumedha Sen
Level 2
manuel.wetze
Level 5
manuel.wetzeLevel 5
 General Product Q&A
How to analyze User behaviour within Views for UX improvement?

Dear all,I was wondering if there are any approaches on how to measure how endusers are actually using the dashboards. With the purpose of improving usability.Does anyone have any approach on how to do this within the platform or by any workarounds on logs or even third party tools? Do you have any other appraoch to determine what the user really needs? Example key question would be:Which views get accessed how often?Which tabs get viewed how often?Which filters get used?Context: Naturally when developing custom dashboards you are implementing a lot of small requirements and end up always adding more functionally and therefore complexity. To have an aggregated analysis on how the users navigate a series of linked dashboards would help to remove less frequent used parts. 

182
S
Celonaut
J
Level 2
jacob.visse14Level 2
 General Product Q&A
I am using the " target=_"blank" statement in a text button to open a new tab with a link to Celonis documentation. But it opens in the same tab as my analyses. How to solve this?

Below an example of the code I am usingFor detailed information go to Celonis info page:<a href="https://docs.celonis.com/en/process-ai.html"target=_"blank"> Process AI</a>

155
milan.eric
Level 3
andres.naran12
Level 4
andres.naran12Level 4
 Data Ingestion & Infrastructure
How to get KPIs values through PyCelonis?

Hi everyone, some months ago, I faced a challenge related to getting variables from a view using PyCelonis. Today I have another challenge where I need to get the result from multiple KPIs and send it back to the data pool.At the beginning, I used the module “Get Rows” from action flows, and I was able to get the values from each KPI. However, in some KPIs, the values that I’m getting inside actions flows, are completely different from the ones that exist in an OLAP’s table where those KPIs are being used. I don’t understand the reason for this, so I was thinking of a workaround solution with PyCelonis, where I would get the values from each KPI and create a dataframe that can be sent to the datapool.I can see in the documentation that we can get the values from records, but only of those records that exist in a data model. But I cannot see in the documentation how to deal with KPIs.Does anyone know if is there a way to get the value of multiple KPIs with PyCelonis, pls?

120
andres.naran12
Level 4
fabian.altendorfer
Level 3
fabian.altendorferLevel 3
 Process Analysis
Is it possible to open link to view with filter in link parameter?

Hi, I would like to link from a dashboard to a View with Process Explorer. In the dashboard, an object is selected and I would like to give the object identifier with the link to celonis, so that I can filter in the process explorer based on that (so that I only see this individual object and it’s event log).Is this possible to achieve with a Celonis View?Many Thanks,

71
julia.bauer
Level 5
A Rab
Level 2
A RabLevel 2
 General Product Q&A
Executing Data Model Schedule from Action Flow

Hi,Do you know if there is a way to execute an already exist Schedule in the Data Model from the Action flow. I have an Action Flow that updates some fields in the source system, and I want the data jobs (extraction, transformations, and data model load) to be executed as the last step of the Action Flow, so the updates will be available in the dashboard as well. Thanks.

211
julia.bauer
Level 5

Badge Winners

VIEW ALL
Community Code of Conduct