General Product Q&A

FILTER ANALYSIS VIA ACTION ENGINE ACTION FILTER "BKPF"."BELNR"=${Document Number} ERROR:Operator requirements are not met. Comparison operator = (equal) does not support comparing column ["BKPF".BELNR"] of type [STRING] with constant of type [CONST_INT]

Hi all,  I'd like to find where can i add the subscription setting when I failed my data job.I haven't activate data job alerts setting but some of user getting the mail notification. (It might be user private setting but I cant find it.) Thx

Hi, In TryCelonis, I could see lot of Demos. But I would like to see the YAML code behind those dashboards. Please let me know how can i see them?

Is it possible to use the Conformance Checker on only a certain part of a process?

Hello guys, i would like to put a drop down in my reports with the opportunity for the users to switch between light and dark mode. How do I do that? Has someone practice in this topic? Maybe a pql code or something...

What functions can Celonis achieve

hi all, now iI'm looking for text mining module if celonis has. Ｉknow pycelonis but it might take time to dev so please let me know if we have reusable one. just I'd like to do word occurence analysis. i don't need so complicated one.

I have one Main button dropdown to select dimensions(dimension 1 and dimension 2). There are two other different button dropdowns (First and Secondary Category) to retrieve values from the main Dimension for benchmarking purpose. When I select dimension 1 as main dimension and even before selecting the First Category, the process explorer and the other Single KPIs displays empty. Is there any way to populate default values even before selecting the dimensions. Please see attached for more information.

Hi, in an action flow I try to make a connection with our UiPath RPA Orchestrator to start a job there. Because we use the on-premise version on UiPath I have to setup the connection like below. I filled in all details and I requested our IT team to whitelist all Celonis IP addresses on this webserver, but still it is not working.   Does anybody has experience with this connection or maybe has an idea what is going wrong?  Many thanks in advance!Albert-Jan

Hello all,  I keep getting a 403 error when trying to access my knowledge models via the Intelligence API. The App Key is marked as used within Celonis & authorization works.  I have set the required permissions for the App Key. I am trying to access an app that is currently hosted in our sandbox - is that the issue?  Any help would be highly appreaciated.  Best Johannes

Good day, can someone help me with a component filter if I want to filter on a case count for a certain time for yesterday, for example what is the total cases yesterday at 15:30. Thank you

Is it feasible to create variables in Skills to archive the selections' hierarchy? or Does using augmented attributes make it possible to accomplish the same thing? Please help me with this. Appreciated and thank you

how can we write a Pql Statement to count the total cases which passing through the Activity

Good afternoon, among the best practices suggested by Celonis, there are: Scheduling Full Loads if delta loads are not possible or if source tables' metadata are changed frequently (i.e., a column is added or deleted).Extracting only the relevant columns of the source tables (i..e, those actually used in the transformations). If the relevant columns can't be deleted or changed in the source systems (because, for instance, they are crucial for the business and it would be a disaster to change them for the data recovery!), why should I schedule full extractions to consider metadata changes? Shouldn't I launch them only manually when columns need to be added to the extracted tables? Moreover, if the answer is in the documentation, could you share the link? Thanks and regards,Simone

Hi all,  I would like to execute a skill with two variables. Is it possible to set the value of one variable with a kpi from the knowledge model? Thanks and kind regards,Sarina

We would like to connect to SAP Succes Factor but we don't realy know anything about this system. Is there anyone who has some previous experience about this system? Is this an oracle or some kind of other Database? How to connect to it with Celonis?

I know that you can convert dashboards to PDF using Action Flow.Is there any other way to link the PDFs, such as storing them in a designated folder, without having to link them via email?Our company uses MS365, and since it cannot be linked with external applications, we are considering alternatives.Please give me some advice.Thank you.

A client is interested in process mining for PeopleSoft and Accounts Receivable. Is this feasible in Celonis? Any major barriers that I need to be aware of? Thanks for any guidance.

Hi Community, Can any one tell me about value realisation? does celonis offers any course on value realisation? If yes, what are the courses I need to undergo to understand value realisation ?

Hi Community, How can we back up all the work done in Celonis (Analysis/view/knowledge model/Data model/transformation)? and how do we view all the analysis once the license gets expired?

i want change the dimension of olap table using dropdown in views, How to display name like display name in dropdown in views

The overview is currently in a simple analysis table but we can migrate it to views. The user should be able to jump directly into the case in the SAP ERP by clicking the case in the view. Has anyone done something like this or could you point me at how to tackle this use case? Thanks! 

I am trying to screen the cases where we set order block and immediately release without any activities in the middle. The idea is to calcuate how much time we wasted on those cases. To do that: In the activities table, I want to partition along column "Change_to" in such a way: When "Change_from" = 'ZA' (which incdicates release of block)Then look at the immediate preceding rows: if the column "Change_to" = 'ZA' (indicate set block)  Then calculate the datediff between those rows. This is my code: SUM( CASE WHEN ("_CEL_O2C_ACTIVITIES"."CHANGED_FROM" = 'ZA' AND ACTIVITY_LAG ("_CEL_O2C_ACTIVITIES"."CHANGED_TO", 1) = 'ZA')  THEN  DATEDIFF ( MI, ACTIVITY_LAG("_CEL_O2C_ACTIVITIES"."EVENTTIME"),"_CEL_O2C_ACTIVITIES"."EVENTTIME")END) It seems that the above code just ignore the bolded part in the casewhen statement. It calculates the datediff even when