Skip to Content

Changes for page 13 Structure Mapping

Last modified by Helena on 2025/09/10 11:19
From version 10.18
edited by Helena
on 2025/05/16 09:33
Change comment: There is no comment for this version
To version 10.15
edited by Helena
on 2025/05/16 09:30
Change comment: There is no comment for this version

Summary

Details

Page properties
Content
... ... @@ -453,8 +453,31 @@
453 453  
454 454  === 13.10.1 Many to one mapping (N-1) ===
455 455  
456 -[[image:1747377208446-496.png]]
456 +|Source|Map To
457 +|(((
458 +**FREQ**="A"
457 457  
460 +ADJUSTMENT="N"
461 +
462 +**REF_AREA**="PL"
463 +
464 +**COUNTERPART_AREA**="W0"
465 +
466 +REF_SECTOR="S1"
467 +
468 +COUNTERPART_SECTOR="S1" ACCOUNTING_ENTRY="B"
469 +
470 +STO="B5G"
471 +)))|(((
472 +FREQ="A"
473 +
474 +REF_AREA="PL"
475 +
476 +COUNTERPART_AREA="W0"
477 +
478 +INDICATOR="IND_ABC"
479 +)))
480 +
458 458  The bold Dimensions map from source to target verbatim. The mapping simply specifies:
459 459  
460 460  FREQ => FREQ
... ... @@ -479,24 +479,28 @@
479 479  
480 480  The following representation mapping can be used to explicitly map each age to an output code.
481 481  
505 +:
506 +
482 482  (((
483 -(% style="width:669.294px" %)
484 -|(% style="width:218px" %)**Source Input Free Text**|(% style="width:448px" %)**Desired Output Code Id**
485 -|(% style="width:218px" %)0|(% style="width:448px" %)A
486 -|(% style="width:218px" %)1|(% style="width:448px" %)A
487 -|(% style="width:218px" %)2|(% style="width:448px" %)A
488 -|(% style="width:218px" %)3|(% style="width:448px" %)B
489 -|(% style="width:218px" %)4|(% style="width:448px" %)B
508 +|Source Input Free Text|Desired Output Code Id
509 +|0|A
510 +|1|A
511 +|2|A
512 +|3|B
513 +|4|B
490 490  )))
491 491  
492 492  If this mapping takes advantage of regular expressions it can be expressed in two 3464 rules:
493 493  
518 +[[image:SDMX 3-0-0 SECTION 6 FINAL-1.0_en_8c1afe2b.gif||alt="Shape10" height="1" width="302"]]
519 +
494 494  __Regular Expression __Desired Output
495 495  
522 +:
523 +
496 496  (((
497 -(% style="width:675.294px" %)
498 -|(% style="width:219px" %)[0-2]|(% style="width:453px" %)A
499 -|(% style="width:219px" %)[3-4]|(% style="width:453px" %)B
525 +|[0-2]|A
526 +|[3-4]|B
500 500  )))
501 501  
502 502  === 13.10.3 Observation Attributes for Time Period ===
... ... @@ -503,18 +503,21 @@
503 503  
504 504  This use case is where a specific observation for a specific time period has an attribute 3468 value.
505 505  
533 +:
534 +
506 506  (((
507 -(% style="width:689.294px" %)
508 -|(% style="width:220px" %)**Input INDICATOR**|(% style="width:223px" %)**Input TIME_PERIOD**|(% style="width:243px" %)**Output OBS_CONF**
509 -|(% style="width:220px" %)XULADS|(% style="width:223px" %)2008|(% style="width:243px" %)C
510 -|(% style="width:220px" %)XULADS|(% style="width:223px" %)2009|(% style="width:243px" %)C
511 -|(% style="width:220px" %)XULADS|(% style="width:223px" %)2010|(% style="width:243px" %)C
536 +|Input INDICATOR|Input TIME_PERIOD|Output OBS_CONF
537 +|XULADS|2008|C
538 +|XULADS|2009|C
539 +|XULADS|2010|C
512 512  )))
513 513  
514 514  __Or using a validity period on the Representation Mapping__:
515 515  
516 -Input INDICATOR Valid From/ Valid To Output OBS_CONF XULADS 2008/2010 C
544 +[[image:SDMX 3-0-0 SECTION 6 FINAL-1.0_en_6dbf7f.gif||alt="Shape11" height="36" width="555"]] Input INDICATOR Valid From/ Valid To Output OBS_CONF
517 517  
546 +XULADS 2008/2010 C
547 +
518 518  === 13.10.4 Time mapping ===
519 519  
520 520  This use case is to create a time period from an input that does not respect SDMXTime Formats.
... ... @@ -521,15 +521,20 @@
521 521  
522 522  The Component Mapping from SYS_TIME to TIME_PERIOD specifies itself as a time mapping with the following details:
523 523  
554 +:
555 +
524 524  (((
525 -(% style="width:763.294px" %)
526 -|(% style="width:163px" %)**Source Value**|(% style="width:219px" %)**Source Mapping**|(% style="width:198px" %)**Target Frequency**|(% style="width:180px" %)**Output**
527 -|(% style="width:163px" %)18/07/1981|(% style="width:219px" %)dd/MM/yyyy|(% style="width:198px" %)A|(% style="width:180px" %)1981
557 +|Source Value|Source Mapping|Target Frequency|Output
558 +|18/07/1981|dd/MM/yyyy|A|1981
528 528  )))
529 529  
530 530  When the target frequency is based on another target Dimension value, in this example __the value of the FREQ Dimension in the tar__get DSD.
531 531  
563 +[[image:SDMX 3-0-0 SECTION 6 FINAL-1.0_en_dbe68698.gif||alt="Shape12" height="1" width="273"]]
532 532  
565 +:
566 +::
567 +
533 533  (((
534 534  |Source Value|Source Mapping|Target Frequency Output Dimension
535 535  
... ... @@ -553,7 +553,7 @@
553 553  
554 554  Dimension
555 555  
556 - 1981 yyyy D – End of Period 1981-12-31
591 +[[image:SDMX 3-0-0 SECTION 6 FINAL-1.0_en_4ec4bb31.gif||alt="Shape13" height="173" width="555"]] 1981 yyyy D – End of Period 1981-12-31
557 557  
558 558  When the start of year is April 1^^st^^ the Structure Map has YearStart=04-01:
559 559  
1747377208446-496.png
Author
... ... @@ -1,1 +1,0 @@
1 -XWiki.helena
Size
... ... @@ -1,1 +1,0 @@
1 -28.0 KB
Content