Product Updates

Applications and Services features released in December 2021 Opportunity Management: Forecast Guidance App v1.0.0 release (06-Dec-2021)Feature ID: OPPY-167/OPPY-168Description: Releases the forecast guidance module as a standalone app; this app helps sales organizations assess their forecast accuracy and manage the risk of forecast opportunities.Documentation: Forecast Guidance  Opportunity Management: Knowledge Model master package v1.0.0 release (06-Dec-2021)Feature ID: OPPY-179Description: Adds a shared Knowledge Model that can be installed as a module and used by all Opportunity Management apps.Documentation: Not applicable. Opportunity Management: Pipeline Exploration App v1.1.0 release (06-Dec-2021)Feature ID: OPPY-181Description: Updates the Pipeline Exploration app to use the new shared knowledge model master package.Documentation: Pipeline Exploration EMS Store release (15-Dec-2021)Feature ID: STORE-67, STORE-68Description: Adds a new category filter for Action Flows.Documentation: Not applicable. Feature ID: STORE-75Description: Aids successful app installation by highlighting dependent connectors on the app’s detail page.Documentation: Not applicable. Feature ID: STORE-87, STORE-88Description: Adds a new optional property that allows existing execution apps to use the new shared master knowledge model released on 01-Dec-2021 and display its information on each app’s detail page.Documentation: Not applicable. 

Automation features released in December 2021 Automation release (07-Dec-2021)Feature ID: EMA-209Description: Makes edit vs published mode of Action Flows more easily distinguishable.Documentation: Automation Release 07.12.2021 Feature ID: EMA-530, EMA-691Description: Enhances global pages styling for webhooks.Documentation: Automation Release 07.12.2021 Feature ID: EMA-606Description: Adds an Incomplete Executions tab which allows users to view any Action Flow executions that did not complete successfully.Documentation: Automation Release 07.12.2021 and Incomplete executions Feature ID: PHX-612Description: Adds released augmented attributes which can be updated in real time and do not rely on data model reload times.Documentation: Augmented Attributes  Feature ID: PHX-655Description: Revises the Assignment Rules to improve user experience.Documentation: Assignment Rules Feature ID: PHX-675Description: Adds an inbox which acts as a central location where business users can manage and complete their assigned tasks.Documentation: Inbox Automation release (21-Dec-2021)Feature ID: EMA-653Description: Adds a hint for scheduling in the UI.Documentation: Not applicable. Feature ID: PHX-783Description: Add a visual editor for configuration of the Task List component. Documentation: Task List   

Data Ingestion features released in December 2021 Release 2.47.0 (06-Dec-2021)Feature ID: CE-2189Description: Adds the option to clear the cached metadata for the JDBC extractor, both manually in the data connection and automatically when changing the column configuration. Documentation: Downloads and Version History Release 2.48.0 (20-Dec-2021)Feature ID: CE-2327Description: Adds the status of the uplink integration to the data connection page for all relevant extractors.Documentation: Downloads and Version History Feature ID: CE-2367Description: Provides a new extractor for a sustainability app that uses data from EcoVadis.Documentation: Not applicable.  

Entry Products features released in December 2021 No features added in December 2021.

Machine Learning and Simulation features released in December 2021 Process Simulation release (02-Dec-2021)Feature ID: ECSA01-893Description: Adds new KPIs in the results view.Documentation: Simulation Release 2021.12.02 Feature ID: TM-1636Description: Adds more descriptive error messages in Digital Twin Extraction that help users fix issues.Documentation: Simulation Release 2021.12.02  Feature ID: ECSA01-942Description: Adds a data quality check for the configuration of data models used in Digital Twin extraction and simulation.Documentation: Simulation Release 2021.12.02  Process Simulation release (22-Dec-2021)Feature ID: ECSA01-849Description: Improves user experience for the Branches step of DTE and Scenario configuration.Documentation: Not applicable. Feature ID: ECSA01-863Description: Adds a new onboarding model when a user enters the Digital Twin extraction for the first time.Documentation: Not applicable. Feature ID: ECSA01-959Description: Adds dynamic switching of the time unit for activity-level KPIs in the results view.Documentation: Not applicable. Feature ID: ECSA01-975Description: Changes the order of the processing times and resource details steps in the wizard.Documentation: Not applicable. Feature ID: ECSA01-977Description: Adds a closed case filter field that allows configuration of a filter statement to define closed cases.Documentation: Not applicable. Feature ID: ECSA01-981Description: Adds search functionality for the Activities list in the filters step of the wizard.Documentation: Not applicable. 

