Skip to Content

Changes for page 13 Structure Mapping

Last modified by Artur on 2025/09/10 11:19
From version 4.16
edited by Helena
on 2025/06/16 15:07
Change comment: There is no comment for this version
To version 5.2
edited by Helena
on 2025/06/16 15:30
Change comment: There is no comment for this version

Summary

Details

Page properties
Content
... ... @@ -225,7 +225,7 @@
225 225  
226 226  The input 'G' matches on the last rule which is used as a catch-all or default in this example.
227 227  
228 -=== 13. Substrings ===
228 +=== 13.6.2 Substrings ===
229 229  
230 230  Substrings provide an alternative to regular expressions where the required section of an input value can be described using the number of the starting character, and the length of the substring in characters. The first character is at position 1.
231 231  
... ... @@ -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 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**
... ... @@ -515,60 +515,56 @@
515 515  |(% style="width:182px" %)[0-2]|(% style="width:151px" %)A
516 516  |(% style="width:182px" %)[3-4]|(% style="width:151px" %)B
517 517  
518 -=== 13. Observation Attributes for Time Period ===
518 +=== 13.10.3 Observation Attributes for Time Period ===
519 519  
520 -This use case is where a specific observation for a specific time period has an attribute value.
520 +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.
521 521  
522 -|Input INDICATOR|Input TIME_PERIOD|Output OBS_CONF
523 -|XULADS|2008|C
524 -|XULADS|2009|C
525 -|XULADS|2010|C
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 526  
527 -Or using a validity period on the Representation Mapping:
528 +Or using a validity period on the [[Representation>>doc:sdmx:Glossary.Representation.WebHome]] Mapping:
528 528  
529 -Input INDICATOR Valid From/ Valid To Output OBS_CONF
530 +(% style="width:629.294px" %)
531 +|(% style="width:202px" %)Input INDICATOR|(% style="width:197px" %)Valid From/ Valid To|(% style="width:227px" %) Output OBS_CONF
532 +|(% style="width:202px" %)XULADS|(% style="width:197px" %) 2008/2010|(% style="width:227px" %)С
530 530  
531 -XULADS 2008/2010 C
534 +=== 13.10.4  Time mapping ===
532 532  
533 -=== 13. Time mapping ===
536 +This use case is to create a [[time period>>doc:sdmx:Glossary.Time period.WebHome]] from an input that does not respect [[SDMX>>doc:sdmx:Glossary.Statistical data and metadata exchange.WebHome]] Time Formats.
534 534  
535 -This use case is to create a time period from an input that does not respect SDMX Time Formats.
538 +The [[Component>>doc:sdmx:Glossary.Component.WebHome]] Mapping from SYS_TIME to TIME_PERIOD specifies itself as a time mapping with the following details:
536 536  
537 -The Component Mapping from SYS_TIME to TIME_PERIOD specifies itself as a time mapping with the following details:
540 +(% style="width:652.294px" %)
541 +|(% style="width:139px" %)Source Value|(% style="width:165px" %)Source Mapping|(% style="width:182px" %)Target Frequency|(% style="width:163px" %)Output
542 +|(% style="width:139px" %)18/07/1981|(% style="width:165px" %)dd/MM/yyyy|(% style="width:182px" %)A|(% style="width:163px" %)1981
538 538  
539 -|Source Value|Source Mapping|Target Frequency|Output
540 -|18/07/1981|dd/MM/yyyy|A|1981
544 +When the target frequency is based on another target [[Dimension>>doc:sdmx:Glossary.Dimension.WebHome]] value, in this example the value of the FREQ [[Dimension>>doc:sdmx:Glossary.Dimension.WebHome]] in the target [[DSD>>doc:sdmx:Glossary.Data structure definition.WebHome]].
541 541  
542 -When the target frequency is based on another target Dimension value, in this example the value of the FREQ Dimension in the target DSD.
546 +(% style="width:658.294px" %)
547 +|(% style="width:143px" %)Source Value|(% style="width:163px" %) Source Mapping|(% style="width:176px" %)Target Dimension|(% style="width:173px" %)Frequency Output
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)
543 543  
544 -Source Value Source Mapping Target Frequency Output
550 + When the source is a numerical format.
545 545  
546 -Dimension
552 +(% style="width:658.294px" %)
553 +|(% style="width:143px" %)Source Value|(% style="width:163px" %) Start Period|(% style="width:176px" %)Interval|(% style="width:176px" %)Target FREQ|(% style="width:173px" %) Output
554 +|(% style="width:143px" %)1589808220|(% style="width:163px" %)1970|(% style="width:176px" %) millisecond|(% style="width:176px" %)M|(% style="width:173px" %)2020-05
547 547  
548 -|18/07/1981 dd/MM/yyyy FREQ| |1981-07-18 (when FREQ=D)
549 -| When the source is a numerical format| |
550 -|Source Value Start Period Interval|(((
551 -Target
552 -
553 -FREQ
554 -)))|Output
555 -|1589808220 1970 millisecond|M|2020-05
556 -
557 557  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:
558 558  
559 - Source Value Source Mapping Target Frequency Output
558 +(% style="width:666.294px" %)
559 +|(% style="width:131px" %) Source Value|(% style="width:143px" %)Source Mapping|(% style="width:149px" %)Target Dimension|(% style="width:114px" %)Frequency|(% style="width:126px" %)Output
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
560 560  
561 -Dimension
562 +When the start of year is April 1^^st^^ the Structure (% style="color:#e74c3c" %)Map(%%) has YearStart=04-01:
562 562  
563 - 1981 yyyy D – End of Period 1981-12-31
564 +(% style="width:666.294px" %)
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 +|(% style="width:131px" %)1981|(% style="width:143px" %)yyyy|(% style="width:149px" %)D – End of Period|(% style="width:114px" %) |(% style="width:126px" %)1982-03-31
564 564  
565 -
566 -When the start of year is April 1^^st^^ the Structure Map has YearStart=04-01:
567 -
568 - Source Value Source Mapping Target Frequency Output
569 -
570 -Dimension
571 -
572 572  ----
573 573  
574 574  {{putFootnotes/}}