Product Q&A

I am trying to configure a comment component in the new views. I followed all the steps in the documentation but it is still not working. Is there additional documentation or other steps to configure the component that is not in the documentation?

I have number of files in pdf/word format. These are POD/BOL for an individual lineitem. I want to create a new column called as attachment where these files such as POD/BOL are available as hyperlink. Fileformat is in InvoiceNumber_BOL.pdf or InvoiceNumber_POD.docx . Is there a way to automatically attach the document to a particular line item and show as hyperlink.

I just want to understand what are the limitiations you may have faced while using a MEL model. Alos is it eveb a good option to use Multi-Event Log and are there any alternatives for the same ?

I am trying to add Custom object to the perspective without linking it to any object. Similar to currency conversion object. Table/Object that i am trying to add is TFACS for Workday Calendar, But result in below error.

We are using File upload data connection. I forget the datatype of column, so can anyone help in writing query like how I can find the datatype of column.

I was under the impression that Task Mining has this capability and, EEK, I found out differently just days before closing this deal. Please answer quickly as I need an answer tomorrow, if possible. If you can give me maybe the cost per invoice, that would help.

I'm looking at the IM started kit and excessive inventor. I see "Active Stock is defined on a SKU level, and is calculated by taking the the ratio between Target Stock and Actual stock." How do I see what the target stock level is to better understand the calculation?

Hi all, Question related to variables and images. The Image component works with a http URL as the input; I am attempting with not much luck to make this image interactive with input dropdown filters which are linked to a variable. Then editing in the YAML editor to insert a case when statement that would point towards a different image URL depending on the selection.  As mentioned I'm not having much luck on this and wondered if this was possible or anyone has dealt with this before?  Thanks in advance!

Hello All, I want to check of the fourth character in a phone number and make sure it's / and also make sure the 8 character is a dash - How would I do that? Example 314/789-9696

Hi, As title, in the new view, can you create a stacked column and line graph?  Can it be implemented into components? Best RegardsSew

Hi, is there an overview somewhere of process-orientated KPIs that are frequently used in purchasing? Of course I know the procurement starter kit, but is there any documentation beyond that? Thanks in advance! Best, Jonas

PQL - I am trying to find duplicate phone numbers within my table. Does anyone know how I can write this PQL?

Hi Community, I am trying to Identify the Cases PRs without PO (And POs Without PR) in my OCPM Procurement Perspective, But i am not able to add a filter, I tried it through Activity and Attribute selection but it is not working (Giving no Values when I Select a Blank PO / PR).  The idea here is to select the Backlogs ( PRs without PO ) and Deviation (POs Without PR), If anyone explored this part in OCPM give me suggestion how i can resolve this.. This i am trying it through PO Item Object and PR Item Object. Attaching Few screenshots below Without Selection Selection of Blank PRs Selection of Blank POs

Hi,I created a Knowledge Model. Then, on top of it, created a view, which is working good in studio. I published it. But, when i am looking that view under Apps, I am getting the error as " This component has been misconfigured. It can be fixed by people who have access to Studio" - I am not sure what that misconfiguration is. Can some experts please help me ?

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 transformation was created from a template, and you

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. Skipping missing data lets your transformations run with errors, so

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 Extractor is in Limited Availability status. To get access as an early adopter, ask your Celonis point of contact. 

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 to add SQL statements to identify the

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 your custom attributes and relationship

Removal of SAP on-premise extraction (OPE) client for data integration (2024-08-20) We removed the SAP on-premise extraction client from the Celonis Platform Download Portal on 2024-08-20. While any OPE instances that are already in use are unaffected, you now won't be able to set up a new SAP extractor or upgrade any existing SAP extractors. From 2024-08-20, you should use our on-premise client (OPC) instead. For information about accessing the OPC, see Installing on-prem clients. For information about the benefits of using OPC, see On-premise clients (OPC).

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.

Improved augmented attribute creation flow in Studio (2024-08-19) We've improved our augmented attribute creation flow, making it easier to select and configure different data types. Augmented attributes are a Knowledge Model (KM) asset that can be updated in real-time and without the Data Model reloading. By assigning an augmented attribute to a specific table in the Data Model, you can add additional information to the source system. This additional information can then be referenced in your Views, describing your business objects in further detail and generating additional process insights. To learn more about creating and using augmented attributes in your Studio content, see: Augmented attributes.