Page Comparison

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

6.3.6 / Released October 9, 2021

Features:

•  Added support for a separate OLAP DWH database, for example, Vertica.
•  Extended custom field functionality support for file import.
•  Added an option for custom field measure sharing in multiple cubes.
•  Added an option for configuring regular import error count before the import is canceled (for Enterprise users).
•  Added an option for configuring a custom import frequency for a particular HW register.
•  Added an option for configuring a custom import refresh period for a particular HW register.
•  Added an option for configuring a custom import start date for a particular HW register.
•  Shared Planned Purchase Order measures and Stock measures to Invoices cube.
•  Updated the documentation resources.

Bug fixes:

• Fixed a bug that caused account cancelation warning messages being sent to the wrong account owners.

• Fixed  a bug that caused incomplete information logging in the log files when importing HW data using incremental import.

• Fixed a bug that caused an error when working with custom field property of date data type. that has no value.

• Fixed a bug that caused an error when generating company list for consolidation from a HW file import.

6.3.5 / Released August 6, 2021

Features

• Added Account dimension in Stock cube
• Added State and Zip Code properties for Supplier dimension
• Added Customer closed and Customer no-mailing calculated members in Quotations cube

Bug-fixes

• Fixed a bug that caused an error when creating importing a property from custom fields in the Customer dimension

6.3.4 / Released July 30, 2021

Features

• Created a new measure In stock WA value in the Stock cube.

Bug-fixes

• Fixed a bug that prevented (none) member creation in the Item Group hierarchy of the Item dimension.
• Fixed a bug that caused wrong New customer count values after data reimport.

6.3.3 / Released July 22, 2021

Requirements after version change

• Job Costing cube has to be emptied and reimported.

Features

• Implemented a feature for counting new customers in HansaWorld cubes.
• Added new measures in the Sales Orders cube for open gross profit and not invoiced gross profit and quantity.

Bug-fixes

• Fixed a bug that caused wrong data after invalidating an already imported invoice.
• Fixed a bug that caused empty Invoice to Customer Code and Invoice to Customer Name properties.

6.3.2 / Released July 14, 2021

Features

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

Bug fixes

• Fixed a bug that caused Financials cube import error when no profit account was defined.
• Fixed a bug that caused Invoices cube import error when importing custom country codes.
• Fixed a bug that caused wrong request url logging for incremental import.

6.3.1 / Released July 09, 2021

Features

• Introduced Planned delivery date support in Sales Orders and Purchase Orders cube.
• Created a new subscription payment method - Invoice. 
• Extended the Custom fields functionality to all HansaWorld registers.

6.3.0 / Released May 21, 2021

Features

• 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.
• Improved calculated member formatting selection drop-down.
• Remember the last used Analyze tab view (grid or list) and sorting criteria.
• Support for MySQL 8 database and JDBC driver.
• 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.
• Implemented Show Key functionality that allows changing between dimension item key and name display in report rows.
• Removed Zendesk chat option from the mobile devices, to enhance report readability.
• Created a new login screen.
• Implemented a solution for enabling incremental import for the supported registers by default.

Bug fixes

• Perform automatic vacuum on PostgreSQL tables after each import to reduce table size and improve query performance.
• Fixed the issue that caused different color schema being used by default, when creating new reports reports.
• Fixed the issue that prevented plan change from Trial to Business when Advanced Settings were defined.
• Fixed the issue that caused HansaWorld authorization error message being shown for other source applications.
• Fixed the issue causing geocoding error message being displayed when there is no Suppliers dimension in the data cube.
• Fixed the placeholder for the HansaWorld REST API import refresh period.
• Fixed the placeholder for the HansaWorld REST API default import start date.
• Fixed the issue that caused underscores being used in the cube custom fields section title.

6.1.3 / Released Apr 15, 2021

Features

• Implemented unique customer/supplier count measures in all relevant cubes.

Bug fixes

• Changed Quotation Count measure datatype to integer.

6.1.2 / Released Mar 22, 2021

Features

• Added an option to enable Custom Hierarchy creation for consolidated accounts

Bug fixes

• Fixed compatibility issues with PostgreSQL database server
• Fixed the issue that caused incomplete PDF exports
• Fixed the issue that caused Geocoding request failures

6.1.1 / Released Feb 26, 2021

Bug fixes

• Fixed FIFO Value import in Stock Depreciations cube
• Fixed the issue with error handling for Google Spreadsheet import
• Fixed the issue with import error handling that caused clutter in the log files
• Fixed the issue that caused a deadlock when importing consolidated data
• Fixed the issue that prevented dashboard embedding

6.1.0 / Released Feb 05, 2021

Features

