Product Q&A

Hi all I have a fairly common question I believe:I have a linked View which focuses on one single instance of object. This has two augmented attributes: status and freetextfield of reason. The View has an ID variables (and filters) to narrow down on exactly one object. Now I am only aware of updating augmented attributes via a table and a row. But I would rather use a more userfriendly way of a Button + Input Field to update the Object characterized by the ID.  Does anyone have a similar setup and a solution on updating Augmented Attributes via anything else but an OLAP Table? I could imagine an Action Flow and passing in the ID, but I am unsure if its possible to trigger one via a Button Component.

I tried it already with the Extractor Builder and a "Basic Authentification" but it didn't work.

Hi,Is there any way for a team admin to extract/gather view statistics for analyses and views?Ideally - event logs with events like object (analysis/view) + timestamp when it was viewed. Also it would be great to have user as well. The goal is to get an objective picture of how often particular objects are used instead of interviewing the users.For example, users say: "We use this report every day!", but you look into the stats and see that this report is open once per week/month. Therefore, maybe smth can be done to improve user experience. Thanks in advance!

API to extract and push it to data pool, so i can build an analysis for visualization. Right now i am manually exporting to Excel and uploading it into to a data pool and then to Data Model. Have a visualization on top of it, so it is too many manual tasks, trying to automate this. ThanksMuthappan

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 statment for BKPF I am not able to include fields from BSEG. evean after using joined configuration. If you have any suggestions, I would be very greatful!! BR,Magda

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!

(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