v2021.2 Release Notes

Release 15

2023-7-7

Issues Fixed

• Changes to date functions are accurately reflected in formulas used in date fields
• The default export type, when set in the admin console to Excel, now exports chained reports in Excel format
• The function Round and rounding numbers using cell formatting, when applied to the same decimal number and place, now return identical results
• Fixed an issue that returned an error message when opening a dashboard that contains a filter applied to a custom column
• When you change a scheduled report filter interval, a new schedule is created accurately reflecting the dates to send future reports
• If a data column contains an If and And statement that returns an error, the error is shown and no longer stops an ExpressView from running
• Fixed an issue that prevented Upper() from recognizing new lines where appropriate
• When you import a filter from dashboard, it appears in the list after ungrouping it from other filters
• You can remove interactive filter values by clicking the red X next to them on the list
• When you export a Child-linked report from the Dashboard Viewer, the resulting file displays only the data displayed in the UI
• Format cell option can be used for cell formatting without any issues with the cell content
• Fixed an issue that returned a unique name error message when editing Report Level Custom SQL Objects
• You can modify the date format in the cell without it impacting the cell border formatting
• Clicking the "Find" search bar and pressing enter on reports with no data now return with a message stating that no records are found
• Fixed an issue that returned JS API errors message when using DisposePage() in callback method
• Display Filter Value on Advanced report displays correct values
• You can scroll down to see Custom Options on Advanced report without any issues
• Fixed an issue where adding a sort prevented "show x more results" appearing on advanced report when using step size row limit
• Fixed an issue that returned a database error message when using the Exago Switch formula in a sort
• Fixed an issue related to extraneous pop-ups generated by user-added content in ExpressView reports

Release 14

2023-4-4

Issues Fixed

• Advanced Attribute “toolTipSepChar” for works now for bubble charts
• Dashboards, while undoing added data field, now re-execute  the tile
• Added httpRuntime executionTimeout on WebServiceApi\web.config.Linux
• Added “CloudToJson” tool in Linux installs
• Dashboard w/ report that has prompting formula filter on a report-level custom SQL object removed stack trace
• Fixed Having a  “>” (special characters )  in a Column Name sorting
• Fixed ReportTemplatesAllowEdit language element to render correctly
• Chart advance Features: Bar 2D, specifically the Chart Cosmetics attributes, now gets applied to chart elements
• Fixed dashboard Import filter 'from' naming appears on the new interactive filter
• Dashboard filters dropdown menu is now resizing correctly when the page window changes
• Fixed Cell background of hidden columns shown on PDF Snapshot export of dashboard report
• Dashboard Slider ranges now accept values exceeding starting values
• Fixed the issue when too many filters cause pagination/scroll on the filter menu
• Fixed issue when in express view auto-formatting string to date
• Fixed issue parameter prompt text does not appear in the dashboard parameter modal
• Fixed issue for templates inheriting access flags from the user rather than the parent object
• Fixed the issue of the date picker being displayed out of place when calling a single report from the JS API
• Fixed issue with recurring scheduled jobs on Sundays hanging up
• Fixed issue on report viewer Page navigation buttons getting disabled after the first use
• Fixed issue with debug package generation code to account for the new Salesforce Ticketed format
• Fixed issue with advanced reports designer freezes after trying to move a repeating group section
• Fixed issue with the exception being  thrown when trying to schedule a report
• Custom SQL now handling parameters without default values

Release 13

2022-12-06

• The AR Interactive Filter value input is no longer empty after you save a value in the Date Time field
• The Hyperlink() function in column metadata now returns correct results
• The “DateFormatMethodString” for Postgres now uses a valid database function for Postgres v13
• You can now close the executed report tab when running through wrApiAction.EditReport
• Using .NET API w/ JS front end, Exago no longer calculates the export options pop-up location based on window width
• Advanced report  background now fills the entire tile of the dashboard
• The manage data object no longer disappears after the report runs, when you return to designer
• The Scheduler <error_report_to> now sends emails to everyone on the list, not just to the last person in the list
• The Dashboard Toolbar Menu Title text now uses the correct language file, and is no longer hard coded

