Make Data Model ready for SDMX 3.0 multiple measures
The objective of this feature is to prepare the .Stat Suite Data Model for the "multiple measures" of SDMX 3.0.
SDMX 2.1 data model already allows for a special "measure dimension" that uses a conceptscheme for its values, rather than a codelist. In SDMX 3.0, the measure dimension is pivoted into a flat multi-measure model. The model becomes thus much more generic. It can be seen as a fully flat table with observations in rows and the following value types in columns:
- dimensions
- measures
- attributes
All 3 are very similar, as they can be coded, non-coded, numeric, string, etc. The remaining main differences are:
- dimensions uniquely identify an observation
- attributes logically relate to one or more dimensions or measures
EXAMPLES:
Current 2.1 model without measure dimension:
Component type: | Dimension | Dimension | TimeDimension | PrimaryMeasure | Attribute |
---|---|---|---|---|---|
Concept: | Country | Subject | Time Period | Observation Value | Observation Status |
AUS | GDP | 2000 | 6789 | E |
Corresponding future 3.0 model (without multiple measures):
Component type: | Dimension | Dimension | Dimension | Measure | Attribute (to Observation) |
---|---|---|---|---|---|
Component role: | Geo | Time_Period | |||
Concept: | Country | Subject | Time Period | Observation Value | Observation Status |
AUS | GDP | 2000 | 6789 | E |
Current 2.1 model with measure dimension:
Component type: | Dimension | Dimension | MeasureDimension | TimeDimension | PrimaryMeasure | Attribute |
---|---|---|---|---|---|---|
Concept: | Country | Subject | Measure | Time Period | Observation Value | Observation Status |
AUS | Trade | Concept: Inflow | 2000 | 6789 | E | |
AUS | Trade | Concept: Outflow | 2000 | 6543 | A |
Corresponding future 3.0 model with MeasureDim role and without multiple measures:
Component type: | Dimension | Dimension | Dimension | Dimension | Measure | Attribute (to Observation) |
---|---|---|---|---|---|---|
Component role: | Geo | MeasureDimension | Time_Period | |||
Concept: | Country | Subject | Measure | Time Period | Observation Value | Observation Status |
AUS | Trade | Inflow | 2000 | 6789 | E | |
AUS | Trade | Outflow | 2000 | 6543 | A |
Corresponding future 3.0 model with multiple measures:
Component type: | Dimension | Dimension | Dimension | Measure | Measure | Attribute (to Inflow) | Attribute (to Outflow) |
---|---|---|---|---|---|---|---|
Component role: | Geo | Time_Period | |||||
Concept: | Country | Subject | Time Period | Inflow | Outflow | Observation Status for Inflow | Observation Status for Outflow |
AUS | Trade | 2000 | 6789 | 6543 | E | A |