Skip to main content

Version 9.3

April 14, 2020

note

From version 9.3 of SEI, Finance and Sales cubes are deprecated in Sage 300 and are now supported only in UDM.

Improvements​

Web Client​

Data Model​

  • The word Prompt has been replaced with Global Parameters. This change can be seen when you right-click on a Data Model and select Manage Data Model Parameters.

Report​

  • The Freeze Group Column feature has been added to the Report Properties under the General section. It allows you to always display the Group column when scrolling to the right.
  • Improved the grid display.

User Interface​

  • The Command Center title on the left is now displayed on 1 line when enabling the Console in your web browser.

View​

  • Doughnut:
    • The Thickness feature has been added in the General section to adjust the chart thickness.
    • The Total section has been created below the Labels & Tooltips section. With this section comes the Show Total feature, which displays the total of values in the chart.
    • Doughnut / Pie / Funnel: The Show Percentage of Total feature has been added to the Labels & Tooltips section, showing the total of each group as a percentage.

Dashboard & Charts​

  • Implemented multilanguage feature for Dashboards and Charts.

Web Central Point Configurator​

  • A pop-up window now reminds you to restart the BI Service to apply changes.

Distribution​

  • Implemented daily logs.

OLAP Manager​

  • Updated error message when Job Service cannot be reached/stopped: "The Job Service was not found or was not accessible. Verify that the service is running and that the firewall is configured to allow connections".
  • OLAP Manager no longer hides the last row for Dimension and Measure mapping.

DataSync​

Backend settings​

  • Added rolling log interval; logs are now saved in daily .txt files.
  • SQL query improved with WHERE 1=2 instead of TOP(1) for faster metadata validation on OData / Acumatica.

Connections​

  • Added offset to the Source Connection when selecting Date as tracking during Incremental Load job.
  • Minimum Batch Size can now be reduced to 50.
  • New Source Connection: Sage Intacct. Click here for details.

Extractions​

  • Removed unique ID validation to avoid issues with same source/destination sharing the same Unique ID.

User Interface​

  • Now, the URL for the documentation will change according to the language (French or English) you select in the Login page.

Templates​

Acumatica (Version 112)​

  • Removed the Body field from Tasks, Email and Activity

UDM (Version 216)​

  • Improved French translation and compatibility between Oracle and SQL Server.
  • Disabled Data Entry for Sales Forecast when Forecast is approved.
  • Added return carriage for Currency Conversion in Info-Pages.
  • Changed Budget Calculation.
  • Added filter for closed orders in Sales Detail data source.
  • Improved translations for Forecast data model and Dashboards.
  • Increased size of Account dimensions in Finance Staging and Finance cubes.
  • Improved Sales Forecast Calendar Quarter, Fiscal Period, and Fiscal Quarter data models.
  • Integrated Sage Intacct cubes: UDM Finance, UDM Sales, UDM Account Payable.

Sage X3 HR (Version 104)​

  • Complete rebuild with major improvements without depending on OLAP (deprecated all Data Models, Cubes, and Reports except for the Égalité Homme-Femme module).

Excel Add-in​

  • Pivots can be summarized by Distinct Count for Excel 2013 and newer.

Fixes​

Web Client​

Dashboard - Distribution - Report - View​

  • Fixed background color used by Worksheet Auto Grey Tones when exporting or scheduling distribution.

Data Model​

  • Data Model Designer: Added return carriage now saved for calculations.
  • Data Model Parameters: We fixed the overwriting translations behavior by English when pressing Confirm in Manage Data Model Parameters and when logged in another language than English (with User Content Language different than English).
  • Info-Page: We fixed error message "Must specify valid information for parsing in the string" when validating.
  • Stored Procedure: The Execute Stored Procedure feature was not working when logging in French.

Global Scripts​

  • Special characters (é and è) now saved correctly.

Global Variables​

  • Fixed validation issue when retrieved data was zero.
  • Filter now saves Global Variable ID instead of value.

Prompt​

  • Fixed filter issues with special characters (&, <, >).

Report​

  • Fixed export issue when using Custom Calcul. More specifically, only the title and the calculated section were displayed (the rest of the report displayed no data).
  • Fixed disappearing column headings.
  • Fixed Subtotal Restrictions removing last level of detail in export.

View​

  • KPI / Word Cloud: It was impossible to create Word Cloud and KPI when the first group contained the NULL value.
  • Column Formatting: When editing an existing Column Formatting for the first time, the window displayed a blank Global Variable. At this point, when saving the Column Formatting, the Global Variable was lost and the Column Formatting was broken.
  • Doughnut - Total: When the Numeric format was enabled, the Decimal Places feature was not working. When the Abbreviate format was enabled, the title we specified remained on the same line and did not use return carriage.

Templates​

  • When importing/exporting templates, translations for Application Links, Global Selection Page, Global Parameters were not taken into account.

Acumatica (Version 112)​

  • Fixed NEC_CREATEATTRIBUTEVIEWS
  • Fixed the Amounts for the Sales Orders and Sales Invoice data models

Sage X3 (Version 111)​

  • Fixed some French translations.

UDM (Version 216)​

  • Fixed two Stored Procedures
  • Fixed bugs in Inventory Staging cube
  • Fixed bugs in Sales Staging cube
  • Fixed incorrect formula in Budget Ending Balance
  • Fixed bug in the Finance data source in OLAP
  • Fixed bugs related to Joins in Acumatica data source (EndPeriod)
  • Fixed Global Selection Pages
  • Sage X3 Posting, YTD were not working when using X3 Closing Balance
  • Fixed Inventory Historical data model
  • Fixed the Customer Order Analysis dashboard
  • Fixed the Fiscal Year Detail view for Sage 100
  • Fixed the Ledger Currency mapping for Sage 100
  • Fixed the Finance Staging cube for Sage 100
  • Fixed the Sales Order cube for Sage 300
  • Changed LedTyp data type to String(50)
  • Fixed DimOpportunity cube

OLAP Manager​

  • Fixed hiding last cube issue.
  • Fixed wrong label for Job Type on mouse hover in Job Scheduler.

Distribution​

  • When the Subtotal Exception was defined in Design Data Model or the Load All Data on Open feature for the Worksheet, Groups content from distributed Worksheet was expanded.
  • When we had a Scheduled Job (Daily/Weekly/Monthly) that failed and tried to run it now, the Scheduler was incrementing +1 the Next Run Time.

DataSync​

Extractions​

  • When adding and deleting a Calculation Field in Migration extraction type, the field drop-down list for destination were not shown anymore. In Synchronization extraction type, the edit calculation field window showed a drop-down list for Destination Field Name.
  • It was impossible to run an extraction if connected to the Wireless network (wifi).
  • The Refresh by Date feature was not working for the Acumatica connector.
  • There was a error when synchronizing the CLOB datatype from Oracle to SQL database.

User Interface​

  • Fixed email confirmation error "<STR_ERROR_CONFIRMING_EMAIL_FOR_USER>".

Logs​

  • Fixed Log Cleaning process not including all child_triggers + child_logs.