General Product Q&A

Hi all in Analysis I can create a Variable using a PQL statement (A static value). How do i do this in Views?

Do data permissions affect pu functional data??

I need to select every black item in a filter, but when I use the "Select All": every gray disabled items + black items are selected.  I know that the gray ones do not change the report. The idea is to filter the report on a specific way so that I can get some codes in the filter in which I am trying to do this "trick". These codes are the ones in black, and the rest of the codes that have been filtered are the ones in gray.  Once I get to this point, I need to remove every other filter from the report, but maintain the previous black codes filtered. For example, if I want to get the journal entries that contains an entry with the account "xxxxxxx":I need to filter the report by account = "xxxxxxxx".Then I need to filter the report by the "black" journal entry numbers in the Entry Number filter.Finally, I need to remove the Account filter and maintain the black entry numbers in the Entry Number filter. Do you know how to achieve this? C

I am trying to make a dashboard to identify bottlenecks in the process. I already make use of the Celonis Process Overview page which can identify which activity flows impact the TPT, but it is not sufficient for me to detect the most important activity reworks or activity flows that impact TPT.  What would be effective ways to use Celonis for such application? Is there a way to identify which activity flows impact TPT significantly? E.g. a process flow normally goes through activity A-->B, but if it goes from A-->C-->B it increases TPT by 'x' days. Thanks!

Hi, I am not able to upload excel file which is having around 20 MB with .xlsx extension. My colleague who has same permission is able to upload though. I am wondering why it is happening? Is there any restriction to upload excel file? Thank you

Hi everyone,I'd like to calculate the workDay between two date, considering national holidays (in my case Italy). What is the best method?I was thinking the combination o WORDAYS_BETWEEN and WORKDAY_CALENDAR PQL function, but I really don't know where to find a TFACS calendar for Italy (or a TFACS calendar in .csv that I could edit). Does someone have a solution? Thanks

We are trying to create a dynamic olap table in new views.Requirement is we have 20 columns in a table.in summary olap we need to show only 5 columns.in details olap we show all 20 columns from the same table.currently we have created 2 olaps in new views.the user does not want multiple olaps but needs a solution where there will be a radio button/dropdown with 2 options: summary & details. on clicking any of them the same olap will display 5/20 columns on the same olap.there is no option to show/hide olaps columns based on variables etc. I tried with creating an enhanced variable inside the view & also inside KM.I added a popup button where on changing the button options i set the variable to boolean true & false .Then i set the hide attribute in the table column's yaml code with the boolean variable.Even though the variable is changing on selecting the popup options - i dont see the column hiding/showing accordingly. Its not dynamically changing.

I have gone through the Celonis documentation but it only speak about connection through front end(action -flow) but there is nothing mentioned about connection in bBackend

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?

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?

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?

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

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

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

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 

Hi everyone, I would like to create a color mapping for a KPI in a OLAP TABLE.Each row in the table represents a case, with ID, an attribute from the same table (numeric), and a KPI created on that attribute (also numeric).I would like to color the value of the KPI based on the value of that attribute, for each case. For example, if it is greater in red, if it is less in green.I selected color mapping based on Dimension, and entered the first threshold as in the figure, but it colors everything red, not taking into account the value of the attribute.  Where am I going wrong? Thanks 

I am new user for celonis, I would like to apply for the new account for COTD (Customer order Deliver Delay). but there are so many choice when I raise a support for new count ticket, I am quite confused, where can I get guide or support?