BI4Dynamics NAV March 2018 (6.2)

BI4Dynamics latest release brings Enterprise BI features with partition based processing, editable process flow and other performance and development features.


  • Partition based cube processing
    Partial data-based processing that enables up to 90% faster cube processing. Users can set 3 partitions – current, intermediate and archived.
  • Editable process flow
    To support adding external data source BI4Dynamics process flow is flexible and enables adding new SSIS packages.


  • Inventory state redesign: Measures are based on a data warehouse.
  • Setup execution log: Monitor execution time and table inserts in Power BI.
  • Folder translations: Translation option added to the Wizard.

BI4Dynamics NAV January 2018 (6.1)


  • Built on latest .NET framework 4.7.1 to support latest Microsoft technologies.
  • Added full support for SQL 2017.


Added support for NAV 2018 (Application, Metadata, Multitenant).


  • Added fully editable 12 dimensions (total 16): Business Unit, Currency, Customer, Fixed Asset, GL Account, Item, Job, Location, Reason Code, Resource, Resource Group, SalespersonPurchaser, Shipment Method, Shipping Agent, Source Code, Vendor.
  • Added Filter on loading data into Fact (WHERE condition).
  • Added Many-to-Many (dimension: measure group) relation in a cube.

BI4Dynamics NAV 6.0 (November 2017) with Wizard 2.0

Create new or edit existing cubes, dimensions and measures through simple 5 step process that is based on Metadata and supports many-to-one concept (source-to-destination table).

Build New Cubes and Data Warehouse

Create new cubes and data warehouse covering your specifics in Microsoft Dynamics NAV (or vertical BI solution) without prior SQL knowledge.

Customize BI Solution with Wizard or Manually

Add fields to existing solution. Mix and match. Wizard or manual generated code. All inside one BI solution. Customization and development has never been easier.

BI4Dynamics NAV Express September 2017 (5.7) Release

Corporate BI Solution for SMB price.

Business Intelligence project is no longer reserved for companies with deep pockets. Get all information you need with BI4Dynamics Express. Connect  Power BI and Excel reports to the ready-to-analyze data warehouse.

If you don’t have BI4Dynamics license yet please fill in the free trial form on

Data Warehouse based BI solution

BI4Dynamics Express uses the data warehouse to transform data from Microsoft Dynamics NAV to valuable information. This enables connecting to dashboards without affecting your Microsoft Dynamics.

Runs on SQL Server Express edition

BI4Dynamics Express runs on SQL Server Express edition. This entry-level SQL edition is free and allows up to 10 GB database size.

Affordable subscription

BI4Dynamics Express is available as an affordable subscription (renting). Users can choose 3 or (all) 6 modules from Sales, Receivables, Purchase, Payables, Inventory, and Finance application area.

Installation and usage

  1. Where to download available resources?
  2. How to install BI4Dynamics Express?
  3. How to connect to predefined Power BI reports?
  4. How to connect to Excel reports?

Download resources

Recent BI4Dynamics NAV Releases

BI4Dynamics NAV August 2017 (5.6) Release

  • Updated translations,
  • Updated Excel reports (EnglishGermanSpanish and Dutch),
  • Fully redesigned Service Management module,
  • New Sales cube measures “Original Profit” and “Cost Non-adjusted” (both from Customer Ledger Entry) with respected time intelligence and ACY variations.

Need translations and reports in your language? We are looking forward to your feedback on

If you don’t have BI4Dynamics license yet please fill in the free trial form on

BI4Dynamics NAV April 2017 (5.4) Release

This release enhances international business intelligence by adding 64 measures in additional currency and offers a whole new set of Excel ACY reports for the standard areas (Sales, Purchase, Account Receivables, Account Payables, Inventory, General Ledger) based on Additional Currency.

Filter Stage data by company

NAV upgrade requires merging old and new data from NAV companies. To this end, a company filter for closing balances (i.e. receivables) prevents duplicate from an old NAV company, because, the same value is brought forward as an opening balance in a new NAV company.

Users can filter Stage data by any transactional data (f.e. values, items, etc.). To get an idea how filtering can be done in BI4Dynamics we recorded a video.

Add custom MDX measures

Adding custom MDX measures to BI4Dynamics is very simple. You don’t need any technical knowledge but using standard Excel functionality. After you are happy with the result just copy and paste the MDX formula to BI4Dynamics customization wizard and you’re done.

Company ID attribute with roles and permissions

Analyze what’s important. If you have more than 1 database it comes handy that you can filter the data by Company ID to avoid redundancy. We introduced an added attribute Company ID to dimensions Customer, Vendor, Item, GL Account, Location, Salesperson-purchaser.

Added attributes to dimensions

  • Company: CompanyID (used to filter Stage), Data Source ID, Data Source Server Name, Data Source Database Name
  • Document Customer: External Document Number, Due Date, Closed at Date, On Hold, Open, Due Days
  • Document Vendor: External Document Number, Due Date, Closed at Date, On Hold, Open, Due Days
  • Document GL: External Document Number, Document Date, General Posting Type

Receivables cube (12 ACY measures):

Sales On Credit ACY, Avg Receivables Payment Terms ACY, Avg Receivables ACY, Receivables Coefficient ACY, Receivables Turnover (Days) ACY, % Receivables Overdue ACY, % of Total Receivables Balance ACY, % of Total Sales ACY, Sales on Credit (%) ACY, Avg Overdue Days Receivables ACY, Avg Due Days Receivables ACY, Avg Open Days Receivables ACY.

Inventory cube (10 ACY measures):

Avg Price ACY, Avg Stock Price ACY, Opening Stock Value ACY, Stock Rotation Coefficient ACY, Inventory Cost Amount Consumption ACY, Inventory Cost Amount Negative Adjmt ACY, Inventory Cost Amount Output ACY, Inventory Cost Amount Positive Adjmt ACY, Inventory Cost Amount Sale ACY, Inventory Cost Amount Transfer ACY.

Added attribute Company ID to dimensions:

Customer, Vendor, Item, GL Account, Location, Salesperson-purchaser;

In BI4Dynamics Data Warehouse, most dimension entries have an attribute CompanyID that defines which company the record was created for. If a record (i.e. Customer) has the same code and name in more companies, CompanyID is the attribute (identifier) that separates transactions by companies.

Payables cube (12 ACY measures):

Purchase On Credit ACY, Avg Payables ACY, Payables Coefficient ACY, Payables Turnover (Days) ACY, % Payables Overdue ACY, % of Total Payables Balance ACY, % of Total Purchase ACY, Avg Payables Payment Terms ACY, Purchase On Credit (%) ACY, Avg Overdue Days Payables ACY, Avg Due Days Payables ACY, Avg Open Days Payables ACY.

Purchase cube (2 ACY measures):

Purchase Budget Cost Amount ACY, Avg Purchase Price ACY.

General Ledger cube (2 ACY measures):

Net Change Last ACY, Opening Balance ACY.

Added dimensions to GL cube:

General Product Posting Group, General Business Posting Group, Source Code, Reason Code.

Added measures to Sales Order measures group in Sales cube:

Sales Order Cost Amount, Sales Order Profit, Sales Order Profit %.

Sales cube (17 ACY measures):

Avg Sales Price ACY, Avg Sales Cost ACY, Avg Sales Profit ACY, Net Sales ACY/Budget Index, Net Sales ACY/Budget YTD Index, Sales Budget Cost Amount ACY, Sales Budget Sales, Amount ACY, Sales Budget Amount YTD ACY, Sales Budget Variance ACY, Sales Budget Variance YTD ACY, Sales Discount % ACY, Net Sales Pop Index ACY, Net Sales YoY Index ACY, Profit ACY %, Profit % Expected ACY, Profit PoP Index ACY, Profit YoY Index ACY.

Sales cube (6 PCY – posted currency measures):

Net Sales PCY, Gross Sales PCY, Cost PCY, Sales Discount Amount PCY, Profit PCY, Net Sales Expected PCY.

Purchase cube (3 PCY – posted currency measures):

Cost Amount PCY, Cost Amount Expected PCY, Purchase Discount Amount PCY.

BI4Dynamics NAV January 2017 (5.3.1) Release

This release adds support for NAV 2017, adds global dimension from more different NAV database versions to one data warehouse (very useful when doing NAV upgrade).

BI4Dynamics NAV November 2016 (5.3.0) Release

SSIS option for faster processing, support for SQL 2016 and improved manage dimension feature that pushes BI4Dynamics Cube Wizard to the next level. There is also new built-in content (30+ new measures) in almost all cubes and support for Fiscal date.

BI4Dynamics NAV 5.3.0

Watch this 15-minutes video that shows all new content and framework features.

BI4Dynamics and Power BI are the perfect match.

BI4Dynamics as data foundation.

As BI4Dynamics delivers out-of-the-box content it’s most rational to use it as a base and build your BI specifics on top of that.

Power BI for further modelling.

Power BI can greatly extend the usage of BI4Dynamics Data Warehouse with integrating additional sources.

Mobile and Web reports.

To help you started we created a set of Power BI reports and dashboards based on BI4Dynamics data warehouse.

Manage Dimension Feature (Cube Wizard)

Manage dimensions feature is here to add Standard or Non-Empty or All Fields from Microsoft Dynamics to BI during the daily process. New release is bringing Cube Wizard to the next level with Show/Hide dimension attributes and Add/Delete dimension hierarchies.

SSIS option for faster processing (Framework)

SSIS processing option for faster processing. When using SSIS option, stored procedures are automatically transformed and send to SSIS as packages. As packages are executed parallel we can expect decrease of processing time for 50% or more.

BI4Dynamics NAV May 2016 (5.2.0) Release

Manage dimension feature for adding fields from Microsoft Dynamics NAV to BI4Dynamics automatically. BI4Dynamics transfers fields (Standard or Non-Empty or All Fields) from NAV to BI immediately by clicking “Update now” or later, during daily update process.


BI4Dynamics NAV November 2015 (5.1.0) Release

This release brings an automated Wizard and Role Management feature. There is also major content improvement to include Multi-Measure Tools and new Purchase Cube content.

Multi-Measure Tool (All Cubes)

By adding new dimension “Multi-Measure Tool” to columns, current measure (for example Net Sales) is automatically expanded by 28 new measures. New measures are based on combination of base measure and date. It works with every transactional measure in all cubes!

Virtual Cubes (Wizard)

Virtual Cubes are easily created from physical cubes (standard and wizard created cube). Each deploy updates physical and virtual cubes.

Roles and Permissions Management (Wizard)

Roles and Permission are created within standard Microsoft OLAP cubes (SSAS). Roles and Permissions are stored and applied automatically.