Version 2022 R1.3
Web Client Build Number: 22.1.3.10160
Excel Add-in Build Number: 22.1.3.10160
DataSync Build Number: 22.1.3.10150
SEI for Sage 300 Embed Build Number: 22.1.3.10150
October 18, 2022
Breaking Changes
-
As of the last release for the year 2022, we will no longer support the 32-bit version of Excel Add-in for Windows 32 bits. The SEI Excel Add-in - WIN32.exe installation package will not be available. You will need Windows 64 bits in order to install Excel Add-in for MS-Office 32-bit or 64-bit version ( Excel Add-in - WIN64.exe).
-
Oracle users must now be created before installing SEI.
-
As of January 10, 2023, Windows Server 2012 R2 will no longer be supported by Microsoft nor by SEI.
Improvements
Installation
-
New scripts are available to create Oracle and SQL users. Oracle users must now be created before installing SEI. The installation steps of the SEI License Server and Central Point have been updated to include these users by default. 14422
-
Installation log files are consolidated and saved in the same location defined as installation path at the beginning of the basic or advanced server installation. 11991
- Ports are validated during the installation to make sure they are not already used by other hosts. 13096
- SEI installation packages are now automatically run as an Administrator. You no longer need to right-click the .exe file and select this option. However, your Windows user must have Administrator rights. 14339
Web Client
-
The new Edit Advanced Filter data model role has been added to views. 14419
- Wildcards can now be used to filter values in Reporting Trees. 15116
-
For worksheets and reports, a new option to enable or disable the outline has been added to the Excel Export tab. 13273
- Improvements to the Web Workbook (Preview):
- Several currencies have been added to the workbook. 13075
- Workbook components are now translated in all languages supported by SEI. 13145
- Workbook folders can now be renamed.13171
- Workbooks can now be renamed using a shortcut.13172
- Workbook context menus have been enhanced so that the text is displayed properly when the language is French. 13178
- In the formula wizard, the display of fields available for selection in the filter has been improved. 13187
- A workbook item can now be set as a landing page. 3652
-
You can now customize the web application content security; refer to this procedure. 14085
OLAP Manager
-
When creating a cube, the table name is now verified to avoid duplicate names. 13339
Distribution
-
The Scheduler now allows you to use the Run As option without having to add any users or groups to send emails using external addresses. 4430
-
The Scheduler history has been improved to display more log details on failures. 13256
Excel Add-in
-
Wildcards can now be used to filter values in reporting trees, pivots, data extractions, and formulas. 15417
-
The new Refresh Style drop-down has been added to data extractions. 14068
DataSync
- A new Execution Timeout option has been added to extractions. 12864
Web Client Templates
Template | Change description |
---|---|
Primavera |
|
Sage Intacct |
|
Sage X3 |
|
Sage 300 |
|
UDM |
|
Fixes
Web Client
-
Sorting a view that contained a Pivot with Advanced Options was sometimes not applied. 15101
-
Subtotal Restrictions were sometimes not applied when exporting the view to an Excel file. 15045
-
Improvements were made to add more security to the cookies used in the Web application. 14084
-
These defects have been fixed in the Web Workbook (Preview):
-
The formula wizard would sometimes fail when a formula was set to create a dynamic list and was filtering on a number in an Oracle environment. 11806
-
The formula wizard would sometimes return an error if the formula was using a table whose name contained a space. 14184
-
-
After adding multiple dockable filters to a dashboard and saving it, only the first filter was saved. 15174
-
The Reporting Tree Node comment was sometimes not saved. 14789
-
The look and feel of external links has been fixed so as to be consistent with the Web Client. 13453
-
French accent characters in view, dashboard, and report names were not showing properly in the mobile version of Web Client. 15094
-
For on premise installations, the Web application would sometimes take longer to start when set up in HTTPS. 13972
OLAP Manager
-
After saving a new job, the time displayed in the Next Run Date column was in UTC instead of the local time zone. After the initial job run, the time would be displayed correctly. 15382
Distribution
-
When a job included several Excel Add-in views to be distributed, the job would sometimes fail. 13415
Excel Add-in
-
When a dimension name contained a single quote or a range with one or two asterisks (*), the formula wizard could not return the correct value. 15117
-
Using a prompt or a quick prompt would return an error when the Data Model had field names using SQL Reserved Keywords. 11738
-
Distributing a spreadsheet that contained a pivot created using SEI and a pivot created in Excel would cause an error. 13200
Web Client Templates
Template | Change description |
---|---|
Sage Intacct |
|
Sage X3 |
|