Release 1
2020-07-30
Features Added
- The Admin Console > General > Culture Settings > Time Zone Name will now be used for all time related features, including DateTime functions such as Now(). Admin Console > General > Culture Settings > Server Time Zone Offset only applies if Time Zone Name is not set.
Issues Fixed
- Fixed an issue where a date field in the X-Axis label on a chart from a report header section would show an error when exporting a report with the WkHtmlToImage rendering engine enabled
- Fixed an issue where a chart in a Repeating Group included values that were outside of the group
- Fixed an issue with report XML data missing when creating a schedule with a Chained Report and the Scheduler Queue is implemented
- Fixed an issue with report XML data missing when renaming a schedule that would cause the old schedule name to be displayed in the Scheduler Manager when the Scheduler Queue is implemented
- Fixed an issue with imported filters in the Dashboard Designer where the name of the importing report would be listed more than once
- Fixed an issue with interactive Dashboard filters not showing the selected Date formatting option when the input type control is a range slider
- Corrected the sameple
DatabaseToJson.config.jsonconfiguration file to match the schema of Exago reference example of Folder Management - Fixed an issue connecting to Oracle data sources in Linux with the Oracle.ManagedDataAccessClient driver
- Included the CloudToJson Storage Management transitioning utility which was inadvertently excluded from previous builds
- Fixed an issue with GeoCharts not appearing in PDF, RTF and Excel exports when using the WkHtmlToImage rendering library
- Fixed an issue where an error message would be displayed when adding a CrossTab to an existing Advanced Report
- Fixed an issue where a tenant column would not be honored if the configuration contained two data objects that had an identical table name and the same tenant parameter name
- Fixed an issue with the OnSaveReportSuccess Action Event being triggered when clicking the Finish button in the Advanced Report Wizard even if Admin Console > General > Feature/UI Settings > Save on Finish Press is set to False
- Fixed an issue where custom data object columns would evaluate incorrectly if one of the component column's Visible property was set to false
- Fixed an issue where a "Folder must be empty before deleting" error message would be displayed when trying to delete an already empty folder when running Exago on Linux
- Fixed an issue where Group Headers print twice if both Page Break and Repeat Row properties are set for that header
- Fixed an issue where an error message would be displayed when opening a Dashboard if it had been created in a pre-v2019.2 environment and included an ExpressView visualization with a missing data object
- Fixed an issue where Dashboard visualiuzations with a large number of data points could cause the browser to hang
- Fixed an issue that prevented more than 10,000 records from being retrived from an Elasticache data source
- Fixed an issue with scheduling Dashboards with server events where
sessionInfo.Report.DownloadFnwould not point to a file that exists - Fixed an issue where font names would be duplicated in the Designer's font name dropdown after installing a particular fonts package on Linux
- Fixed an issue where the Dashboard Designer would always prompt the user to save changes even if no changes had been made
- Fixed an issue with Number Formatting choices made in the ExpressView Designer were not reflected for aggregates in ExpressView export output files
- Fixed an issue where an ExpressView that had errors on it (e.g. a missing data object) could not be duplicated
- Fixed an issue where an error would occur if a third group was added to an ExpressView with two groups and a visualization
- Fixed an issue where the ExpressView Hints could not be reset from the User Preferences dialog
- Fixed an issue where expanding and then collapsing a tile in the Dashboard Viewer could cause the tile to shrink instead of returning to the pre-expanded size
- Fixed an issue where the Tile Properties Pane in the Dashboard Designer would not always open to the Content tab when creating a new visualization tile as expected
- Fixed an issue where an Express Report with a prompting filter would not prompt for a filter value when the Run button in the Report Designer was clicked
- Fixed an issue where an error would occur if using a negative value for the second argument (the addend) of the DateAdd() function
- Fixed an issue where a DateTime value that included milliseconds (e.g. 2020-06-01 23:59:59.999) would not be passed to the SQL WHERE clause if it were included in a filter function
- Fixed an issue that required custom function names in the
dbconfigs.overrides.jsonfunction dictionary to be in all lowercase in order for them to be pushed to the data source - Fixed an issue where the Cancel button would incorrectly appear in the Report Wizard when the wizard was launched by the API (where the Cancel button is irrelevant)
- Fixed an issue where the Linux installer would not install the mono-4.0-service package on Ubuntu and Debian
- Fixed an issue where a Storage Management database would not be correctly initialized if the Party Type table was not empty
- Fixed an issue where the Font dropdown in the Advanced Report Designer would not open instantly on click
Release 0
2020-07-01
We are proud to release Exago BI v2020.1!
Check out the list of new features and other changes below.
Storage Management
Exago's Storage Management system replaces the legacy file system, cloud storage, folder management and web service (SOAP) storage methods with a relational database. All reports, templates, folders and themes are stored in this database.
As of v2020.1, all legacy storage methods are deprecated and are replaced with the Storage Management system. Storage Management enables a flexible folder and report permissions model and creates a future development platform for features such as collaboration, sharing, annotation, version control and more. All clients upgrading to v2020.1 will need to change their content storage strategy to the Storage Management system. Exago has built several handy utilities for this transitioning process.
The Storage Management system is virtually transparent to the end user, with one exception. The Owner 
icon will appear in the Report Tree if a user owns that content. Content ownership is a new concept in the Storage Management system.
Dashboard Designer Changes
Similar to the Advanced Report Designer, the Dashboard Designer toolbar now includes Undo 
and Redo 
icons. The Undo/Redo memory holds up to the last 100 actions taken in the Designer.
Some additional control is now available to Dashboard Visualizations that have multiple Groups and Values! Number Formatting options are now configurable on a per field basis rather on a per tile basis. Tabular Visualizations, Scatter Chart Visualizations and all other visualization types will now have their own number formatting user interface. Clicking on either a Group or Value for a Tabular or Scatter Chart visualization will pop up a small dialog to edit the field, aggregation, sorting and formatting individually. Number formatting options for the other visualization types remains in the same place as before—on the Style tab of the Tile Properties Pane.
Advanced Report Designer Formula Bar
A new Formula Bar has been added to the top of Advanced Report Designer. This formula bar is a new way to add content to cells. Formulas may be added by selecting a cell and then typing directly into the Formula Bar. Clicking the Formula Editor 
icon on the left side will open the standard Formula Editor dialog.
In-Database Grouping and Formula Aggregation
Exago can now push more grouping and aggregation tasks to the data source instead of performing them in-memory. This can mean noticeable gains in performance. Notably, changes made in v2020.1 if there are no other disqualifying factors that:
- Grouping on a formula, when that formula can be converted to SQL, can be done in the data source. Previously, the presence of a group header or footer on a formula would disqualify the report from in-database grouping.
- Aggregating with formula, when that formula can be converted to SQL, will be done in the database. Previously, aggregate formulas that contained a formula would disqualify it from in-database aggregation if any formula was passed as the data argument to the aggregate function.
- Aggregating on a field on the "one side" of a one-to-many join will be done in the data source if the Admin Console > General > Other Settings > Run Aggregate Functions at Record Level By Default setting is true or the recordLevel argument to the aggregate function is true. Previously, aggregating on the "one side" would disqualify from in-database aggregation regardless of the recordLevel value.
- Having multiple data sources on a report no longer automatically disqualifies it for in-database grouping
Additional Mono Support for Linux
A couple of changes around Exago on Linux have been introduced with v2020.1.0:
- Exago now supports Mono version 6.8.0.105 on Linux. The Linux installer will install this version if requested to do so on systems without Mono already installed.
- An issue was fixed that prevented the Exago Linux installer from installing Mono on CentOS 8.
- Improved performance running Advanced and Express Reports on Linux by changing to a different JSON deserialization library
- Increased verbosity during Mono installation (if elected) as an assurance the process is still working
NotePlease also review the What's New in Version 2020.1 articles for more information regarding these features.
Other Changes
- The Linux installer no longer includes an ADO.NET MySQL connector provided by Exago.
- The System.Data.OracleClient driver is no longer supported in Linux. Use Oracle.ManagedDataAccess.Client instead.
- The ExpressView exporter has been re-written to give a fresh new look that makes data easier to consume. This affects ExpressView exported as files and those saved as Advanced Reports.
- The default ExpressView theme has been updated with a fresh set of colors
- A new Getting Started page has been given a refreshing re-design.
- The new color picker (introduced in v2019.2) has been extended to the rest of the application.
- The internal FusionCharts library has been updated to version 3.15.
- The internal Log4Net library has been updated to version 2.0.6.
- The internal Puppeteer rendering library is now turned on by default.
- A new constructor has been added to the JavaScript API which adds an OnError() callback function.
- New in-memory caching for certain JavaScript files, CSS and language files. They can be served from memory without having to build and compress them repeatedly.
- Added All checkbox and Direction dropdown to the Top N Filters dialog, enabling easy Top N aggregate filtering/sorting
- Changed the default state of the Hide Detail checkbox for tabular Dashboard visualizations to checked
- Several Action Events (
OnRightClickReport, OnRenameReport, OnEditReport, OnDeleteReport, OnDuplicateReport, OnExecuteReport, OnSelectReport, OnDoubleClickReport) now support returning Promises - Relocated the Save and Close and Delete buttons in the Dashboard Designer's Filters menu, to make their location more consistent with the rest of the user interface
- Changed user interface cues in the Dashboard Designer when moving an interactive filter on the canvas back to the Filters menu on the toolbar
Issues Fixed
- Fixed an issue where all visualization tiles on a Dashboard wouldn't be included in an output file when the Dashboard was executed by a Scheduler Service
- Fixed an issue where reports with a Stored Procedure data object whose "Category" property in the configuration contained a backslash would throw an error when the report was executed
- Fixed some issues in the Dashboard Designer that would cause Visualization tiles to reload when not expected
- Fixed an issue that prevented the ExcelFormula() function from working as expected
- Fixed an issue where Microsoft Excel exports would fail in certain circumstances when Exago is running on Linux
- Fixed an issue with error messages being displayed if Mono was not installed as part of the installation process on Linux
- Fixed an issue where the user interface would not fully load when FIPS encryption was used
- Fixed an issue where Action Event code stored in the static part of the static-dynamic configuration could cause incorrect session information to be referenced.
- Fixed some issues with text alignment in Dashboard Interactive Filter tiles
- Fixed an issue where small white borders could be seen around tiles on a Dashboard with a dark canvas background color
- Fixed an issue where an error message could be displayed when a chart referenced an aggregate in a Group Header section
- Fixed an issue with filtering boolean data fields from PostgreSQL data sources
- Fixed an issue where filter dependencies do not work as expected when the report is included on a Dashboard
- Fixed an issue where a Dashboard created pre-v2018.2 could break in v2019.2+
- Fixed an issue where an error message would be displayed if three or more column headers were added to a CrossTab Report
- Fixed an issue with the Report Designer user interface that could cause the grid to unexpectedly resize after closing the Categories dialog from the Report Settings menu
- Fixed an issue that could cause an Advanced Report to show an error message if a page break occurs right after a suppressed row and a repeating row
- Fixed an issue where Group Headers would print twice if that header included a Repeat Row and a Page Break
- Fixed an issue in the Admin Console that could cause the browser to freeze if the ID of a Data Object was cleared
- Fixed an issue preventing reports containing a Gauge visualization from being exported when Exago is run on Linux
- Fixed an issue preventing reports containing a Date field on the X-axis of a chart from being exported
- Fixed an issue in the Report Viewer where right-clicking on a column and selecting Hide Column for a CrossTab Report would not hide the selected column, including on exported output
- Fixed an issue where charts appear very small in an RTF export
- Fixed an issue in the ExpressView Designer with changing the groups and values of charts from the properties pane on the right side of the screen
- Fixed an issue preventing Existing Report tiles from changing their contained report with the Content tab of the Tile Properties Pane when using custom Folder Management for report storage
- Fixed an issue where an "root element is missing" error message might be displayed when running reports in a web farm environment
- Fixed an issue where the data field with the desired color information for Conditional Formatting with a Formula had to be included in the section where the conditional formatting was applied
- Fixed an issue where an error message would be displayed when reports are executed on Remote Execution servers accessing temporary file storage hosted in the cloud
- Fixed an issue where executing a scheduled report with batch execution may return a No Data Qualified error message even though running the report returns data as expected
- Fixed an issue preventing Data Objects from being created if the Data Source contained a column of Geometry data type
- Fixed an issue where document templates including the RepeatForEach feature would display an error message when exported as RTF
- Fixed an issue where prompting filters on chained reports would not display the filter title from the component reports
- Fixed an issue with some charts not rendering correctly in PDF exports using the Puppeteer library with Exago running on Linux
- Fixed an issue where an error message would be displayed if a formula sort included fields from two different data sources
- Fixed an issue with the Monitoring Service not recording data if either the userId or companyId system parameters contained the at-sign (@) in their value
- Fixed an issue that would prevent editing or running a report that contained a data object that had been removed from the system configuration instead of showing an error message
- Fixed an issue in the Dashboard Designer where the Refresh button on the toolbar would become disabled if an Existing Report tile containing an ExpressView was added to the canvas
- Fixed an issue where the "No Data Qualified" message could not be dismissed if it appeared on a child report in a linked report relationship
- Fixed an issue with Batch REST Web Service API calls to
PATCH entities/Fields/{FieldName}where the values would actually be updated in the configuration, but would not be reflected in the return value if doing aGET entities/Fields/{FieldName}to verify - Fixed an issue with REST Web Service API calls to
GET /rest/schedulestaking significantly longer than expected when compared to making a similar request through the Web Application user interface - Fixed an issue where an error message would be displayed in the Dashboard Designer if a filter on Visualization tile contained a formula
- Fixed some issues in the Dashboard Designer that would cause Visualization tiles to reload when not expected
- Fixed an issue in the Dashboard Designer that could cause an error message to be displayed when reordering Group or Values on a visualization tile if one of the Groups or Values didn't have a field defined yet
- Fixed the look of the checkboxes when adding Custom Aggregate Functions in the Admin Console that made them difficult to determine their state
- Fixed an issue where the hidden flag
<expressviewdefaultformattheme>to select a default ExpressView theme would not be honored in either a static or dynamic configuration file - Fixed an issue where a filter applied to the right side of a Left Outer Join would still show values from the left side joined to null values
- Fixed an issue where Stored Procedure Data Objects connected to a MySQL Data Source would return all unfiltered rows if a date parameter is passed as a filter value
- Fixed an issue where aggregating in the database would fail if filtering was done in-memory
- Fixed an issue where schedules created weekends would be pushed to start on Monday with a weekday recurrence pattern
- Fixed an issue with Google Maps visualizations that prevented more than one label to be added
- Fixed an issue where some vertical table integrations that use the DataType enumeration were broken
- Fixed an issue with the automatic debug package submitter that prevented debug packages being submitted if the report contained a prompting parameter
- Fixed an issue with the embedded Roboto font not properly loading when integrating Exago with the JavaScript API
- Fixed an issue with REST Web Service API calls to where a call to any Sessions endpoint would return a
nullSortsResourceproperty even if a report has pre-existing sorts or new ones were added with the REST Web Service API - Fixed an issue where creating a child folder with the same name as a report in the parent folder could cause the new folder to take the icon of the report until the browser is refreshed
- Fixed an issue where cell formatting changes in the Advanced Report Designer may take a long time if a lot of cells are selected at once
- Fixed an issue that prevented JavaScript files from being cached when cookieless sessions is enabled
- Fixed an issue where styling applied to tooltips would be applied to client host application elements with a title attribute when implementing Exago with the JavaScript API
- Fixed an issue loading images on the Getting Started tab when accessing Exago with the JavaScript API
- Fixed an issue where Category aliases would appear in the Advanced Report Wizard's list of Categories
- Fixed an issue where an error message would be displayed is passing True to the
includeNullsargument of theAggDistinctCount()function - Fixed an issue with fetch and XHR requests to allow cookies to be set when Exago is accessed from a different origin than the host page. This was necessary to allow Exago to be embedded at a different origin without the need to turn on cookieless sessions
- Fixed an issue where an error message would appear if a user attempted to send a Debug Package to our Support Group through the automatic debug package submission process and they were submitting a Dashboard, a Chained Report, or an Advanced Report with a linked report on it.
- Fixed an issue where an error message relating to cross-origin embedding would incorrectly be displayed from the same origin if the WebEndpoint JavaScript API constructor argument contained any capital letters in the URL's origin.