• 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
• Custom property hierarchies in Customer, Person, Item, Account, Supplier dimensions
• Now for Consolidated accounts there is an extra hierarchy that combines members with the same name from different companies
• Purchase Invoice measures are now shared in Invoices cube
• Hansaworld imports now retry import several times when receiving Unauthorised error
• In usage statistics more detailed information now is available for HansaWorld imports

Bug fixes

• 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

...

6.0.1 / Released Nov 27, 2020

Bug fixes

• Fixed a bug that caused a timeout when consolidating 90 companies
• Fixed a bug that caused client/supplier category name and item group name removal with incremental import
• Fixed a bug that caused a data validation error when using incremental import
• Fixed a bug that caused the Week day dimension breakdown on consolidated import

6.0.0 / Released Nov 6, 2020

Features

• Now all the companies are available for selection for consolidation in import options application setup step
• Added Budgets and Revised budgets for Financials cube
• Editing HansaWorld source application works faster now
• Added Week Day dimension
• 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.

Bug fixes

• Fixed a incorrect "There is no active subscription for this account" message in HansaWorld application setup
• Fixed some incremental import interrupt issues
• Fixed a bug with breaking the cube structure when selecting and deselecting cubes for import and having source files linked to then
• Fixed a bug that showed incorrect error message in Source Data section when creating a Trial account

5.2.1 / Released Aug 28, 2020

Bug fixes

• Fixed the issue that caused Rest API authorization failure for any company other than the 1st.
• Fixed the issue that caused extra dimension selection drop-down menus not being updated after selecting different company.

...

• Added consolidation support for all cubes

Bug fixes

• Fixed gross profit base amount not being imported correctly with multiple currencies
• Fixed error message after successful payment with credit card
• Fixed a bug where a new application with no selected cube would count as another cube selected
• Fixed a bug where it was only possible to add one less user then the actual account limit
• Fixed a bug where emptying or deleting one cube would cause all the other cubes to be re-imported from start as well
• Fixed a bug where "Authorize URL" and "Token URL" fields where not filled when switching from file
• Fixed an incorrect error message when embedded dashboard was not available anymore

5.1.2 / Released June 19, 2020

Bug fixes

• Fixed the issue that caused wrong error messages appearing in the Source Application section.
• Fixed the issue that caused error messages with missing translations.
• Fixed the issue that prevented users from resetting their passwords.
• Added the All Accounts section for administrators.
• Added a procedure for deleting old accounts.
• Removed unnecessary code for the dark theme.

...

• Added automatic tests for Purchase Invoices cube.

Bug fixes

• Fixed the compatibility issue with MySQL-java connector v8.0.
• Fixed the issue that caused duplicate import initialization after server restart.
• Fixed customer and supplier classification issue in Purchase Invoices un Purchase Orders cubes.
• Fixed the issue with a wrong account unlock link sent to the user.

...

• • 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.

Bug fixes

• • Better detection of mobile devices.
  • Fixed overlapping of label names in some charts.
  • Export to Excel cell formatting for empty cells.
  • Fixed DateAddDays and DateAddWorkdays to work correctly with daylight saving time changes and additional non-working days.

...

• • Improved geocoding address formatting and optimised precision change
  • Added Purchase Invoices to available cubes for import

Bug fixes

• • Fixed subscription for START plan for Tilde application
  • Fixed a bug with incremental import and exporting/importing HansaWorld server
  • Fixed a bug with invalidated invoice import still creating some records
  • Removed dynamic fields import from Stock Movements cube

...

• • Currency support added for Tilde application

Bug fixes

• • Fixed URI validation problem for Geocoding feature
  • Fixed problem, when importing invoices with items that have code ending with a do

5.0.2 / Released December 27, 2019

Bug fixes

• • Fixed empty purchase order import
  • Restricted invalid invoices import
  • Adjusted CSS for improved visual style

5.0.1 / Released December 09, 2019

Bug fixes

• • Fixed import for REST API and Google spreadsheets applications

5.0.0 / Released December 09, 2019

Bug fixes

• • Fixed calculated member disappearing when being created during import for rest api import

...

4.5.1 / Released November 08, 2019

Bug fixes

• • Fixed data import with reverse VAT for HansaWorld application
  • Fixed updated lines not importing for Tildes Jumis application

...

4.4.1 / Released August 06, 2019

Bug fixes

• • 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

...

• • Added a new source application - Tildes Jumis
  • Invoice items are now linked with financials accounts
  • Removed "first_invoice_date" property

Bug fixes

• • 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.

Bug fixes

• • 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.
  • Fixed sending of email notifications about failed source application imports.
  • Order dimensions in the same original sequence when dragging dimensions back to available dimensions in the Analyze tab.

  • Fixed access to cube reports for admins when using data access roles.

  • Fixed saving of the "No regular import" frequency.

