Technical & Minor Version Release Notes
A comprehensive list of all technical information regarding new releases. Includes warnings, which usually have implications on existing models and settings, as well as general technical information.
6.5.1
LTS - Hotfix
Warnings:
Behavior Change - FILLMISSING(_LAST) on Empty Inputs
The behavior of the FILLMISSING and FILLMISSING_LAST functions has been updated for cases with completely empty inputs. Previously, with no data and only one level to fill, the function returned an empty result if the behavior parameter was set to “FinishAtLast.” Now, in this configuration, the function fills the entire dimension as if the behavior were set to “All,” as there is no last value to stop at.Label Update - Scenario Assumptions in Bridge Deltas
Scenario assumptions now retain their complete name, including version number and version name, when shown in scenario or YoY bridge deltas. Previously, the version details were omitted, causing inconsistencies with the Scenario Manager.
6.5.0
LTS - Major
Warnings: No upgrade warnings
View the full feature notes here: Release Notes 6.5.0
6.4.0
LTS - Major
Warnings:
Behaviour Change - The behavior of the ‘Exclude from Presentations’ option for Sheets has been updated. Previously, when a Sheet was marked as excluded from a Presentation, it would still appear in the final Presentation, but without any chart results being calculated. With this update, when the ‘Exclude from Presentations’ option is selected, the Sheet will no longer appear in the Presentation at all.
Order Change - Order of exported charts- The order of charts in the workspace Excel export has been updated for both raw and formatted exports. Charts are now sorted as follows:
First by sheet order, exactly as they appear in the workspace
Charts on the same sheet are sorted from top to bottom
Charts at the same height are sorted from left to right
View the full feature notes here: Release Notes 6.4.0
6.3.16
Hotfix
Included a features from the upcoming 6.5.0 release for performance reasons:
Exporting & Importing of Line-Items in all Views
6.3.12
Hotfix
General Improvements:
Added a new Scenario export feature to the 6.3. versions which allows the compact exporting of a scenario including all assumptions and variables
Introduced a new formula, FILLMISSING_LAST(), which fills empty values in a column with the last available value.
Bug Fixes:
Fixed a bug which would cause closed workflows to be inaccessible
Resolved an issue where it was not possible to remove parameter deltas in new view
Please view the 6.3.0. release notes for a comprehensive list of all additions to our GDPR features.
6.3.7
Hotfix
Bug Fixes:
Fixed a bug where, in special cases, exports of formatted charts would have missing values.
Fixed an issue with table syncing between multiple users working on the same table, where one user’s manual refresh could cause table inconsistencies.
Fixed a race condition issue that could corrupt the cache, leading to errors in untouched models.
6.3.5
Hotfix
General Improvements:
Significantly reduced upload time of large XLSX files for large dimensions with two or more levels. (10 minutes → 6-9 sek. for a file with 60,000 elements)
Bug Fixes:
Fixed a bug where user which were created and then logged in via SAML did not get admin and other user rights from the initial configuration
Deleting a scenario now refreshes the workspace
6.3.3
Hotfix
General Information:
Fixed a known CSRF vulnerability issue in one of our internal libraries
Hotfix bug fixes
6.3.0
LTS - Major
Warnings:
ACCESS RIGHTS CHANGE - API restriction - Only project admins have full access to the shared workspace. This has always been possible only via API, never through the front end. - LOW
NUMBER CHANGE - Change in system table “MONTH_LAST_DAY” - This change will fix values for the last day of December but will not apply automatically on deploy. It affects only new projects (excluding duplicate and import). To fix an existing project, change its time dimension by shrinking or expanding the horizon. - LOW
General Information:
There has been an update regarding the available OpenID connect client authentication types. A new guide has been created to describe the steps needed to use oAuth 2.0 with Private Key JWT Client Authenticaiton and the general OpenID configuration page has been updated.
The number formatting in the node data preview is now synchronized with the user language setting. Thus, numbers will be displayed as: 100.000,00 in German and 100,000.00 in English, matching the rest of the application.
6.2.0
Major
Warnings:
Database Upgrade – H2 Compatibility Change
We have upgraded H2 from version 1.4.200 to 2.2.224, which breaks compatibility with previous installations. To prevent data loss, users should manually migrate their data before upgrading the application. Please note that H2 is intended only for demos and proof of concepts (PoCs) and is not supported in production environments, as it cannot be upgraded across releases. – TrivialConfiguration Update – Feature Flag Change
The feature flagfeatureFlags.job.pathFolderSystemExportedFiles
has been removed and replaced by thesystemFlags.tempFileRootDirectory
configuration in the YAML file. If a value was set for the previous feature flag, it must now be manually updated to the new setting. There is no automatic migration for this change. – TrivialAssumption Group Visibility
A new assumption group called 'Szenario-Annahme' may appear in some workspaces. This change addresses scenarios where scenario assumptions were active but not visible in the scenario manager. After the update, any previously hidden assumptions will now be displayed in this new group. – Trivial
6.1.4
Hotfix
Warnings:
NUMBER CHANGE - ROLLFORWARD_ADVANCED fix for gaps in input data when using an aging Level - There is a chance that numbers will change from ROLLFORWARD_ADVANCED calculations when using an aging Level where an input data Level value key does not exist within a specific rollforward iteration’s data after shifting. - High
6.1.2
Hotfix
General Information:
Need to update the public-facing OIDC documentation regarding a new config value
valsightOpenIdConnectProperties → userInfoEndpointScopes
. See the internal documentation for details on OpenID Connect Configuration.
6.1.0
Major
Warnings:
API REMOVAL - Removed API /v1/models/validateData - This API and all related tasks and helper functions in valsight-client have been removed. - LOW
CONFIGURATION CHANGE - config.yaml changes for SAML authentication - The config fields “valsightSamlProperties → name-id-format” and “valsightSamlProperties → signingAlgorithms → RSA” have been removed. - LOW
General Information:
Replace SAML with SAML Configuration.
6.0.1-6.0.28
LTS - Major
Warnings:
INFORMATION - Fixed group membership changes did not take immediate effect - If you remove (a) user(s) from a group, they will not lose their group permissions until they log out and log back in. - TRIVIAL
NUMBER CHANGE - Fix for ROLLFORWARD_ADVANCED when applying relative changes - When using ROLLFORWARD_ADVANCED in ADDITIVE mode, relative changes are now applied correctly. - TRIVIAL
NUMBER CHANGE - Fix for leaking number impact of boolean operations - This issue fixes a bug where values (rows) could leak into results if boolean operations did not match all inputs. - TRIVIAL
NUMBER CHANGE - Fix for horizon overrides for ROLLFORWARD_ADVANCED - This issue fixes a bug where ROLLFORWARD_ADVANCED calculations did not correctly account for horizon overrides. - TRIVIAL
INFORMATION - New E-Mail Verification Process - All details in sub-pages of 6.0.15 - New E-Mail Verification Process have been updated. - TRIVIAL
INFORMATION - No new metrics added or removed - There are no metrics added or removed, just some Hotfix adjustments to existing ones. - TRIVIAL
CONFIGURATION CHANGE - Rename 'Reader' user type to 'Basic License' - This removes the user type ‘Reader’ and renames users with this type to ‘Basic License’. - TRIVIAL
INFO - Update user type pages - Update user type pages, because of ES-9209: Unify reader and analyst to basic license. - TRIVIAL
NUMBER CHANGE - Fix for rare case of missing ROLLFORWARD_ADVANCED rows - This fixes a rare case where certain rows that should be calculated with ROLLFORWARD_ADVANCED were missing. - TRIVIAL
FUNCTIONALITY CHANGE - Affects SHIFT, FILLMISSING, and other functions - Affects the following functions: SHIFT, FILLMISSING, and others related to rolling forward data. - TRIVIAL
FUNCTIONALITY CHANGE - Chart hierarchy totals - This affects charts that had hierarchy totals enabled, ensuring totals are now correct. - TRIVIAL
API RESTRICTION - Prevent API from changing chart measures - We have decided to prevent the API from changing chart measures directly. - TRIVIAL
MEASURE SCALE - Default scale of measures in all Scenarios - By default, the scale of measures within all Scenarios has been set to 1. - TRIVIAL
PERMISSION RESTRICTION - Disable creating dimensions via API - After the deploy, it will be impossible to create dimensions via API, enhancing security. - TRIVIAL
MIGRATION SCRIPT UPDATE - Updated version of migration script for dimensions - An updated version of the migration script for dimensions has been included in this release. - TRIVIAL
SHIFT FUNCTION UPDATE - Changes how SHIFT handles missing data - This changes numbers when you were using SHIFT in conjunction with missing data. - TRIVIAL
HORIZON GENERATION - Changes how horizons are generated on Week level - This changes how horizons are generated on Week level. - TRIVIAL
VALIDATION - Extra validation for NONSIM input types - Extra validation has been added to the NONSIM input types. - TRIVIAL
MIGRATION - Manual migration required for 6.0.X versions - This version contains a migration that needs to be run manually if upgrading from 6.0.X. - TRIVIAL
BUG FIX - Fix for rare ROLLFORWARD_ADVANCED edge cases - This fixes a rare issue when in some edge cases ROLLFORWARD_ADVANCED would not calculate correctly. - TRIVIAL
API INFORMATION - API details visible via front end - As all API information is also visible via the front end, no further changes are required. - TRIVIAL
GRAND TOTALS - Grand totals display for hierarchy charts - Behavior until now: if grand totals were active, they could be displayed incorrectly. - TRIVIAL
ACCESS LOG EXPANSION - Server access log readability - This simply makes the server access log more readable by including more details. - TRIVIAL
REMOVAL OF ROLLFORWARD RENAME MIGRATION - Applies only when upgrading from 6.0.X versions - Applies only when upgrading from 6.0.X versions, ensuring compatibility. - TRIVIAL
EXTERNAL URL REQUEST FIX - Fix for external URL request handling - By fixing this issue, the application will now handle external URL requests more efficiently. - TRIVIAL
YOY BRIDGE CONFIGURATION - Remove option for 2 scenarios in a YOY Bridge - This will cause all YOY bridges configured with more than one scenario to require reconfiguration. - MEDIUM
AUTO_DIMS REMOVAL - Remove AUTO_DIMS 1.0 - This issue removed support for modifying dimensions through AUTO_DIMS 1.0. - MEDIUM
XLS DATA SOURCE IMPORT UPDATE - Streamline XlsDataSourceImportService - This issue moves all dimension tables that were previously imported via XLS to be handled through a more streamlined process. - LOW
General Information:
Need to update the public-facing OIDC documentation regarding a new config value
valsightOpenIdConnectProperties → userInfoEndpointScopes
. See the internal documentation for details on OpenID Connect Configuration.Update user type pages due to ES-9209: Unify reader and analyst to basic license.
Replace Mail Server with Mail Server Configuration
6.0.0
LTS - Major Release
Warnings
EXCEL FORMAT CHANGE - Removed AUTO_DIM 1.0 - This issue removed support for modifying dimensions via data-source upload. Clients need to modify files that had the '= DIM[Dim,Level,1]' tags in them, or they will end up with DS columns with that name. - MEDIUM
BREAKS CALCULATIONS - DATA function break - This issue moves all dimension tables that were in user data sources into the system data source. This breaks DATA functions that used dimension tables. Users will need to manually adjust the DATA function to the System data source. Chance of occurring: very low. - LOW
NUMBER CHANGE - Potential number change - DataFrameKeyEntry equals method can return false when keys are equal. Chance of occurring: basically none. - LOW
CONFIGURATION CHANGE - SSO config.yml change - Replaced the functionality introduced in ES-11511: Open ID connect group sync prefix to allow for multiple prefix values for both OpenID connect and SAML. This involved changing the config.yaml configuration key for the functionality:
Old configuration key: spring → security → oauth2 → client → registration → openIdConnect → valsightOpenIdConnectProperties → requiredGroupNamePrefix
New configuration key: loginMethodConfigurations → commonSSOOptions → requiredGroupNamePrefixes
Any environment configured to use the old OpenId group name prefix filter will be required to reconfigure to use the new SSO wide group name prefixes filter. Note the old configuration key was a single string value while the new configuration key is a list. - MEDIUM
NUMBER CHANGE - Potential number change with OData scenario exports - OData exports of scenarios were not applying the overridden values of variables. Any existing OData export will now be changed to reflect their influence on node results. - HIGH
FILE DELETION - All job results are purged, regardless of the purge settings - All existing job result files need to be deleted because we changed the file format. - LOW
FUNCTION RENAME - Renamed the ROLLFORWARD functions - The existing ROLLFORWARD function is renamed to ROLLFORWARD_BASIC. The existing ROLLFORWARD_MUL function is renamed to ROLLFORWARD_MUL_BASIC. Upgrading to 6.0 requires modifying any node operations that contain the old names of the above functions to use the new ones. A new function named ROLLFORWARD that has different parameters and logic from the ROLLFORWARD_BASIC has been introduced. - HIGH