Previous changes in Private eazyBI
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 thelib
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 thepublic
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 thelib/
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).
- Additional Sprint Story Points completed measure
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 ineazybi.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 ineazybi.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.
- Added
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
There are several major changes made between versions 2.3 and 3.0. Please read the upgrade instructions from version 2.3 to 3.0.
Please test the upgrade in a separate test environment before upgrading the production environment.
New features:
eazybi.toml
configuration file in TOML format is used instead of previouseazybi.yml
configuration file in YAML format.database.toml
configuration file is used instead ofdatabase.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
andeazybi-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 previousprivate
). - 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
When upgrading from previous version perform the following steps:
- Delete previous
eazybi_private/torquebox
directory (will be recreated from new version zip file) before unzipping new distribution file. - Please read about the changes in startup scripts if you are setting EAZYBI_HOME to a symbolic link directory name.
New features:
Add custom helpers from
EAZYBI_HOME/app/helpers
and custom initializers fromEAZYBI_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
When upgrading from previous version perform the following steps:
- Delete previous
eazybi_private/torquebox
directory (will be recreated from new version zip file) before unzipping new distribution file.
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
parametersdisable_account_creation
(allow only for system administrators) anddisable_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 toiframe
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 inhttp.proxyHost
andhttp.proxyPort
should not be used). - More meaningful error messages when MultiPass authentication is failing.
2.2.0 / Released Jul 18, 2014
When upgrading from previous version perform the following steps:
- Delete previous
eazybi_private/torquebox
directory (will be recreated from new version zip file) before unzipping new distribution file.
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.
(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
andproduction_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
andcustom_stylesheet_link
methods when publishing reports as OpenSocial gadgets.Set additional custom schema connection parameters (e.g.
port
) from defaultdatabase.yml
parameters.
2.1.0 / Released May 21, 2014
When upgrading from previous version perform the following steps:
- Delete previous
eazybi_private/torquebox
directory (will be recreated from new version zip file) before unzipping new distribution file.
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
When upgrading from previous version perform the following steps:
- Delete previous
eazybi_private/torquebox
directory (will be recreated from new version zip file) before unzipping new distribution file. - Review additional sample settings in
eazybi.yml.sample
and add toeazybi.yml
if necessary (see below).
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 addrest_api
andsql
to list ofapplication_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
When upgrading from previous version perform the following steps:
- Delete previous
eazybi_private/torquebox
directory (will be recreated from new version zip file) before unzipping new distribution file.
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
When upgrading from previous version perform the following steps:
- Delete previous eazybi_private/torquebox directory (will be recreated from new version zip file) before unzipping new distribution file.
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
When upgrading from previous version perform the following steps:
- Delete previous eazybi_private/torquebox directory (will be recreated from new version zip file) before unzipping new distribution file.
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
When upgrading from previous version (including previous beta version) perform the following steps:
- Delete previous eazybi_private/torquebox directory (will be recreated from new version zip file) before unzipping new distribution file.
- Delete all your existing layout customizations in
app/views/layouts/
directory as eazyBI user interface design has changed significantly.
Extract new layout files fromeazybi_private.knob
and customize them as needed.
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
When upgrading from previous version perform the following steps:
- Delete or comment the following lines in eazybi.yml (it might help to increase performance of some reports)
“mondrian.native.filter.enable”: false
“mondrian.result.limit”: 100000
- If custom eazyBI URL prefix is used and also layout .html.haml files are customized then ensure that customized layout files include (see original layout files for placement of these lines)
:javascript
Eazy.prefix = “#{Eazybi.prefix}”;
- 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
When upgrading from previous version perform the following steps:
- Delete previous eazybi_private/torquebox directory (will be recreated from new version zip file)
- Unzip distribution zip file (in parent directory of eazybi_private directory so that existing default files will be replaced with new ones)
- Add -Dfile.encoding=UTF-8 to JAVA_OPTS in startup scripts (if using other scripts than default bin/start.sh or bin/start.bat)
- If using MySQL then download MySQL JDBC driver from http://dev.mysql.com/downloads/connector/j/ and copy mysql-connector-java-*.jar JDBC driver file to eazybi_private/lib directory (as MySQL JDBC driver is using GPL license it cannot be bundled with Private eazyBI)
- It is recommended to increase pool size to 20 in database.yml (see database.yml.sample)
- 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)
- 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.