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.