TrendMiner 2023.R2.0

8th of August 2023

The 2023.R2.0 release contains the following new functionality and improvements:

Innovation Highlights

  • Conditional formatting in ContextHub tables – Quickly identify event conditions in a view by configuring logical rules on columns. Individual table values can now be configured to have different background colours to call attention to binary conditions, such as on- or off- specification, or to a scale of varying levels of severity, such as limit bands.
  • Global time frame adjustment for DashHub  Easily change the timeframe TrendHub view and ContextHub view tiles on a dashboard at once to adjust the reported period, capture specific events, or compare current operations to longer time period.  Use the same dashboards to facilitate shift, morning and monthly meetings.
  • Connectivity
    • Plug 'n Play connectivity to Generic JDBC provider to ingest Time Series and/or Asset data from a database as source. Several commonly used database drivers (Postgres, MariaDB, SQLite, MSSQL) are provided and can be used out of the box. 
    • Plug 'n Play connectivity to AspenTech Production Record Manager (APRM) provider to bring your batch process data to TrendMiner. 

Application Enhancements 

  • Improved editor for formula creation in TrendHub.
  • Improved visualization options when dealing with very big and small numbers throughout the TrendMiner application. Users can also adjust the displayed accuracy per tag.
  • Support of Duration and Type fields in ContextHub Multi scatter plots. 
  • Quality of life improvements for notebooks. 
  • Value Based Search on digital & string tags: Re-introduced the select all option to select all states (with a maximum of 10K states). 
  • ADMIN only 
    • Datasource performance metrics. In ConfigHub you can now have a clear view on the performance of your data source connection in which the index operations execution time, plot operations execution time and sync operations execution time are visualized. The values  represent the 50 and 95 percentile over the most recent data. These metrics will make it possible to determine, for example,  the location of an issue faster, by inspecting the metrics of data sources/connectors in ConfigHub and, for example, by excluding the possibilities of related issues such as performances of particular data sources 
  • Search functionality for workflows, types and fields configuration screens in ContextHub. 

Bug fixes 

  • The total amount of active filters is limited to 10.000 for both static and dynamic filters combined. The message for dynamic filters has been adjusted accordingly. 
  • Formulas involving the provided TM time tags were not correctly visible when a time shift was included or when looking at recent time periods. These formulas are now displayed correctly. 
  • Dashboards with a lot of monitor tiles were not able to load correctly due to timeouts. Tiles are loaded sequentially now and should be displayed correctly. 
  • Some assets were missing grandparents, which is now fixed. 

Patch Release Updates

We release patches periodically. To receive email updates on important TrendMiner patch releases, subscribe via ​​this link​.

End of Support Notice

Given the large technology changes in TrendMiner 2022.R1.0, support for older versions of the software will be fully discontinued after December 31st, 2023. This includes support on issues when upgrading to version 2022.R1.0 or older. As we won't be able to support your upgrade after this date, failures might result in the loss of all TrendMiner data. If you are currently running a TrendMiner version older than 2022.R1.0, we strongly advise to start the upgrade process to one of the latest versions now. For more information and guidance, consult your Customer Success Manager or our Technical Support team.

Known limitations  

  • Embedding TrendMiner in external applications is limited to Microsoft teams. Extensions to improve this functionality and make it more robust, will arrive later.
  • External content tiles in dashboard need cookies to properly load all content (and be able to login when required). 
  • Scooter values may change when zooming in after adding the scooter. This is because scooters currently interpolate the data points on the chart. 
  • When calculated tags are deleted, they cannot be created with the same name again. 
  • After renaming a calculated tag linked to a context item, the component of the context item is not updated correctly. 
  • The action displayed on the right-side panel of ConfigHub when a service is restarted, is no longer visible. 

Synopsis 

Tag Builder Formula editor improvements 

The formula field has been reworked and you can now format your formula like a code editor. This allows you to indent and even add comments to your formula. 

Clicking a variable, function or other item also highlights other occurrences inside the formula. When a parenthesis is clicked, only its matching parenthesis is highlighted. Unclosed parentheses are marked in red for easier detection. 