Platform features released in December 2021 Event Collection App v1.75 release (06-Dec-2021)Feature: ECUI-153Description: Allows sharing of data from the global scope with other data pools using the data transfer functionality.Documentation: Transfer data between Data Pools Data Lake release (07-Dec-2021)Feature ID: DL-337Description: Adds a timestamp in the _CELONIS_CHANGE_DATE column that indicates when loading to the EMS data lake (Vertica) started; previously a random timestamp was used.Documentation: Change date of an extracted table Data Foundation release (15-Dec-2021)Feature: DFD-255Description: Adds a dropdown list to the Team Settings > License Page that lets admin users select a threshold percentage for APC Consumption and notifies them when this threshold percentage value is exceeded.Documentation: License Event Collection App v1.76 release (20-Dec-2021)Feature: ECUI-333Description: Allows copying of data jobs, including extractions, transformations, local parameters and templates, from one data pool to another data pool.Documentation: Data Jobs Feature: ECUI-334, ECUI-149Description: Extends the data_job_state_updated_events table for custom data pipeline monitoring and allows the export of data from the monitoring pool using the data transfer feature.Documentation: Custom Data Pipeline Monitoring Admin Experience release (21-Dec-2021)Feature ID: PAD-105Description: Allows Audit Logs to be extracted via the Use Audit Log API so CSV files no longer need to be downloaded manually. Documentation: Application Keys 

Task Mining features released in December 2021 No features added in December 2021.

Celonis Advisory - CVE-2021-44228  Dear Customer, Celonis is aware of the recently announced security vulnerability (CVE-2021-44228) within Log4j, a common Java library used by many applications.Since the announcement, our teams have been working to assess any potential impact to Celonis customers, our products, Infrastructure and internal systems. We have identified actions for all customers who are using Celonis products or applications. More information can be found in this Article: Celonis Advisory - CVE-2021-44228 

Change to timestamps in the _CELONIS_CHANGE_DATE column for Celonis EMS Event Collection We’re changing how we use timestamps in the _CELONIS_CHANGE_DATE column for tables extracted during Celonis EMS Event Collection.  Previously, these timestamps were randomly generated and did not reflect the time that loading to the EMS data lake (Vertica) started. From December’s Data Lake Inserter release, these timestamps will indicate when loading to the EMS data lake (Vertica) actually started. If you’re using this column in your transformations, please check your business logic after the Data Lake Inserter release. 

