Changelog - Private eazyBI

Private eazyBI

8.0.0  /  Relesed Nov 19, 2024

New in this release:

• AI assistants for building reports and writing calculated member MDX formulas.
• Add multiple instances of the same report to a dashboard and use different page filter selections.
• Upgraded charting library with several chart display improvements and bug fixes.
• Font Awesome upgraded to version 6.6.0.
• Improved display of date format errors when importing custom source data.
• Improved audit log – view and copy old and new values of changed attributes.
• Additional usage statistics measures.
• Improved Settings page with separate database, license, and additional settings tabs.
• Removed support for data import from Jira apps, just core Jira data are imported (see comparison with Jira DC app).

Fixed in this release:

• Fixed centering of string and date measure values in gauge charts.
• Use the same zero level when several axes are used in a chart.
• Fixed display of Gantt chart hover popups when Markdown or HTML formatting is used.
• Allow to fix a report after a report execution error is received.
• Fixed LDAP group role checking.
• Fixed custom source data import after renaming custom data cube name.
• Improved headless Google Chrome initialization and error handling.
• Several fixes for synchronization to the ClickHouse OLAP DWH database.

7.2.1  /  Released Aug 19, 2024

Fixed in this release:

• Fixed security vulnerability, which allowed unauthorized code execution on the server from custom JavaScript code.
• Fixed detection of installed headless Google Chrome on Linux servers.
• Fixed connection to remote headless Google Chrome by ignoring proxy server settings.
• Fixed REST API OAuth2 authorization from Jira servers.
• Fixed user authentication from an external OAuth provider when mixed-case emails are used.
• Fixed database migrator when using Oracle and "Preserve original IDs".

7.2.0  /  Released Jul 18, 2024

New in this release:

• Audit log of report definitions, calculated members, access rights, and other changes.
• Arrange dashboards in folders.
• New FuturePeriods and GetCaptionWithoutKey MDX functions.
• Improved MDX functions Case, Match, Generate, and CoalesceEmpty to handle arguments with different types.
• Improved calculated member formula syntax validation.
• Improved JavaScript custom code error messages with original line number reference.
• Several Jira import improvements and bug fixes.

Fixed in this release:

• Fixed cell formatting range definition when using a percentage value.
• Fixed long measure names in gauge chart labels.
• Fixed frozen header for wide table reports in dashboards.
• Fixed custom JavaScript code out-of-memory error handling during data import.
• Fixed resetting of import status for failed import jobs.
• Fixed parsing of invalid dates in custom column mapping.
• Updated several library dependencies to the latest versions without known vulnerabilities.
• Several other smaller UI and data import fixes.

7.1.0  /  Released Feb 08, 2024

New in this release:

• Automatic dark theme that matches the selected system theme.
• Select the dark or light theme for embedded reports.
• Improved latest report and dashboard updates on the home page.
• Show the last import status and time for reports in the Analyze tab and dashboard subscription emails.
• Several Jira import improvements and bug fixes.

Fixed in this release:

• Improved performance of cell formatting using MDX expressions in large reports.
• Fixed drill through into standard calculation "empty as 0".
• Fixed the columns' total when a measure is drilled into another dimension or when using date and numeric measures.
• Fixed report execution with references to missing dimension members.
• Fixed horizontal table scrolling in dashboards.
• Fixed some Gantt chart rendering bugs.
• Fixed showing of the Bubble button in scatter charts.
• Fixed "Expand all" when multiple hierarchy levels are used in a report.
• Allow showing full non-truncated names in pie charts.
• Fixed rendering of charts in hidden browser windows or tabs.
• Fixed gauge chart export to PDF.
• Fixed unexpected reloading of dashboard reports when opening popup menus.
• Fixed PreviousRowValue MDX function when it is used by several calculated measures.
• Prevent usage of getDocument callbacks within other getDocument calls (which cause performance problems) in custom JavaScript code.
• Fixed handling and termination of getDocument and postDocument callbacks in custom JavaScript code.
• Fixed Google Sheets import if data are deleted.
• Fixed validation of unsupported source file formats.
• Fixed several data mapping problems.
• Fixed updating of data access roles after renaming a cube.
• Fixed some report results export API problems.
• Fixed conditional alert email cell text color.
• Fixed conditional alert with report-specific measures in conditional MDX formulas.
• Fixed conditional alerts in Gantt charts.
• Several ClickHouse OLAP DWH database synchronization improvements and fixes.
• PostgreSQL JDBC driver updated to a later version without known vulnerabilities.
• Fixed validation of a database name in SQL import to avoid injection of vulnerable additional JDBC URL parameters.
• Fixed MultiPass authentication.

