Previous changes in Private eazyBI

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.

5.3.0  /  Released Mar 05, 2020

New in this release:

• 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.
• Export and import definition of Jira import options in Source Data.
• Do not allow empty or delete a cube while a data import is in progress.

Fixed in this release:

• Fixed support for custom EAZYBI_PREFIX in bin/start.sh.
• 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.
• Fixed eazyBI account deletion when using Oracle which could cause data deletion in other accounts.

5.2.0  /  Released Nov 29, 2019

New in this release:

• 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.
• Oracle JDBC driver is removed from the eazyBI distribution, download and add ojdbc8.jar  to the lib  directory if needed.

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 getting of operating system memory parameters when using Java 11.

5.1.0  /  Released Oct 28, 2019

New in this release:

• Highlight individual chart series on a mouse hover.
• New MDX function DateMembersBetween.
• Close idle connections in the database connection pool (which avoids problems with firewalls that close inactive connections).
• Jira integration
  • Predefined Time dimension calculated members – Current month, Previous month, Last 12 months, Last 30 days, Last 4 weeks.

Fixed in this release:

• Fixed wrapping of long axis titles.
• Fixed handling of empty values in a stacked area chart.
• Fixed positioning of a frozen table header.
• Better detection of mobile devices.
• Several Data access roles fixes.
• Do not show other objects in LDAP group selection.

5.0.2  /  Released Jul 27, 2019

Fixed in this release:

• Do not include large Mondrian XML schema dumps in log files.
• Reduced used Java heap memory for large SQL imports.
• Fixed storing of database password with some specific character sequences.
• Do not create too many table indexes for custom data imports.
• Fixed support for Active Directory groups when using LDAP authentication.

5.0.1  /  Released Jul 12, 2019

Fixed in this release:

• Fixed the sample init.d startup script.
• Fixed missing files bug in map charts.
• Fixed a range bar display if only one end-point is present.
• Fixed sending a test dashboard subscription email when data access roles are used.

5.0.0  /  Released Jul 2, 2019

New in this release:

• eazyBI platform and libraries updates:
  • Upgraded internal libraries (JRuby, Ruby on Rails framework, Mondrian OLAP engine and other libraries).
  • Support for Java 8 and Java 11 (dropped support for Java 7).
• Add standard calculations based on selected measures.
• All Accounts page in System Administration.
• Improved Measures and Dimension UI in the Analyze report builder:
  • Predefined and User defined measures groups, stored and calculated measures shown in the same list.
  • Do not allow to modify predefined measure formulas.
  • Filter measures by name.
  • Remove selected report dimensions quicker using the remove icon.
  • Select dimension members using the table row header actions.
• Grant access to accounts for LDAP user groups when LDAP authentication is used.
• Show a progress bar during Jira issues import.
• Removed deprecated PhantomJS support for PDF export (just the headless Google Chrome is supported for PDF exports).
• If user interface customizations were added to the public/eazybi  directory then they should be moved to the public  directory.

Fixed in this release:

• LDAP users will not receive email notifications when added to an eazyBI account.
• Fixed report results export API when a report contains a drilled into calculated member.
• Fixed report results export API when using Top N rows selection.
• Fixed autocompletion of dimensions with ] in their name in the calculated member formula editor.
• Several Jira import bug fixes.

4.7.2  /  Released Feb 28, 2019

Fixed in this release:

• Fixed usage of Google API for authentication.
• Fixed pie chart borders on wallboards with a dark theme.
• Fixed gauge chart colors on wallboards with a dark theme.
• Do not show in "Latest events" reports that are not visible for the current user.
• Validate the Referer header when showing back links in some pages.

4.7.1  /  Released Feb 11, 2019

New in this release:

• Report results export API can be used with the embed_token authentication parameter.
• Support MySQL SSL connection for the eazyBI database and for SQL data import.

Fixed in this release:

• Show bar chart range series as scatter points if one range end-point is missing or if both range points are the same.
• Order dimensions in the same original sequence when dragging dimensions back to available dimensions in the Analyze tab.
• Fixed showing of "Time for each slide" in wallboard options if only one page break is used.
• Fixed axis labels color in the wallboard with a dark theme.
• Fixed access to cube reports for admins when using data access roles.
• Fixed saving of the "No regular import" frequency.
• Fixed report results export API with multiple pages in selected_pages parameter.

4.7.0  /  Released Dec 27, 2018

New in this release:

• Share dashboards in a wallboard mode (optimized for showing on large monitors for public viewing).
• Specify Concurrency for paginated REST API import.

Fixed in this release:

• Allow report admins to see and change private reports of other users.
• Several fixes for MDX autocompletion in the calculated members editor.
• Fixed positioning of drill through dialogs in embedded reports.
• Show the correct first label for the range bar chart type.
• Fixed dashboard subscription email sending for dashboards with data access roles.
• Headless Google Chrome version 71 can be used for PDF export.
• Support the latest Microsoft SQL Server JDBC driver.
• Support http.nonProxyHosts property with several hosts.
• Fixed selected_pages parameter for embedded reports and dashboards when a dimension is both in pages and rows or columns.
• Fixed sending of email notifications about failed source application imports.
• Several Jira import bug fixes.

4.6.2  /  Released Oct 3, 2018

New in this release:

• Improved clearing of the unused report results cache.
• Improved mobile device detection.
• Additional settings for password confirmation.

Fixed in this release:

• System administrators can search all users when adding account users.
• Allow to change Google Sheets data source when the sheet ID has changed.
• Show only visible dashboards in the dashboard email subscriptions dialog.
• Fixed auto-refreshing of embedded reports.
• Fixed dimension member access rights when using custom schemas with complex union roles.
• Load additional *.jar files from the lib/ directory in alphabetical order to ensure their sequence in the class path.
• Several Jira import bug fixes.

