Product Q&A

Hello, We have a python script which is failing in ML workbench giving "running out of memory" error. We received suggestion to run the script on our local server with our own resources. I am out of my expertise here, can anyone suggest how to achieve this. Regards,Tapan

Is there a possibility to integrate data from Elasticsearch(where relevant journey data is present in an index) with Celonis. Also if new data can be pulled via a schedule again if the source is Elasticsearch

Hi there,I was wondering if it is somehow possible to change the decimal separator from , to . and the thousands group separator from . to , I want to use the following format in my Knowledge Model: ",.2f" but with the separators switched. So going form 432,882.35 to 432.882,35Any help would be appreciated.Best regards,Florian

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

Error Function 'getResponseBody' finished with error! Script execution timed out after 10000ms

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?

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?