Skip to Content

Changes for page 13 Structure Mapping

Last modified by Helena K. on 2026/06/10 10:18
From version 14.1
edited by Helena K.
on 2026/06/10 10:18
Change comment: There is no comment for this version
To version 13.2
edited by Helena K.
on 2026/06/10 10:15
Change comment: There is no comment for this version

Summary

Details

Page properties
Content
... ... @@ -391,7 +391,7 @@
391 391  
392 392  == 13.8 Using TIME_PERIOD in mapping rules ==
393 393  
394 -The source TIME_PERIOD [[Dimension>>doc:sdmx:Glossary 2\.1.Dimension.WebHome]] can be used in conjunction with other input [[Dimensions>>doc:sdmx:Glossary 2\.1.Dimension.WebHome]] to create discrete mapping rules where the output is conditional on the [[time period>>doc:sdmx:Glossary 2\.1.Time period.WebHome]] value.
394 +The source TIME_PERIOD [[Dimension>>doc:sdmx:Glossary 2\.1.Dimension.WebHome]] can be used in conjunction with other input [[Dimensions>>doc:sdmx:Glossary 2\.1.Dimension.WebHome]] to create discrete (% style="color:#e74c3c" %)mapping(%%) rules where the output is conditional on the [[time period>>doc:sdmx:Glossary 2\.1.Time period.WebHome]] value.
395 395  
396 396  The main use case is setting the value of Observation [[Attributes>>doc:sdmx:Glossary 2\.1.Attribute.WebHome]] in the target [[dataset>>doc:sdmx:Glossary 2\.1.Data set.WebHome]].
397 397  
... ... @@ -399,23 +399,23 @@
399 399  |(% style="width:103px" %)**Rule**|(% style="width:405px" %)**Source**|(% style="width:198px" %)**Target**
400 400  |(% style="width:103px" %)1|(% style="width:405px" %)(((
401 401  If
402 -INDICATOR=XULADS; and TIME_PERIOD=2007.
402 +[[INDICATOR>>doc:sdmx:Glossary 2\.1.Statistical indicator.WebHome]]=XULADS; and TIME_PERIOD=2007.
403 403  )))|(% style="width:198px" %)(((
404 404  Set OBS_CONF=F
405 405  )))
406 406  |(% style="width:103px" %)2|(% style="width:405px" %)(((
407 407  If
408 -INDICATOR=XULADS; and TIME_PERIOD=2008.
408 +[[INDICATOR>>doc:sdmx:Glossary 2\.1.Statistical indicator.WebHome]]=XULADS; and TIME_PERIOD=2008.
409 409  )))|(% style="width:198px" %)Set OBS_CONF=F
410 410  |(% style="width:103px" %)3|(% style="width:405px" %)(((
411 411  If
412 -INDICATOR=XULADS; and TIME_PERIOD=2009.
412 +[[INDICATOR>>doc:sdmx:Glossary 2\.1.Statistical indicator.WebHome]]=XULADS; and TIME_PERIOD=2009.
413 413  )))|(% style="width:198px" %)(((
414 414  Set OBS_CONF=F
415 415  )))
416 416  |(% style="width:103px" %)4|(% style="width:405px" %)(((
417 417  If
418 -INDICATOR=XULADS; and TIME_PERIOD=2010.
418 +[[INDICATOR>>doc:sdmx:Glossary 2\.1.Statistical indicator.WebHome]]=XULADS; and TIME_PERIOD=2010.
419 419  )))|(% style="width:198px" %)(((
420 420  Set OBS_CONF=**C**
421 421  )))
... ... @@ -424,9 +424,9 @@
424 424  
425 425  == 13.9 Time span mapping rules using validity periods ==
426 426  
427 -Creating discrete mapping rules for each TIME_PERIOD is impractical where rules need to cover a specific span of time regardless of frequency, and for high-frequency data.
427 +Creating discrete (% style="color:#e74c3c" %)mapping(%%) rules for each TIME_PERIOD is impractical where rules need to cover a specific span of time regardless of frequency, and for high-frequency data.
428 428  
429 -Instead, an optional validity period can be set for each mapping.
429 +Instead, an optional validity period can be set for each (% style="color:#e74c3c" %)mapping(%%).
430 430  
431 431  By specifying validity periods, the example from Section 13.8 can be re-written using two rules as follows:
432 432  
... ... @@ -434,7 +434,7 @@
434 434  |(% style="width:74px" %)Rule|(% style="width:215px" %)Source|(% style="width:223px" %)Target
435 435  |(% style="width:74px" %)1|(% style="width:215px" %)(((
436 436  If
437 -INDICATOR=XULADS.
437 +[[INDICATOR>>doc:sdmx:Glossary 2\.1.Statistical indicator.WebHome]]=XULADS.
438 438  Validity Period
439 439  start period=2007
440 440  end period=2009
... ... @@ -441,7 +441,7 @@
441 441  )))|(% style="width:223px" %)Set OBS_CONF=F
442 442  |(% style="width:74px" %)2|(% style="width:215px" %)(((
443 443  If
444 -INDICATOR=XULADS.
444 +[[INDICATOR>>doc:sdmx:Glossary 2\.1.Statistical indicator.WebHome]]=XULADS.
445 445  Validity Period
446 446  start period=2010
447 447  )))|(% style="width:223px" %)(((
... ... @@ -460,7 +460,7 @@
460 460  === 13.10.1 Many to one mapping (N3513 -1) ===
461 461  
462 462  (% style="width:542.294px" %)
463 -|(% style="width:274px" %)**Source**|(% style="width:265px" %)**Map To**
463 +|(% style="width:274px" %)**Source**|(% style="width:265px" %)(% style="color:#e74c3c" %)**Map**(%%)** To**
464 464  |(% style="width:274px" %)(((
465 465  (% style="color:#8e44ad" %)**FREQ**="A"
466 466  [[ADJUSTMENT>>doc:sdmx:Glossary 2\.1.Adjustment.WebHome]]="N"
... ... @@ -478,30 +478,30 @@
478 478  
479 479  )))
480 480  
481 -The bold [[Dimensions>>doc:sdmx:Glossary 2\.1.Dimension.WebHome]] map from source to target verbatim. The mapping simply specifies:
481 +The bold [[Dimensions>>doc:sdmx:Glossary 2\.1.Dimension.WebHome]] (% style="color:#e74c3c" %)map(%%) from source to target verbatim. The (% style="color:#e74c3c" %)mapping(%%) simply specifies:
482 482  
483 483  > FREQ => FREQ
484 484  > REF_AREA=> REF_AREA
485 485  > COUNTERPART_AREA=> COUNTERPART _AREA
486 486  
487 -No [[Representation>>doc:sdmx:Glossary 2\.1.Representation.WebHome]] Mapping is required. The source value simply copies across unmodified.
487 +No [[Representation>>doc:sdmx:Glossary 2\.1.Representation.WebHome]] (% style="color:#e74c3c" %)Mapping(%%) is required. The source value simply copies across unmodified.
488 488  
489 -The remaining [[Dimensions>>doc:sdmx:Glossary 2\.1.Dimension.WebHome]] all map to the [[Indicator>>doc:sdmx:Glossary 2\.1.Statistical indicator.WebHome]] [[Dimension>>doc:sdmx:Glossary 2\.1.Dimension.WebHome]]. This is an example of many [[Dimensions>>doc:sdmx:Glossary 2\.1.Dimension.WebHome]] mapping to one [[Dimension>>doc:sdmx:Glossary 2\.1.Dimension.WebHome]]. In this case a [[Representation>>doc:sdmx:Glossary 2\.1.Representation.WebHome]] Mapping is required, and the mapping first describes the input 'partial key' and how this maps to the target [[indicator>>doc:sdmx:Glossary 2\.1.Statistical indicator.WebHome]]:
489 +The remaining [[Dimensions>>doc:sdmx:Glossary 2\.1.Dimension.WebHome]] all (% style="color:#e74c3c" %)map(%%) to the [[Indicator>>doc:sdmx:Glossary 2\.1.Statistical indicator.WebHome]] [[Dimension>>doc:sdmx:Glossary 2\.1.Dimension.WebHome]]. This is an example of many [[Dimensions>>doc:sdmx:Glossary 2\.1.Dimension.WebHome]] (% style="color:#e74c3c" %)mapping(%%) to one [[Dimension>>doc:sdmx:Glossary 2\.1.Dimension.WebHome]]. In this case a [[Representation>>doc:sdmx:Glossary 2\.1.Representation.WebHome]] (% style="color:#e74c3c" %)Mapping(%%) is required, and the (% style="color:#e74c3c" %)mapping(%%) first describes the input 'partial key' and how this (% style="color:#e74c3c" %)maps(%%) to the target [[indicator>>doc:sdmx:Glossary 2\.1.Statistical indicator.WebHome]]:
490 490  
491 491  > N:S1:S1:B:B5G => IND_ABC
492 492  
493 -Where the key sequence is based on the order specified in the mapping (i.e [[ADJUSTMENT>>doc:sdmx:Glossary 2\.1.Adjustment.WebHome]], REF_SECTOR, etc will result in the first value N being taken from [[ADJUSTMENT>>doc:sdmx:Glossary 2\.1.Adjustment.WebHome]] as this was the first item in the source [[Dimension>>doc:sdmx:Glossary 2\.1.Dimension.WebHome]] list.
493 +Where the key sequence is based on the order specified in the (% style="color:#e74c3c" %)mapping(%%) (i.e [[ADJUSTMENT>>doc:sdmx:Glossary 2\.1.Adjustment.WebHome]], REF_SECTOR, etc will result in the first value N being taken from [[ADJUSTMENT>>doc:sdmx:Glossary 2\.1.Adjustment.WebHome]] as this was the first item in the source [[Dimension>>doc:sdmx:Glossary 2\.1.Dimension.WebHome]] list.
494 494  
495 -**Note**: The key order is NOT based on the [[Dimension>>doc:sdmx:Glossary 2\.1.Dimension.WebHome]] order of the [[DSD>>doc:sdmx:Glossary 2\.1.Data structure definition.WebHome]], as the mapping needs to be resilient to the [[DSD>>doc:sdmx:Glossary 2\.1.Data structure definition.WebHome]] changing.
495 +**Note**: The key order is NOT based on the [[Dimension>>doc:sdmx:Glossary 2\.1.Dimension.WebHome]] order of the [[DSD>>doc:sdmx:Glossary 2\.1.Data structure definition.WebHome]], as the (% style="color:#e74c3c" %)mapping(%%) needs to be resilient to the [[DSD>>doc:sdmx:Glossary 2\.1.Data structure definition.WebHome]] changing.
496 496  
497 497  === 13.10.2 Mapping other data types to Code Id ===
498 498  
499 499  In the case where the incoming data type is not a string and not a [[code>>doc:sdmx:Glossary 2\.1.Code.WebHome]] identifier i.e. the source [[Dimension>>doc:sdmx:Glossary 2\.1.Dimension.WebHome]] is of type Integer and the target is [[Codelist>>doc:sdmx:Glossary 2\.1.Code list.WebHome]]. This is supported by the RepresentationMap. The RepresentationMap source can reference a [[Codelist>>doc:sdmx:Glossary 2\.1.Code list.WebHome]], Valuelist, or be free text, the free text can include regular expressions.
500 500  
501 -The following [[representation>>doc:sdmx:Glossary 2\.1.Representation.WebHome]] mapping can be used to explicitly map each [[age>>doc:sdmx:Glossary 2\.1.Age.WebHome]] to an output [[code>>doc:sdmx:Glossary 2\.1.Code.WebHome]].
501 +The following [[representation>>doc:sdmx:Glossary 2\.1.Representation.WebHome]] (% style="color:#e74c3c" %)mapping(%%) can be used to explicitly (% style="color:#e74c3c" %)map(%%) each [[age>>doc:sdmx:Glossary 2\.1.Age.WebHome]] to an output [[code>>doc:sdmx:Glossary 2\.1.Code.WebHome]].
502 502  
503 503  (% style="width:402.294px" %)
504 -|(% style="width:197px" %)**Source Input Free Text**|(% style="width:204px" %)**Desired Output Code Id**
504 +|(% style="width:197px" %)**Source Input Free Text**|(% style="width:204px" %)**Desired Output [[Code>>doc:sdmx:Glossary 2\.1.Code.WebHome]] Id**
505 505  |(% style="width:197px" %)0|(% style="width:204px" %)A
506 506  |(% style="width:197px" %)1|(% style="width:204px" %)A
507 507  |(% style="width:197px" %)2|(% style="width:204px" %)A
... ... @@ -508,7 +508,7 @@
508 508  |(% style="width:197px" %)3|(% style="width:204px" %)B
509 509  |(% style="width:197px" %)4|(% style="width:204px" %)B
510 510  
511 -If this mapping takes advantage of regular expressions it can be expressed in two rules:
511 +If this (% style="color:#e74c3c" %)mapping(%%) takes advantage of regular expressions it can be expressed in two rules:
512 512  
513 513  (% style="width:336.294px" %)
514 514  |(% style="width:182px" %)**Regular Expression**|(% style="width:151px" %)**Desired Output**
... ... @@ -525,7 +525,7 @@
525 525  |(% style="width:201px" %)XULADS|(% style="width:192px" %)2009|(% style="width:225px" %)C
526 526  |(% style="width:201px" %)XULADS|(% style="width:192px" %)2010|(% style="width:225px" %)C
527 527  
528 -Or using a validity period on the [[Representation>>doc:sdmx:Glossary 2\.1.Representation.WebHome]] Mapping:
528 +Or using a validity period on the [[Representation>>doc:sdmx:Glossary 2\.1.Representation.WebHome]] (% style="color:#e74c3c" %)Mapping(%%):
529 529  
530 530  (% style="width:629.294px" %)
531 531  |(% style="width:202px" %)Input [[INDICATOR>>doc:sdmx:Glossary 2\.1.Statistical indicator.WebHome]]|(% style="width:197px" %)Valid From/ Valid To|(% style="width:227px" %) Output OBS_CONF
... ... @@ -535,16 +535,16 @@
535 535  
536 536  This use case is to create a [[time period>>doc:sdmx:Glossary 2\.1.Time period.WebHome]] from an input that does not respect [[SDMX>>doc:sdmx:Glossary 2\.1.Statistical data and metadata exchange.WebHome]] [[Time Formats>>doc:sdmx:Glossary 2\.1.Time format.WebHome]].
537 537  
538 -The [[Component>>doc:sdmx:Glossary 2\.1.Component.WebHome]] Mapping from SYS_TIME to TIME_PERIOD specifies itself as a time mapping with the following details:
538 +The [[Component>>doc:sdmx:Glossary 2\.1.Component.WebHome]] (% style="color:#e74c3c" %)Mapping(%%) from SYS_TIME to TIME_PERIOD specifies itself as a time (% style="color:#e74c3c" %)mapping(%%) with the following details:
539 539  
540 540  (% style="width:652.294px" %)
541 -|(% style="text-align:center; width:139px" %)Source Value|(% style="text-align:center; width:165px" %)Source Mapping|(% style="text-align:center; width:182px" %)Target Frequency|(% style="text-align:center; width:163px" %)Output
541 +|(% style="width:139px" %)Source Value|(% style="width:165px" %)Source (% style="color:#e74c3c" %)Mapping|(% style="width:182px" %)Target Frequency|(% style="width:163px" %)Output
542 542  |(% style="width:139px" %)18/07/1981|(% style="width:165px" %)dd/MM/yyyy|(% style="width:182px" %)A|(% style="width:163px" %)1981
543 543  
544 544  When the target frequency is based on another target [[Dimension>>doc:sdmx:Glossary 2\.1.Dimension.WebHome]] value, in this example the value of the FREQ [[Dimension>>doc:sdmx:Glossary 2\.1.Dimension.WebHome]] in the target [[DSD>>doc:sdmx:Glossary 2\.1.Data structure definition.WebHome]].
545 545  
546 546  (% style="width:658.294px" %)
547 -|(% style="text-align:center; width:143px" %)Source Value|(% style="text-align:center; width:163px" %) Source Mapping|(% style="text-align:center; width:176px" %)Target Dimension|(% style="text-align:center; width:173px" %)Frequency Output
547 +|(% style="width:143px" %)Source Value|(% style="width:163px" %) Source (% style="color:#e74c3c" %)Mapping|(% style="width:176px" %)Target [[Dimension>>doc:sdmx:Glossary 2\.1.Dimension.WebHome]]|(% style="width:173px" %)Frequency Output
548 548  |(% style="width:143px" %)18/07/1981|(% style="width:163px" %)dd/MM/yyyy|(% style="width:176px" %)FREQ|(% style="width:173px" %)1981-07-18 (when FREQ=D)
549 549  
550 550   When the source is a numerical format.
... ... @@ -556,13 +556,13 @@
556 556  When the source frequency is lower than the target frequency additional information 3568 can be provided for resolve to start of period, end of period, or mid period, as shown 3569 in the following example:
557 557  
558 558  (% style="width:666.294px" %)
559 -|(% style="text-align:center; width:131px" %)(% style="color:#000000" %) Source Value|(% style="text-align:center; width:143px" %)(% style="color:#000000" %)Source Mapping|(% style="text-align:center; width:149px" %)(% style="color:#000000" %)Target Dimension|(% style="text-align:center; width:114px" %)(% style="color:#000000" %)Frequency|(% style="text-align:center; width:126px" %)(% style="color:#000000" %)Output
559 +|(% style="width:131px" %) Source Value|(% style="width:143px" %)Source (% style="color:#e74c3c" %)Mapping|(% style="width:149px" %)Target [[Dimension>>doc:sdmx:Glossary 2\.1.Dimension.WebHome]]|(% style="width:114px" %)Frequency|(% style="width:126px" %)Output
560 560  |(% style="width:131px" %)1981|(% style="width:143px" %)yyyy|(% style="width:149px" %)D – End of Period|(% style="width:114px" %) |(% style="width:126px" %)1981-12-31
561 561  
562 -When the start of year is April 1^^st^^ the Structure Map has YearStart=04-01:
562 +When the start of year is April 1^^st^^ the Structure (% style="color:#e74c3c" %)Map(%%) has YearStart=04-01:
563 563  
564 564  (% style="width:666.294px" %)
565 -|(% style="text-align:center; width:131px" %) Source Value|(% style="text-align:center; width:143px" %)Source Mapping|(% style="text-align:center; width:149px" %)Target Dimension|(% style="text-align:center; width:114px" %)Frequency|(% style="text-align:center; width:126px" %)Output
565 +|(% style="width:131px" %) Source Value|(% style="width:143px" %)Source Mapping|(% style="width:149px" %)Target Dimension|(% style="width:114px" %)Frequency|(% style="width:126px" %)Output
566 566  |(% style="width:131px" %)1981|(% style="width:143px" %)yyyy|(% style="width:149px" %)D – End of Period|(% style="width:114px" %) |(% style="width:126px" %)1982-03-31
567 567  
568 568  ----
© Semantic R&D Group, 2026