Release 12

2022-11-7

• You can now double click toolbar icons for dialogs without opening the dialog
• You can now click undo twice after adding a filter to the dashboard without causing a JS error
• You can now add custom columns without getting a non-grouping sort problem
• Dynamic filters on executed advanced reports now work properly
• Dashboard visualizations now properly fill the entire tile when the dashboard is first to run

Release 11

2022-10-05

• Updated security for Advanced reports 
• Reports now display correctly when you disable pagination
• You can now use the Move Folder option for Read-only Folders

Release 10

2022-09-28

• You can now modify non-sort group formulas after adding them to a report
• Credential-less SMTP now works with your Mail Kit
• RTF Exports now populate consistently
• You can now export a Linked report, and it returns all data and applies all parent filters
• Dashboard date parameters no longer allow string values that break your dashboard execution
• You can now export reports and all the data you want in the report can be viewed
• When you export a Crosstab from the HTML viewer, Exago does not convert numbers to Zeros
• Express View reports are no longer vulnerable to cross-site scripting
• You can now set an OnReportExecuteInit event and it will execute reports on the dashboard

 

Release 9

2022-07-28

• PDF exports for specific expressView report structure now function properly
• Date quick functions now work properly for null date values
• Clearing an interactive filter value for a dashboard tile now functions correctly when it is refreshed
• Heat Map style & color distribution now allows you to use "Percentage of data" checkbox in chart wizard
• Heat map slider scale max value is output now matches the largest value in the associated dataset
• Report editor no longer allows categories to be enabled that should not be enabled
• You can now apply a Role filter to a Stored Procedure Data Object without getting an error
• You can now add reports to a chained report
• Column header bar is no longer duplicated when you press the down arrow of the search bar twice in report viewer

Release 30-2021.1

2022-12-06

• The AR Interactive Filter value input is no longer empty after you save a value in the Date Time field
• The Hyperlink() function in column metadata now returns correct results
• The “DateFormatMethodString” for Postgres now uses a valid database function for Postgres v13
• You can now close the executed report tab when running through wrApiAction.EditReport
• Advanced report  background now fills the entire tile of the dashboard
• The Scheduler <error_report_to> now sends emails to just to the last person in the list.
• The “Dashboard Toolbar Menu Title.” now uses the correct language file.

Release 29-2021.1

2022-11-07

• You can now double click toolbar icons for dialogs without opening the dialog
• You can now click undo twice after adding a filter to the dashboard without causing a JS error
• You can now add custom columns without getting a non-grouping sort problem
• Dynamic filters on executed advanced reports now work properly
• Dashboard visualizations now properly fill the entire tile when the dashboard is first to run

 

Release 26-2021.1

2022-07-28

• PDF exports for specific expressView report structure now function properly
• Date quick functions now work properly for null date values
• Clearing an interactive filter value for a dashboard tile now functions correctly when it is refreshed
• Heat Map style & color distribution now allows you to use "Percentage of data" checkbox in chart wizard
• Heat map slider scale max value is output now matches the largest value in the associated dataset
• Report editor no longer allows categories to be enabled that should not be enabled
• You can now apply a Role filter to a Stored Procedure Data Object without getting an error
• You can now add reports to a chained report
• Column header bar is no longer duplicated when you press the down arrow of the search bar twice in report viewer

Release 42-2020.1

2022-12-06

• The AR Interactive Filter value input is no longer empty after you save a value in the Date Time field
• The “DateFormatMethodString” for Postgres now uses a valid database function for Postgres v13
• Advanced report  background now fills the entire tile of the dashboard
• The Scheduler <error_report_to> now sends emails to just to the last person in the list.
• The “Dashboard Toolbar Menu Title.” now uses the correct language file.

Release 41-2020.1

