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

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.

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, 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?

(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, 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

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.

is not working for me, I'm not sure why? Do I have to keep in mind which using it or are there any conditions to use it?

may I know what is the definition of case selected on top left of the analysis and how can it be determined?

Hello everyone,  I am using Throughput time search to get the time between 2 activities excluding weekend days and I got the values. I wanted to verify this, so I calculated these data through an OLAP table and the data are the same for each individual case.  The problem is that the average number for a set of data is different.  I chose 4 cases in the OLAP table together and I noticed that the graph selected 6 cases or more and that is why the graph gives different total avg.  Can someone advise about the possible cause here so I can deepened on the graph since it is much easier and faster in the analysis Thanks    

Hi, I would like to set up a connection with an Azure data lake consisting of same parquet files. Does anyone know which data connection to make and with which settings?

Hi, my one data model is failing with this error: The Data Model Load experienced an issue loading to the PQL Engine. Celonis Support ID: b9be2416-8fc9-4d33-a121-0e8fa013da32 Is there a problem in Celonis or in my data model?