4.6.1  /  Released Aug 23, 2018

Fixed in this release:

• Fixed canceling of long imports which caused that several import jobs of the same source application were started in parallel.
• Fixed data access role definition when a specified hierarchy member did not exist anymore.
• Fixed LDAP authentication conflict with Atlassian Connect authentication and with default password strength settings.
• Several Jira import bug fixes.

4.6.0  /  Released Aug 13, 2018

New in this release:

• Use row dimensions also as page filter dimensions.
• Incremental REST API and SQL import.
• MDX autocompletion for the calculated member formula editor.
• Source data import usage statistics.
• Show / hide available dimensions in the Analyze tab report designer.
• Enforce usage of Measures in the Analyze tab report designer.
• Show row dimension headers in table reports.
• Improvements for performance and error debugging:
  • Enable report request profiling for performance debugging.
  • Show individual source application import error log in the Source Data tab error dialog.
• Enable SSRF protection for REST API and SQL imports.
• Additional password strength settings.

Fixed in this release:

• Fixed report execution on MS SQL when special Unicode characters used as dimension member names.
• Fixed starting of the headless Google Chrome for PDF export when the sandbox mode is not supported.
• Improved delete performance of large number of records from PostgreSQL tables.
• Include custom assets when exporting reports to PDF.
• Many Jira and Jira add-ons import improvements.

4.5.2  /  Released May 7, 2018

Fixed in this release:

• Support for PostgreSQL 10 as an eazyBI database.
• Improved logging of database connection test errors.
• Added sample systemd init script.
• Jira integration:
  • Fixed incremental import of project name changes and board and sprint deletions.
  • Improved database connection pool handling during Jira import to use fewer database connections.
  • Fixed drill through worklogs when using a custom issues hierarchy.
  • Fixed creation of a custom issues hierarchy when using an issue priority level.

4.5.1  /  Released Mar 21, 2018

New in this release:

• Jira integration:
  • Import Projectrak custom fields.

Fixed in this release:

• Fixed slow import and deadlock errors on MS SQL Server.
• Detect byte order mark characters in uploaded files.
• Show warning that eazyBI should be restarted when changing the database type in settings.
• Jira integration:
  • Fixed Story Points change calculation when Story Points and Sprint are changed together.

4.5.0  /  Released Mar 6, 2018

New in this release:

• Improved new source application selection page.
• Include drilled into members in CSV and Excel results export.
• New breadcrumb links in the Analyze report editor for opening cube or folder reports.
• Use console.log in custom JavaScript code for debugging purposes.
• Jira integration:
  • Improved Jira import options page (separate tabs for options groups, select project categories etc.).
  • Display only issue key or issue summary in table reports and all chart types.
  • Labels with different uppercase or lowercase spelling are grouped together in the Label dimension.

Fixed in this release:

• Improved Gantt chart export to PDF.
• Fixed generation fo database table and column names for additional data with special Unicode characters in column names.
• Fixed access authorization for embedded reports with an access token.
• System administrators can access also all reports which as saved as "private".
• System administrators can administer data access roles for folders and dashboards in all accounts.
• Jira integration:
  • Improved full re-import performance when only some additional data (e.g. custom field) should be added.
  • Fixed export of drill through issues into CSV and Excel.
  • Several fixes for Sprint and Story Points history import.
  • Update Tempo Account, Category, Customer custom fields for all issues when they are changed.

4.4.0  /  Released Nov 29, 2017

New in this release:

• Define data access roles and restrict access to cube folders, dashboards, and cubes.
• Export to PDF on Private eazyBI using the headless Google Chrome browser.
• Share embedded reports and dashboards to anonymous users using access tokens.
• Rename cubes and prevent accidental deletion (instead of empty) of a cube.
• Delete imported data when deleting a REST API or SQL data source.
• Improved mobile and tablet UI.
• New MDX functions getLinkedMember, getLinkedMemberName, getLinkedMembers, getLinkedMemberNames.
• Jira integration:
  
  • Improved Jira Service Desk SLA import and sample reports.
  • Custom fields are grouped by add-ons in the Jira import options page.
  • Added Sprint Issues completed and Sprint Issues not completed measures.

Fixed in this release:

• Use tcpKeepAlive for PostgreSQL connections to avoid cancelling of database sessions by firewalls.
• Set larger sort_buffer_size for MySQL database sessions.
• Fixed validation of long custom dimension names.
• Fixed filtering of report rows when using multiple page selections.
• Fixed ordering of Time Weekly hierarchy day members in some reports.
• Do not delete calculated members when there are database connection problems.
• Fixed display of vertical lines in timeline area charts.
• Fixed display of full member names in chart labels.
• Jira integration:
  
  • Fixed import of specific worklog comments when using PostgreSQL.
  • Fixed deletion of many project components on Oracle and MS SQL.
  • Fixed importing of renamed issue statuses, types, priorities, and resolutions from changelogs.
  • Fixed import of issue Sprint statuses in some specific cases.
  • Improved performance of some Jira data import steps.

4.3.2  /  Released Jul 10, 2017

New in this release:

• Jira integration:
  • Import Jira Service Desk custom field Organization.
  • Improved Jira incremental import performance.

Fixed in this release:

• Fixed REST API multi-page data import when using custom JavaScript code.
• Fixed XML document handling in REST API import (support for multiple XML nodes with the same name).
• Fixed grouping of vertical bar chart labels in gadgets.

4.3.1  /  Released June 8, 2017

New in this release:

• Group labels in vertical bar charts if multiple dimensions are used is rows
  (similar to how previously labels were grouped in horizontal bar charts).