...

• • Added "row count" measure to POS cube
  • Shared multiple measures to POS cube

Bug fixes

• • Fixed activity states register import

...

• • "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

4.1.6 / Released November 12, 2018

Bug fixes

• • Added an option to disable extra dimensions to access HansaWorld application import option section without checking if flex.bi has access to the register in HansaWorld

...

• • Made changes to START subscription plan

Bug fixes

• • Fixed an issue where extra dimension selections would disappear when there is no connection with HansaWorld Oauth
  • Fixed an issue with importing transaction and simulations with PostgreSQL
  • Fixed locations dimension not working with invoices record level
  • Added configuration for default HansaWorld Oauth token expire time

...

• • Added additional properties to item dimension - "Base price" , "Weighted Average", "Weighted Average Base 2", "Cost Price", "Cost Price in Base 2"

Bug fixes

• • Fixed incorrectly creating item groups when importing without Item Groups (ITVc) register
  • Fixed incorrectly creating item groups for items with dots in their code
  • Fixed VAT codes not working for Sales Order cube
  • Fixed dashboards export to PDF with wrong colours for pie charts
  • Fixed PDF export sometimes exporting empty reports
  • Fixed some source files with specific formatting to be not uploaded

...

• • Improved look & feel when using HansaWorld as a source application

Bug fixes

• • Fixed an issue with JIRA and Google Documents Applications 

...

• • Added simulation import to Financials cube
  • Adjusted subscription form
  • Now interface when selecting source application
  • Shared measures from POS to Invoices cube and from Invoices to POS cube

Bug fixes

• • 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

...

• • Moved the least used dimensions to a separate dimension group called "Additional dimensions"
  • Changed sign up form - now you agree to our terms and conditions when sign up
  • Added an option to disable Zendesk for flex.bi Enterprise
  • Added Holiday and Transferred working day imports to all relevant data cubes
  • Disabled the ability to change the cube prefix
  • Added register import progress to HansaWorld application status

Bug fixes

• • Fixed issue where VATCodeBlock from Rest AP wasn't detected for VAT/GST check when importing
  • Fixed an issue where deleting a HansaWorld applcation would cause "Table is already taken" error
  • Fixed issue where it wasn't possible to change user role when user limit was reached
  • Fixed issue where it wasn't possible to drill into Financials and Job Costing cube measures
  • Fixed an issue where Rest API with Oauth2 import would not handle thousand separators correctly

...

• • Define data access roles and restrict access to folders, dashboards, and cubes.
  • Export to PDF using the headless Google Chrome browser.
  • Added methods to prevent accidental deletion (instead of empty) of a cube.
  • Added "delete imported data" option to warning message when deleting a REST API or SQL data source.
  • Improved mobile and tablet UI.
  • Embedded dashboards can now enable public access with tokens
  • Added multi-threaded import for most registers.
  • Added support for HansaWorld Rest API v2.
  • Added consolidation hierarchy for objects and accounts.
  • Removed currency import from the Delivery cube.
  • Added sample reports for POS and Deliveries cubes.
  • Added warning messages to automatically generated calculated members to prevent them from being edited.
  • Added registration number property to Customer and Supplier dimensions.

Bug fixes

• • Adjusted customer geocoding to only geocode new or updated customers.

...

• • Added a templates button to the navigation, that links to the templates accounts dashboard specified in the new server parameter:

    Code Block
    templates_account = "https://flex.bi/bi/accounts/47/dashboards"

    
    

  • Replaced each cubes sample reports with only 2 reports, that convey the cubes purpose more thoroughly.
  • Added support for importing days off with the BHollVc register as well as support for the moved work day register EPWorkDayChVc.
  • Added the flex.bi enterprise version to the footer.
  • All customers are now imported regardless of their type.
  • Added a "Task type" dimension in the CRM cube.
  • Added "Activity state" dimension in the CRM cube.
  • Added more validity checks and warnings when setting up consolidation.
  • Added an option to import transaction row comments for the Financials cube.

  • Added an account parameter to ignore the historic changes of a persons sales group and only show the newest sales group for each person:

    Code Block
    import_historic_salesman_groups = true/false

    Will import historic data by default

  • Dark theme for embedded dashboards

    • Requires account level parameter dashboard_theme = "dark"

Bug fixes

• • Adjusted text in error e-mails.

...

• • Added another hierarchy to the Item dimension
    
  • Removed fields, that weren't being used
  • Removed "Reserved" from the Stock Cube
  • First page of the HansaWorld application has been restyled
    
  • Added a new cube - Deliveries
  • Imports will be stopped if records have VAT, but no VAT codes have been uploaded
  • It is now possible to import down payment invoices
  • Added VAT/GST to the POS cube
  • Unlimited Google Sheets applications are now available for the Business plan

Bug fixes

• • Company status now imports correctly
  • Added geocoding for the Suppliers dimension
  • Stock movements now show the "Objects" property correctly
  • Fixed the way person groups are displayed if they are ever changed
  • Fixed an issue when deleting cubes
  • Fixed Extra dimensions import for quotations
  • Fixed the missing (none) class for Projects
  • Fixed the Job costing cubes item level measures not working
  • Fixed missing register messages for registers with versioning

...

• • Enterprise customers should now be able to run their enterprise versions without having to edit eazybi.toml as much
  • Added the ability to import OK'd and Not OK'd POS invoices

Bug fixes

• • Fixed an issue where Invoice To Customer Code and Invoice To Customer Name were not inserted in the database
  • Fixed an issue where Update date property was not working for the Customer dimension with Rest API
  • Fixed an issue with the Start import from date and refresh period
  • Fixed an issue where Activity types didn't have a (none) group
  • Fixed an issue where special characters were not displayed properly in record names with Rest API
  • Fixed an issue where the links weren't working on the login page
  • Fixed a description on the HansaWorld import setup form
  • Fixed an issue with broken map images
  • Fixed an issue where Future days and Refresh period and days would default to the wrong values
  • Fixed an issue with PayPal and FirstData payments

4.0.8 / Released June 20, 2017

Bug fixes

• • Fixed "This month" and "Previous month" calculated members within the Time dimension
  • Fixed a bug where refreshing a report during a Rest API import would return an error
  • Stock depreciation cube Accounts will now be taken from the row level if possible
  • Fixed an issue where imported Quotations didn't have a (none) class
  • Fixed a bug with Rest API refresh day values being converted to the wrong data type

...

• • Country dimension is now available in the Invoice cube without the need for geocoding

Bug fixes

• • Fixed an issue where TRIAL plan accounts couldn't select a regular import frequency

...

• • 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 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

Bug fixes

• • Trying to embed reports/dashboard when the plan does not permit it will return an error message stating so
  • Fixed an issue where a JIRA cube was being counted twice towards maximum cubes in an account
  • Fixed an issue where items with full stops in the names were not being imported correctly

...

• • It is now possible to cancel Invoice, Transaction and CRM imports during row import.
  • Adjusted Quotation cube drill through columns
    
    
  • Dynamic dimensions have been renamed to Extra dimensions in the application and documentation
  • Moved Extra dimension import options to the top of the import option list
  • Added non-alphanumeric character handling for Item and Location classes

Bug fixes

• • Fixed browser tab titles not showing the correct text during login
  • Zendesk chat will no longer show up in embedded reports and dashboards
  • Fixed used data showing up with more than 2 decimal points

...

• • Changed mandatory missing source files warning message from an error message to a warning message
  • Changed optional missing source files warning message from a warning message to an info message
  • Made missing source file messages collapsible
    
    
  • Changed the save button color in the HansaWorld application setup for from grey to blue

  • REST API request limit can now be changed in eazybi.toml by adding the following parameter in the [general] section -

    
    

    rest_api_request_size_limit = 12000

    
    

  • Added a validation for REST AP request limit size when loading the HansaWorld form

  • It is now possible to use the Weighted Average as the value of Total Cost price by specifying the following parameter in your account parameters -

    
    

    use_wa_cost_price =  true

    
    

Bug fixes

• • Fixed an issue where the accounts dimension would have a (none) level if the Goods Receipts cube was imported
  • Fixed grammatical errors
  • Fixed the placement of the manual date format field
  • Fixed the validation for the start date field
  • Fixed the flickering of error messages and HansaWorld setup form elements

...

• • Added a new overall design for Flex.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

Bug fixes

• • Fixed issue where a (none) level would be created for the Accounts dimension when Goods Receipts were imported.
  • Fixed an issue where a user couldn't create an account
  • Fixed an issue where SysFormatBlock registers with spaces for values weren't being parsed properly
  • Fixed an issue where switching to the Start plan would produce an error
  • Fixed an issue where having a non-HansaWorld source application would break embedding
  • Removed account creation debugging

...

• • Added USD as a currency option for plans
  • Updated Flex.bi subscription plans
  • Changed Start plan to a free subscription

Bug fixes

• • Added debugging to figure out where account creation issues arise
  • Fixed an issue that arose when trying to update database parameters in database.toml

4.0.1 / Released April 3, 2017

Bug fixes

• • Fixed a bug that caused all Extra dimensions to be deselected when the HansaWorld setup form was saved after an import
  • Fixed issues when usage statistics were enabled

...

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

Bug fixes

• • Dashboards automatically refresh after data import
  • Fixed "Invoice count" measure

  • Improved precision for amount import

...