Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

7.

...

0.

...

3 / Released

...

June 20, 

...

2024

Features:

  • Implemented Jira Helpdesk customer support system Contact Us form.
  • Adjusted Subscription plan information according to the pricing changes.
  • Implemented a new Premium subscription plan.
  • Made custom field definitions for Jumis PRO and Horizon applications more flexible.
  • Adjusted Card Payment procedure according to the changes in the service provider specifications.
  • Implemented a feature that allows multiple custom dimension creation from the same register, using custom fields in Jumis Pro and Horizon applications.

Bug-fixes:

  • Fixed a bug in Jumis PRO application, that caused aggregation of transactions with the same code value.
  • Fixed a bug in Hansaworld application, that caused an error when importing account groups from user defined SERP reports.
  • Fixed a bug that caused Google Sheet application errors.

6.4.0 / Released May 12, 2022

Features:

Bug-fixes:

  • Fixed a bug in HansaWorld that caused Item Variety validation errors even when the Item Variety Groups were disabled for an account.
  • Fixed a bud that caused integer values being imported instead of decimal values in HansaWorld Sales Orders cube.
  • Fixed a bug that caused an error state when trying to use the Reimport all Data option.

6.3.9 / Released January 10, 2022

Features:

  • Standard ERP user defined report synchronization in Accounts dimension of Financials cube.
  • Integration with Visma Horizon ERP.
  • New Jumis PRO application with custom fields support.
  • In HasaWorld application, new custom fields functionality that allows for new measure set creation based on an a custom date field.
  • Upgrade to eazyBI engine version 6.4.0.
  • Warnings about required cube reimport after changing critical HansaWorld application parameters.

Bug-fixes:

...

  • Created integration with 3CX Phone System.
  • Implemented demo data generation for Horizon Invoices cube.
  • Added an option to share measures from the standard cubes into custom cubes for Standard ERP application.
  • Rest API import procedure code refactoring.
  • Added an option to configure record deletion and skipping during  custom cube import.
  • Optimized custom field definition parsing.
  • Added an option to set Rest API import concurrent request thread count on account and application level
  • Added Horizon Invoices cube to the default Horizon cube list.

Bug-fixes

  • Fixed the issue causing empty cube options page even when a cube is selected for import.
  • Fixed the issue causing prediction import errors when prediction import is enabled for multiple accounts.

7.0.2 / Released February 16, 2024

Features:

  • Simplified custom fields definition process.
  • Added an option to create a record and item level custom cube for Horizon application.

Bug-fixes

  • Fixed the issue causing PayPal payment failure.

7.0.1 / Released December 22, 2023

Features:

  • Added support for conditional report alerts.
  • Added support for HSESSION cookie in HansaWorld application, to streamline HW authentication process.
  • Adjusted the Horizon application authorization process according to the latest security requirements set by Visma.
  • Added an option to define prediction start date for Machine Learning model integration.
  • Created automatic tests for Priority application testing.

Bug-fixes

  • Fixed the issue causing an internal error when user performs drill-through cell operation on a dimension member containing a complex aggregation.
  • Fixed the issue causing an error in the sample report for HansaWorld Financials cube.
  • Fixed the issue that prevented user id logging in the web-log file.

7.0 / Released November 3, 2023

Features:

  • Engine upgrade to eazyBI Private 7.0.1.
  • Updated the .toml configuration file to include the latest configuration options.
  • Added an option to change the content type setting for the Rest API application.
  • Added the Customer dimension to all HansaWorld cubes containing the Supplier dimension, and wise-versa.
  • Implemented a functionality for implementing a prediction models based on weather forecast and location data.
  • Added an option to import nested fields in Priority custom cubes.

Bug-fixes

  • Fixed an issue that caused incorrect budget import for HansaWorld application.
  • Fixed an issue that caused Weather data import cancellation for all accounts in case of an error in one of the accounts.
  • Fixed an issue that caused record duplication in Priority Financials cube.
  • Fixed an issue that caused an error in case a measure was imported in a custom cube and no dimension was created from the associated source.
  • Fixed an issue that prevented dimension binding to Item level measures in Priority custom cube.
  • Fixed the Holiday and Transferred working days measures in HansaWorld Invoices and Quotations cubes.

6.7 / Released September 20, 2023

Features:

  • Added an option to change the length of the trial period.
  • Added validations for account plan parameter values.
  • Created an integration with the Priority ERP.
  • Added an option to build custom cubes, using custom fields definitions.
  • Added additional information to the account subscription page.
  • Renamed the templates link in the product header.