Changes to our release notes from November 2021From November 2021, we’ve changed our approach to release notes. Instead of producing separate release notes for each part of the product, we’re now creating a single, monthly set of release notes to provide a more cohesive view of our new functionality.  What these release notes coverThese release notes contain information about all the new features and bug fixes we released in November 2021. Accessing the release notesYou can access the release notes for November 2021 here. (You'll need to be signed in to your team to access the release notes and links to the documentation.) You can also see the new features for each product area by viewing the November 2021 release information we've posted in each product area. 

Applications and Services features released in November 2021 Opportunity Management: Pipeline exploration app v1.0 release (01-Nov-2021)ID: EXP 1.0Description: Adds six views and a Knowledge Model to provide insights into close rates, born-to-win opportunities and sales cycle durations.Documentation: Pipeline Exploration Opportunity Management: Opportunity management connector 2.7.1 release (15-Nov-2021)ID: DE-86Description: Adds an opportunity-centric data model, transformations and table list and updates extraction and transformation scheduling. Documentation: Data Pools Accounts Payable: Duplicate Checker module v1.0.0_2021_11_15 release (15-Nov-2021)ID: AP-367Description: Creates a new table (GROUPS_DUPLICATE_INVOICES) when the ML Sensor is first run and which is continuously updated (GROUPS_DUPLICATE_INVOICES) and linked to the DUPLICATE_INVOICES table so tasks and augmented attributes can be created at group level. ID: AP-369Description: Changes to the UI based on external and internal feedback. Inventory Management: Control Center app v1.0.0 release (17-Nov-2021)ID: SSC-1021Description: A new app which provides views of inventory management, procurement, production and sales related KPIs and execution gaps at different levels of aggregation and includes a starter kit with pre-built analyses. Documentation: Inventory Management Apps Inventory Management: Inventory Management Connector v1.0.0 release (17-Nov-2021)ID: SSC-1031Description: Adds a new data model, data transformations and extractions.Documentation: Inventory Management Apps

Automation features released in November 2021 Automation release (24-Nov-2021) Feature ID: EMA-553Description: Allows specific URL extensions by making the URL field relative to the system connection defined in the Celonis On-Premises Agent.Documentation: Automation Release 24.11.2021 Feature ID: EMA-674Description: Improves user experience by automatically navigating to the home page of the Action Flows help if a specific help page does not exist. Documentation: Automation Release 24.11.2021  

Data Ingestion features released in November 2021 Release 2.45.0 (05-Nov-2021)Feature ID: CE-2244Description: Adds a new JDBC extractor that adapts the Google BigQuery extraction by removing the ‘order by’ from the SQL query and improves logging for the total count.Documentation: Downloads and Version History SAP Extractor 3.7.0 release (17-Nov-2021)Feature ID: SE-808Description: Adds a system timezone offset to the SAP timezone before CDHDR/CDPOS transformation.Documentation: SAP Extractor new version (RFC Module: 3.1, Extractor: 3.7/2021-11-16) Feature ID: SE-904Description: Adds support for microseconds in Change Log timestamps.Documentation: SAP Extractor new version (RFC Module: 3.1, Extractor: 3.7/2021-11-16) RFC Module 3.1.10 release (17-Nov-2021)Feature ID: SE-877Description: Adds one-click creation of Change Log tables in /CELONIS/CLMAN_UI.Documentation: SAP Extractor new version (RFC Module: 3.1, Extractor: 3.7/2021-11-16) Feature ID: SE-962Description: Adds ‘Check Table’ function in /CELONIS/CLMAN_UI for validation of Change Log tables before creation. Documentation: SAP Extractor new version (RFC Module: 3.1, Extractor: 3.7/2021-11-16) Feature ID: SE-808Description: Adds a system timezone offset based on the SAP timezone for the CDHDR/CDPOS transformation.Documentation: SAP Extractor new version (RFC Module: 3.1, Extractor: 3.7/2021-11-16) Feature ID: SE-904Description: Adds support for microseconds in Change Log timestamps.Documentation: SAP Extractor new version (RFC Module: 3.1, Extractor: 3.7/2021-11-16) Release 2.46.0 (23-Nov-2021) Feature ID: CE-1951Description: Adds the SAP Master Data Retrieval API for Procurement to the SAP Ariba Extractor, allowing customers to extract saved master data into Celonis.Documentation: Supported API Endpoints and available Tables Feature ID: CE-2318Description: Provides real-time connectivity to Azure Event Hub via the new Celonis streaming functionality, allowing retrieval of real-time event data and ingestion into Celonis.Documentation: Not applicable. NOTE: For access to this new connector, contact our Service Desk.     

Entry Products features released in November 2021 TryCelonis release (26-Nov-2021)Feature IDs: NOVA-570/NOVA-623/NOVA-626/NOVA-645/NOVA-652Description: Implements an enhanced TryCelonis portal with an improved UI.Documentation: Not applicable.

Machine Learning and Simulation features released in November 2021 No features released in November 2021.  

Platform features released in November 2021 User Management 1.7.0 release (02-Nov-2021)Feature IDs: PCS-1483/PCS-1543Description: Improves the user management UI in the Celonis ID. Visibility: Free Plan users only.Documentation: Not applicable. Team 1.79.0 release (03-Nov-2021)Feature ID: PCS-1483Description: Adds team logo URL to the identity provider (IdP) team result.Visibility: Free Plan users only.Documentation: Not applicable. Feature ID: PCS-1486Description: Catches SSO runtime errors and presents them as human-readable error messages.Documentation: Not applicable. Event Collection 1.73 release (04-Nov-2021) Feature ID: ECUI-299Description: Adds permission handling in team settings for teams that use Event Collection on premises.Documentation: Event Collection On-Premises - Team Settings Permissions Vertica Inserter 1.31.0 release (11-Nov-2021)Feature ID: DL-363Description: Improves the handling of error messages for transformations in Event Collection by passing additional technical details for Pool Provider errors to the Event Collection UI for display in Data Job logs or directly in the SQL workbench.Documentation: Not applicable. Team 1.80.0 release (12-Nov-2021)Feature ID: PCS-1487Description: Integrates a 2FA provider with the Celonis ID.Visibility: Free Plan users only.Documentation: Not applicable. Feature ID: PCS-1588Description: Activates Content Security Policy (CSP) in blocking mode in team settings in realm eu-1.Documentation: Not applicable. Quickstarts release (16-Nov-2021)Feature ID: DOB-1076Description: Provides support for Oracle EBS AP column name mapping. If the source data uses a different column naming convention (for example, due to version differences in EBS), all columns of the input tables can be mapped to the expected schema. This means tables can also be replaced if they provide the expected data.Documentation: Not applicable. User Management 1.9.0 release (17-Nov-2021)Feature ID: PCS-1482Description: Implements user deletion in the identity provider (IdP).Visibility: Free Plan users only.Documentation: Not applicable. Event Collection 1.74 release (23-Nov-2021)Feature ID: ECUI-191Description: Extends data job alert options and allows notifications for skipped data jobs to be enabled.Documentation: Data Job Alerts Feature ID: DFD-307Description: Provides a new APC consumption service which enables more frequent and timely APC calculations without affecting the APC consumption functionality.Documentation: Not applicable.

Process Mining and PQL features released in November 2021 release-2.35.0 (26-Oct-2021)Feature ID: CPL-4902 Description: Adds the MERGE_EVENTLOG function which creates an additional column containing the name of the corresponding activity table as a string. Documentation: MERGE_EVENTLOG - MERGE_EVENTLOG_DISTINCT NOTE: While the initial release of this feature was in October 2021, it has been included here due to the sequential roll out of customer-facing changes to PQL operators in November. release-2.36.0 (02-Nov-2021)Feature ID: CPL-4694 Description: Adds filtering/restriction of input rows when creating MERGE_EVENTLOG/ MERGE_EVENTLOG_DISTINCT.Documentation: MERGE_EVENTLOG - MERGE_EVENTLOG_DISTINCT release-2.37.0 (09-Nov-2021)Feature ID: CPL-5507Description: Adds ROUND operator which rounds values to the nearest whole number. 

Studio features released in November 2021 PA 1.60 release (15-Nov-2021)Feature ID: DV-3590Description: Allows a custom dimension to be specified in the conformance checker for Process Analytics and Studio so conformance of columns other than the default activity column can be measured.Documentation: PA 1.60 BINFR 2.18.0 release (23-Nov-2021)Feature ID: BINFR-1543Description: Allows editing of an embedded view component.Documentation: Not applicable. Feature ID: BINFR-1658Description: Clarifies relationship between extended and base views and simplifies navigation between these views.Documentation: Not applicable. Feature ID: BINFR-1836Description: Auto-generates variables when creating a profile view so components can be item specific without setting variables manually.Documentation: Not applicable. Feature ID: BINFR-1908Description: Improves user experience by collapsing the YAML component editor by default and therefore increasing the screen space available when creating YAML definitions.Documentation: Not applicable. Feature ID: BINFR-1928Description: Updates YAML component editor so previews reflect the defined layout settings such as background color.Documentation: Not applicable. NAVI 1.26 release (23-Nov-2021) Feature ID: TN-2468Description: Improves accessibility including in the explorer and tree views and in the YAML component editor.Documentation: Not applicable. Feature ID: TN-2487Description: Improves load and save times for visual editors.Documentation: Not applicable. CC 0.32.0 release (24-Nov-2021)Feature ID: BC-2184 Description: Adds search and filter functionality within table columns for string data types.Documentation: Table Column Filtering & Searching Feature ID: BINFR-1513Description: Allows the textbox component to be built using visual editors.Documentation: Text Box Component Visual Editor    

Task Mining features released in November 2021 Release 2.6.0 (19-Nov-2021)Feature ID: FEC-2105Description: Improves set up of the Task Mining Client.Documentation: Task Mining Release 2021.11.19  Feature ID: LIVE-1258Description: Adds SAP integration support for SAP Business Client and improved performance.Documentation: Task Mining Release 2021.11.19 

Ready to seize unlimited opportunities? Visit the EMS Store from your EMS team and discover the different new Apps added every week we are offering to our global customer base made by Celonis and Partners (Accenture, Cognito Analytics, etc).  The EMS Store contains:1) Apps to empower business users to apply data and intelligence to solver specific business problems2) Extractors to create data pipelines between a source system and EMS3) Process Connectors with data extraction with SQL transformation, event logs, data structure and model 4) Action Flows to allow automated actions across multiple applications5) Machine Learning Workbench (“MLWB”) to provide a fully managed data science platform. Visit the EMS Store or find your team.  Newest: Opportunity Management - Pipeline ExplorationThe opportunity management team released the pipeline exploration app in November. Acting as a process cockpit, the app provides users in sales leadership and sales operations insights into their past and present pipeline. Users can, for instance, analyze their close rate, sales cycle length, and born-to-win opportunities across different regions, industries, or sales motions. The benchmarking tool further allows them to identify best practices and promote compliance across the sales organisation. Thus, pipeline exploration will kickstart the process mining journey with Celonis for Opportunity Management. Accenture’s Procurement Operations Execution App:Accenture proposed a Procurement Operations Control Tower solution built on Ariba system, to combine data, insights and automation in an industrialized manner. This enabled operations to measure process performance, identify opportunities and drive continuous improvement. The app enables:Fast access to operational data, up to date analytics and reportingIdentify and automate corrective actions, early warningsDrives effective work Management, actions and automationConsiderable reduction in process turnaround timeCelonis’ automated process analysis uses sensors to surface anomalies in the process - trends, patterns, and changes - that are impacting KPIs. This Execution App provides a number of predefined sensors to capture the most commonly identified patterns in the process. Additional sensors can be defined as desired.

