2.3.2 Allow for attributes at group-level that includes the time dimension - part 2 - SDMXRI-1660 - SDMXRI-1683 - SDMXRI-1744 - NSI WS 8.7.0
As continuation of ticket #159 (closed) and completion of the time dimension management changes, extend the current implementation with moving the database storage location of group/dimension attached attributes to the Fact table from Attr table, as these attributes are also related to the value of the time dimension stored only in Fact table.
Check list:
-
Allow uploading corresponding observation and attribute values -
Allow retrieving corresponding observation and attribute values -
Correctly cleanup DB structures when DSD is deleted and cleanup method -
Correctly create database tables and database views, even if there are no other attributes only the ones related to time dimension -
Create SQL script for migration
Sample structure and data file for testing import and data retrieval with multiple years:
- structure: SPC-DF_POP_COAST_TEST-2.0-all.xml
- data: TEST_DATA.csv
Extra samples for testing implementation:
- structure SPC-DF_HEALTH-1.0-all.xml
- Sample of data with 2 different values for 2 different combinations of TIME_PERIOD + GEO_PICT t01_df_health_Test2.csv
Currently importing this data file fails with an error.
Edited by jean-baptiste nonin