7.0.1  /  Released Jul 19, 2023

Fixed in this release:

• Fixed data access role limitations in drill-through results.
• Jira import:
  • Fixed import of Jira worklog dates when using the default server time zone in import options. 
  • Fixed Jira import on Oracle which failed when updating table column data types.

7.0.0  /  Released Jul 05, 2023

New in this release:

• Conditional report alerts.
• Administer dashboard email subscriptions of other users.
• Improved Time weekly and fiscal hierarchies, define calculated Time hierarchy.
• Markers for selected chart options.
• Select member display name (with or without key, truncate or not) in scatter charts.
• Improved storing of drill into level actions in report definitions.
• New JavaScript function getCachedDocument.
• New MDX function CalculatedChildrenSet. 
• Revalidate invalid measures after full data re-import.
• Use ClickHouse OLAP DWH database to improve report performance in large accounts.
• Font Awesome upgraded to version 6.3.0.
• Support headless Google Chrome 110 and later versions on the server for PDF export.
• Old jTDS JDBC driver replaced with MS SQL JDBC driver.
• Removed support for Internet Explorer 11.
• Comic style reports and charts.
• Jira import
  • New Days assigned and Workdays assigned measures.
  • Log and display issue key for which custom JavaScript code failed during the import.
  • Several other improvements and bug fixes.

Fixed in this release:

• Fixed overlapping long pie chart labels.
• Fixed data label positioning to be the same in bar and line charts.
• Fixed decimal percentage formatting to be the same in all chart types.
• Improved performance of drill through dimension level.
• Improved performance of Mondrian schema generation for large data cubes.
• Fixed time ago and sparklines standard calculations for Time dimension calculated members.
• Fixed Abs and Round MDX functions when using PostgreSQL.
• Fixed nonempty reports with missing measures or dimension members.
• Improved case-insensitive name uniqueness validation of user-defined and report-specific calculated members.
• Fixed several custom data mapping problems.
• Fixed several database migrator problems.
• Fixed several problems in dashboard export to PDF.

6.6.0  /  Released Nov 10, 2022

New in this release:

• Support POST requests for REST API imports.
• New "Use SSL" and "Skip SSL certificate verification" options for import from MS SQL Server when using MS JDBC driver.
• Jira import
  • New Jira custom field advanced import options dialog and JavaScript calculated custom field dialog.
  • Search projects and categories in Jira import options; show only selected or all projects.
  • Several other improvements and bug fixes.

Fixed in this release:

• Fixed saving of modified dashboards sequence.
• Fixed consistent display of the last import error date in all tabs.
• Fixed consistent positioning of data labels in charts.
• Fixed linear trend standard calculation in some specific cases.
• Fixed creation of new calculated members in dashboard common pages.
• Restrict HTML element "class" and "style" attribute values in report and dashboard descriptions.
• Do not allow making reports private if already included in dashboards.
• Fixed several source data mapping problems for REST API, SQL, and file import.
• Fixed support for dimensions containing a dot in the name.
• Fix "result set is not updatable" errors in SQL import from MS SQL Server.
• Fixed potential infinite loop problem in REST API import if custom JavaScript code is used.
• Fixed compression and minification of JavaScript and CSS files.

6.5.0  /  Released Jul 4, 2022

New in this release:

• Nonempty page selection (show subset of available page dimension members based on previous page selections).
• Improved editing of common dashboard page dimensions.
• Save dashboards with collapsed reports.
• Improved performance of reports with multiple pages and multiple members selection.
• Improved performance of standard calculations.
• Show a message when there are no report data to show.
• New MDX functions DateDiffWorkHours, PreviousRowValue, ConstantValue, ConstantColumnValue, CumulativeSum.
• Improved selection of available regions and countries in map charts.
• Improved source data mapping for REST API, SQL, and files import.
• Several Jira import new features and improvements.
• Do not include authentication secrets in REST API import definition export.
• Removed support for PostgreSQL versions before 9.4.
• Support for macOS on Apple Silicon (M1 and M2 processors).

Fixed in this release:

• Fixed zooming into a short time period in timeline charts.
• Fixed date measure display in timeline charts.
• Fixed total value formatting in pie charts.
• Fixed display of OpenStreetMap in map charts.
• Fixed Gantt chart PDF export with long measure names.
• Fixed Gantt chart weekly view.
• Keep row totals after drilling across another dimension.
• Fixed measure drill into a dimension in combination with DefaultMember in custom formulas.
• Fixed drill through shared measures.
• Fixed display of page dimensions in the chart PDF export.
• Improved validation of calculated member names to prevent conflicts with existing dimension member and level names.
• Upgraded several libraries to the latest versions (including log4j upgrade to 2.17.1).
• Several other small bug fixes.

6.4.0  /  Released Nov 02, 2021

New in this release:

• Conditional formatting in the bar, line, and timeline charts.
• Separate Save as button for creating a copy of the report.
• Save button is active only after the report is changed and only saves the current report.
• Allow saving of sample reports with a new name.
• Convert report-specific measures to shared user-defined measures.
• Show eazyBI Latest News on the Home page.
• Improved storing and display of import warnings.
• Use data type "text" in source data mapping.
• Additional countries and regions in the static map selection.

Fixed in this release:

• Fixed rendering of bar chart labels after zooming.
• Fixed highlighting of pie chart slices on hover.
• Fixed Markdown and sparkline formatting in Total and All other rows.
• Fixed removing of a measure when another measure is drilled into a dimension.
• Fixed bookmarking of members with square brackets in their names.
• Fixed using of report-specific measures in report filters.
• Fixed indentation of aggregated calculated members in table reports.
• Show warning when user-defined measure references report-specific measure.
• Do not allow moving of sample reports to a different folder.
• Collapse dimensions after removing from a report.
• Fixed export to PDF of a dashboard with an embed token.
• Improved layout of large multi-page tables when exporting to PDF.
• Fixed gauge chart export to PNG.
• Fixed multiple page selection display in dashboard reports.
• Fixed Gantt chart rendering with additional dimensions in columns.
• Fixed exact value conditional formatting for empty values.
• Fixed showing of database migratory options.
• Fixed resetting of source application statuses after database migration.
• Allow changing of default custom JavaScript code execution timeout.
• Fixed usage of SQL Server connection "instance" parameter.
• Fixed problems when using MySQL JDBC Connector 8.0.26 or later.
• Fixed support for headless Google Chrome version 93 or later.
• Fixed the possibility to disable 2FA during the authentication process.
• Fixed CSRF that allowed to log out the user.

6.3.0  /  Released May 10, 2021

New in this release:

• Show source data import warnings until they are manually cleared.
• Improved row filter validation for regular expressions.
• Added endless scroll to large table reports in dashboards.
• Use size formatting suffixes (KB, MB, GB) in cell formatting conditions.
• Include report or dashboard name in the page HTML title element.

Fixed in this release:

• Perform automatic vacuum on PostgreSQL tables after each import to reduce table size and improve query performance.
• Recreate dimension tables on PostgreSQL after adding and dropping many custom fields.
• Fixed support for the latest MySQL JDBC driver version 8.0.23.
• Fixed default Java time zone handling when using MySQL.
• Fixed Git log import when Time dimension custom hierarchies are defined.
• Fixed several problems when saving template reports.

6.2.1  /  Released Mar 04, 2021

New in this release:

• Support Okta authentication (additional configuration needed).

Fixed in this release:

• Fixed several cell formatting bugs and improved cell formatting colors in the wallboard view of the dashboard.
• Fixed positioning of data labels in horizontal bar charts in Firefox.
• Fixed tooltips in stacked bar charts with ranges.
• Trim leading and trailing spaces from a report name when saving a report.
• Fixed standard calculations that are based on removed other standard calculations.
• Standard calculations on a string property will return an empty result instead of an error.
• Fixed Time dimension aggregation (random missing values on higher hierarchy levels) when using Oracle.
• Remove the Wikimedia map type from map charts.
• Improved table row count performance on Oracle during Mondrian schema generation.
• Prevent too deep stack (caused by recursion) in custom JavaScript code.
• Several Multipass authentication fixes.

6.2.0  /  Released Jan 19, 2021

New in this release:

• Conditional cell formatting improvements – new exact value and regular expression conditions, top/bottom, and heatmap formatting, custom formulas.
• Change report height in dashboards – specify either fixed or dynamic report height.
• Add sparklines in table reports and gauge charts.
• Show Markdown, HTML, plain text, and date measures in gauge charts.
• Improved gauge width calculation to enable showing of more gauge items in one row.
• HTML and plain text formatting for calculated measures.
• MDX autocomplete improvements for calculated measure formulas – hidden dimensions and measures, dimension levels, property names, members in lower dimension levels.
• Improved calculated member formatting selection drop-down.
• Remember the last used Analyze tab view (grid or list) and sorting criteria.
• Upgraded Font Awesome icons that can be used in descriptions and Markdown/HTML measures.
• Upgraded JavaScript engine to Rhino 1.7.13 which allows more modern syntax in custom JavaScript code.
• Support for MySQL 8 database and JDBC driver.

Fixed in this release:

• Fixed rounding when using calculated measure minutes formatted.
• Do not close the dashboard page selection popup after a dashboard report is rendered.
• Limit allowed HTML tags and CSS properties in report and dashboard descriptions.
• Allow users with the User role to delete report specific measures in their reports.
• Validate the presence of report-specific calculated measure name.
• Fixed timeline chart rendering problems on Safari.
• Fixed report results export API when using report-specific calculated measures.
• Avoid out of memory errors when importing large Excel files.
• Limit used database connections during Mondrian schema generation.
• Fixed connection to PostgreSQL with specific secure connection settings.

6.1.1  /  Released Oct 02, 2020

Fixed in this release:

• Fixed merging of table report header cells when using multiple dimensions.
• Show warning when too much data are selected for bar, line, and pie charts.
• Fixed export to PDF from embedded reports with an access token.
• Fixed export to PDF from reports with report-specific calculated measures.
• Fixed XSS problems in calculated member delete warning messages.
• Improved Mondrian schema generation performance.
• Limit SQL import max connection, read, and query timeouts.
• Show a warning when the database migrator cannot preserve account, report, and dashboard IDs.
• Prevent internal network requests in PDF export using the headless Google Chrome when SSRF protection is enabled.
• Fixed adding of account users when LDAP user search is disabled.

6.1.0  /  Released Sep 14, 2020

New in this release:

• Define report specific calculated measures.
• View calculated member usage in reports and other calculated member formulas.
• Show a warning when navigating away from an unsaved modified report in the Analyze tab.
• Markdown formatting for calculated measures.
• Support for PostgreSQL versions 11 and 12.
• Admins can delete invalid predefined calculated measures.
• Optional two-factor authentication (2FA) using TOTP authenticator apps.
• Set SQL import query timeout to avoid stuck imports when using too slow SQLs.
• Jira integration:
  • Template accounts with a set of reports, dashboards, and calculated members that can be imported into other accounts.
  • Custom property hierarchies in Project and user dimensions.
  • Import additional Issue dimension properties Fix Versions, Affects Versions, Components, Labels, Sprint.
  • Limit created database records for issues with very large changelogs and worklogs.

Fixed in this release:

• Fixed ordering actions in gauge charts.
• Fixed report and dashboard description Markdown formatting of bullet and numbered lists.
• Fixed rendering of table reports with a frozen header.
• Fixed dashboard rendering if some stored common pages are deleted.
• Fixed static map chart colors for small measure values.
• Fixed several XSS problems in report descriptions and chart labels.
• Show warning if too many data selected for bar, line, or pie charts.
• Fixed date and interval formatting, custom cell formatting colors in results export to Excel.
• Fixed export of dashboard definition if some dashboard reports are deleted.
• Fixed export to PDF from an embedded report with a token.
• Added several missing time zones in import options.
• Several fixes in additional data import column mapping validations and import.
• Allow delete of custom data cube dimensions.
• Fixed user search by case-insensitive email when using LDAP authentication.

6.0.0  /  Released May 26, 2020

New in this release:

• New user interface with a lighter and brighter look. The new larger color palette for charts, lighter headers for table reports, new icons, and improved navigation.
• Additional standard calculations – cumulative sum including empty values, many "time ago" calculations, empty as 0.
• Freeze row headers (in addition to column headers) in table reports.
• Show All member names in gauge charts when other members used from the same dimension.
• Added hours, minutes, seconds formatter for usage statistics duration measures.
• Use additional LDAP filters when autocompleting user names (see ldap.toml.sample file)
• Jira integration
  • Many new Jira Issues and Time Tracking sample reports.
  • Use the new Sprint activated date (introduced from Jira version 8.7) for calculation of Sprint actual start date that is used for sprint committed issues and story points. After upgrade, please verify user defined calculated members that used sprint start date.
  • Added new Week Day dimension.
  • Support import of Jira Cloud next-gen projects.

Fixed in this release:

• Improved decimal percentage display in chart axis labels.
• Fixed display of the "order by" measure after drilling into it.
• Fixed row filtering when using custom weekly hierarchy.
• Fixed total calculation errors for some calculated measure formulas.
• Fixed restart of canceled imports during the startup.
• Fixed selection of Google Sheet name in import options.
• Fixed data access role definition for additional dimension hierarchies.
• Fixed case-insensitive search of user groups in the account users page.
• Use the case-insensitive search in Admin / All accounts page.
• Fixed creation of a new PostgreSQL database during the initial setup.
• Allow using the specified MS SQL database if the default master database is not accessible.

See changes in the previous Private eazyBI versions.