The Core Mining Engine team plans to roll out a behavior change for the CASE WHEN operator in PQL. Why are we planning this?The current CASE WHEN behavior is not intuitive and contradicts the behavior of established SQL systems. The new behavior can simply be thought of as "NULL is treated as false". More information and details can be found here. What will change? When using an ELSE fallback condition, so far the rows evaluating to NULL would be returned as NULL even if the ELSE statement was correctly defined. Example, when <COLUMN> = ‘A’ evaluates to NULL, then the following statement CASE    WHEN <COLUMN> = ‘A’ THEN ‘option A’  ELSE ‘other’ END  returns NULL instead of ‘other’. This counterintuitive behavior will change: CASE WHEN will return ‘other’ with NULL inputs. This will lead to less NULL results and more ELSE results if NULL values are input values, and if ELSE is being used. If no ELSE is defined or if ELSE NULL is used, the result will still be NULL and nothing will change.  What are the next steps?The plan is to gradually roll out the change beginning in February 2022.

Dear Celopeers, On December 2nd, 2021, we are hosting our next Webinar on how to Use Celonis data in Action Flows! This is the fourth part of our new series of Webinars. The Session will cover:What options are available to access Celonis Data within Action Flows? (presentation)How to set up Action Flows based on Celonis Data (live training)Where to find further material (link to resources)Q&A (live)FAQ (live, gathered from the previous session) You can directly register here!

What are the new features in CPM 4.7 compared to CPM 4.6?

The Celonis Visual Editing Experience is now live! With the big release of the Visual Editing Experience we enable you to make changes to your Studio package with a couple of clicks! Now you can edit your KPIs on the fly, while configuring a table.Simply switch to the Visual Editor and experience the new powerful capabilities! Find the Release Notes here!  

Hi, For a project in CPM4 I need to configure the cardinalities in a 1-1 table relationship. Unfortunately, Celonis detects the wrong table (for my use case) as the parent table, making the desired calculations impossible. Is there an option / trick similar to what David described in the answer of the first question in Process Data Model (relationship activity - case table ) On the edge, it shows how you have configured the join. If you click on the edge, you will see that you have configured Activities as the 1-side of the Join, and Cases as the N-side of the join. I would suggest to use the Swap Tables option in the Foreign key settings to configure it in the correct way. Then, the cardinalities will be shown as you expect. I already tried redefining the key and swapping the left and right hand table (and reloaded the DM), however this didnt make a difference. Thanks, best regards, Lucas