new
improved
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 use 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