2022-11-07

• You can now add custom columns without getting a non-grouping sort problem
• Dynamic filters on executed advanced reports now work properly
• Dashboard visualizations now properly fill the entire tile when the dashboard is first to run

Release 38-2020.1

2022-07-28

• PDF exports for specific expressView report structure now function properly
• You can now apply a Role filter to a Stored Procedure Data Object without getting an error
• Column header bar is no longer duplicated when you press the down arrow of the search bar twice in report viewer

Release 8

2022-07-05

• Dashboard export now shows the correct data.
• Interactive dashboard filters now show valid values.
• Repeating headers now stationery , fixed error after attempting to move.
• Custom filter functions are able to be saved in report metadata.
• Merged Cells Need to be Un-Merged to Work in Columns with Cells in Merged Area.
• “Is One Of/Is Not One Of” plus sign is no longer removed in filter menu.
• Dashboard filter menu no longer goes off screen when embedding Exago.
• isnull() formulas used as filters are now passed to the database.
• All of the intended Vis Tiles now render properly in a Snapshot.

Release 25-2021.1

2022-07-05

• Dashboard filter menu no longer goes off screen when embedding Exago.
• “Is One Of/Is Not One Of” plus sign is no longer removed in filter menu.
• Merged Cells Need to be Un-Merged to Work in Columns with Cells in Merged Area.
• Custom filter functions are able to be saved in report metadata.

Release 36-2021.1

2022-07-05

• “Is One Of/Is Not One Of” plus sign is no longer removed in filter menu.

Release 7

2022-06-06

Features Added

Better logging for AWS SKD for S3 uploads, to help with debugging issues.

Issues Fixed

• Prefix settings now work properly when you confirm operations when using the import/export storage management utility.
• You can now export special characters without experiencing problems .
• The update run count now works properly after your first execution, when you migrate to the latest version of Exago BI.
• The Boolean field in the Npgsql driver now works properly when you use the import/export storage management utility.
• Repeating header group sorting fields now display properly when you are editing a report.
• You no longer see hidden columns on exported Dashboards.

Release 6

2022-05-02

Features Added

• The color picker dialog suggests the previously selected element color, rather than white, when clicking the Reset button in the dialog
• Increased security around the handling of serving image files from the web server
• Added new EncryptionKey and EncryptionIV tags to the AppSettings.config file for the Web Application

Issues Fixed

• Fixed an issue where an incorrect SQL statement was constructed when executing a Linked Report with an interactive multiple choice filter and one of the values was null
• Fixed an issue where calculations with Date paramters using dd/MM/yyyy format returned an incorrect result
• Fixed an issue where Filter Functions were not evaluated for every execution of a report, only for the first execution
• Fixed an issue where clicking the X in the Data Objects Pane search field wouldn't actually clear the search value
• Fixed an issue where using the AggSum() function in a Repeating Group Header section returned the first value in the data set rather than the sum
• Fixed an issue where a disabled Dashboard Canvas background color shows through on interactive filter tiles during execution
• Fixed an issue where Existing Report tiles with an ExpressView would not show the chart if moving away from Dashboard tab
• Fixed an issue where no error message would be displays when opening a report with a Data Objects that has been disabled by the active Role

Release 5

2022-04-04

Features Added

• Changed the order in which jobs are sent to Scheduler Services, to first validate the connection to the Scheduler Service
• Updated the included jQuery UI library to v1.10.0

Issues Fixed

• Fixed an issue where In Between filters did not apply if one of the filter values was not provided
• Fixed an issue where large tables in reports could spill off the Report Viewer page if several instances of the report were executed simultaneously
• Fixed an issue where Conditinal Formatting did not apply when in a Footer Section, Aggregate and Group in Database is True and Convert Formulas to SQL is True
• Fixed an issue where special characters that do appear in the Report Viewer do not appear in PDF exports when Exago is running on Linux in certain environments
• Fixed an issue where the FilterValue() function returned different output if the filter had one value or several values
• Fixed an issue with column width calculation in the Report Viewer in certain circumstances
• Fixed an issue where the wrong language file element was being referenced when including Setup Data at the start or end of a report that included one or more Top N Filters
• Fixed an issue where deleting a report from the Report Tree didn't close any Designer or Report Virewer tabs that are open related to the report