• Bubble type option in bar, line, and timeline charts – display the first measure on Y-axis and use the second measure for the bubble size.
• getDocument function in REST API import custom JavaScript code for requesting additional data from another REST API end-point.
• Jira integration:
  • Additional Sprint Story Points completed measure
    (which can be used instead of Story Points resolved measure if some completed stories are not marked as resolved).

Fixed in this release:

• Do not overlap "Reset scale" button with a chart legend.
• Display future vertical line markers in a timeline chart.
• Jira integration:
  • Several fixes for import of sprint scope changes.
  • Several fixes to avoid full re-import when incremental import should be performed.
  • Fixed removal of custom field tables on Oracle.
  • Fixed import of issues with many sprint changes on Oracle.
  • Fixed import of issues with a missing initial issue type value.
  • Fixed import of duplicate issue types, priorities, resolutions (additional ID value will be added to the display name).

4.3.0  /  Released May 22, 2017

New in this release:

• Maximize calculated member formula definition dialog.
• Exclude expanded higher level rows from the total calculation.
• Additional axes options for scatter charts.
• Improved the page selection dropdown (by default the All member is expanded).
• Export definition of all dashboards in the current account.
• Security improvement – do not include stored passwords in settings and source data pages and in source application definition exports.
• Updated initial page design.
• Jira integration:
  • Improved JIRA Software data import (improved tracking of sprint scope changes and new sample reports).
  • Import changes of additional JIRA standard fields (priority, issue type, resolution).
    Historical dimension field values are shown when using the Issues history calculated measure.
  • Use non-working days from Time dimension options when displaying a Gantt chart.

Fixed in this release:

• Improved rendering of horizontal bar charts to avoid missing vertical axis labels.
• Fixed pagination of a dasbboard export to PDF when report descriptions are used.
• Fixed REST API next page URL pagination when custom JavaScript code is used.
• Migrate also report folders when using the eazyBI database migrator.
• Fixed export of dashboard definitions with reports in folders.
• Improved import performance of large number of report definitions.
• Fixed import of datetime properties in the current time zone of the Time dimension.

4.2.3  /  Released Mar 30, 2017

New in this release:

• Preserve original account, report and dashboard IDs when migrating the eazyBI database.
• Export report results to CSV, Excel or JSON using the report results export API.
• Use report name with Unicode characters for report results export file name.

Fixed in this release:

• Fixed new user invitation when using Oracle.
• Re-render pie charts when resizing a window.
• Fixed MultiPass authentication for iframes hosted on another host.

4.2.2  /  Released Feb 16, 2017

New in this release:

• Support for Microsoft SQL Server with Microsoft JDBC driver (if an SSL database connection is required).

Fixed in this release:

• Fixed export to PDF of table reports and Gantt charts.
• Fixed drill through cell when using aggregated calculated members.
• Fixed color picker rendering bugs.
• Reconnect to PostgreSQL if a read-only connection is detected.
• Fixed testing of database connection in the settings page and displaying of connection error messages.
• JIRA integration:
  • Fixed import of deleted users in user dimensions.
  • Fixed Project Category hierarchy usage on Oracle.

4.2.1  /  Released Feb 2, 2017

Fixed in this release:

• Fixed changing of chart font sizes on Firefox and Internet Explorer.
• Fixed export to PDF of gauge charts.
• JIRA integration:
  • Fixed import of custom date fields.
  • Fixed user dimensions with duplicate display names.

4.2.0  /  Released Jan 26, 2017

New in this release:

• Dashboard visual design improvements.
• Dashboard monthly email subscriptions.
• Additional chart axes and font size options.
• eazyBI usage statistics analysis.
• Additional next page URL pagination option for REST API import.
• Sort source files by any column in the Source Data tab.
• Added show_all_public_accounts setting in eazybi.toml.
• Enable drill through by in custom schema definitions.
• JIRA integration:
  • Time dimension options for JIRA import (time zone, the first day of the week, non-working days).
  • Additional Project and Status dimension Category hierarchies.

Fixed in this release:

• Fixed several SSL connection and certificate validation problems.
• Improved positioning of popups in embedded eazyBI reports.
• Fixed proportional size of bubbles in a scatter chart.
• Try to refresh the REST API OAuth access token if expired.
• Do not allow PDF export using PhantomJS when in the development mode.
• JIRA integration:
  • Fixed formatting of drill through worklog hours as decimal numbers.
  • Fixed removal of custom field columns in eazyBI when a custom field is unselected in import options.
  • Fixed import of issues which where changed from sub-tasks to parent issues.
  • Fixed update of duplicate display names in user dimensions.

4.1.0  /  Released Oct 20, 2016

New in this release:

• Organize reports in report folders in the Analyze tab.
• New multi-color report type icons.
• Export definitions of only filtered reports.
• Option to show vertical column headers.
• Option to disable symbols in line charts.
• Delete a range of unused dates in the Time dimension
  (in the Analyze tab / Time dimension / All hierarchy level members).
• Improved advanced options of source columns mapping when importing files, REST API, or SQL data source.
• Replaced MapQuest with Wikimedia maps in the map chart.
• Added session and request references in eazybi-web.log
  (enables tracing of all requests from one user session).
• Removed support for Internet Explorer 9.
• JIRA integration:
  • Import issue links as dimensions or properties.
  • Define additional Issue dimension hierarchies.
  • Drill through from hours spent into detailed worklog entries with comments.
  • Issues in transition status measure renamed to Issues history.
  • Import Customer Request Type display names from JIRA Service Desk.
  • Import the Flagged custom field as a dimension (including changes) from JIRA Software.
  • Import calculated worklog custom fields.

Fixed in this release:

