1.1 Automatically create the database views for DSDs and dataflows (Replace NSI-Plugin)
-
Automatically create the database views for DSDs and dataflows. The creation should happen at the same time as the filter and fact tables are created. - Two views
[data].[VI_CurrentDataDataset_{internal dsd id}_{table version(A|B)}]
- Joining filter, fact and codelist tables to export SDMX codes.
- Each component column (measure, dimension and attribute) should be named with its SDMX concept name.
- Two views
[data].[VI_CurrentDataDataFlow_{internal df id}_{table version(A|B)}]
- Select from the previous view and include filters if there is an allowed content constraint.
- Two views
-
When the strucutre of the DSD/DF is changed or deleted, the related views have to be automatically treated (Same as filter and fact tables are treated). -
Migrate current users (create database views for all existing DSDs/dataflows). -
Add views to the documentation of the database model.
The work of this ticket is in preparation to the replacement of the custom nsi-plugin. The implementation can be done in parallel with the other related tickets.
Edited by Pedro Carranza