accoONE-DB v2.3

Several UpdateModel changes

UpdateModel = 0, now only drops, recreates or creates the changed objects, instead of recreating the stage layer entirely. Hereby unnecessary data loads can be omitted.
UpdateModel = 1, now also drops PREV tables.

Lineage

The table [acco].[Lineage] holds the lineage metadata, which is used to find and run stored procedures throughout the OneDB, related to a given dimension or fact table.

Process Changes

The stored procedure [accoRUN].[sp_Process_Changes] is a helper procedure for running UpdateModel = 0, to repopulate changed or new objects, and their dependencies. This avoids having to full load the entire data warehouse, when isolated changes are needed.

CleanViews

Multitenant / Multienvironment support

Other Changes

Default -1000 members on all dimensions
Improved logging - including accoMonitoring functionality
Improved Error messages
Metadata Overview
Error Handling