• Add measure table primary indexes to support MySQL replication.
• Fixed support for the Oracle 12c database server.
• Fixed scheduling of incremental data imports each 10 minutes.
• Delete old data during the incremental import if REST API or SQL data source does not return any data.
• Fixed "Delete missing" option in SQL and REST API data import.
• Fixed import of column headers with non-Latin characters from Google Spreadsheets.
• Fixed detection of decimal number formatting in other language locales when exporting to Excel.
• Fixed horizontal scrolling of a Gantt chart when several dimensions are on rows.
• Fixed display of the last data import time in the dashboards
  (was not calculated correctly if the user and server time zones were different).
• Fixed adding of new account users when using LDAP and Oracle.
• JIRA integration:
  • Update JIRA Software board names during each import.
  • Fixed import of Service Desk completed cycles breached / not breached statuses
    (in some cases initial statuses were not imported for some issues during the full re-import).
  • Update sub-tasks during the incremental import if the corresponding parent issue is updated.
  • Improved recovery from database errors when too many custom fields are selected.
  • Fixed import of custom cascading select field changes.

4.0.1  /  Released Jun 09, 2016

New in this release:

• Improved visual design for sign up and login pages.
• Support OAuth2 user authentication from external providers (Google and Salesforce).
• JIRA integration:
  • Support for Tempo Timesheets 8.0 (fixed import of checkbox worklog attribute values).

Fixed in this release:

• Improved performance of searching reports when there is a large number of reports in the Analyze tab.
• Fixed the eazyBI database migration tool for renamed users, as well as for missing users in the target database.
• Fixed showing of data export icons in eazyBI gadgets on Confluence pages.
• Fixed "Use SSL" option in SQL import from a PostgreSQL database.
• Several small fixes for visual styles in the user interface.
• JIRA integration:
  • Fixed support for JavaScript calculated custom fields with uppercase names.

4.0.0  /  Released May 16, 2016

New in this release:

• New improved UI design. There are many usability improvements in Analyze and Dashboards tabs and in gadget settings.
• Add calculated member annotations using special comments.
• Changed configuration settings for custom chart types.
• New user management and authentication settings in eazybi.toml file (see the devise section examples in eazybi.toml.sample).
• Added NonEmptyString MDX function.
• View log files or download a zip file of all log files from the new Troubleshooting page.
• Database migration on Private eazyBI tool for migrating all or selected accounts from one eazyBI database to another.
• Delete old system events (more than one year old) during the startup.
• JIRA integration:
  • Added check_calculated_value advanced setting for calculated custom fields.
  • Additional validations of custom field advanced settings.
  • Separate Import and Edit actions in the Source Data tab for JIRA import.
  • Import JIRA project, component, version description fields.
  • Always create Time dimension members for version start and end dates.
    

Fixed in this release:

• Improved cancellation of long report queries after a timeout
  (cancellation of background threads that consumed CPU after a timeout).
• Optimized Oracle database metadata queries (will reduce initial database schema setup time during the source data import).
• Show last successful import time in the Analyze tab for the Issues cube (previously also failed import updated this timestamp).
• Fixed rendering bug of lists of calculated members on Safari.
• Fixed text styling for stacked bar chart labels.
• Fixed MultiPass authentication when LDAP authentication is enabled.
• JIRA integration:
  • Fixed import of user dimensions when users have the same display name as well as when a username is changed.
  • Fixed import of Zephyr test cycles with the same name.

3.3.0  /  Released Oct 16, 2015

New features:

• Gauge chart – show only values or use another measure as a gauge limit.
• Timeline chart – show vertical lines for milestone dates.
• Scatter and bubble chart – show name labels.
• Hide or show report frames in the dashboards.
• View the status of background job queues in the system administration background jobs page, additional settings for background job queues.

• JIRA integration:

  • Atlassian Connect integration supports JIRA version 7.0.
  • JIRA Service Desk SLA custom fields import improvements, new measures and dimensions.
  • Added the Average closing days calculated measure.
  • Added the Transition from status first / last date measures.
  • Added the By status hierarchy for the Affects / Fix version dimensions (to get the totals by all Released or Unreleased versions).
  • Custom field dimensions and measures are grouped in the Analyze tab report builder. There are add-on specific groups (Agile, Service Desk, Tempo, Zephyr) as well as a general group Custom fields.

Improvements:

• Improvements for MDX date functions (DateInPeriod, StartDate, PreviousPeriods and others) to support Time dimension aggregated calculated members
  (the first and last dates are detected from the aggregated Time members).

Bug fixes:

• Fixed that sometimes not all data labels were shown in charts.
• Fixed scaling of the chart Y axis (drag-and-drop bottom or top of the Y axis).
• Fixed execution of JavaScript custom code on a large number of data rows.
• Several fixes for MySQL version 5.7 (but still the stable MySQL versions 5.5 and 5.6 are recommended).
• Fixed All users search (for system administrators) on MS SQL.
• Fixed initial setup of Oracle database connection.
• Increased the database connections pool size if a separate DWH database connection is used.
• Fixed starting of eazyBI on from a path with spaces in directory names.

3.2.0  /  Released Jul 30, 2015

New features:

• Atlassian Connect integration with JIRA Server.
• New gauge and scatter chart types.
• Added PreviousPeriods, NextStartDate, AllProperties MDX functions.

• JIRA integration:

  • Import Reporter Group, Assignee Group, Logged by Group and Transition Author Group dimensions.
  • Import JIRA Service Desk SLA custom fields.
  • Additional Transition to status first date and Transition to status last date measures.

Improvements:

• Improved LDAP user authentication support (including Active Directory).
• System administrator can grant system administration rights to other users in the All Users page.
• Add a group annotation for custom schema dimensions.
• Added disable_public_accounts and disable_custom_schema_accounts eazybi.toml settings.
• Additional days, hours and minutes calculated member formatter.
• Performance improvements for custom JavaScript code and calculated custom fields.

