Changes for page 13 Structure Mapping
Last modified by Artur on 2025/09/10 11:19
Summary
-
Page properties (1 modified, 0 added, 0 removed)
Details
- Page properties
-
- Content
-
... ... @@ -480,50 +480,53 @@ 480 480 481 481 The bold [[Dimensions>>doc:sdmx:Glossary.Dimension.WebHome]] (% style="color:#e74c3c" %)map(%%) from source to target verbatim. The mapping simply specifies: 482 482 483 -> FREQ => FREQ 484 -> REF_AREA=> REF_AREA 485 -> COUNTERPART_AREA=> COUNTERPART _AREA 483 +FREQ => FREQ 486 486 487 - No [[Representation>>doc:sdmx:Glossary.Representation.WebHome]]Mapping is required. The source value simply copies across unmodified.485 +REF_AREA=> REF_AREA 488 488 489 -T he 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:487 +COUNTERPART_AREA=> COUNTERPART _AREA 490 490 491 - >N:S1:S1:B:B5G=>IND_ABC489 +No Representation Mapping is required. The source value simply copies across unmodified. 492 492 493 - Wherethekey sequenceisbasedonthe orderspecifiedinthe(%style="color:#e74c3c"%)mapping(%%)(i.e[[ADJUSTMENT>>doc:sdmx:Glossary.Adjustment.WebHome]],REF_SECTOR,etc willresultin the firstvalueNbeingtakenfrom [[ADJUSTMENT>>doc:sdmx:Glossary.Adjustment.WebHome]]asthiswasthe firstiteminthesource[[Dimension>>doc:sdmx:Glossary.Dimension.WebHome]] list.491 +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: 494 494 495 - **Note**:The key order is NOT based on the [[Dimension>>doc:sdmx:Glossary.Dimension.WebHome]] order of the [[DSD>>doc:sdmx:Glossary.Datastructure definition.WebHome]], as the (% style="color:#e74c3c" %)mapping(%%) needs to be resilient to the [[DSD>>doc:sdmx:Glossary.Datastructure definition.WebHome]] changing.493 +N:S1:S1:B:B5G => IND_ABC 496 496 497 - ===13.10.2Mappingotherdata types toCodeId===495 +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. 498 498 499 - Inthecase wheretheincomingdata type isnotastring and not a [[code>>doc:sdmx:Glossary.Code.WebHome]]identifieri.e.thesource [[Dimension>>doc:sdmx:Glossary.Dimension.WebHome]]isof type Integer and thetargetisCodelist. This is supportedby the RepresentationMap. The RepresentationMapsource canreference a Codelist,Valuelist,orbefree text,thefreetextcaninclude regular expressions.497 +**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. 500 500 501 -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]]. 499 +1. 500 +11. 501 +111. Mapping other data types to Code Id 502 502 503 -(% style="width:402.294px" %) 504 -|(% style="width:197px" %)**Source Input Free Text**|(% style="width:204px" %)**Desired Output Code Id** 505 -|(% style="width:197px" %)0|(% style="width:204px" %)A 506 -|(% style="width:197px" %)1|(% style="width:204px" %)A 507 -|(% style="width:197px" %)2|(% style="width:204px" %)A 508 -|(% style="width:197px" %)3|(% style="width:204px" %)B 509 -|(% style="width:197px" %)4|(% style="width:204px" %)B 503 +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. 510 510 505 +The following representation mapping can be used to explicitly map each age to an output code. 506 + 507 +|Source Input Free Text|Desired Output Code Id 508 +|0|A 509 +|1|A 510 +|2|A 511 +|3|B 512 +|4|B 513 + 511 511 If this mapping takes advantage of regular expressions it can be expressed in two rules: 512 512 513 -(% style="width:336.294px" %) 514 -|(% style="width:182px" %)**Regular Expression**|(% style="width:151px" %)**Desired Output** 515 -|(% style="width:182px" %)[0-2]|(% style="width:151px" %)A 516 -|(% style="width:182px" %)[3-4]|(% style="width:151px" %)B 517 517 517 +Regular Expression Desired Output 518 + 519 +|[0-2]|A 520 +|[3-4]|B 521 + 518 518 === 13. Observation Attributes for Time Period === 519 519 520 -This use case is where a specific observation for a specific [[time period>>doc:sdmx:Glossary.Timeperiod.WebHome]]has an[[attribute>>doc:sdmx:Glossary.Attribute.WebHome]]value.524 +This use case is where a specific observation for a specific time period has an attribute value. 521 521 522 -(% style="width:621.294px" %) 523 -|(% style="width:201px" %)Input INDICATOR|(% style="width:192px" %)Input TIME_PERIOD|(% style="width:225px" %)Output OBS_CONF 524 -|(% style="width:201px" %)XULADS|(% style="width:192px" %)2008|(% style="width:225px" %)C 525 -|(% style="width:201px" %)XULADS|(% style="width:192px" %)2009|(% style="width:225px" %)C 526 -|(% style="width:201px" %)XULADS|(% style="width:192px" %)2010|(% style="width:225px" %)C 526 +|Input INDICATOR|Input TIME_PERIOD|Output OBS_CONF 527 +|XULADS|2008|C 528 +|XULADS|2009|C 529 +|XULADS|2010|C 527 527 528 528 Or using a validity period on the Representation Mapping: 529 529