Bug-fixes

  • Fixed the issue causing Jumis demo data generation error.
  • Fixed the issue causing an error when disabling an active Excellent Books BI account.

6.6.1 / Released June 28, 2023

Features:

  • Historical weather data and weather forecast integration.
  • Extended logging for XML validation errors during HansaWorld data import.
  • Added an option to define an ordinal column for custom dimension in separate table created using custom fields functionality.
  • Removed the redundant regular import frequency options for HansaWorld application.
  • Added a functionality for automated flex.bi user mailing list management.
  • Code refactoring for better import performance.
  • Automated Excellent BI account creation workflow.
  • Added Object extra dimension support for HansaWorld CRM cube.
  • Added an option to create a custom dimension in separate table containing only the key value.
  • Added Department dimension in Horizon Financials cube.
  • Added an option to customize Transaction data import source for Jumis PRO application.

Bug-fixes

  • Fixed the issue that caused VAT number validation during when creating a new subscription.
  • Fixed feature list in the Edit Account page.
  • Fixed the issue that prevented Geocoding from working on PostgreSQL database.
  • Fixed the issue that prevented the cancellation of HansaWorld application import.
  • Fixed the data type mismatch for ordinal column import in HansaWorld cubes.
  • Fixed the issue that prevented Location Classes extra dimension creation in HansaWorld POS cube.
  • Fixed the issue that caused demo data generation errors for Jumis PRO application.
  • Fixed the issue that prevented the company change during HansaWorld application setup.

6.6.0 / Released February 17, 2023

Features:

  • Upgrade to the eazyBI 6.6.0 engine.
  • Added explicit xml parsing validation to avoid import silent failure.
  • Added Sales Group name import for HansaWorld application.
  • Improved notification workflow for Excellent Books integration.
  • Added support for HansaWorld Items export file version 4.
  • Added a default Profit/Loss account for Horizon and Jumis applications.

Bug-fixes

  • Fixed a bug that caused HansaWorld user defined account group import failure in case of an empty definition in SERP.
  • Fixed a bug that caused Subscription page rendering errors.
  • Fixed a bug that prevented PayPal payment reversal cancelation.
  • Fixed a bug that caused an error when emptying a cube, when using PostgreSQL database.
  • Fixed a bug that caused Geocoding failure.

6.5.1 / Released January 06, 2023

Features:

  • Removed the outdated Rest API authentication method for the HansaWorld source application.
  • Created an integration with the Standard Books ERP system.
  • Adjusted Subscription amount calculation to take into account additional upgrade purchases.
  • Added an option for HansaWorld application to crate a new custom dimension from any register available in the SERP.
  • Added an option to disable extra dimension import for HansaWorld application.
  • Shared all HansaWorld Quotations cube measures in other HansaWorld cubes.

Bug-fixes

  • Fixed a bug that caused a timeout error while importing a large amount of data in a SQL application.
  • Fixed a bug that caused a HansaWorld consolidated import error when importing data from a lot of companies.
  • Fixed a bug that caused an infinite loop during data import in some Rest API applications.
  • Fixed a bug that caused an import error during HansaWorld Financials cube import in case an account group with a trailing space character was defined in SERP.
  • Fixed the Tilde application compatibility with PostgreSQL.
  • Fixed the issue with different fonts being used in the HansaWorld application Settings page.

6.5.0 / Released September 24, 2022

Features:

  • Upgrade to the eazyBI 6.5.0 engine.
  • In Jumis application, added the original transaction document code to the record display name of the Document level in the Transaction dimension.
  • Optimized Rest API import from SERP servers.

Bug-fixes:

  • Fixed a bug that caused a HansaWorld application error for an item code value containing only a dot symbol.
  • Fixed a bug that caused a HansaWorld CRM cube import error for an activity with an empty start or end date value.
  • Fixed the shipped and invoiced quantity data types in the HansaWorld Purchase Invoices data cube.

6.4.1 / Released July 28, 2022

Features:

  • Implemented Jira Helpdesk customer support system Contact Us form.
  • Adjusted Subscription plan information according to the pricing changes.
  • Implemented a new Premium subscription plan.
  • Made custom field definitions for Jumis PRO and Horizon applications more flexible.
  • Adjusted Card Payment procedure according to the changes in the service provider specifications.
  • Implemented a feature that allows multiple custom dimension creation from the same register, using custom fields in Jumis Pro and Horizon applications.