Bug fixes:

• Fixed rendering of timeline chart with stacked areas.
• Fixes for dashboard export to PDF.
• Fixed the problem that logging to eazybi-web.log was sometimes suspended.

3.1.0  /  Released May 15, 2015

Improvements:

• Cube reports now store both the original creator (owner) and the last updated by user (shown in the Analyze tab detailed list).
• Added "Delete missing" columns mapping advanced option for source file, REST API or SQL import.
• Updated to JRuby 1.7.20.
• Reduced Mondrian maxQueryThreads setting to 10 (to reduce the impact of slow queries on overall performance).

Bug fixes:

• Fixed showing of cube reports in the Analyze tab for accounts with a custom schema.

• JIRA import:

  • Fixed import of Sprint custom field from JIRA Agile version 6.7.
  • Fixed import of additional properties for Project dimension from files, REST API or SQL source.
• Fixed adding of column date filter when there are several dimensions on columns.
• Fixes for TOML format parser (arrays with comments, empty array, better error messages for duplicate keys).

3.0.0  /  Released Apr 29, 2015

New features:

• eazybi.toml configuration file in TOML format is used instead of previous eazybi.yml configuration file in YAML format.
• database.toml configuration file is used instead of database.yml to store database connection parameters.
• Set database connection and license information from system administration Settings page (instead of modifying configuration files).
• Log file names are changed to eazybi-web.log and eazybi-queues.log.
• Enable Mondrian OLAP engine logging in eazybi-mondrian.log file.
• Detailed list view of cube reports in Analyze tab.
• Download source files in Source Data tab.
• Switch charts to the table view in dashboards.
• Localization in French and German languages.
• Active background jobs page for system administrators.
• New eazybi.toml parameters for session timeout, password length, remember user period, user locking strategy and others.
• Email subjects and body text templates can be customized using translation files.
• Override page member selection in embedded reports or dashboards using URL parameters.
• Private eazyBI can be run in a cluster of several application server nodes (with a shared database).

• JIRA import additions:

  • Option to import Zephyr add-on test schedules and test execution results.
  • New Sub-task hierarchy for the Issue dimension that shows sub-tasks as children for the corresponding parent issues.
    If JIRA Agile Epic Link custom field is imported then also the Epic hierarchy is added for the Issue dimension.
  • Improved Average age days calculated member performance.
  • New Issues last updated measure (based on issue last updated date).
  • Import Age interval and Resolution interval dimensions.
  • Define additional calculated custom fields with JavaScript code.

Improvements:

• Private eazyBI distribution is much smaller as it does not include full JBoss application server installation anymore.
• Changed location of uploaded source files to data subdirectory (from previous private).
• Expired license warning messages will be shown in each page.
• Improved performance of reports with multiple page selection.
• Additional improvements for cancellation of long report queries after a timeout.
• Show additional hierarchy names in Drill across selection.

Bug fixes:

• Fixed import of Excel files with empty rows.
• Do not allow to select dimension members from different hierarchies.
• Fixed font information in the chart export to PDF.
• Fixed support for EnterpriseDB database.

2.3.2  /  Released Jan 26, 2015

New features:

• Add custom helpers from EAZYBI_HOME/app/helpers and custom initializers from EAZYBI_HOME/config/initializers.

Improvements:

• Updated to JRuby 1.7.18 and Mondrian 3.9.0 prerelase.
  
• Improved cancellation of long report queries after a timeout
  (previously some background threads continued to consume CPU after a timeout).
• Cell color formatting of table report results is exported to Excel.
• Improved Google Spreadsheets source selection (at first a file selection should be made and then a sheet selection in the selected file).
• Add drill through dimension levels option in a custom schema.
• Additional custom schema non empty annotations for dimensions.

Bug fixes:

• Fixed invalid hiding of calculated measures when using Hide empty
  (for example, previously in JIRA Issues cube Open issues or Issues in transition statuses measures were hidden if in the corresponding Time period there was no activity recorded).
• Fixed Time dimension Week level to have just one week member at the end and start of the year
  (for imported source applications and files).
• Improved performance of expanding large dimension level members when filter conditions are used to return a limited set of members.
• Fixed action buttons in the source files list after pressing More button.
• Fixed Moscow time zone offset from UTC.

2.3.1  /  Released Dec 08, 2014

New features:

• In JIRA import added default Cumulative Story Points resolved and Story Points remaining measures for JIRA Agile Sprint burn-down and burn-up charts.

Improvements:

• Improved color picker for conditional table cell formatting and for chart series which allows selection of custom colors.
• Improved OAuth2 authentication for REST API import to support additional providers (e.g. Teamweek, Vimeo).

Bug fixes:

• In JIRA import fixed import of Story Points change, Story Points history, Remaining estimated hours change and Remaining estimated hours history measures when analyzing by Sprint dimension.
• Do not hide measure group if saved report has selected measures from this group.
• Fixed mouse event processing on Windows 8.1 and Chrome browser (disabled detection of touch user interface).

2.3.0  /  Released Nov 28, 2014

New features:

• Use custom schema definitions with Amazon Redshift, IBM Netezza, HP Vertica or other databases which are supported by Mondrian OLAP engine.
• Import from SQL using Generic JDBC connection (copy additional JDBC driver to eazybi_private/lib directory).
• Add additional description for reports and dashboards.
• JIRA import latest features (JIRA Agile import improvements and Tempo Timesheets import and others).
• Hide and show measure groups in Analyze tab report editor.
• Show Ordered by toolbar button when order by columns are removed from a report.
• Show last import date tooltip in a header of dashboard and embedded reports.
• Freeze header toolbar option for long table reports.
• New eazybi.yml parameters disable_account_creation (allow only for system administrators) and disable_user_registration (allow only invitations).
• Added StringInCSV MDX function.

