General Product Q&A

How can I Merge the 2 tables (Paid invoices and Unpaid invoices) to one main case table. After uploading the above files.

Automatic tailoring of PQL queries using Static PQL checks (2024-08-28) You can now write PQL queries that run based on the outcome of one or more data model conditions, such as the data type of a column or the existence of match list elements in comparison operators. Before your query is run, Static PQL dynamically checks some properties of your data model and modifies or cancels your PQL query depending on the outcome of these checks. This lets you define business applications that can be used with a range of different data models, helping drive standardization. For more information, see Static PQL functions.

Create templates for your object-centric transformations (2024-08-27) You can now set up a template containing an SQL query, and use it to create the transformations for many similar object types or event types. Templates are especially useful if you are modeling multiple flavors of the same event (for example, delivery dispatch by different shipping methods), or if you are transforming data from multiple data sources to create the same objects or events. When you're creating a transformation for an object type or event type, you'll now get the choice to use one of your transformation templates. There's a new Templates tab in the Transformations area of the Objects and Events environment, where you can create, edit, rename, and delete your transformation templates. You can also see the transformation instances that you've created using each template. The list of transformations in the Transformations tab tells you if a transformatio

Automatically handle source system data issues for object-centric process mining (2024-08-22) When you enable a process from the Celonis catalog, you can now choose to skip missing data from your source system. If you enable this feature for a data connection, we'll handle these issues:If your source system data is missing columns that the Celonis object types and event types require, we'll skip over them. Your objects and events will be created with null values in these fields.If your source system data has data types for required columns that don't match those expected by the Celonis object types and event types, we'll cast them to match the expected data types, and use that in your objects and events. You can activate the feature when you create a new connection or at any time afterwards. We’ve disabled it by default for your existing data connections, but you can activate it for them if you need it.

Optionally extract non-populated columns with Oracle Fusion BICC Extractor (2024-08-22) The Oracle Fusion BICC Extractor didn't previously extract columns marked in the metadata as "isPopulate": false (non-populated columns). You can now choose to extract these as well by selecting the new extraction parameter Include Optional Columns during column configuration. When you do, we'll add the optional columns to the display and include them in the extraction by default. This can add a lot of extra columns, so we recommend you also select Customize Column Selection, then go through the updated list of columns and uncheck any that you don't want for your business case. For the extractor instructions, see Oracle Fusion Cloud BICC. The BICC Ex

Create object types and their transformations from source system tables for object-centric process mining (2024-08-21) Instead of modeling an object type from scratch, you can now choose to create it based on a table in your source system, with columns from the table becoming attributes of the object type. When you use this method, we'll create a preview of the object type where you can select which columns you do and don't want to turn into attributes. You can rename the object and its attributes (by default we use the table and column names). You can also add extra attributes for data in your table or outside it. When you've finished, we'll create the object type, and you can choose to also have us autogenerate the SQL transformation scripts for it. The autogenerated transformation contains the SQL statements that you'll need to populate the object type’s attributes with the data from your source system table. You'll need

Extend Celonis event types with attributes and relationships for object-centric process mining (2024-08-20) You can now add custom attributes to event types from the Celonis catalog, and create custom event to object relationships using them. The event to object relationships can be to custom object types or to object types from the Celonis catalog. So you can now leverage both the ready-made object types and event types to create customized processes. If you've already created custom event types to replace Celonis event types, consider customizing the equivalent Celonis event types instead. Using the Celonis object types and event types means you don’t need to reproduce attributes, relationships, and transformations that we already created. It also means you'll stay up to date with the requirements for the Celonis apps and features that are built to use our standard objects and events. You can customize app views and logic to incorporate y

RFC Module 3.9 (2024-08-19) With the 3.9 version of the RFC Module, there's no need to create a directory on the SAP file system to store extracted data temporarily. The new extractor uses a staging table within the SAP application database for this purpose. This updated architecture offers a simplified setup and improved reliability. For more information, see RFC module.

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

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 mainta

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 colu

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 downl

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