Bug-fixes:

  • Fixed a bug in Jumis PRO application, that caused aggregation of transactions with the same code value.
  • Fixed a bug in Hansaworld application, that caused an error when importing account groups from user defined SERP reports.
  • Fixed a bug that caused Google Sheet application errors.

6.4.0 / Released May 12, 2022

Features:

Bug-fixes:

  • Fixed a bug in HansaWorld that caused Item Variety validation errors even when the Item Variety Groups were disabled for an account.
  • Fixed a bug that caused integer values being imported instead of decimal values in HansaWorld Sales Orders cube.
  • Fixed a bug that caused an error state when trying to use the Reimport all Data option.

6.3.9 / Released January 10, 2022

Features:

  • Implemented an automatic retry on HansaWorld authorization issues, to reduce the amount of Unauthorizes errors.
  • Improved timeout error handling, to reduce server load in case of HansaWorld timeout errors.
  • Added an option to automatically disable incremental import for particular HansaWorld SEPR versions.
  • Added a feature for custom JavaScript code usage in the Custom Fields definition.
  • Adjusted flex.bi import procedure for the current changes in the HansaWorld Rest API return data structure.
  • Created a feature for HansaWorld data consolidation from multiple SERPs.

Bug-fixes:

  • Fixed a bug that prevented company VAT number validation on the subscription information page.
  • Fixed a bug that caused authorization issues for incremental HansaWorld import in a consolidated account.


6.3.8 / Released December 8, 2021

...

Bug-fixes:

  • Fixed a bug that caused prevented dimension expansion when dimension name contained a full-stop character.
  • Adjusted default calculated members in the Time dimension so that they are aggregated and can be used with other calculated members.
  • Fixed an issue that prevented data synchronization between flex.bi and HW SERP after changing record status form OK to unOK and back.
  • Fixed an issue that caused an error when trying to export flex.bi database to a file.
  • Fixed an issue that prevented custom field creation for HansaWorld POS and CRM cubes.

...

  • Added additional information on the Plans page.
  • Implemented flex.bi colors schema as the default setting for new report creation

...

  • Several fixes in additional data import column mapping validations and import
  • Allow deletion of custom data cube dimensions
  • Budget import in financials cube now works with consolidation
  • Import only selected companies in Companies dimension for consolidated accounts
  • Fixed a bug where consolidated accounts with companies that had characters in their code would fail to import objects
  • Fixed a bug where custom fields would not import
  • Fixed a bug where Good Receipts import would fail if they contained information in Best Before property

...

    • 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.
    • Removed deprecated PhantomJS support for PDF export (just the headless Google Chrome is supported for PDF exports).
    • Highlight individual chart series on a mouse hover.
    • New MDX function DateMembersBetween.
    • 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.
    • Drill into a single measure by another dimension level (and leave other measures at the summary level).
    • Gantt chart weekly, quarterly, and yearly views.
    • Improved Freeze header functionality when doing horizontal scrolling of wide tables.
    • Add custom multi-weekly hierarchies in the Time dimension.
    • Show stacked bars or areas using relative percentage also in timeline charts.
    • Do not allow empty or delete a cube while a data import is in progress.

...

    • Fixed Item History register file import for the newest HansaWorld version
    • Fixed some import errors when using PosgreSQL for flex.bi
    • Made the start page for flex.bi private server users more mobile friendly

...

    • Fixed a bug where invoices balances would not work with postgreSQL
    • Fixed Dashboard selection when accessing flex.bi from mobile
    • Fixed project dimension missing (none) member

...

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

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

...

    • "Closed" and "Disable Mass Email" properties to Customer dimension
    • Updated SQL and REST API application design
    • Added "Unpaid invoice periods" dimension
    • Added invoice row count measure to invoices cube
    • Updated "Cube properties" section design in "HansaWorld import options"
    • Added "Unit" dimension
    • MDX autocompletion for the calculated member formula editor.
    • Dimension now can be used both - in pages and in rows or columns
    • Incremental import for REST API and SQL applications
    • Show / hide available dimensions in the Analyze tab report designer
    • Enforce usage of Measures in the Analyze tab report designer
    • Rename row dimension headers in table reports
    • Improvements for performance and error debugging
    • Enable SSRF protection for REST API and SQL imports
    • Improved mobile device detection
    • Allow to change Google Sheets data source when the sheet ID has changed