Improvements:

• Updated to JRuby 1.7.16 and Mondrian 3.8.0.
• Support for Java 8.
• New LDAP authentication parameter use_admin_to_bind.
• Improved preview of REST API source JSON data (expand/collapse JSON objects and arrays).
• Show SQL SELECT initial comment in Source Data list (can be used to describe what data are retrieved with this SQL SELECT).
• Reset dimension All member name to default (by saving empty All member name).
• Truncate dashboard and embedded report names to fit in report header.
• Improved horizontal bar chart height calculation.

Bug fixes:

• Fixed import of UTF-8 characters when using MS SQL database.
• Do not apply conditional cell formatting for Total or All others rows and columns.
• Fixed new member creation in a Time dimension with modified Weekly hierarchy first week day.
• Fixed display of Timeline chart date labels (previously could show previous day depending on the user browser time zone).
• Fixed chart width calculation for Timeline charts with many measures.
• Fixed getBoolean MDX function to return false if property value is missing.
• Fixes for import of report definitions in a custom schema account.

2.2.2  /  Released Sep 02, 2014

New in this release:

• Display date columns in a horizontal bar chart with date-time axis.
• Group labels of several row dimension members in a horizontal bar chart.
• Change a marker symbol of a chart scatter or line series type.
• Show dimension member keys instead of names in chart labels (e.g. issue key and not full or truncated summary).
• Data labels option is always visible in chart series options (no need to enable Data labels toolbar button).
• Specify the first day of the week for Time dimension Weekly hierarchy.
• In JIRA Issues cube export Drill through Issue results to Excel or CSV.
• Disable report actions option for embedded reports (add disable_actions parameter to iframe source URL) and OpenSocial gadgets ("Disable report actions" gadget parameter).
• Use custom JavaScript code to modify REST API import data.
• Added DefaultContext MDX function.

Fixed in this release:

• Wrap long dimension names in Analyze tab report designer.
• Fixed deleting of dimensions of custom imported cubes.
• Fixed disappearing cursor bug in a calculated member formula editor.
• Fixed refreshing of dimensions section borders on Chrome after expanding a dimension in Analyze tab.
• Fixed disabling of invalid calculated member formulas on Oracle.

2.2.1  /  Released Aug 04, 2014

New in this release:

• In JIRA Issues cube new Drill through Issue option when clicking on table report cell or in chart results (allows also to open all issues in JIRA Issue Navigator).
• Define Fiscal hierarchy in Time dimension (from All hierarchy members section, available for imported source applications and source files).
• Customize data labels for pie chart (option to show also percentage).

Fixed in this release:

• Do not request authorization when publishing reports and dashboards in Confluence pages from eazyBI public accounts.
• Improved performance of report queries on Oracle (increased prefetch rows setting for database connection).
• Use http.nonProxyHosts Java property when making REST API requests (specify for which hosts proxy server specified in http.proxyHost and http.proxyPort should not be used).
• More meaningful error messages when MultiPass authentication is failing.

2.2.0  /  Released Jul 18, 2014

New features:

• Conditional cell formatting (text and background color) in table reports.
• Manually add Time dimension members for specified date range (from All hierarchy level members section).
  (Only for Time dimension from source files and source applications and not for custom schema accounts)
• Import additional data from Google Sheets and Microsoft 365 Excel.
  (Requires additional authentication keys in eazybi.yml)
• Change column, line and timeline chart height (start drag-and-drop from Y axis bottom).
• Display date measures and date ranges in bar charts.
• Added CurrentUser, CurrentUserName, CurrentUserEmail, Key MDX functions.

Improvements:

• Updated to JRuby 1.7.13, Torquebox 3.1.1 and Mondrian 3.7.0.
• Use LDAP user name (and not email) in login page when using LDAP authentication.
• Custom property measures are added automatically when importing custom properties from additional data sources.
• Improved visual design of bar, line, pie and timeline charts.
• Additional countries for Map chart.
• Weekly rotation of production.log and production_queues.log files and keeping of last 10 log files.
• Improved performance of getMemberByKey and getMembersByKeys MDX functions.

Bug fixes:

• Fix for OutOfMemoryError when uploading large files.
• Do not allow to delete users which are eazyBI account owners.
• Fixed report export from gadget in Confluence page.
• Fixed chart export to PDF from IE 8.
• Fixed display of uploaded file size in MB.

2.1.1  /  Released May 30, 2014

Improvements:

• Improved performance of large report query results preparation.
• Included latest JIRA source application improvements and bug fixes.

Bug fixes:

• Fixed Gantt chart export to PDF.
• Fixed several issues when mapping source columns to dimensions and measures in CSV, Excel, REST API and SQL source data import.
• Fixed custom_javascript_include and custom_stylesheet_link  methods when publishing reports as OpenSocial gadgets.
• Set additional custom schema connection parameters (e.g. port) from default database.yml parameters.

2.1.0  /  Released May 21, 2014

New features:

• Publish eazyBI dashboard as OpenSocial gadget.
• Allow export report results from OpenSocial gadgets.
• Option to show full non-truncated member names in chart legend and axis labels.
• Change chart Y axis scale with drag-and-drop.
• Specify custom format string for calculated members.
• Option to skip missing dimension members when importing source files or REST API or SQL sources.

Improvements:

• Updated to JRuby 1.7.12, Rails 3.2.18 and Mondrian 3.6.7.
• Store JBoss server.log in eazybi_private/log directory.
• System administrator can change owner of any eazyBI account.
• Improved performance of large table results display by incremental display of results when scrolling.
• Improved calculation of total rows and columns (will show totals of dimension number properties).
• Added IsNumber, getMembersByKeys, getString, getNumber, getDate, getBoolean MDX functions.

