Version 2023 Release 3
Web Client Build Number: 23.0.3.10154
Excel Add-in Build Number: 23.0.3.10154
DataSync Build Number: 23.0.3.10154
SEI for Sage 300 Embed Build Number: 23.0.3.10154
April 17, 2023 - Available for On premise and Cloud
Breaking Changes
-
Since April 11, 2023, Microsoft Office 2013 is no longer supported by Microsoft nor by SEI.
-
As of October 10, 2023, Windows Server 2012 R2 will no longer be supported by Microsoft nor by SEI.
Improvements
Web Client
-
Improvements to the Web Workbook (Preview):
-
The data structure has been changed in the database to improve the workbook performance. If you had an older version of SEI and upgraded to the latest version, we highly recommend that you open and save your workbooks in order to start using the new structure. 18453
-
You can now import your Excel templates and reuse them in the web workbook. 2957
-
The default number of rows has increased from 200 to 1000 when creating a workbook. 18186
-
The formula wizard now has the option to use Description as an operator for Dimensions and Description (for the Description Data column type and CHAR data type in the Data Model Designer). 10975
-
-
Users can now enter data with increased accuracy and control in these dialog boxes: Advanced Filter, Data Model Parameter, Selection Page, Global Selection Page, and Stored Procedure, with the implementation of data type validation in Global Parameters, Data Model Designer and Manage Data Model Parameters. 14418
-
In the Data Model Designer, validation has been added to verify that the generated SQL query is valid upon saving the data model. 19147
-
For SEI Cloud: Users ADMCA and users with administration rights can now add a new environment in Env & Data Sources.19373
OLAP Manager
-
OLAP cube lists and jobs sometimes had the wrong date and time when the job was scheduled with a timezone other than UTC. Tool tips on the bottom right-hand side in views, dashboards and reports were also corrected accordingly. 18977
DataSync
-
Post Execution Scripts and Purge Conditions are now included when importing and exporting templates. 19589
-
Documentation has been added for these connectors: MS-Access, MS-Excel, ODBC, Oracle, PostgreSQL, Quickbooks Desktop, SQL Server, and SQL Azure. doc backlog
Web Client Templates
Template | Change description |
---|---|
Sage Intacct |
|
Sage X3 |
|
Fixes
Web Client
-
After upgrading from version 2021 R1.2 to 2023 Release 1, the Web Workbook command center did not show parent folders that contained empty sub-folders. 19664
-
Subtotal restrictions were not applied when exporting a view containing columns only. 19933
-
The Users tab of the Authentication page has been improved: 19318
-
Case sensitivity has been removed;
-
When searching for a user, the user list remains displayed;
-
The check box next to the selected row is no longer automatically checked;
-
A confirmation message has been added when clicking on Reset or Delete;
-
You can now increase the number of users shown in the list (up to 100 users).
-
-
In the Command Center, searching for a view with a name containing an accent would not return the proper results. 20027
-
In Doughnut views, the Total Row formatting was not kept although it had been saved. 19723
-
Single quotes usage has been streamlined so that it can be used that same way in Data Models and Workbooks. 19411
-
In the Data Model Designer, if a calculation was erroneous, copying the error message after validating the calculation would sometimes be impossible. 19817
-
The Save Data function was always present although the worksheet was not editable. 17611
-
In rare cases, saving a report in Oracle could generate an error if the report had a description set in another language but was empty. 19603
Distribution
-
Scheduler jobs would sometimes fail when the view format was set to External Link. 19887
OLAP Manager
-
The OLAP Manager would sometimes have performance issues when building, loading and refreshing cubes. 19767
Excel Add-in
-
The Link to Formula feature was not functioning properly.19409
-
Excel processes would continue running after distributing Excel Add-in reports, which could cause performance issues. 19225