Product Q&A

Hi, I have one chart and in this chart I do have one dimension which is showing countries. Also, I do have one metric which is showing Automation Rate.Dimension/Country names are A-B-C-DMy need is that I need to combine A-B-C into A so in the end I need to see A-D with their Automation Rate.How can I make it? What are the ways that I can follow into Studio?

Hello everybody,I have a filter bar in which I have inserted a quick filter component containing quick filters on 9 different Boolean fields.Technically it works fine, but the problem is that the visual rendering is awful as I cannot increase the height of the quick filter component and all labels are truncated and incomprehensible, as in attached screenshot: Is there a way to increase the height of the quick filter component so that the filters can be grouped and displayed on multiple lines? Thanks to everybody who can help me, best regards,Andrea

Hello, I'm using the views in the studio for the first time. The old version allowed you to make a selection (see screenshot below). Is it possible to do the same thing in the new version of the studio? Thanks for your help

Good day everyone. With Analysis one could export the KPI's on an analysis into a document - is that possible for Views? I am using the old views?

I have 2 tables connected with each other. From table1 when I select Current month value in drop down. I want to sum the balance column values from table2 where month value is selected month value - 1.

Hi Celopeers,I would like to set-up a live connection with Informatica for fetching data for Celonis. What would be the best way to go about it?

How can i send the csv through action flow while using the smart sensor?

Is there a way to extract data from image or PDF and relate it with respect to the document number and We need to visit external URL and provide the document number. Each document will have its attachment which can be in PDF/Image format. We need to extract data from PDF/Image and prepare a table of the details (tabular format output) This table needs to be push to backend data model. Overall, we want to extract data from image/PDF relate with the PO Number/Accounting document number and push this data to backend data model.

I cannot utilize SCIM API in my environment, and as far as I am aware, other APIs (Audit logs, Platform adoption...) have different uses.

The idea is to have a script that automatically downloads a json file with the list of members of the Celonis environment through the Members API (/api/external/members). I have the following code: url = ""api_token = ""key_type = "AppKey" headers = { key_type: api_token, 'User-Agent': 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/128.0.0.0 Safari/537.36',  'Body-Type': 'application/json', 'Accept': 'text/html,application/xhtml+xml,application/xml;q=0.9,image/avif,image/webp,image/apng,*/*;q=0.8,application/signed-exchange;v=b3;q=0.7'}response = requests.get(url=url, headers=headers) This code always returns <Response [403]> (Access denied). However, the api key I'm using works perfectly in the Swagger UI webpage, being able to download the json file without any problems. I wrote a ticket to Celonis support and they told me it's possible to p

Hi all,I want to extract data from a table in the schema explorer, which is loaded via an extraction, the standard way is to do it is by loading the table into datamodel and pulling the data from the datamodel using pycelonis as mentioned in the pycelonis documentation I am curious to know if there is any other way to do it without loading the table into datamodel (via the schema explorer if possible)

HAs anyone tried moving Data ingestion and transformation out side Celonis like in Azure DB or Google Big Query?and what is the Pros and Cons in this approach

Is there a way to only publish Knowledge Model asset objects, not the whole Knowledge Model asset?

Hello everyone, I want to send out every Monday (e.g. 12.08) all data records (e.g. deliveries) for the next workweek (19.08-23.08.24). I think I haven't found the right functions yet, therefore cannot wrap my head around how to implement this. Does anyone have an idea how to filter the data like this? Thank you! BRJulia Bauer

Hello everybody,I have a data model in which I need to manage one of the case attributes that can have multiple values simultaneously for a single case (i.e. a multi-value attribute) and I am wondering about which is the proper why to model it. In other DBs and DWHs, I usually model this situation with an additional table linked to the main master data with an N:1 relationship (N records for each master data record), but if I do such thing on Celonis and then connect the master data table to the Activity Table with a 1:N relationship (N activity records for each master data record), when I try to display the Throughput Time by the multi-attribute values, I get the infamous "No common table could be found" error message. Which is the recommended way to model multi-value attributes in Celonis data model creation? Thank you, best regards,Andrea

Would like to add fields from the AR_KNVV_KNVP_PA002 in an OLAP table along with fields from the BSEG table. However, have the error below - will the PQL functionality BIND ( ) work here?

In my output (OLAP) table I want to have each activity name from the activity table and then an overview of the number of cases in which that activity name has occurred. Then I want to get an overview of the number of cases in which that activity name has occurred two times, three times, or multiple times etc.  I know that with the following code I can get the number of cases where the activity happened at least 1 time, but I do not know how to calculate the number of cases where the activity happened 1 time and not more often.  SUM(CASE WHEN INDEX_ACTIVITY_TYPE ("ACTIVITY_TABLE"."ACTIVITY") = 1 THEN 1 ELSE 0 END) The other thing I still miss is how I can calculate the number of cases in which that activity occurred >=2 times. When I change the formula to >=2, I get the wrong count as then a case with 4 activity occurrences is counted as 3 instead of 1 (it counts the second occurrence, third occurrence and fourth occurrence all as one 'case'). Is there

Hello together, I want to build a dynamic filter that can vary depending on when a particular button is clicked. This means I write a variable and update it depending on the button. The filtering also depends on this. Unfortunately, I cannot use the variables created in the view as input for the filter.  Specifically, I have a button called “Process start” and one called “Process end”. Depending on what was clicked, the start of the process in the filtering should not be longer than 12 months ago, or if the end of the process was clicked, it should not be longer than 12 months ago. I'm using this for a diagram. Unfortunately, the dynamic variables cannot be used in filtering.  Does anyone have an idea? I'm really desperate. Thank you very much and kind regards! 

Hi all, I want to update the value of a runtime variable with a Button input from a View (JAB) in order to use this runtime variable for a KPI with a PQL Statement inside a knowledge model .But I can't find the runtime variable in the 'update variable' selection of the button. Any Ideas how I can dynamically update the runtime variable value from a View?

GRIR Analysis Value Quantification Is there any Business Case Where GRIR Analysis Value Quantification is a Tangible Outcome? - E.g. P&L, WC Type impact apart from Productivity?

Debit Balance Analysis. Can anyone provide any UI/UX parameters which was deployed across their AP Analysis? Any wireframes which i can refer?

Hi,   I have two questions;   -I created variable into the KM but I cannot see them in the View Asset to be used -I have Input dropdown in the View asset and I want to assign user selection into KM Variable; is it possible?  

I have created an activity table with 5 activities,i also created the change activities by joining both activity table and change table,but when i use select distinct activities from activity table im getting only 5 activities,i want change activitis also

If FIRST(column) would return the first element and LAST(column) the last one, I would like to obtain the n-th element of that list. There isn't a straightforward function to do that but is there a way?

WRONG Name: PRIYADASHINI RCORRECT NAME: PRIYADHARSHINI R