Bug fixes:

• Fixed drill through example in foodmart_schema.rb
• Display error message if new user invitation token is expired.
• On MS SQL do not use sp_spaceused to determine table size if table does not yet exist.
• Fixed decimal type detection in source file, REST API and SQL import (e.g. do not fail if all values are 0.0).
• Ignore empty measures in timeline chart.
• Fixed hiding of page selection and member action popups.

2.0.0  /  Released Apr 17, 2014

New features:

• Import source data from REST API or SQL data sources (similar to existing source data import from CSV or Excel files).
  If you have upgraded Private eazyBI from previous version then add rest_api and sql to list of application_types in eazybi.yml (see how it should look like in eazybi.yml.sample).
• Send regular emails with eazyBI dashboards as PDF attachments.
  To use this feature you need to install PhantomJS to enable PDF export of dashboards.
• Cancel running source file or source application import jobs.

Improvements:

• Updated to JRuby 1.7.11, Torquebox 3.1.0 and Mondrian 3.6.5.
• Additional source column mapping (to eazyBI dimensions and measures) validations when importing data from CSV or Excel files or from REST API or SQL sources.
  It will prevent common mistakes when creating custom eazyBI cubes and dimensions.
• Delete imported custom measures and dimensions from cube in Analyze tab.
• Improved performance of non-empty crossjoin of several dimensions in rows.
• By default server time zone is used and not UTC (if necessary then change it in eazybi.yml file).

Bug fixes:

• Fixed PhantomJS usage on Windows for PDF export.
• Fixed several bugs in source columns mapping to eazyBI dimensions and measures.
• Fixed chart export to PDF and PNG when data contain Unicode characters.
• Remove invalid characters from Excel sheet name when exporting report results to Excel.
• Show custom charts in dashboard pages.

1.5.3  /  Released Dec 31, 2013

New features:

• Upload and import Excel files in Source Data tab (similar to existing CSV file upload and import)

Improvements:

• Updated to JRuby 1.7.9, Rails 3.2.16
• Delete calculated member will show warning if calculated member is used in any reports or in any calculated member formulas
• Delete report will show warning if report is used in eazyBI dashboard page
• Disable calculated members with invalid formulas (could happen if they use a dimension which is not available anymore)
• Specify non-default dimension hierarchy when defining calculated members (can be used in Time dimension with Weekly hierarchy)
• Added warning when renaming All members
• Added "disable" and "default" selection for "Data labels" chart option for individual measure
• JIRA source application in different accounts will use the same consumer and public keys
  (as in JIRA only one application link can be defined for Private eazyBI server)

Bug fixes:

• Fixed "cannot show Gantt chart" error even when using correct date columns
• Report name uniqueness validation will be case insensitive

1.5.2  /  Released Nov 28, 2013

New features:

• Export and import dashboard definitions (including reports and calculated members)
• Show Total row or column in report results

Improvements:

• Updated to JRuby 1.7.8, Torquebox 3.0.1
• Insert page breaks in dashboard PDF export
• Improvements in table report and Gantt chart pagination in PDF export
• Show warning with reports and calculated members which use calculated member which is deleted

Bug fixes:

• Fixed handling of Unicode characters in report definition export and import
• Fixed handling of serialized table columns with Unicode characters
• Fixed initial display of large number of markers on interactive maps

1.5.1  /  Released Nov 11, 2013

New features:

• Export and import report definitions
• Export reports and dashboards to PDF using PhantomJS
• OpenStreetMap and MapQuest interactive map charts with markers
• Import source files from directory
• Create and update account user role from MultiPass token

Improvements:

• Improved Analyze tab reports list using grid layout
• Show just count of reports for each eazyBI account in Home tab
• Show separately default and user defined calculated measures in report builder
• Hide only empty rows or only empty columns in report builder
• Dash line option for line charts
• Improved individual measure stacked option selection for stacked bar, line and timeline charts
• Improved data label positioning in bar and line charts

Bug fixes:

• Fixed eazyBI initialization errors on latest Java 7 versions
• Fixed selection of separate axis in timeline chart
• Do not show empty data points in timeline chart

1.5.0  /  Released Sep 20, 2013

Improvements:

• New user interface design with many usability improvements - lighter color scheme, more tasks accessible from top menu bar, new high resolution icons.
• Layout templates are split into several partials (app/views/layouts/_*.haml.html files in eazybi_private.knob) for easier customization.
• Updated to JRuby 1.7.4, TorqueBox 3.0.0, Highcharts 3.0.2
• Updated to latest mondrian-olap with latest Mondrian 3.5 branch build
• New stacked and separate axis customization options for data series in bar and line charts
• New documentation site at docs.eazybi.com
• MultiPass authentication
• User interface can be translated to many languages
• Additional Reports admin and Dashboards viewer roles
• Improved support for iPad - faster click processing, larger fonts in popup menus
• Additional "Expand all" and "Collapse all" actions in dimension "Drill into or expand" section
• Added custom_javascript_include and custom_stylesheet_link methods (see custom chart type example)
• Added embedding of dashboards using iframe
• Added support for virtual cubes (see config/schemas/foodmart_schema.rb examples)

Bug fixes:

• Improved positioning of bar chart data labels
• Fixed chart point actions popup positioning on Safari and IE
• Fixed several issues of chart PDF or PNG export from dashboard
• Fixed startup script comments about running in development mode

1.4.1  /  Released May 16, 2013

• Improvements
  
  • Upgraded to Highcharts 3.0.1
  • Added nonempty crossjoin option for cube report rows
  • Improved performance of additional user defined MDX functions
  • Redesigned Analyze tab cube and reports listing to allow more space for report names
  • Increased report name max length to 100
  • Save report as private report which will not appear in report list for other users
  • Reduce number of pies per row in pie charts if available width is too small
  • Initial LDAP authentication support
