What's New in Version 2021.2
We are proud to release Exago BI v2021.2!
Check out the list of new features and other changes below.
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.
Default SQLite Storage Management Database
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.
- New JSONExtract() function can be used to extract data from JSON objects and use it in reports.
/rest/Sessions/Saveendpoint 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 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
Fixed an issue where the Admin Console > General > Culture Settings > Time Zone Name was not applied to the Now() and Today() functions.