Version 2021 R2.3
Web Server Build Number: 10.2.3.88765
Excel Add-in Build Number:
DataSync Build Number: 10.2.3.90719
SEI for Sage 300 Embed Build Number:
May 18, 2022
Excel Add-in Build Number:
DataSync Build Number: 10.2.3.90719
SEI for Sage 300 Embed Build Number:
May 18, 2022
Improvements
OLAP Manager
- New columns have been added so that the user can see a cube's settings without having to select it.
- Cubes list: Description, Logging, Columnstore indexes, No null in sources.
- Data Sources list: Dynamic, Active.
- Dimensions list: Precision, Description.
- Measures list: Summarizable.
DataSync
- The connection to DataSync is now validated before performing an extraction action to make sure the destination tables are properly updated (for example, when performing a Load All or Validate and Build action).
- New connector for Sage 50 UK (Beta version).
- New connector for Active Directory (Beta version).
- New connector for LDAP / LDAPS (Beta version).
- New connector for HubSpot (Beta version).
- New connector for SAP HANA (Beta version).
Web Client Templates
| Template | Change Description |
|---|---|
| Sage 200 Evolution | New Sage 200 Evolution template |
Fixes
Web Client
- Important – After searching for a Reporting Tree and adding nodes to it, Web Client would only save the Reporting Tree displayed on the screen when saving it. The other existing tree nodes were deleted.
- You could not save a dashboard under another name when there was no filtering panel. The Save As operation would return an error.
- An issue could sometimes happen when creating a worksheet with columns only and one of them contained Count Distinct Subtotal. (Error displayed: The data array dataArray does not have the right dimension).
- When opening a Dashboard, the Date format in the Filtering Panel would not match the user's Date Format configured in the Regional Settings.
- When deleting a folder containing a Data Model or Report, an error message was displayed but the folder was correctly deleted.
- When exporting a report, the Subtotal Restrictions were displayed in the report.
- Saving KPI changes within a view or a dashboard caused all worksheet parameters to be reset to the default values.
OLAP Manager
- When services started a blank token was created, which could cause an issue with the OLAP memory.
- The content language for special variables was set to English instead of being set to the ADMIN user's choice.
Excel Add-in
- A date with a custom format was not displayed in the Excel Add-in and the Data Model preview.
- An error could occur in Excel Add-in if the Date and Datetime fields had a NULL value when performing a data extraction.
- The Get & Transform Data and Queries & Connections features in the Excel Add-in would return an error.
- When creating a pivot and selecting the option Add this data to the Excel Data Model, the Excel Add-in would return an error if the Excel Data Model name started with C, c, R, r, or a digit. (Microsoft Excel limitation – details here).
- When using Data Extractions or Formulas with the number format set to commas for decimal and the content language set to French, the distribution service would return an error.
DataSync
- DataSync log cleaning would cause performance issues.
- DataSync would not handle the maximum file size of the connection logs properly, resulting in large files taking a lot of disk space in the connections folder.
- Data could not be loaded into Sage Intacct tables. DataSync would encounter a mismatch error between cached data and real data.
- An error could occur when adding new tables or extractions for the Sage Business Cloud connector.