accoONE-DB v2.2

Datamodel

The accoONE-DB has been rewritten to be based on a common data model, where the data lineage flow for the accoONE-DB is located. This means that you can track what happens to e.g. a extModel view throughout the data warehouse flow.

This enables more advanced automations, as it simplifies the way automatic objects are created. Furthermore it enables isolated data warehouse runs for e.g. a fact or dimension with their dependencies, without running the entire data warehouse flow.

The following features has been developed on top of this:

Automated Consolidation with Annotations:
Data sources can now be consolidated by using a # notation in the name e.g. #D365BC and #NAV.

Dimensions are consolidated in the the stage layer in a new schema called stgConsistency. Facts are consilidated in DW views, with autogenerated UNION ALL statements.

Module Annotation:
Modules can be identified by a $ notation in non-automated objects enabling a simpler solution, when modules that have not been bought can easily be deleted.

To keep a clean structure a dedicated schema for consolidated data sources and persisted stgModel views has been created named -

stgConsistency

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, especially for BIaaS products.

Minor

PBIDataModelManipulator configuration table has been added to enable use of Accobats Power BI framework.