In addition, the formula field now supports auto-completion. When typing, suggestions of possible built-in functions will be shown. Pressing the "tab"-key on your keyboard fills out the selected function.

1_RN_2023_Formula_r2.png

2_RN_2023_Formula_r2.jpg

Furthermore, you can now add functions directly from the formula documentation. When adding a function from the documentation, the input parameters/expressions for the function are included as placeholders. These placeholders can be replaced by directly typing in the desired info and pressing "tab" via the keyboard to switch between the different parameters/expressions. 

Note: For functions that accept two or more inputs, only the first two parameters/expressions placeholder are added. For example: the max() function can accept up to 10 different inputs, but only two placeholders will be shown.

Customizable precision by tag 

The tag or attribute detail overview provides an option for setting the accuracy of a tag. By setting the accuracy, you can customize how values of your sensor are displayed. 

When the toggle is off, TrendMiner uses its default behaviour to display values. However, you can customize how a value is displayed, within the maximum allowed significant numbers, by activating the accuracy setting toggle.

TrendMiner will now also switch to scientific notation for smaller values instead of showing the zero value when the maximum significant numbers are exceeded.

3_RN_2023_Custom_Tag_r2_real.png

TrendMiner aims to provide transparency to the user regarding the numerical inputs that are being used in computations. To achieve this, any input field in TrendMiner has been implemented with the following features that will automatically adjust the user's input:

  1. When entering values with more significant digits than the maximum supported, we will automatically adjust the input to the maximum supported significant digits.
  2. When entering values outside the supported range, we will adjust the input to the nearest allowed value or return a message that the value is out of range. 

To support small values, we allow the display and input of values in scientific notation for any input field. To enter a value as scientific notation, you can use the E-notation. 

Conditional formatting in ContextHub tables 

The conditional formatting feature gives you the possibility to format the background colour of cells in the ContextHub Table view based on a set of defined rules. 

4_RN_2023_ContextHub_Table_r2.png

Multiple rules can be set on a specified column in the grid. Rules can be reordered by dragging and dropping with the topmost rule bearing the highest priority. These rules can also be based on values from other columns. 

Global time frame adjustment for DashHub 

The global time frame feature gives you the possibility to modify the selected time frames for TrendHub view and ContextHub view tiles in a dashboard in DashHub. 

5_RN_2023_Global_TimeFrame_r2.png

 You could also choose to apply a custom timeframe: 

5_RN_2023_Global_TimeFrame_r2ii.png

Or use one of the predefined periods: 

5_RN_2023_Global_TimeFrame_r2iii.png

Plug 'n Play connectivity to Generic JDBC provider 

This new Generic Java Database Connectivity (JDBC) provider enables you to connect to any data source that allows data transfer through a JDBC API. With this you can connect to many more data sources in addition to the already supported and maintained connectors available in TrendMiner. 

You are in full control of the configuration of this connector by defining your own custom queries to retrieve the data from the data source. The data can contain both time series data and asset data.

Plug 'n Play connectivity to AspenTech Production Record Manager (APRM) provider

As a second new data source we are now supporting the AspenTech Production Record Manager (APRM) with an out of the box connector for contextual data that are present in the APRM system. In combination with the time series data from the AspenTech IP21 data source this will allow you to get the most out of your data and retrieve additional insights by adding contextual process data on top of the time series data. 

To add an AspenTech Production Record Manager (APRM) data source, Plant Integrations must be configured to run under an identity that has access to Aspen Production Record Manager. This user must be a member of the 'Distributed COM Users ’group on Aspen Production Record Manager server. 

Notebook improvements 

  • A delete button is now available from the toolbar to delete all selected cells in a notebook. 
  • You can now export your notebook to save your notebooks locally. 
  • When publishing your notebook, you can now select all cells instead of clicking each cell one by one. 

6_RN_2023_Notebook_r2.png

7_RN_2023_NoteBook_r2.png

Enjoying TrendMiner? Share your experience to help the community.
Rate TrendMiner