Product Q&A

For instance, ... 5 WO's have 3 Distinct Claim ID's, 7 WO's have 2 Distinct Claim ID's, and 125 WO's have 1 Claim ID. Thank you ... I am sure this is simple, but I can't find how to do it.

e.g. in schema explorer there are two tables that i want to export the data and put it into another environment.

Hi everyone, I am trying to calculate Automation Rate at Case Level.Within my dataset, each case have more than one activities. And, any of the activity could be either manual or automated. However, in my calculation, if case does have any manual steps; automation rate should be zero. Do you know how can I calculate it as a KPI?

Hi, I have the followng case, where I need to write the same code but in PQL:some ideas needed, I'm trying to implement this in PQL: "tbl_xxx"."date" + COALESCE(CAST("tbl_xxx"."time" AS TIME),'00:00') AS Date_Time As you see, "tbl_xxx"."date" is of type DATETIME, and "tbl_xxx"."time" is of type STRING.In PQL you have to use || instead of +, which only takes STRING, so the "tbl_xxx"."date" needs to be converted to STRING, but the issue is with "tbl_xxx"."time", because it can be NULL... Any ideas. Thanks

We are experiencing issues where a copy of an analysis or data model, when deleted, also deletes the original asset used to create the copy. It seems the copied object retains a link to the original object. Is there a way to create a copy of one or more objects such that the copy can be manipulated without impacting the original? Thank you in advance for your help and support.

Can anyone suggest the best documentation for learning how API's can be used or how custom API's can be built in order to access data regarding different objects in Celonis.

Can anyone help me with this problem, I'm not able to convert this date field in this format to SQL. Does anyone know if I can get this in PQL? Or even in SQL 08-JUL-24

Hi,  Even if I published my Studio package with KM, I am receiving an error at Apps: This component has been misconfigured. It can be fixed by people who have access to the Celonis Studio.How can I tackle this issue?

Hi, I'm getting this error in Open PR app, "Table could not be found. Table with name "PR_ITEMS_CEL_TASK" cannot be found". can anyone please help me with the solution. Thank you

There is 9 similar operations/output from the Array aggregator module inside action flow. How to reduce or remove the duplicate operations from the array aggregator(considering that change is any prior modules not possible but ready to adapt any filters ot add any more modules after the array aggregator module giving 9 similar operations)? Thanks!

Hi team, our business would like to see some historical data from BSEG (as now we have the oldest data from 2023). We were able to apply filter on the extraxtion level on BSEG, that the GJAHR is 2023 OR KOART is equal t specific Account type that they had in mind. This ent through correctly however the analysis is basing on BSEG and BKPF, so we would need to do the same corre ction in extraction filter for BKPF, but unfortunately the field account type is not available there. The question is. Are we able to use field from one table (BSEG) as a filter in extraction for different table(BKPF)? I tried to do that as a join configuration:However it did not work - I did not get any data older than 2023, so I believe this filter applies only to joined table (BSEG) instead of BKPF. In the Filter statm

I need to show a client all available permissions in the platform in order for their security department to determine which user gets what permission. Before doing all this manually, I wanted to know if there is a way to obtain all available permissions in the platform?

I know that a dynamic title is possible by using an attribute. It would be great, if it is possibly by linking to the breakdown selection, too.Please see the screenshot for reference. After 'Cash discount statistics per' the selected breakdown entry should be added to the title.

When selected from dropdown entry the result should reflect in both donut chart as well as in table. Can anyone help me to resolve it?

Column and Line ChartHi, In View, there is a feature that you can split the line by column in the graph. I tried to create the same feature in the New View using column and line chart component. But having no luck! Any helps would be helpful!

Hi, is there a way to see/use autogenerated KPI in the View?

(I know I can make this configuration into OLAP Table; I am looking for seeing this calculation automatically within predefined assets)

Will  Case When var_number IN (10) get the correct result? Thank you.

Hi all, i am trying to build a table and profile view that is similar to the ones that are shown in the celonis demos (table from celonis demo)(profile view from celonis demo) What I am trying to show is some root causes for the bottlenecks in the process and when user clicks on the category, a detailed analysis will be displayed  But im still struggling with the first step which is how do i get to display those bottlenecks in the table, do i need to create a new table just to store those 'inefficiencies'?  Thanks for your help in advance!

Hi, I was working on scripting transformations in OCPM events. I came across a scenario where events having m:1 (involves one) relationship with objects are populating those objects in the transformations as the mandatory field. I could not find these fields in the object table, that made me think that why can't I use source tables here ?

Hi, Can anyone help me with the pql code to BIND to connect the Eventime of the creation of a purchase order and the release date of a requisiton? I don´t get the logic of BIND yet

Hello everyone, I'm intending to send out data to stakeholders (numerous documents to a stakeholder - n:1 relation). I'm using the query module, csv module and the microsoft outlook module to implement it like this. Therefore, the documents will be aggregated on the basis of a stakeholder - this file will be sent out. However, per document, internally, there could be different employees assigned/responsible for those documents. Is it possible to put them into the CC of the mail (sending out to one stakeholder but numerous internal employees that should be notified - 1:n)?  Thank you so much! Best regardsJulia Bauer

Hy,I have connected a skill with action flow using webhooks module and connected a view with that skill.As I wanted that user be able to enter text at runtime, I am getting error if I enter text in next lineThe 'execute action flow' module throwing error as follows

I tried this system. The first module gets all the data from the table to be checked, stores it in an array and then uses the if operator with the contains function to verify the data (CASE_ID) doesn't exist in the array, but this system doesn't work. I end up with duplicates every time because the if function always returns 0.