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:
- 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.
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 date, Space 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.
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.