Changelog - eazyBI for Confluence

eazyBI for Confluence

We recommend using the latest version of eazyBI for Confluence Server to get the latest features and bug fixes.

7.0.1  /  Released Jul 19, 2023

Fixed in this release:

• Fixed testing and sending of dashboard email subscriptions and report alert emails.
• Fixed data access role limitations in drill-through results.
• Fixed showing of MS SQL database type in SQL import.
• Fixed use of encrypted database password.

7.0.0  /  Released Jun 30, 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.
• Encrypt eazybi.toml database password with a key from a file.
• Font Awesome upgraded to version 6.3.0.
• Removed support for Confluence 6.x.
• 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 for Confluence Cloud and Data Center.

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.
• Fixed use of saved dashboard common pages in dashboard macros.
• 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.
• Fixed some child process startup problems.
• Fixed releasing of some unused database connections.
• Fixed restarting of canceled import jobs during Data Center node startup.

6.6.0  /  Released Nov 07, 2022

New in this release:

• Search spaces and categories in Confluence import options; show only selected or all projects.
• Automatically scale table reports and Gantt charts to full width in Confluence page PDF exports.
• 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.
• Support for Confluence 8.0 (tested with the current latest EAP release).

Fixed in this release:

• Fixed detection and import of Confluence search queries.
• Fixed table "Freeze header" in Confluence macros.
• 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 some specific custom hierarchy import problems when using MS SQL Server.
• Fixed potential infinite loop problem in REST API import if custom JavaScript code is used.
• Improved memory cleanup after uninstallation and reinstallation of eazyBI.
• Fixed compression and minification of JavaScript and CSS files.

6.5.2  /  Released Jul 12, 2022

Fixed in this release:

• Fixed cube report queries in some specific server configurations.
• Do not fail imports if the collation "und-x-icu" is not available in PostgreSQL.
• Do not show warning messages during startup in the eazybi-child.out file.
• Fixed detection of active dedicated Data Center nodes after the initial setup.

6.5.1  /  Released Jun 29, 2022

Fixed in this release:

• Fixed starting of eazyBI on servers with disabled IPv6.
• Fixed starting of eazyBI on Windows servers.
• Fixed starting due to BootstrapMethodError after repeated installations of eazyBI.
• Add a caption to calculated aggregated members in pages that can be used in other formulas.

6.5.0  /  Released Jun 27, 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.
• Publish collapsed reports and dashboards on Confluence pages.
• 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.
• Add members in the Time dimension during data import.
• Improved source data mapping for REST API, SQL, and files import.
• Improved load balancing of import jobs when using several Data Center dedicated nodes.
• Show information about child processes on all Data Center dedicated nodes on the Troubleshooting page.
• Improved eazyBI database migrator to Cloud (longer timeouts) and improved warning messages.
• Do not include authentication secrets in REST API import definition export.
• Add advanced database setting for encrypting REST API and SQL import authorization credentials.
• 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 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.
• Fixed import of Confluence page attachment size as big integers.
• Upgraded several libraries to the latest versions (including log4j upgrade to 2.17.1).
• Several other small bug fixes.

6.4.1  /  Released Nov 29, 2021

Fixed in this release:

• Retry saving of import job status after database connection is lost.
• Show bidirectional Unicode characters in code editors.
• Fixed database migration when importing from a zip file.
• Fixed table optimization (automatic vacuum) on PostgreSQL.
• Improved database table size calculation performance on PostgreSQL.
• Fixed too frequent changes of d_time table which caused errors on MS SQL Server.
• Fixed update of integer field limit on Oracle.

6.4.0  /  Released Oct 29, 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.
• Add warning when emptying the Confluence data cube.
• 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 several additional data import problems.
• Fixed resetting of source application statuses after database migration.
• Allow changing of default custom JavaScript code execution timeout.
• Delete created junction links when stopping eazyBI on Windows which prevented stopping of Confluence server.
• 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.

6.3.0  /  Released Apr 29, 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:

• Improved performance of Page dimension member selection from secondary hierarchies.
• Perform automatic vacuum on PostgreSQL tables after each import to reduce table size and improve query performance.
• Fixed support for the latest MySQL JDBC driver version 8.0.23.
• Fixed default Java time zone handling when using MySQL.
• Do not load large Mondrian schema objects in the main Jira process after source data import.
• Fixed several problems when saving template reports.
• Fixed CSRF token validation in several eazyBI pages.

6.2.2  /  Released Mar 02, 2021

New in this release:

• Confluence Administrators (who are not System Administrators) can be excluded from eazyBI admins.

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.
• Fixed import of blog pages with a title longer than 250 characters.
• Fixed XSS in Troubleshooting / view log files.
• Fixed the error message when saving the settings without selected dedicated Data Center nodes.
• Fixed eazyBI initialization when Tomcat configuration uses the NIO protocol.
• Check during the startup if a previous child process is still present and remove it.

6.2.0  /  Released Jan 14, 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.
• Automatic source file import from a directory.
• 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.
• Show warnings when two different eazyBI instances are using the same database.

Fixed in this release:

• Fixed display of page names in the Top Page hierarchy.
• Fixed display of members with special UTF-8 characters in Jira report and dashboard macros.
• 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.
• Fixed detection of page attachments changed in incremental Confluence import.
• Do not import Confluence personal spaces when all spaces are selected for import.
• Avoid out of memory errors when importing large Excel files.
• Limit used database connections during Mondrian schema generation.
• Fixed stopping of the stuck child process.
• Fixed connection to PostgreSQL with specific secure connection settings.
• Only system admins (and not other admins) can change google_chrome and ssrf_filter advanced settings.

6.1.2  /  Released Oct 01, 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.
• Fixed Confluence data import when using PostgreSQL 10.
• Fixed Confluence data import when more than 1024 spaces are selected.
• Fixed import of template account calculated members with the same formula.
• Limit SQL import max connection, read, and query timeouts.
• Show a warning when the database migrator cannot preserve account, report, and dashboard IDs.
• Fixed restarting of the child process on dedicated Data Center nodes.
• Improved logging of child process request errors when using Data Center.

6.1.1  /  Released Sep 03, 2020

New in this release:

• Template accounts with a set of reports, dashboards, and calculated members that can be imported into other accounts.

Fixed in this release:

• Fixed report execution error with several dimensions on rows and ordering by a column measure.
• Fixed incremental import of page labels changes.

6.1.0  /  Released Sep 01, 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
• New getting started page with links to training videos and documentation.
• Use database migrator to migrate eazyBI from Confluence Server to Confluence Cloud.
• Custom property hierarchies in Space and user dimensions.
• Support for PostgreSQL versions 11 and 12.
• Admins can delete invalid predefined calculated measures.
• Improved large table results in export to Excel and CSV (no need to change default Tomcat server.xml settings).

Fixed in this release:

• Fixed eazyBI macro content rendering inside the Expand macro.
• 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.
• 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 setAutoCommit failure in Confluence data import when using PostgreSQL.
• Fixed Confluence data import when using Oracle.
• Fixed capture of search queries when using Confluence 7.6 or later.
• Fixed Confluence data import if an attachment creation timestamp is missing.
• 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.
• Improved starting of eazyBI on all Data Center nodes (retry several times).

6.0.1  /  Released May 26, 2020

New in this release:

• Test database connection before updating eazyBI settings.

Fixed in this release:

• Fixed import of empty page inline tasks.
• Fixed total calculation errors for some calculated measure formulas.
• Allow using the specified MS SQL database if the default master database is not accessible.
• Use the case-insensitive search in Admin / All accounts page.
• Fixed reports with conditional cell formatting when a measure name contains "color".

6.0.0  /  Released May 11, 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.
• New dimensions and measures for page inline tasks and attachments.
• Import only selected space categories and use Space Category dimension in reports.
• 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.

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 selection of Google Sheet name in import options.
• Fixed data access role definition for additional dimension hierarchies.
• Fixed case-insensitive search of users in the account users page.
• Fixed CurrentUser MDX function to return the current user key.
• Fixed creation of a new PostgreSQL database during the initial setup.

See changes in the previous eazyBI for Confluence versions