Changes for page 13 Structure Mapping

Last modified by Artur on 2025/09/10 11:19

From 4.13 to 4.12 From 4.18 to 4.17

From version 4.17

edited by Helena
on 2025/06/16 15:14

Change comment: There is no comment for this version

To version 4.13

edited by Helena
on 2025/06/16 15:02

Change comment: There is no comment for this version

Raw
Rendered

Summary

Page properties (1 modified, 0 added, 0 removed)

Details

Page properties

Content

@@ -478,52 +478,55 @@
  )))
--The bold [[Dimensions>>doc:sdmx:Glossary.Dimension.WebHome]] (% style="color:#e74c3c" %)map(%%) from source to target verbatim. The mapping simply specifies:
++The bold Dimensions map from source to target verbatim. The mapping simply specifies:
--> FREQ => FREQ
--> REF_AREA=> REF_AREA
--> COUNTERPART_AREA=> COUNTERPART _AREA
++FREQ => FREQ
--No [[Representation>>doc:sdmx:Glossary.Representation.WebHome]] Mapping is required. The source value simply copies across unmodified.
++REF_AREA=> REF_AREA
--The remaining [[Dimensions>>doc:sdmx:Glossary.Dimension.WebHome]] all (% style="color:#e74c3c" %)map(%%) to the Indicator [[Dimension>>doc:sdmx:Glossary.Dimension.WebHome]]. This is an example of many [[Dimensions>>doc:sdmx:Glossary.Dimension.WebHome]] mapping to one [[Dimension>>doc:sdmx:Glossary.Dimension.WebHome]]. In this case a [[Representation>>doc:sdmx:Glossary.Representation.WebHome]] Mapping is required, and the mapping first describes the input 'partial key' and how this (% style="color:#e74c3c" %)maps(%%) to the target indicator:
++COUNTERPART_AREA=> COUNTERPART _AREA
--> N:S1:S1:B:B5G => IND_ABC
++No Representation Mapping is required. The source value simply copies across unmodified.
--Where the key sequence is based on the order specified in the (% style="color:#e74c3c" %)mapping(%%) (i.e [[ADJUSTMENT>>doc:sdmx:Glossary.Adjustment.WebHome]], REF_SECTOR, etc will result in the first value N being taken from [[ADJUSTMENT>>doc:sdmx:Glossary.Adjustment.WebHome]] as this was the first item in the source [[Dimension>>doc:sdmx:Glossary.Dimension.WebHome]] list.
++The remaining Dimensions all map to the Indicator Dimension. This is an example of many Dimensions mapping to one Dimension. In this case a Representation Mapping is required, and the mapping first describes the input 'partial key' and how this maps to the target indicator:
--**Note**: The key order is NOT based on the [[Dimension>>doc:sdmx:Glossary.Dimension.WebHome]] order of the [[DSD>>doc:sdmx:Glossary.Data structure definition.WebHome]], as the (% style="color:#e74c3c" %)mapping(%%) needs to be resilient to the [[DSD>>doc:sdmx:Glossary.Data structure definition.WebHome]] changing.
++N:S1:S1:B:B5G => IND_ABC
--=== 13.10.2 Mapping other data types to Code Id ===
++Where the key sequence is based on the order specified in the mapping (i.e ADJUSTMENT, REF_SECTOR, etc will result in the first value N being taken from ADJUSTMENT as this was the first item in the source Dimension list.
--In the case where the incoming data type is not a string and not a [[code>>doc:sdmx:Glossary.Code.WebHome]] identifier i.e. the source [[Dimension>>doc:sdmx:Glossary.Dimension.WebHome]] is of type Integer and the target is Codelist. This is supported by the RepresentationMap. The RepresentationMap source can reference a Codelist, Valuelist, or be free text, the free text can include regular expressions.
++**Note**: The key order is NOT based on the Dimension order of the DSD, as the mapping needs to be resilient to the DSD changing.
--The following [[representation>>doc:sdmx:Glossary.Representation.WebHome]] (% style="color:#e74c3c" %)mapping(%%) can be used to explicitly (% style="color:#e74c3c" %)map(%%) each [[age>>doc:sdmx:Glossary.Age.WebHome]] to an output [[code>>doc:sdmx:Glossary.Code.WebHome]].
++1.
++11.
++111. Mapping other data types to Code Id
--(% style="width:402.294px" %)
--|(% style="width:197px" %)**Source Input Free Text**|(% style="width:204px" %)**Desired Output Code Id**
--|(% style="width:197px" %)0|(% style="width:204px" %)A
--|(% style="width:197px" %)1|(% style="width:204px" %)A
--|(% style="width:197px" %)2|(% style="width:204px" %)A
--|(% style="width:197px" %)3|(% style="width:204px" %)B
--|(% style="width:197px" %)4|(% style="width:204px" %)B
++In the case where the incoming data type is not a string and not a code identifier i.e. the source Dimension is of type Integer and the target is Codelist. This is supported by the RepresentationMap. The RepresentationMap source can reference a Codelist, Valuelist, or be free text, the free text can include regular expressions.
++The following representation mapping can be used to explicitly map each age to an output code.
++
++|Source Input Free Text|Desired Output Code Id
++|0|A
++|1|A
++|2|A
++|3|B
++|4|B
++
  If this mapping takes advantage of regular expressions it can be expressed in two rules:
--(% style="width:336.294px" %)
--|(% style="width:182px" %)**Regular Expression**|(% style="width:151px" %)**Desired Output**
--|(% style="width:182px" %)[0-2]|(% style="width:151px" %)A
--|(% style="width:182px" %)[3-4]|(% style="width:151px" %)B
++Regular Expression        Desired Output
++
++|[0-2]|A
++|[3-4]|B
++
  === 13. Observation Attributes for Time Period ===
--This use case is where a specific observation for a specific [[time period>>doc:sdmx:Glossary.Time period.WebHome]] has an [[attribute>>doc:sdmx:Glossary.Attribute.WebHome]] value.
++This use case is where a specific observation for a specific time period has an attribute value.
--(% style="width:621.294px" %)
--|(% style="width:201px" %)Input INDICATOR|(% style="width:192px" %)Input TIME_PERIOD|(% style="width:225px" %)Output OBS_CONF
--|(% style="width:201px" %)XULADS|(% style="width:192px" %)2008|(% style="width:225px" %)C
--|(% style="width:201px" %)XULADS|(% style="width:192px" %)2009|(% style="width:225px" %)C
--|(% style="width:201px" %)XULADS|(% style="width:192px" %)2010|(% style="width:225px" %)C
++|Input INDICATOR|Input TIME_PERIOD|Output OBS_CONF
++|XULADS|2008|C
++|XULADS|2009|C
++|XULADS|2010|C
  Or using a validity period on the Representation Mapping: