BI for Business Central
Roadmap
Feedback
Changelog

Changelog

Follow up on the latest improvements and updates.

RSS

new

improved

BIaaS for Business Central v. 2.0

General Optimization
  • The entire data flow, from the Datawarehouse to the Semantic Model and Reports, has been refined to improve performance and eliminate redundancies.
  • A new naming approach has also been implemented, which includes clear data source and module specifications. This ensures that only the relevant data source(s) and module(s) required by the customer are applied to their data model, improving overall efficiency.
  • Additionally, a few tables have been renamed to enhance clarity and consistency across the model.
accoONE-DB 2.2 Upgrade
  • The product has been upgraded to the latest data warehouse framework accoONE-DB 2.2. This new upgrade introduces a more streamlined data structure, significantly reducing complexity. By optimizing data source and module control, the update ensures that redundant tables are automatically excluded, resulting in enhanced system performance.
General updates
  • Automated Datamart Generation: Enables automatic creation of Datamarts, improving time efficiency.
  • Configurable Date Ranges: Allows data grouping to start from a selected date, simplifying the process of working with historical data.
  • Streamlined Account Schedule Hierarchy: Simplified the process for setting up account hierarchies, making it more efficient.
  • Enhanced Global Dimensions Logic: Global dimensions can now be added via dimension set IDs across finance and inventory modules. For sales and purchase, both Navision and Business Central on-premises utilize dimension set IDs, while Business Central global dimensions connect via dimension codes for seamless integration.
Power BI Frontend Framework tool
  • With this new tool, the process of creating a semantic model on top of the Datawarehouse is now automated. The framework efficiently builds tailored data models, saving time and simplifying the setup process.
Currency Conversion Calculation Group
  • The currency conversion process has been simplified, reducing the complexity of measures within the data model. This simplification makes it easier for users to work with and understand the measures.

new

improved

BIaaS for Business Central v. 2.1

General Updates
  • Unique Key Constraints for Meta Data Tables: To improve data consistency and ensure seamless deployments, unique key constraints have been implemented for Meta Data tables. This enhancement helps maintain data integrity during transitions from development to production environments.
  • Updated Guide: Installation & Configuration of Business Central Cloud: The guide for setting up and configuring Business Central Cloud now includes instructions for integrating Microsoft Entra Applications, ensuring smoother implementation.
  • Enhanced Performance for Finance Drill Pages: Performance improvements have been made to Finance Drill pages, offering faster data retrieval and better user experience during financial data analysis.
  • PBI-Reporting Format (PBIR): Leveraging Microsoft's PBIR to enable smart version control for Power BI Reports.
  • Optimized Integration for BC On-Premise and Navision: Reduced Azure costs through enhanced optimization for both Business Central On-Premise and Navision integrations.
Purchase Module
  • Purchase Credit Memo Added to the Data Model: The data model has been expanded to include Purchase Credit Memos, enabling better tracking and reporting of purchase returns and adjustments.

new

improved

BIaaS for Business Central v. 1.4

General Updates
  • URL for BCOpr and NAV: Direct linking to Business Central Opr and NAV from within the reports.
  • Inventory Value Integration: Inventory values now included, sourced from value entry.
  • Delta Loads: Optimized data processing by capturing and transferring only changes since the last update, ensuring faster and more efficient data refreshments.
  • Finance Mapping with AccoPlanning: Added the ability to utilize different Income statement and Balance Sheet structures in the Finance Report.
  • Semantic model structure Streamlined and reorganized into:
    Core Measures:
    Essential metrics and calculations,
    Report-Specific Measures:
    Tailored metrics for individual reports and
    Custom Measure Folder:
    Dedicated space for user-defined calculations.
  • Translation Tool for Reports: New feature enabling translation of reports from Danish to English.
  • Vendor Added to the Budget Module: Vendor details now included.
Project Module
  • Standard Power BI Project Template: Introduced a template for creating native Power BI solutions focused on project and employee performance, leveraging the job section in Business Central.

new

improved

BIaaS for Business Central v. 1.3

General Updates
  • Dynamic Calendar: Now includes fiscal periods for enhanced time-based analysis.
  • Override Views: Simplified customization, allowing for easier adjustments in DataWarehouse.
  • URL Function for BC: Direct linking to Business Central from within the reports.
  • Simplified Naming in Semantic Model: Streamlined naming conventions for easier navigation and understanding.
  • Toggle Feature in Finance Report: Easily switch between monthly and yearly views for income statements and balance sheets.
Budget Module and Admin Center
  • Standard Power BI Budget Template: Introduced a template for creating native Power BI budget solutions, facilitating budgeting for P&L and Sales.
  • Admin Center for Budget Module: Enabling version control and employee access management.

new

improved

BIaaS for Business Central v. 1.2

Integrations
  • The product now supports Business Central On Premise and Navision as data sources. This means a company transitioning from Navision to Business Central will have a more seamless experience, as e.g. the history from Navision can be kept in the BIaaS BC Data Warehouse, and consolidated with data from Business Central.
OneDB 2.2 Upgrade
  • The product has been upgraded to the latest data warehouse framework OneDB 2.2, ensuring better performance and aligning the solution with other products. Furthermore different new helper functions has been implemented, to ease development.

new

improved

BIaaS for Business Central v. 1.1

General Updates
  • Design updates to all modules (Finance, Sales, Supply Chain). New master dataset and reports with an increased focus on user experience and custom setup to ensure that a specific business can be targeted
  • Updates to standard integration and metadata mappings
  • Demo data has been updated
Finance Module
  • Standard template to create native Power BI Finance solution with Profit/Loss and Balance Sheet with support for totaling Accounts. Custom setup is supported.
  • Vendor Ledger / Customer Ledger implementation, including solution of dynamic overdue buckets depending on chosen timeframe