Skip to Content

Changes for page 13 Structure Mapping

Last modified by Helena on 2025/09/10 11:19
From version 10.3
edited by Helena
on 2025/05/16 09:12
Change comment: There is no comment for this version
To version 10.1
edited by Helena
on 2025/05/15 15:48
Change comment: There is no comment for this version

Summary

Details

Page properties
Content
... ... @@ -1,6 +1,4 @@
1 -{{box title="**Contents**"}}
2 -{{toc/}}
3 -{{/box}}
1 += 13 Structure Mapping =
4 4  
5 5  == 13.1 Introduction ==
6 6  
... ... @@ -18,7 +18,7 @@
18 18  
19 19  * Transforming received data into a common internal structure;
20 20  * Transforming reported data into the data collector's preferred structure;
21 -* Transforming unidimensional datasets{{footnote}}Unidimensional datasets are those with a single 'indicator' or 'series code' dimension.{{/footnote}} to multi-dimensional; and
19 +* Transforming unidimensional datasets^^[[^^43^^>>path:#sdfootnote43sym||name="sdfootnote43anc"]]^^ to multi-dimensional; and
22 22  * Transforming internal datasets with a complex structure to a simpler structure with fewer dimensions suitable for dissemination.
23 23  
24 24  == 13.2 1-1 structure maps ==
... ... @@ -27,14 +27,13 @@
27 27  
28 28  In the example below, ISO 2-character country codes are mapped to their ISO 3character equivalent.
29 29  
30 -(% style="width:666.294px" %)
31 -|(% style="width:217px" %)**Country**|(% style="width:251px" %)**Alpha-2 code**|(% style="width:195px" %)**Alpha-3 code**
32 -|(% style="width:217px" %)Afghanistan|(% style="width:251px" %)AF|(% style="width:195px" %)AFG
33 -|(% style="width:217px" %)Albania|(% style="width:251px" %)AL|(% style="width:195px" %)ALB
34 -|(% style="width:217px" %)Algeria|(% style="width:251px" %)DZ|(% style="width:195px" %)DZA
35 -|(% style="width:217px" %)American Samoa|(% style="width:251px" %)AS|(% style="width:195px" %)ASM
36 -|(% style="width:217px" %)Andorra|(% style="width:251px" %)AD|(% style="width:195px" %)AND
37 -|(% style="width:217px" %)etc…|(% style="width:251px" %) |(% style="width:195px" %)
28 +|Country|Alpha-2 code|Alpha-3 code
29 +|Afghanistan|AF|AFG
30 +|Albania|AL|ALB
31 +|Algeria|DZ|DZA
32 +|American Samoa|AS|ASM
33 +|Andorra|AD|AND
34 +|etc…||
38 38  
39 39  Different source values can also map to the same target value, for example when deriving regions from country codes.
40 40  
... ... @@ -159,7 +159,7 @@
159 159  |DZ|DZA
160 160  |AS|ASM
161 161  |AD|AND
162 -|etc…|
159 +|etc…|
163 163  
164 164  A Representation Map mapping free text country names to an ISO 2-character Codelist could be similarly described:
165 165  
... ... @@ -170,7 +170,7 @@
170 170  |"Great Britain"|GB
171 171  |"Ireland"|IE
172 172  |"Eire"|IE
173 -|etc…|
170 +|etc…|
174 174  
175 175  Valuelists, introduced in SDMX 3.0, are equivalent to Codelists but allow the maintenance of non-SDMX identifiers. Importantly, their IDs do not need to conform to IDType, but as a consequence are not Identifiable.
176 176  
... ... @@ -181,7 +181,7 @@
181 181  |Value|Locale|Name
182 182  |$|en|United States Dollar
183 183  |%|En|Percentage
184 -| |fr|Pourcentage
181 +||fr|Pourcentage
185 185  
186 186  Other characteristics of Representation Maps:
187 187  
... ... @@ -280,7 +280,7 @@
280 280  
281 281  Date and time formats are specified by date and time pattern strings based on Java's Simple Date Format. Within date and time pattern strings, unquoted letters from 'A' to 'Z' and from 'a' to 'z' are interpreted as pattern letters representing the components of a date or time string. Text can be quoted using single quotes (') to avoid interpretation. "''" represents a single quote. All other characters are not interpreted; they're simply copied into the output string during formatting or matched against the input string during parsing.
282 282  
283 -Due to the fact that dates may differ per locale, an optional property, defining the locale of the pattern, is provided. This would assist processing of source dates, according to the given locale^^[[(% class="wikiinternallink wikiinternallink wikiinternallink" %)^^44^^>>path:#sdfootnote44sym||name="sdfootnote44anc"]](%%)^^. An indicative list of examples is presented in the following table:
280 +Due to the fact that dates may differ per locale, an optional property, defining the locale of the pattern, is provided. This would assist processing of source dates, according to the given locale^^[[^^44^^>>path:#sdfootnote44sym||name="sdfootnote44anc"]]^^. An indicative list of examples is presented in the following table:
284 284  
285 285  |English (en)|Australia (AU)|en-AU
286 286  |English (en)|Canada (CA)|en-CA
... ... @@ -326,7 +326,7 @@
326 326  
327 327  |Letter|Date or Time Component|Presentation|Examples
328 328  |G|Era designator|[[Text>>url:https://docs.oracle.com/javase/7/docs/api/java/text/SimpleDateFormat.html#text]][[url:https://docs.oracle.com/javase/7/docs/api/java/text/SimpleDateFormat.html#text]]|AD
329 -|yy|Year short (upper case is Year of Week^^[[(% class="wikiinternallink wikiinternallink wikiinternallink" %)^^45^^>>path:#sdfootnote45sym||name="sdfootnote45anc"]](%%)^^)|[[Year>>url:https://docs.oracle.com/javase/7/docs/api/java/text/SimpleDateFormat.html#year]][[url:https://docs.oracle.com/javase/7/docs/api/java/text/SimpleDateFormat.html#year]]|96
326 +|yy|Year short (upper case is Year of Week^^[[^^45^^>>path:#sdfootnote45sym||name="sdfootnote45anc"]]^^)|[[Year>>url:https://docs.oracle.com/javase/7/docs/api/java/text/SimpleDateFormat.html#year]][[url:https://docs.oracle.com/javase/7/docs/api/java/text/SimpleDateFormat.html#year]]|96
330 330  |yyyy|Year Full (upper case is Year of Week)|Year|1996
331 331  |MM|Month number in year starting with 1|Month|07
332 332  |MMM|Month name short|Month|Jul
... ... @@ -531,7 +531,7 @@
531 531  
532 532  The following representation mapping can be used to explicitly map each age to an output code.
533 533  
534 -:
531 +:
535 535  
536 536  (((
537 537  |Source Input Free Text|Desired Output Code Id
... ... @@ -548,7 +548,7 @@
548 548  
549 549  __Regular Expression __Desired Output
550 550  
551 -:
548 +:
552 552  
553 553  (((
554 554  |[0-2]|A
... ... @@ -559,7 +559,7 @@
559 559  
560 560  This use case is where a specific observation for a specific time period has an attribute 3468 value.
561 561  
562 -:
559 +:
563 563  
564 564  (((
565 565  |Input INDICATOR|Input TIME_PERIOD|Output OBS_CONF
... ... @@ -580,7 +580,7 @@
580 580  
581 581  The Component Mapping from SYS_TIME to TIME_PERIOD specifies itself as a time mapping with the following details:
582 582  
583 -:
580 +:
584 584  
585 585  (((
586 586  |Source Value|Source Mapping|Target Frequency|Output
... ... @@ -591,18 +591,18 @@
591 591  
592 592  [[image:SDMX 3-0-0 SECTION 6 FINAL-1.0_en_dbe68698.gif||alt="Shape12" height="1" width="273"]]
593 593  
594 -:
595 -::
591 +:
592 +::
596 596  
597 597  (((
598 598  |Source Value|Source Mapping|Target Frequency Output Dimension
599 599  
600 -|18/07/1981 dd/MM/yyyy|FREQ| |1981-07-18 (when FREQ=D)
597 +|18/07/1981 dd/MM/yyyy|FREQ||1981-07-18 (when FREQ=D)
601 601  |(% rowspan="2" %)(((
602 602  __When the source is a numerical form__at
603 603  
604 604  Source Value Start Period Interv
605 -)))| | |
602 +)))|||
606 606  |al|(((
607 607  Target
608 608  
... ... @@ -626,5 +626,3 @@
626 626  Dimension
627 627  
628 628  1981 yyyy D – End of Period 1982-03-31
629 -
630 -{{putFootnotes/}}