• Bug fixes:
  • Calculated members with Aggregate({…}) formula should preserve child members specified order when expanding
  • Fixed endless redirect issue when user session was expired
  • Fixed showing of <, >, & characters in chart labels
  • Fixed support for custom eazyBI URL prefix with EAZYBI_PREFIX environment variable

1.4.0  /  Released Mar 29, 2013

• Improvements
  
  • Updated to JRuby 1.7.3 (in Ruby 1.9 mode), TorqueBox 2.3.0, Rails 3.2.12
  • Support Oracle as main Private eazyBI database
  • Enable drill through for custom schema cube and specify drill through fields and default measures (see drill through help page for more details)
  • Customize in eazybi.yml which results tabs are visible (see help page for more details)
  • Customize in eazybi.yml which vector maps are used in Map chart (see help page for more details)
  • Specify custom eazyBI URL prefix with EAZYBI_PREFIX environment variable (instead of default /eazybi)
  • Account owner can transfer account ownership to another user
  • Improved JIRA integration with latest additions from eazyBI JIRA plugin
• Bug fixes
  • Fixed database session initialization after database session reconnect (when database session was lost)
  • Fixed custom model and controller file loading in production environment

1.3.4 / Released Feb 02, 2013

• Improvements
  • Improved JIRA integration with support for GreenHopper custom fields
• Bug fixes:
  • Updated to latest mondrian-olap version with fixes for Microsoft SQL Server support
  • Updated to devise 2.1.3 with latest security fixes

1.3.3 / Released Jan 14, 2013

• Improvements:
  • Timeline chart is redesigned and has new zoom in and drill into time periods features (see https://eazybi.com/help/charts-tutorial#timeline_chart)
• Bug fixes:
  • Upgraded to Rails 3.2.11 with latest security fixes

1.3.2 / Released Dec 26, 2012

• Improvements:
  • Exact and dynamic date filters for date columns and Time dimension member selection (see https://eazybi.com/help/date-filters)
  • Drill into calculated members with AGGREGATE(…) formula (see Calculated members in other dimensions#Aggregatemembersinotherdimensions)
  • Drill into column or row members or drill across other dimensions from table report cell or from bar, line or pie chart slice
• Bug fixes:
  • Do not require xalan and xerces jars from Batik when using TorqueBox (they were conflicting with newer jar versions included in JBoss)
  • When using custom schema with cube xml definition then add calculated members after cube xml definition in generated Mondrian XML schema
  • Fixed missing accept_user_invitation_url method exception when inviting new users

1.3.1 / Released Dec 6, 2012

• Improvements:
  • Added support for Microsoft SQL database as primary private eazyBI database
  • Updated to mondrian-olap version 0.4.0
  • Configure in eazybi.yml available source_application and source_file application_types
  • Add custom source file or source application importers in EAZYBI_HOME/app/models/source_application directory
  • Added additional chart main colors
  • Chart series colors and options saved by series name and not position
• Bug fixes:
  • Export all pie chart rows to PDF or PNG
  • Do not display null in chart data labels

1.3.0 / Released Nov 12, 2012

• Added dynamic title in default layout templates
• Save cube_report and dashboard system events and show latest events in “my home” page
• Serve static assets from EAZYBI_HOME/public directory
• Load custom controllers, models and routes from EAZYBI_HOME app/controllers, app/models and config/routes.rb
• Define data access roles in custom schema definition files (using mondrian-olap role method) and assign data access roles to account users

1.2.1 / Released Sep 28, 2012

• Updated TorqueBox application server to version 2.1.2
• Upgraded Rails to version 3.2.8
• Several JIRA import fixes
• During initialization check that Java 6 is used
• Additional description in bin/start.sh and bin/start.bat how to change bind address and port
• Additional comments about default_url_options in eazybi.yml.sample
• Added sample init.d script in bin/init.d/eazybi.sample
• jQuery UI CSS fixes for latest version of Chrome

1.2.0 / Released Aug 28, 2012

• Updated TorqueBox application server to version 2.1.1
• Added support for publishing eazyBI reports as OpenSocial gadgets
• OAuth client application registration (used by OpenSocial gadgets authentication)
• First user is registered with super admin access rights (can access all accounts and has access to super admin tasks)
• Added Super admin tasks - all users list, edit pages, search system events (errors)
• Help pages by default link to eazybi.com, additional eazybi.yml setting local_help to change links to local help
• More descriptive “no custom schema settings” error message

1.1.1 / Released Aug 07, 2012

• Added missing /eazybi prefix for autocomplete queries

1.1.0 / Released Aug 06, 2012

• Updated TorqueBox application server to version 2.1.0
• Enable drill through in table reports with enable_drill_through=1 URL parameter

1.0.2 / Released Jul 19, 2012

• Added start.bat startup script for Windows

1.0.1 / Released Jul 13, 2012

• Updated to use new eazyBI logo
• Export dashboard report results from dashboard pages
• Calculate embedded report (bar, line, pie and timeline chart) height based on iframe height (if necessary then set manually with results_height=… embedded report URL parameter)
• Enable embedded report results export with enable_export=1 URL parameter

1.0.0.beta3 / Released Jul 09, 2012

• Added PostgreSQL support as a main eazyBI database
• Export charts to PNG and PDF formats
• Changed default JAVA_OPTS parameters in bin/start.sh

1.0.0.beta2 / Released Jun 29, 2012

• Added LICENSE
• Fixed loading of smtp settings from eazybi.yml
• Fixed setting of mondrian properties in eazybi.yml
• Added embed/report_pages request to render iframe with only pages of specified report

1.0.0.beta1 / Released Jun 22, 2012

• Initial version.