Bug fixes

    • Fixed source application creation with "Source Files only" option
    • Support for PostgreSQL 10 as an flex.bi database
    • Improved database connection pool handling during Jira import to use fewer database connections
    • Improved logging of database connection test errors
    • Fixed file import with register having multiple custom fields
    • Fixed "Project (Job)" not working correctly in CRM cube
    • Fixed flex.bi not offering to authorise again when there was no access to a register when setting up HansaWorld application
    • Fixed extra dimensions selection being removed when there is no more access

...

    • Fixed an issue with Refresh period not working correctly with HansaWorld Rest API 2.0
    • Fixed an issue with HansaWorld Rest API 2.0 not importing Activity Types (ActTypeVc) register
    • Fixed import stopping when some register records missing code
    • Fixed last import time not displaying correctly for registers for rest api

4.1.1 / Released March 21, 2018

...

    • Added an option to edit how many days in the future REST API will take data from (default = 0)
    • Added an option to edit how many days in the past REST API will refresh data from (default = 90)
    • Added more measures, properties and dimensions to the Invoice cube:
      • User information has been added to the Item dimension
      • Supplier dimension has been added
      • Stock in, Stock out and Goods Receipt item quantity, total cost and total base cost have been added as shared measures
      • Calculated members that can return User information from the Item dimension have been added
    • Added a  debug_import parameter  option for imports (available to Flex.bi Enterprise to flex.bi Enterprise administrators)
    • Added the e-mail as a property to the Person dimension
    • Added a "Skip SSL verification" checkbox when trying to create a REST API connection

...

    • Added a new overall design for Flexflex.bi to match that of the homepage
    • Added shared measures from the Financials cube to the Invoice and CRM cubes
    • Added an informative display in the Source Files tab that shows the user their total source file size and database size
    • Added a warning when a user has exceeded 80% of their allocated source file and database size
    • Added an error that stops an import when the REST API request exceeds a certain size

...

...

Easier subscription to flexto flex.bi plansbi plans

Changes to flex.bi plans

    • total amount of cubes is controlled instead of specific cubes

    • regular import frequency available depends on the selected flex.bi plan

...

Additional chart axes and font size options.

...

flex.

...

bi usage statistics  analysis.

    • can be enabled in the eazybi.toml configuration file
    • can be used to analyze flexanalyze flex.bi usagebi usage

Additional next page URL pagination option for REST API import.

...

    • Added support for all the rest of the cubes to REST API import. Now all of the standard cubes are available for REST API import
    • Added a feature in REST API where setting "Start Import From" to a certain date will re-import all the data from the specified date no matter what
    • Added a new refresh_period_in_days parameter for REST API. Now it's possible to set a number of days in the past that REST API will import from the current day
    • REST API now supports automatic import
    • Added support for company consolidation. The companies drop down menu now allows you to import data for multiple companies in the same flexsame flex.bi accountbi account. The object, item class, customer class and location type fields will show data from all available companies

...

If you are using item varieties in Standard ERP to purchase and/or sell your items you will be happy to hear that with this version we implemented full support for it in flex.bi. You can now choose which item variety groups you wish to analyse by. 

...

    • Added classification types support. Please note that, since this feature is going to change names of your objects in flexin flex.bi, using it you might encounter some conflicts in your current reports. 
    • Added Flex.bi and Added flex.bi and PostgresSQL compatibility
    • Added two new measures in Invoice cube: "Stock Item quantity" and "Stock Item FIFO". These measures are shared on the Stock cube. In order to make these changes you will have to empty these cubes and import the data again

...

      With the addition of REST API several features have become simpler, for instance you will now be able to directly connect to your HansaWorld server and import data into flex.bi completely eliminating the need to manually export registers, just hand flex.bi a URL to your HansaWorld server and it will do the rest. Before you even confirm your first import you will be able to set and freely configure the automatic imports schedule and change it when ever you wish. REST API currently supports importing data for Invoices, Quotations, Sales Orders and Financials cubes. It is now available for the users with the flex.bi "Standard" or "Business" packages and a HansaWorld Standard ERP version 8.1 2015-06-02 or higher.

...

      To help you keep a better track of what is coming and going through your warehouses, the flex.bi team has implemented support for item history. You will now be able to see how much of your items have come and gone, where they have come from, where they have gone to and have they been sold, bought, written off as damaged, lost, are they in transit or are they being used on the production line to create something new and unique.

...