Skip to Content

Changes for page 13 Structure Mapping

Last modified by Helena on 2025/09/10 11:19
From version 10.6
edited by Helena
on 2025/05/16 09:14
Change comment: There is no comment for this version
To version 10.19
edited by Helena
on 2025/05/16 09:36
Change comment: There is no comment for this version

Summary

Details

Page properties
Content
... ... @@ -97,37 +97,26 @@
97 97  
98 98  A simple example mapping a source dataset with a single dimension to one with multiple dimensions is shown below:
99 99  
100 -|Source|Target|Output Series Key
101 -|SERIES_CODE=XMAN_Z_21|(((
100 +(% style="width:819.294px" %)
101 +|(% style="width:240px" %)**Source**|(% style="width:246px" %)**Target**|(% style="width:329px" %)**Output Series Key**
102 +|(% style="width:240px" %)SERIES_CODE=XMAN_Z_21|(% style="width:246px" %)(((
102 102  Dimensions
103 -
104 104  INDICATOR=XM
105 -
106 106  FREQ=A
107 -
108 108  ADJUSTMENT=N
109 -
110 110  Attributes
111 -
112 112  UNIT_MEASURE=_Z
113 -
114 114  COMP_ORG=21
115 -)))|XM:A:N
116 -|SERIES_CODE=XMAN_Z_34|(((
110 +)))|(% style="width:329px" %)XM:A:N
111 +|(% style="width:240px" %)SERIES_CODE=XMAN_Z_34|(% style="width:246px" %)(((
117 117  Dimensions
118 -
119 119  INDICATOR=XM
120 -
121 121  FREQ=A
122 -
123 123  ADJUSTMENT=N
124 -
125 125  Attributes
126 -
127 127  UNIT_MEASURE=_Z
128 -
129 129  COMP_ORG=34
130 -)))|XM:A:N
119 +)))|(% style="width:329px" %)XM:A:N
131 131  
132 132  The above behaviour can be okay if the series XMAN_Z_21 contains observations for different periods of time then the series XMAN_Z_34. If however both series contain observations for the same point in time, the output for this mapping will be two observations with the same series key, for the same period in time.
133 133  
... ... @@ -143,24 +143,26 @@
143 143  
144 144  A Representation Map mapping ISO 2-character to ISO 3-character Codelists would take the following form:
145 145  
146 -|CL_ISO_ALPHA2|CL_ISO_ALPHA3
147 -|AF|AFG
148 -|AL|ALB
149 -|DZ|DZA
150 -|AS|ASM
151 -|AD|AND
152 -|etc…|
135 +(% style="width:763.294px" %)
136 +|(% style="width:252px" %)**CL_ISO_ALPHA2**|(% style="width:508px" %)**CL_ISO_ALPHA3**
137 +|(% style="width:252px" %)AF|(% style="width:508px" %)AFG
138 +|(% style="width:252px" %)AL|(% style="width:508px" %)ALB
139 +|(% style="width:252px" %)DZ|(% style="width:508px" %)DZA
140 +|(% style="width:252px" %)AS|(% style="width:508px" %)ASM
141 +|(% style="width:252px" %)AD|(% style="width:508px" %)AND
142 +|(% style="width:252px" %)etc…|(% style="width:508px" %)
153 153  
154 154  A Representation Map mapping free text country names to an ISO 2-character Codelist could be similarly described:
155 155  
156 -|Text|CL_ISO_ALPHA2
157 -|"Germany"|DE
158 -|"France"|FR
159 -|"United Kingdom"|GB
160 -|"Great Britain"|GB
161 -|"Ireland"|IE
162 -|"Eire"|IE
163 -|etc…|
146 +(% style="width:770.294px" %)
147 +|(% style="width:247px" %)**Text**|(% style="width:520px" %)**CL_ISO_ALPHA2**
148 +|(% style="width:247px" %)"Germany"|(% style="width:520px" %)DE
149 +|(% style="width:247px" %)"France"|(% style="width:520px" %)FR
150 +|(% style="width:247px" %)"United Kingdom"|(% style="width:520px" %)GB
151 +|(% style="width:247px" %)"Great Britain"|(% style="width:520px" %)GB
152 +|(% style="width:247px" %)"Ireland"|(% style="width:520px" %)IE
153 +|(% style="width:247px" %)"Eire"|(% style="width:520px" %)IE
154 +|(% style="width:247px" %)etc…|(% style="width:520px" %)
164 164  
165 165  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.
166 166  
... ... @@ -168,10 +168,11 @@
168 168  
169 169  In common with Codelists, each item in a Valuelist has a multilingual name giving it a human-readable label and an optional description. For example:
170 170  
171 -|Value|Locale|Name
172 -|$|en|United States Dollar
173 -|%|En|Percentage
174 -| |fr|Pourcentage
162 +(% style="width:780.294px" %)
163 +|(% style="width:126px" %)**Value**|(% style="width:153px" %)**Locale**|(% style="width:498px" %)**Name**
164 +|(% style="width:126px" %)$|(% style="width:153px" %)en|(% style="width:498px" %)United States Dollar
165 +|(% style="width:126px" %)%|(% style="width:153px" %)En|(% style="width:498px" %)Percentage
166 +|(% style="width:126px" %) |(% style="width:153px" %)fr|(% style="width:498px" %)Pourcentage
175 175  
176 176  Other characteristics of Representation Maps:
177 177  
... ... @@ -195,30 +195,31 @@
195 195  
196 196  Below is an example set of regular expression rules for a particular component.
197 197  
198 -|Regex|Description|Output
199 -|A|Rule match if input = 'A'|OUT_A
200 -|^[A-G]|Rule match if the input starts with letters A to G|OUT_B
201 -|A~|B|Rule match if input is either 'A' or 'B'|OUT_C
190 +(% style="width:708.294px" %)
191 +|(% style="width:133px" %)**Regex**|(% style="width:377px" %)**Description**|(% style="width:194px" %)**Output**
192 +|(% style="width:133px" %)A|(% style="width:377px" %)Rule match if input = 'A'|(% style="width:194px" %)OUT_A
193 +|(% style="width:133px" %)^[A-G]|(% style="width:377px" %)Rule match if the input starts with letters A to G|(% style="width:194px" %)OUT_B
194 +|(% style="width:133px" %)A~|B|(% style="width:377px" %)Rule match if input is either 'A' or 'B'|(% style="width:194px" %)OUT_C
202 202  
203 203  Like all mapping rules, the output is either a Code, a Value or free text depending on the representation of the Component in the target Data Structure Definition.
204 204  
205 205  If the regular expression contains capture groups, these can be used in the definition of the output value, by specifying \//**n** //as an output value where //**n**// is the number of the capture group starting from 1. For example
206 206  
207 -|Regex|Target output|Example Input|Example Output
208 -|(((
209 -([0-9]{4})[0-
200 +(% style="width:720.294px" %)
201 +|(% style="width:199px" %)**Regex**|(% style="width:126px" %)**Target output**|(% style="width:192px" %)**Example Input**|(% style="width:200px" %)**Example Output**
202 +|(% style="width:199px" %)(((
203 +([0-9]{4})[0-9]([0-9]{1})
204 +)))|(% style="width:126px" %)\1-Q\2|(% style="width:192px" %)200933|(% style="width:200px" %)2009-Q3
210 210  
211 -9]([0-9]{1})
212 -)))|\1-Q\2|200933|2009-Q3
213 -
214 214  As regular expression rules can be used as a general catch-all if nothing else matches, the ordering of the rules is important. Rules should be tested starting with the highest priority, moving down the list until a match is found.
215 215  
216 216  The following example shows this:
217 217  
218 -|Priority|Regex|Description|Output
219 -|1|A|Rule match if input = 'A'|OUT_A
220 -|2|B|Rule match if input = 'B'|OUT_B
221 -|3|[A-Z]|Any character A-Z|OUT_C
210 +(% style="width:725.294px" %)
211 +|(% style="width:198px" %)**Priority**|(% style="width:148px" %)**Regex**|(% style="width:212px" %)**Description**|(% style="width:164px" %)**Output**
212 +|(% style="width:198px" %)1|(% style="width:148px" %)A|(% style="width:212px" %)Rule match if input = 'A'|(% style="width:164px" %)OUT_A
213 +|(% style="width:198px" %)2|(% style="width:148px" %)B|(% style="width:212px" %)Rule match if input = 'B'|(% style="width:164px" %)OUT_B
214 +|(% style="width:198px" %)3|(% style="width:148px" %)[A-Z]|(% style="width:212px" %)Any character A-Z|(% style="width:164px" %)OUT_C
222 222  
223 223  The input 'A' matches both the first and the last rule, but the first takes precedence having the higher priority. The output is OUT_A.
224 224  
... ... @@ -230,14 +230,16 @@
230 230  
231 231  For instance:
232 232  
233 -|Input String|Start|Length|Output
234 -|ABC_DEF_XYZ|5|3|DEF
235 -|XULADS|1|2|XU
226 +(% style="width:742.294px" %)
227 +|(% style="width:191px" %)**Input String**|(% style="width:154px" %)**Start**|(% style="width:211px" %)**Length**|(% style="width:182px" %)**Output**
228 +|(% style="width:191px" %)ABC_DEF_XYZ|(% style="width:154px" %)5|(% style="width:211px" %)3|(% style="width:182px" %)DEF
229 +|(% style="width:191px" %)XULADS|(% style="width:154px" %)1|(% style="width:211px" %)2|(% style="width:182px" %)XU
236 236  
237 237  Sub-strings can therefore be used for the conceptual rule //If starts with 'XU' map to Y// as shown in the following example:
238 238  
239 -|Start|Length|Source|Target
240 -|1|2|XU|Y
233 +(% style="width:740.294px" %)
234 +|(% style="width:194px" %)**Start**|(% style="width:151px" %)**Length**|(% style="width:208px" %)**Source**|(% style="width:183px" %)**Target**
235 +|(% style="width:194px" %)1|(% style="width:151px" %)2|(% style="width:208px" %)XU|(% style="width:183px" %)Y
241 241  
242 242  == 13.7 Mapping non-SDMX time formats to SDMX formats ==
243 243  
... ... @@ -249,15 +249,16 @@
249 249  
250 250  The output of a time-based mapping is derived from the output Frequency, which is either explicitly stated in the mapping or defined as the value output by a specific Dimension or Attribute in the output mapping. If the output frequency is unknown or if the SDMX format is not desired, then additional rules can be provided to specify the output date format for the given frequency Id. The default rules are:
251 251  
252 -|Frequency|Format|Example
253 -|A|YYYY|2010
254 -|D|YYYY-MM-DD|2010-01-01
255 -|I|YYYY-MM-DDThh:mm:ss|2010-01T20:22:00
256 -|M|YYYY-MM|2010-01
257 -|Q|YYYY-Qn|2010-Q1
258 -|S|YYYY-Sn|2010-S1
259 -|T|YYYY-Tn|2010-T1
260 -|W|YYYY-Wn|YYYY-W53
247 +(% style="width:771.294px" %)
248 +|(% style="width:187px" %)**Frequency**|(% style="width:159px" %)**Format**|(% style="width:422px" %)**Example**
249 +|(% style="width:187px" %)A|(% style="width:159px" %)YYYY|(% style="width:422px" %)2010
250 +|(% style="width:187px" %)D|(% style="width:159px" %)YYYY-MM-DD|(% style="width:422px" %)2010-01-01
251 +|(% style="width:187px" %)I|(% style="width:159px" %)YYYY-MM-DDThh:mm:ss|(% style="width:422px" %)2010-01T20:22:00
252 +|(% style="width:187px" %)M|(% style="width:159px" %)YYYY-MM|(% style="width:422px" %)2010-01
253 +|(% style="width:187px" %)Q|(% style="width:159px" %)YYYY-Qn|(% style="width:422px" %)2010-Q1
254 +|(% style="width:187px" %)S|(% style="width:159px" %)YYYY-Sn|(% style="width:422px" %)2010-S1
255 +|(% style="width:187px" %)T|(% style="width:159px" %)YYYY-Tn|(% style="width:422px" %)2010-T1
256 +|(% style="width:187px" %)W|(% style="width:159px" %)YYYY-Wn|(% style="width:422px" %)YYYY-W53
261 261  
262 262  In the case where the input frequency is lower than the output frequency, the mapping defaults to end of period, but can be explicitly set to start, end or mid-period.
263 263  
... ... @@ -270,36 +270,36 @@
270 270  
271 271  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.
272 272  
273 -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:
269 +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{{footnote}}Unidimensional datasets are those with a single 'indicator' or 'series code' dimension.{{/footnote}}. An indicative list of examples is presented in the following table:
274 274  
275 -|English (en)|Australia (AU)|en-AU
276 -|English (en)|Canada (CA)|en-CA
277 -|English (en)|United Kingdom (GB)|en-GB
278 -|English (en)|United States (US)|en-US
279 -|Estonian (et)|Estonia (EE)|et-EE
280 -|Finnish (fi)|Finland (FI)|fi-FI
281 -|French (fr)|Belgium (BE)|fr-BE
282 -|French (fr)|Canada (CA)|fr-CA
283 -|French (fr)|France (FR)|fr-FR
284 -|French (fr)|Luxembourg (LU)|fr-LU
285 -|French (fr)|Switzerland (CH)|fr-CH
286 -|German (de)|Austria (AT)|de-AT
287 -|German (de)|Germany (DE)|de-DE
271 +(% style="width:772.294px" %)
272 +|(% style="width:190px" %)English (en)|(% style="width:230px" %)Australia (AU)|(% style="width:348px" %)en-AU
273 +|(% style="width:190px" %)English (en)|(% style="width:230px" %)Canada (CA)|(% style="width:348px" %)en-CA
274 +|(% style="width:190px" %)English (en)|(% style="width:230px" %)United Kingdom (GB)|(% style="width:348px" %)en-GB
275 +|(% style="width:190px" %)English (en)|(% style="width:230px" %)United States (US)|(% style="width:348px" %)en-US
276 +|(% style="width:190px" %)Estonian (et)|(% style="width:230px" %)Estonia (EE)|(% style="width:348px" %)et-EE
277 +|(% style="width:190px" %)Finnish (fi)|(% style="width:230px" %)Finland (FI)|(% style="width:348px" %)fi-FI
278 +|(% style="width:190px" %)French (fr)|(% style="width:230px" %)Belgium (BE)|(% style="width:348px" %)fr-BE
279 +|(% style="width:190px" %)French (fr)|(% style="width:230px" %)Canada (CA)|(% style="width:348px" %)fr-CA
280 +|(% style="width:190px" %)French (fr)|(% style="width:230px" %)France (FR)|(% style="width:348px" %)fr-FR
281 +|(% style="width:190px" %)French (fr)|(% style="width:230px" %)Luxembourg (LU)|(% style="width:348px" %)fr-LU
282 +|(% style="width:190px" %)French (fr)|(% style="width:230px" %)Switzerland (CH)|(% style="width:348px" %)fr-CH
283 +|(% style="width:190px" %)German (de)|(% style="width:230px" %)Austria (AT)|(% style="width:348px" %)de-AT
284 +|(% style="width:190px" %)German (de)|(% style="width:230px" %)Germany (DE)|(% style="width:348px" %)de-DE
288 288  
289 -[[image:SDMX 3-0-0 SECTION 6 FINAL-1.0_en_59eee18f.gif||alt="Shape8" height="1" width="192"]]
286 +(% style="width:773.294px" %)
287 +|(% style="width:190px" %)German (de)|(% style="width:234px" %)Luxembourg (LU)|(% style="width:345px" %)de-LU
288 +|(% style="width:190px" %)German (de)|(% style="width:234px" %)Switzerland (CH)|(% style="width:345px" %)de-CH
289 +|(% style="width:190px" %)Greek (el)|(% style="width:234px" %)Cyprus (CY)|(% style="width:345px" %)el-CY__([[*>>https://www.oracle.com/java/technologies/javase/jdk8-jre8-suported-locales.html#cldrlocale]])__
290 +|(% style="width:190px" %)Greek (el)|(% style="width:234px" %)Greece (GR)|(% style="width:345px" %)el-GR
291 +|(% style="width:190px" %)Hebrew (iw)|(% style="width:234px" %)Israel (IL)|(% style="width:345px" %)iw-IL
292 +|(% style="width:190px" %)Hindi (hi)|(% style="width:234px" %)India (IN)|(% style="width:345px" %)hi-IN
293 +|(% style="width:190px" %)Hungarian (hu)|(% style="width:234px" %)Hungary (HU)|(% style="width:345px" %)hu-HU
294 +|(% style="width:190px" %)Icelandic (is)|(% style="width:234px" %)Iceland (IS)|(% style="width:345px" %)is-IS
295 +|(% style="width:190px" %)Indonesian (in)|(% style="width:234px" %)Indonesia (ID)|(% style="width:345px" %)in-ID__([[*>>https://www.oracle.com/java/technologies/javase/jdk8-jre8-suported-locales.html#cldrlocale]])__
296 +|(% style="width:190px" %)Irish (ga)|(% style="width:234px" %)Ireland (IE)|(% style="width:345px" %)ga-IE__([[*>>https://www.oracle.com/java/technologies/javase/jdk8-jre8-suported-locales.html#cldrlocale]])__
297 +|(% style="width:190px" %)Italian (it)|(% style="width:234px" %)Italy (IT)|(% style="width:345px" %)it-IT
290 290  
291 -|German (de)|Luxembourg (LU)|de-LU
292 -|German (de)|Switzerland (CH)|de-CH
293 -|Greek (el)|Cyprus (CY)|el-CY[[__(*)__>>url:https://www.oracle.com/java/technologies/javase/jdk8-jre8-suported-locales.html#cldrlocale]][[url:https://www.oracle.com/java/technologies/javase/jdk8-jre8-suported-locales.html#cldrlocale]]
294 -|Greek (el)|Greece (GR)|el-GR
295 -|Hebrew (iw)|Israel (IL)|iw-IL
296 -|Hindi (hi)|India (IN)|hi-IN
297 -|Hungarian (hu)|Hungary (HU)|hu-HU
298 -|Icelandic (is)|Iceland (IS)|is-IS
299 -|Indonesian (in)|Indonesia (ID)|in-ID[[__(*)__>>url:https://www.oracle.com/java/technologies/javase/jdk8-jre8-suported-locales.html#cldrlocale]][[url:https://www.oracle.com/java/technologies/javase/jdk8-jre8-suported-locales.html#cldrlocale]]
300 -|Irish (ga)|Ireland (IE)|ga-IE[[__(*)__>>url:https://www.oracle.com/java/technologies/javase/jdk8-jre8-suported-locales.html#cldrlocale]][[url:https://www.oracle.com/java/technologies/javase/jdk8-jre8-suported-locales.html#cldrlocale]]
301 -|Italian (it)|Italy (IT)|it-IT
302 -
303 303  Examples
304 304  
305 305  22/06/1981 would be described as dd/MM/YYYY, with locale en-GB
... ... @@ -314,32 +314,30 @@
314 314  
315 315  The following pattern letters are defined (all other characters from 'A' to 'Z' and from 'a' to 'z' are reserved):
316 316  
317 -|Letter|Date or Time Component|Presentation|Examples
318 -|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
319 -|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
320 -|yyyy|Year Full (upper case is Year of Week)|Year|1996
321 -|MM|Month number in year starting with 1|Month|07
322 -|MMM|Month name short|Month|Jul
323 -|MMMM|Month name full|Month|July
324 -|ww|Week in year|[[Number>>url:https://docs.oracle.com/javase/7/docs/api/java/text/SimpleDateFormat.html#number]][[url:https://docs.oracle.com/javase/7/docs/api/java/text/SimpleDateFormat.html#number]]|27
325 -|W|Week in month|[[Number>>url:https://docs.oracle.com/javase/7/docs/api/java/text/SimpleDateFormat.html#number]][[url:https://docs.oracle.com/javase/7/docs/api/java/text/SimpleDateFormat.html#number]]|2
326 -|DD|Day in year|[[Number>>url:https://docs.oracle.com/javase/7/docs/api/java/text/SimpleDateFormat.html#number]][[url:https://docs.oracle.com/javase/7/docs/api/java/text/SimpleDateFormat.html#number]]|189
327 -|dd|Day in month|[[Number>>url:https://docs.oracle.com/javase/7/docs/api/java/text/SimpleDateFormat.html#number]][[url:https://docs.oracle.com/javase/7/docs/api/java/text/SimpleDateFormat.html#number]]|10
328 -|F|Day of week in month|[[Number>>url:https://docs.oracle.com/javase/7/docs/api/java/text/SimpleDateFormat.html#number]][[url:https://docs.oracle.com/javase/7/docs/api/java/text/SimpleDateFormat.html#number]]|2
329 -|E|Day name in week|[[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]]|Tuesday; Tue
313 +(% style="width:896.294px" %)
314 +|(% style="width:133px" %)**Letter**|(% style="width:414px" %)**Date or Time Component**|(% style="width:157px" %)**Presentation**|(% style="width:172px" %)**Examples**
315 +|(% style="width:133px" %)G|(% style="width:414px" %)Era designator|(% style="width:157px" %)Text|(% style="width:172px" %)AD
316 +|(% style="width:133px" %)yy|(% style="width:414px" %)Year short (upper case is Year of Week{{footnote}}yyyy represents the calendar year while YYYY represents the year of the week, which is only relevant for 53 week years{{/footnote}})|(% style="width:157px" %)Year|(% style="width:172px" %)96
317 +|(% style="width:133px" %)yyyy|(% style="width:414px" %)Year Full (upper case is Year of Week)|(% style="width:157px" %)Year|(% style="width:172px" %)1996
318 +|(% style="width:133px" %)MM|(% style="width:414px" %)Month number in year starting with 1|(% style="width:157px" %)Month|(% style="width:172px" %)07
319 +|(% style="width:133px" %)MMM|(% style="width:414px" %)Month name short|(% style="width:157px" %)Month|(% style="width:172px" %)Jul
320 +|(% style="width:133px" %)MMMM|(% style="width:414px" %)Month name full|(% style="width:157px" %)Month|(% style="width:172px" %)July
321 +|(% style="width:133px" %)ww|(% style="width:414px" %)Week in year|(% style="width:157px" %)Number|(% style="width:172px" %)27
322 +|(% style="width:133px" %)W|(% style="width:414px" %)Week in month|(% style="width:157px" %)Number|(% style="width:172px" %)2
323 +|(% style="width:133px" %)DD|(% style="width:414px" %)Day in year|(% style="width:157px" %)Number|(% style="width:172px" %)189
324 +|(% style="width:133px" %)dd|(% style="width:414px" %)Day in month|(% style="width:157px" %)Number|(% style="width:172px" %)10
325 +|(% style="width:133px" %)F|(% style="width:414px" %)Day of week in month|(% style="width:157px" %)Number|(% style="width:172px" %)2
326 +|(% style="width:133px" %)E|(% style="width:414px" %)Day name in week|(% style="width:157px" %)Text|(% style="width:172px" %)Tuesday; Tue
327 +|(% style="width:132px" %)U|(% style="width:414px" %)Day number of week (1 = Monday, ..., 7 = Sunday)|(% style="width:157px" %)Number|(% style="width:217px" %)1
328 +|(% style="width:132px" %)HH|(% style="width:414px" %)Hour in day (0-23)|(% style="width:157px" %)Number|(% style="width:217px" %)0
329 +|(% style="width:132px" %)kk|(% style="width:414px" %)Hour in day (1-24)|(% style="width:157px" %)Number|(% style="width:217px" %)24
330 +|(% style="width:132px" %)KK|(% style="width:414px" %)Hour in am/pm (0-11)|(% style="width:157px" %)Number|(% style="width:217px" %)0
331 +|(% style="width:132px" %)hh|(% style="width:414px" %)Hour in am/pm (1-12)|(% style="width:157px" %)Number|(% style="width:217px" %)12
332 +|(% style="width:132px" %)mm|(% style="width:414px" %)Minute in hour|(% style="width:157px" %)Number|(% style="width:217px" %)30
333 +|(% style="width:132px" %)ss|(% style="width:414px" %)Second in minute|(% style="width:157px" %)Number|(% style="width:217px" %)55
334 +|(% style="width:132px" %)S|(% style="width:414px" %)Millisecond|(% style="width:157px" %)Number|(% style="width:217px" %)978
335 +|(% style="width:132px" %)n|(% style="width:414px" %)Number of periods, used after a SDMX Frequency Identifier such as M, Q, D (month, quarter, day)|(% style="width:157px" %)Number|(% style="width:217px" %)12
330 330  
331 -[[image:SDMX 3-0-0 SECTION 6 FINAL-1.0_en_59eee18f.gif||alt="Shape9" height="1" width="192"]]
332 -
333 -|U|Day number of week (1 = Monday, ..., 7 = Sunday)|[[Number>>url:https://docs.oracle.com/javase/7/docs/api/java/text/SimpleDateFormat.html#number]][[url:https://docs.oracle.com/javase/7/docs/api/java/text/SimpleDateFormat.html#number]]|1
334 -|HH|Hour in day (0-23)|[[Number>>url:https://docs.oracle.com/javase/7/docs/api/java/text/SimpleDateFormat.html#number]][[url:https://docs.oracle.com/javase/7/docs/api/java/text/SimpleDateFormat.html#number]]|0
335 -|kk|Hour in day (1-24)|[[Number>>url:https://docs.oracle.com/javase/7/docs/api/java/text/SimpleDateFormat.html#number]][[url:https://docs.oracle.com/javase/7/docs/api/java/text/SimpleDateFormat.html#number]]|24
336 -|KK|Hour in am/pm (0-11)|[[Number>>url:https://docs.oracle.com/javase/7/docs/api/java/text/SimpleDateFormat.html#number]][[url:https://docs.oracle.com/javase/7/docs/api/java/text/SimpleDateFormat.html#number]]|0
337 -|hh|Hour in am/pm (1-12)|[[Number>>url:https://docs.oracle.com/javase/7/docs/api/java/text/SimpleDateFormat.html#number]][[url:https://docs.oracle.com/javase/7/docs/api/java/text/SimpleDateFormat.html#number]]|12
338 -|mm|Minute in hour|[[Number>>url:https://docs.oracle.com/javase/7/docs/api/java/text/SimpleDateFormat.html#number]][[url:https://docs.oracle.com/javase/7/docs/api/java/text/SimpleDateFormat.html#number]]|30
339 -|ss|Second in minute|[[Number>>url:https://docs.oracle.com/javase/7/docs/api/java/text/SimpleDateFormat.html#number]][[url:https://docs.oracle.com/javase/7/docs/api/java/text/SimpleDateFormat.html#number]]|55
340 -|S|Millisecond|[[Number>>url:https://docs.oracle.com/javase/7/docs/api/java/text/SimpleDateFormat.html#number]][[url:https://docs.oracle.com/javase/7/docs/api/java/text/SimpleDateFormat.html#number]]|978
341 -|n|Number of periods, used after a SDMX Frequency Identifier such as M, Q, D (month, quarter, day)|[[Number>>url:https://docs.oracle.com/javase/7/docs/api/java/text/SimpleDateFormat.html#number]][[url:https://docs.oracle.com/javase/7/docs/api/java/text/SimpleDateFormat.html#number]]|12
342 -
343 343  The model is illustrated below:
344 344  
345 345  [[image:SDMX 3-0-0 SECTION 6 FINAL-1.0_en_295af259.jpg||height="265" width="477"]]
... ... @@ -360,17 +360,16 @@
360 360  * microsecond
361 361  * nanosecond
362 362  
363 -|Numerical datetime systems|Base|Period
364 -|(((
357 +(% style="width:573.294px" %)
358 +|(% style="width:276px" %)**Numerical datetime systems**|(% style="width:117px" %)**Base**|(% style="width:177px" %)**Period**
359 +|(% style="width:276px" %)(((
365 365  Epoch Time (UNIX)
366 -
367 367  Milliseconds since 01 Jan 1970
368 -)))|1970|millisecond
369 -|(((
362 +)))|(% style="width:117px" %)1970|(% style="width:177px" %)millisecond
363 +|(% style="width:276px" %)(((
370 370  Windows System Time
371 -
372 372  Milliseconds since 01 Jan 1601
373 -)))|1601|millisecond
366 +)))|(% style="width:117px" %)1601|(% style="width:177px" %)millisecond
374 374  
375 375  The example above illustrates numerical based datetime mapping rules for two commonly used time standards.
376 376  
... ... @@ -392,41 +392,34 @@
392 392  
393 393  The main use case is setting the value of Observation Attributes in the target dataset.
394 394  
395 -|Rule|Source|Target
396 -|1|(((
388 +(% style="width:786.294px" %)
389 +|(% style="width:92px" %)**Rule**|(% style="width:377px" %)**Source**|(% style="width:315px" %)**Target**
390 +|(% style="width:92px" %)1|(% style="width:377px" %)(((
397 397  If
398 -
399 399  INDICATOR=XULADS; and TIME_PERIOD=2007.
400 -)))|(((
393 +)))|(% style="width:315px" %)(((
401 401  Set
402 -
403 403  OBS_CONF=F
404 404  )))
405 -|2|(((
397 +|(% style="width:92px" %)2|(% style="width:377px" %)(((
406 406  If
407 -
408 408  INDICATOR=XULADS; and TIME_PERIOD=2008.
409 -)))|(((
400 +)))|(% style="width:315px" %)(((
410 410  Set
411 -
412 412  OBS_CONF=F
413 413  )))
414 -|3|(((
404 +|(% style="width:92px" %)3|(% style="width:377px" %)(((
415 415  If
416 -
417 417  INDICATOR=XULADS; and TIME_PERIOD=2009.
418 -)))|(((
407 +)))|(% style="width:315px" %)(((
419 419  Set
420 -
421 421  OBS_CONF=F
422 422  )))
423 -|4|(((
411 +|(% style="width:92px" %)4|(% style="width:377px" %)(((
424 424  If
425 -
426 426  INDICATOR=XULADS; and TIME_PERIOD=2010.
427 -)))|(((
414 +)))|(% style="width:315px" %)(((
428 428  Set
429 -
430 430  OBS_CONF=**C**
431 431  )))
432 432  
... ... @@ -440,27 +440,22 @@
440 440  
441 441  By specifying validity periods, the example from Section 13.8 can be re-written using two rules as follows:
442 442  
443 -|Rule|Source|Target
444 -|1|(((
429 +(% style="width:808.294px" %)
430 +|(% style="width:93px" %)**Rule**|(% style="width:385px" %)**Source**|(% style="width:328px" %)**Target**
431 +|(% style="width:93px" %)1|(% style="width:385px" %)(((
445 445  If
446 -
447 447  INDICATOR=XULADS.
448 -
449 449  Validity Period start period=2007 end period=2009
450 -)))|(((
435 +)))|(% style="width:328px" %)(((
451 451  Set
452 -
453 453  OBS_CONF=F
454 454  )))
455 -|2|(((
439 +|(% style="width:93px" %)2|(% style="width:385px" %)(((
456 456  If
457 -
458 458  INDICATOR=XULADS.
459 -
460 460  Validity Period start period=2010
461 -)))|(((
443 +)))|(% style="width:328px" %)(((
462 462  Set
463 -
464 464  OBS_CONF=F** **
465 465  )))
466 466  
... ... @@ -472,31 +472,8 @@
472 472  
473 473  === 13.10.1 Many to one mapping (N-1) ===
474 474  
475 -|Source|Map To
476 -|(((
477 -**FREQ**="A"
456 +[[image:1747377208446-496.png]]
478 478  
479 -ADJUSTMENT="N"
480 -
481 -**REF_AREA**="PL"
482 -
483 -**COUNTERPART_AREA**="W0"
484 -
485 -REF_SECTOR="S1"
486 -
487 -COUNTERPART_SECTOR="S1" ACCOUNTING_ENTRY="B"
488 -
489 -STO="B5G"
490 -)))|(((
491 -FREQ="A"
492 -
493 -REF_AREA="PL"
494 -
495 -COUNTERPART_AREA="W0"
496 -
497 -INDICATOR="IND_ABC"
498 -)))
499 -
500 500  The bold Dimensions map from source to target verbatim. The mapping simply specifies:
501 501  
502 502  FREQ => FREQ
... ... @@ -521,49 +521,43 @@
521 521  
522 522  The following representation mapping can be used to explicitly map each age to an output code.
523 523  
524 -:
525 -
526 526  (((
527 -|Source Input Free Text|Desired Output Code Id
528 -|0|A
529 -|1|A
530 -|2|A
531 -|3|B
532 -|4|B
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
533 533  )))
534 534  
535 -If this mapping takes advantage of regular expressions it can be expressed in two 3464 rules:
492 +If this mapping takes advantage of regular expressions it can be expressed in two rules:
536 536  
537 -[[image:SDMX 3-0-0 SECTION 6 FINAL-1.0_en_8c1afe2b.gif||alt="Shape10" height="1" width="302"]]
538 -
539 -__Regular Expression __Desired Output
540 -
541 -:
542 -
543 543  (((
544 -|[0-2]|A
545 -|[3-4]|B
495 +(% style="width:675.294px" %)
496 +|(% style="width:219px" %)(((
497 +**Regular Expression**
498 +)))|(% style="width:453px" %)**Desired Output**
499 +|(% style="width:219px" %)[0-2]|(% style="width:453px" %)A
500 +|(% style="width:219px" %)[3-4]|(% style="width:453px" %)B
501 +
502 +(% style="color:inherit; font-family:inherit; font-size:max(21px, min(23px, 17.4444px + 0.462963vw))" %)13.10.3 Observation Attributes for Time Period
546 546  )))
547 547  
548 -=== 13.10.3 Observation Attributes for Time Period ===
549 -
550 550  This use case is where a specific observation for a specific time period has an attribute 3468 value.
551 551  
552 -:
553 -
554 554  (((
555 -|Input INDICATOR|Input TIME_PERIOD|Output OBS_CONF
556 -|XULADS|2008|C
557 -|XULADS|2009|C
558 -|XULADS|2010|C
508 +(% style="width:689.294px" %)
509 +|(% style="width:220px" %)**Input INDICATOR**|(% style="width:223px" %)**Input TIME_PERIOD**|(% style="width:243px" %)**Output OBS_CONF**
510 +|(% style="width:220px" %)XULADS|(% style="width:223px" %)2008|(% style="width:243px" %)C
511 +|(% style="width:220px" %)XULADS|(% style="width:223px" %)2009|(% style="width:243px" %)C
512 +|(% style="width:220px" %)XULADS|(% style="width:223px" %)2010|(% style="width:243px" %)C
559 559  )))
560 560  
561 561  __Or using a validity period on the Representation Mapping__:
562 562  
563 -[[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 +Input INDICATOR Valid From/ Valid To Output OBS_CONF XULADS 2008/2010 C
564 564  
565 -XULADS 2008/2010 C
566 -
567 567  === 13.10.4 Time mapping ===
568 568  
569 569  This use case is to create a time period from an input that does not respect SDMXTime Formats.
... ... @@ -570,20 +570,15 @@
570 570  
571 571  The Component Mapping from SYS_TIME to TIME_PERIOD specifies itself as a time mapping with the following details:
572 572  
573 -:
574 -
575 575  (((
576 -|Source Value|Source Mapping|Target Frequency|Output
577 -|18/07/1981|dd/MM/yyyy|A|1981
526 +(% style="width:763.294px" %)
527 +|(% style="width:163px" %)**Source Value**|(% style="width:219px" %)**Source Mapping**|(% style="width:198px" %)**Target Frequency**|(% style="width:180px" %)**Output**
528 +|(% style="width:163px" %)18/07/1981|(% style="width:219px" %)dd/MM/yyyy|(% style="width:198px" %)A|(% style="width:180px" %)1981
578 578  )))
579 579  
580 580  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.
581 581  
582 -[[image:SDMX 3-0-0 SECTION 6 FINAL-1.0_en_dbe68698.gif||alt="Shape12" height="1" width="273"]]
583 583  
584 -:
585 -::
586 -
587 587  (((
588 588  |Source Value|Source Mapping|Target Frequency Output Dimension
589 589  
... ... @@ -607,7 +607,7 @@
607 607  
608 608  Dimension
609 609  
610 -[[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 + 1981 yyyy D – End of Period 1981-12-31
611 611  
612 612  When the start of year is April 1^^st^^ the Structure Map has YearStart=04-01:
613 613  
1747377208446-496.png
Author
... ... @@ -1,0 +1,1 @@
1 +XWiki.helena
Size
... ... @@ -1,0 +1,1 @@
1 +28.0 KB
Content