Skip to Content

Changes for page 13 Structure Mapping

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

Summary

Details

Page properties
Content
... ... @@ -39,7 +39,9 @@
39 39  Different source values can also map to the same target value, for example when deriving regions from country codes.
40 40  
41 41  (% style="width:674.294px" %)
42 -|(% style="width:284px" %)**Source Component: REF_AREA**|(% style="width:387px" %)**Target Component: REGION**
42 +|(% style="width:284px" %)**Source Component:
43 +REF_AREA**|(% style="width:387px" %)**Target Component:
44 +REGION**
43 43  |(% style="width:284px" %)FR|(% style="width:387px" %)EUR
44 44  |(% style="width:284px" %)DE|(% style="width:387px" %)EUR
45 45  |(% style="width:284px" %)IT|(% style="width:387px" %)EUR
... ... @@ -453,31 +453,8 @@
453 453  
454 454  === 13.10.1 Many to one mapping (N-1) ===
455 455  
456 -|Source|Map To
457 -|(((
458 -**FREQ**="A"
458 +[[image:1747377208446-496.png]]
459 459  
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 -
481 481  The bold Dimensions map from source to target verbatim. The mapping simply specifies:
482 482  
483 483  FREQ => FREQ
... ... @@ -502,49 +502,43 @@
502 502  
503 503  The following representation mapping can be used to explicitly map each age to an output code.
504 504  
505 -:
506 -
507 507  (((
508 -|Source Input Free Text|Desired Output Code Id
509 -|0|A
510 -|1|A
511 -|2|A
512 -|3|B
513 -|4|B
485 +(% style="width:669.294px" %)
486 +|(% style="width:218px" %)**Source Input Free Text**|(% style="width:448px" %)**Desired Output Code Id**
487 +|(% style="width:218px" %)0|(% style="width:448px" %)A
488 +|(% style="width:218px" %)1|(% style="width:448px" %)A
489 +|(% style="width:218px" %)2|(% style="width:448px" %)A
490 +|(% style="width:218px" %)3|(% style="width:448px" %)B
491 +|(% style="width:218px" %)4|(% style="width:448px" %)B
514 514  )))
515 515  
516 -If this mapping takes advantage of regular expressions it can be expressed in two 3464 rules:
494 +If this mapping takes advantage of regular expressions it can be expressed in two rules:
517 517  
518 -[[image:SDMX 3-0-0 SECTION 6 FINAL-1.0_en_8c1afe2b.gif||alt="Shape10" height="1" width="302"]]
519 -
520 -__Regular Expression __Desired Output
521 -
522 -:
523 -
524 524  (((
525 -|[0-2]|A
526 -|[3-4]|B
497 +(% style="width:675.294px" %)
498 +|(% style="width:219px" %)(((
499 +**Regular Expression**
500 +)))|(% style="width:453px" %)**Desired Output**
501 +|(% style="width:219px" %)[0-2]|(% style="width:453px" %)A
502 +|(% style="width:219px" %)[3-4]|(% style="width:453px" %)B
503 +
504 +(% style="color:inherit; font-family:inherit; font-size:max(21px, min(23px, 17.4444px + 0.462963vw))" %)13.10.3 Observation Attributes for Time Period
527 527  )))
528 528  
529 -=== 13.10.3 Observation Attributes for Time Period ===
530 -
531 531  This use case is where a specific observation for a specific time period has an attribute 3468 value.
532 532  
533 -:
534 -
535 535  (((
536 -|Input INDICATOR|Input TIME_PERIOD|Output OBS_CONF
537 -|XULADS|2008|C
538 -|XULADS|2009|C
539 -|XULADS|2010|C
510 +(% style="width:689.294px" %)
511 +|(% style="width:220px" %)**Input INDICATOR**|(% style="width:223px" %)**Input TIME_PERIOD**|(% style="width:243px" %)**Output OBS_CONF**
512 +|(% style="width:220px" %)XULADS|(% style="width:223px" %)2008|(% style="width:243px" %)C
513 +|(% style="width:220px" %)XULADS|(% style="width:223px" %)2009|(% style="width:243px" %)C
514 +|(% style="width:220px" %)XULADS|(% style="width:223px" %)2010|(% style="width:243px" %)C
540 540  )))
541 541  
542 542  __Or using a validity period on the Representation Mapping__:
543 543  
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
519 +Input INDICATOR Valid From/ Valid To Output OBS_CONF XULADS 2008/2010 C
545 545  
546 -XULADS 2008/2010 C
547 -
548 548  === 13.10.4 Time mapping ===
549 549  
550 550  This use case is to create a time period from an input that does not respect SDMXTime Formats.
... ... @@ -551,20 +551,15 @@
551 551  
552 552  The Component Mapping from SYS_TIME to TIME_PERIOD specifies itself as a time mapping with the following details:
553 553  
554 -:
555 -
556 556  (((
557 -|Source Value|Source Mapping|Target Frequency|Output
558 -|18/07/1981|dd/MM/yyyy|A|1981
528 +(% style="width:763.294px" %)
529 +|(% style="width:163px" %)**Source Value**|(% style="width:219px" %)**Source Mapping**|(% style="width:198px" %)**Target Frequency**|(% style="width:180px" %)**Output**
530 +|(% style="width:163px" %)18/07/1981|(% style="width:219px" %)dd/MM/yyyy|(% style="width:198px" %)A|(% style="width:180px" %)1981
559 559  )))
560 560  
561 561  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.
562 562  
563 -[[image:SDMX 3-0-0 SECTION 6 FINAL-1.0_en_dbe68698.gif||alt="Shape12" height="1" width="273"]]
564 564  
565 -:
566 -::
567 -
568 568  (((
569 569  |Source Value|Source Mapping|Target Frequency Output Dimension
570 570  
... ... @@ -588,7 +588,7 @@
588 588  
589 589  Dimension
590 590  
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
559 + 1981 yyyy D – End of Period 1981-12-31
592 592  
593 593  When the start of year is April 1^^st^^ the Structure Map has YearStart=04-01:
594 594  
1747377208446-496.png
Author
... ... @@ -1,0 +1,1 @@
1 +XWiki.helena
Size
... ... @@ -1,0 +1,1 @@
1 +28.0 KB
Content