All eazyBI for Jira eazyBI for Confluence Private eazyBI

Previous changes in eazyBI for Confluence
eazyBI for Confluence

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:

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.

5.3.1  /  Released Mar 05, 2020

Fixed in this release:

  • Fixed Gantt chart export to PDF.
  • Fixed showing of the Troubleshooting page when the child process is not working correctly.

5.3.0  /  Released Feb 26, 2020

New in this release:

  • eazyBI report and dashboard macros are included in a Confluence page PDF or Word export.
    Please ensure that headless Google Chrome is installed on the server for export to PDF.
  • Support Jira report and dashboards macros from Jira application links without user impersonation.
  • eazyBI is approved by Atlassian as a Confluence Data Center compatible app.
  • Drill into a single measure by another dimension level (and leave other measures at the summary level).
  • Gantt chart weekly, quarterly, and yearly views.
  • Improved Freeze header functionality when doing horizontal scrolling of wide tables.
  • Add custom multi-weekly hierarchies in the Time dimension.
  • Show stacked bars or areas using relative percentage also in timeline charts.
  • Do not allow empty or delete a cube while a data import is in progress.
  • Specify "sslmode" for PostgreSQL database connection in advanced database settings.

Fixed in this release:

  • Fixed exporting of Jira dashboard macro to PDF.
  • Fixed import of Confluence page versions without a creation timestamp.
  • Fixed expansions of visible measure groups when filtering by name is used.
  • Fixed DateAddDays and DateAddWorkdays to work correctly with daylight saving time changes and additional non-working days.
  • Fixed drill into chart values in some specific scenarios.
  • Fixed rendering of bar charts with grouped labels.
  • Fixed positioning of data points when zooming into bar charts with date ranges.
  • Show selected member Display names when exporting results to Excel or CSV.
  • Fixed source file uploads on some file system setups.
  • Rename a measure in source file data mapping if it is renamed in the Analyze tab.
  • Fixed MS SQL Server connection when using Windows authentication.
  • Added eazybi-child.out log file rotation to avoid too large log files.
  • Fixed eazyBI account deletion when using Oracle which could cause data deletion in other accounts.
  • Fixed Troubleshooting info about the child process when using Java 11.

5.2.1  /  Released Nov 26, 2019

Fixed in this release:

  • Fixed connection to PostgreSQL using SSL.
  • Fixed getting of operating system memory parameters when using Java 11.

5.2.0  /  Released Nov 25, 2019

New in this release:

  • Import pages from Confluence archived spaces.
  • Additional Space dimension Status hierarchy with Current and Archived members.
  • Additional Space created dateSpace Status, and Page space status property measures.
  • Import the Page likes measure.
  • Show stacked bar or area charts using relative percentage instead or values.
  • Show drilled into member names in bar and line charts.
  • Add a vertical line in bar and line charts (similar to previous functionality in timeline charts).
  • Search and filter members by name in additional hierarchies.
  • Google Sheets import is migrated to the latest Google Sheets API v4.
    (warning) Please enable both Google Drive and Google Sheets API in Google API console and re-authenticate Google Sheets import.
  • Confluence 7.1 support.

Fixed in this release:

  • Fixed overlapping of label names in some charts.
  • Export to Excel cell formatting for empty cells.
  • Show the page break option in dashboard editing when PDF export is not configured (as it can be also used for wallboards).
  • Fixed adding of an account user with a data access role.
  • Fixed HTML escaping of data access role names.
  • Fixed database error handling when non-English error messages are returned.
  • Fixed saving of eazyBI database passwords with specific character sequences.
  • Upgraded PostgreSQL JDBC driver to the latest version.

5.0.3  /  Released Oct 10, 2019

New in this release:

  • Confluence 7.0 support.

5.0.2  /  Released Oct 03, 2019

Fixed in this release:

  • Increased timeout for eazyBI for Jira macro queries (previously default 10 seconds timeout was applied).
  • Fixed saving of new users when they access a Confluence page with eazyBI macros for the first time.

5.0.1  /  Released Sep 20, 2019

New in this release:

  • The same core functionality as in eazyBI for Jira Server version 5.0.
  • Confluence source application data import
    • Page created, updated events (available from page history stored data)
    • Page view events (only new events available since eazyBI installation)
    • Search queries (only new events available since eazyBI installation)
  • REST API, SQL source application data import, CSV, Excel source file import.
  • eazyBI for Confluence macros for publishing local eazyBI reports and dashboards in Confluence pages.
  • eazyBI for Jira macros for publishing eazyBI reports and dashboards from Jira application links.
  • Experimental Confluence Data Center support (not yet Data Center approved app).

Not yet implemented (planned for later versions):

  • eazyBI report and dashboard macros are not yet included in a page PDF export.