Release 4

2022-03-15

Features Added

• Improved error messaging when launching a session fails

Issues Fixed

• Fixed an issue with the horizontal scroll bar on a Dashboard existing report tile rendering behind another user interface element preventing access to it
• Fixed an issue where the Scheduler Service would not send emails with credential-less or unauthenticated SMTP connections
• Fixed an issue where an incomplete list of Dashboard interactive filter values was presented in the user interface
• Fixed an issue where reports grouping on non-sort fields stopped working in v2021.2.0+
• Fixed an issue where an error message would be displayed and report execution would be canceled if the @pageNumber@ parameter or PageNumber() function were included in either a Page Header or Page Footer section
• Fixed an issue where Advanced Reports would load uncentered in their Dashboard tile if the Dashboard loads in a tab other than the currently selected one
• Fixed an issue where the X and Y Axis Labels do ot get saved or display for Statistical Process Charts
• Fixed an issue where the Dashboard canvas color shows through an existing report tile after scrolling the report in the tile

Release 3

2022-02-22

Features Added

• Improved error messaging when launching a session fails

Issues Fixed

• Fixed an issue with certain in-memory filters on Assembly Data Sources compared to SQL Data Sources causing different result sets
• Fixed an issue where an error message would appear if linking to another report in a Report Footer section and the linking field is both a Key Column and has a Column Alias
• Fixed an issue where charts sometimes do not appear in a Dashboard Snapshot export
• Fixed an isuse with Excel exports not honoring the Apply Numeric Decimal Places to General Cell Formatting Culture Setting
• Fixed an issue that prevented the use of the FitlerValue() function's third argument
• Fixed an issue with the placement of the Open Rows icon when the first few cells of a row are empty
• Fixed an issue where tiles that are close together on a Dashboard might overlap when exporting as a Dashboard Snapshot
• Fixed an issue where an existing report tile on a Dashboard could not be deleted if the report could not be loaded
• Fixed an issue where the DateAdd() function shows different output in Excel export versus the Report Viewer if cell formatting set to General and DateTime values are being treated as dates
• Fixed an issue where scrolling a visulziation's scroll bar in the Dashboard Deigner moved the tile up and down the canvas with the scrolling action
• Fixed an issue preventing a warning message from being displayed when adding or removing Data Objects from an Advanced Report that could affect the reports join configuration
• GlobalNumericFormat() is now listed in the Arithmetic and Geometric Functions category for all versions of Exago
• Chnaged the return type of GlobalNumericFormat() from numeric to string

Release 2

2022-01-28

Features Added

• Add official support for Oracle Linux in the Linux installer
• Added support for proxying the Storage Management assembly for environments where access to the Storage Management system outside of the domain are required
• Added support for table functions in Snowflake Data Sources

Issues Fixed

• Fixed several issues with the handling of Collapsed Rows in the Report Viewer if the collapsed rows included vertically merged cells or groups
• Fixed an issue where adjusting an interactive range slider on a Dashboard could cause repeated data rows to appear in the child report of a Linked Report
• Fixed an issue where a consolidated Dashboard filter that was unconsolidated in the Dashboard Designer would not save in the unconsolidated state
• Fixed an issue where dragging an existing report to the Dashboard canvas but then dragging over another part of the interface prevents the tile from being created when returning to the canvas
• Fixed an issue where an interactive range slider filter on a Dashboard using the MonthName() function could inadvertently cause month names to appear out of chronological order
• Fixed an issue where a Pie Chart with an Other category percenter value greater than zero would show No Data to Display instead of rendering the chart
• Fixed an issue where changing the foreground color of an Express Report cell would change it to white regardless of selected color
• Fixed an issue where the filter operator and value are displayed in the Report Viewer even if the filters are hidden or removed
• Fixed an issue where a scheduled Chained Report or scheduled report with an associated linked report would fail if one of the component or child reports was modified after the report had been scheduled
• Fixed an issue where Group Headers set to Repeat Header on new pages were not doing so
• Fixed an issue with the Report Viewer's Conditional Formatting dialog filter list forgetting the setting for conditionally formatted sections of the report
• Fixed an issue where a visual glitch occurred when viewing an Advanced Report on a Dashboard

Release 1

2021-01-07

Features Added

• Decreased the line height in ExpressView cells to increase readability for narrow width columns

Issues Fixed

• Fixed an issue where tiles that are close together on a Dashboard would collide with each other on a Dashboard Snapshot export

Release 0

2021-12-17

We are proud to release Exago BI v2021.2!

Check out the list of new features and other changes below.

Dashboard Snapshots

A new exciting Dashboard export type has been added to the application. A Dashboard Snapshot captures a screenshot-like picture of the Dashboard as it would appear in the Dashboard Viewer. Since these snapshots are an export type, they can be scheduled and emailed or saved to a user's local file system just as any other export file can.

As a result, new size and style controls have been added to the Dashboard Designer's toolbar. For more information, review the Dashboard Designer (v2019.2+) and Exporting Dashboards (v2019.2+) topics for details about the new controls and how to create a snapshot.

New Advanced Report Designer Group Workflow

Creating a Group sections in the Advanced Report Designer requires first creating a sort. To simplify this workflow, a sort can now be added right from the Add Section menu on the Design Grid. The dialog for creating groups has been removed, and replaced with this much simpler menu driven system.

 

For more information, visit the Advanced Reports: Sections (v2021.1+) topic.

Data Source Connection String Builder

The new Connection String Builder for Data Sources in the Admin Console takes the guesswork out of connecting data to the application. Instead of having to use a connection string, the Admin Console can create the connection string in an interactive format. Of course, using a standard connection string is still available if that is preferred. Since the connection string is still used by the application in the background, it still exists. This also means that no changes need to be made to accommodate this enhancement when upgrading—it will work out of the box.

Add All Complete Objects

This feature adds new tables, views, stored procedures or database functions that have at least one primary key defined in the data source (called a complete object). Joins are added when there is a foreign key from one complete object to another. The process happens automatically, so each data object, join and metadata does not need to selected in the wizard format of the Discover Object/Join Metadata option. For more information, review Automatic Database Discovery.

The Storage Management system introduced in v2020.1 supports using a variety of SQL databases for storage of user content—including a SQLite file for testing and demonstration purposes. To decrease initial setup and configuration time, Exago now initializes this SQLite file, loads the default data and folders into it, and imports the chart and report themes automatically during installation. Previously, visiting the Storage Management section of the Admin Console was required to perform these steps manually.

Exago still recommends transitioning off of the SQLite file for production environments.

Other Enhancements

• New JSONExtract Function can be used to extract data from JSON objects and use it in reports.
• New /rest/Sessions/Save endpoint to the REST Web Service API to save session changes to a file.
• New user interface design for providing the login credentials for the Admin Console.
• Decreased report execution time in certain situations with large data sets and in-memory grouping.
• Improved memory management for internally used Image and Bitmap objects.
• Upgraded the internal JavaScript minifier to Terser.
• Upgraded the internal NodaTime library to version 2.4.14.
• The SQL generation engine now supports custom logic-based SQL generation per function.
• The SQL generation engine emits neater and more compact SQL by using column aliases from the SELECT clause in the ORDER BY clause.
• Updated the Snowflake CDATA driver to version 21.0.7887.0

Other Bugfixes

• Fixed an issue where the Admin Console > General > Culture Settings > Time Zone Name was not applied to the Now() and Today() Date Functions.