Skip to Content

Changes for page 13 Structure Mapping

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

Summary

Details

Page properties
Content
... ... @@ -101,32 +101,20 @@
101 101  |(% style="width:240px" %)**Source**|(% style="width:246px" %)**Target**|(% style="width:329px" %)**Output Series Key**
102 102  |(% style="width:240px" %)SERIES_CODE=XMAN_Z_21|(% style="width:246px" %)(((
103 103  Dimensions
104 -
105 105  INDICATOR=XM
106 -
107 107  FREQ=A
108 -
109 109  ADJUSTMENT=N
110 -
111 111  Attributes
112 -
113 113  UNIT_MEASURE=_Z
114 -
115 115  COMP_ORG=21
116 116  )))|(% style="width:329px" %)XM:A:N
117 117  |(% style="width:240px" %)SERIES_CODE=XMAN_Z_34|(% style="width:246px" %)(((
118 118  Dimensions
119 -
120 120  INDICATOR=XM
121 -
122 122  FREQ=A
123 -
124 124  ADJUSTMENT=N
125 -
126 126  Attributes
127 -
128 128  UNIT_MEASURE=_Z
129 -
130 130  COMP_ORG=34
131 131  )))|(% style="width:329px" %)XM:A:N
132 132  
... ... @@ -144,24 +144,26 @@
144 144  
145 145  A Representation Map mapping ISO 2-character to ISO 3-character Codelists would take the following form:
146 146  
147 -|CL_ISO_ALPHA2|CL_ISO_ALPHA3
148 -|AF|AFG
149 -|AL|ALB
150 -|DZ|DZA
151 -|AS|ASM
152 -|AD|AND
153 -|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" %)
154 154  
155 155  A Representation Map mapping free text country names to an ISO 2-character Codelist could be similarly described:
156 156  
157 -|Text|CL_ISO_ALPHA2
158 -|"Germany"|DE
159 -|"France"|FR
160 -|"United Kingdom"|GB
161 -|"Great Britain"|GB
162 -|"Ireland"|IE
163 -|"Eire"|IE
164 -|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" %)
165 165  
166 166  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.
167 167  
... ... @@ -169,10 +169,11 @@
169 169  
170 170  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:
171 171  
172 -|Value|Locale|Name
173 -|$|en|United States Dollar
174 -|%|En|Percentage
175 -| |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
176 176  
177 177  Other characteristics of Representation Maps:
178 178  
... ... @@ -196,30 +196,31 @@
196 196  
197 197  Below is an example set of regular expression rules for a particular component.
198 198  
199 -|Regex|Description|Output
200 -|A|Rule match if input = 'A'|OUT_A
201 -|^[A-G]|Rule match if the input starts with letters A to G|OUT_B
202 -|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
203 203  
204 204  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.
205 205  
206 206  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
207 207  
208 -|Regex|Target output|Example Input|Example Output
209 -|(((
210 -([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
211 211  
212 -9]([0-9]{1})
213 -)))|\1-Q\2|200933|2009-Q3
214 -
215 215  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.
216 216  
217 217  The following example shows this:
218 218  
219 -|Priority|Regex|Description|Output
220 -|1|A|Rule match if input = 'A'|OUT_A
221 -|2|B|Rule match if input = 'B'|OUT_B
222 -|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
223 223  
224 224  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.
225 225  
... ... @@ -231,14 +231,16 @@
231 231  
232 232  For instance:
233 233  
234 -|Input String|Start|Length|Output
235 -|ABC_DEF_XYZ|5|3|DEF
236 -|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
237 237  
238 238  Sub-strings can therefore be used for the conceptual rule //If starts with 'XU' map to Y// as shown in the following example:
239 239  
240 -|Start|Length|Source|Target
241 -|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
242 242  
243 243  == 13.7 Mapping non-SDMX time formats to SDMX formats ==
244 244  
... ... @@ -250,15 +250,16 @@
250 250  
251 251  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:
252 252  
253 -|Frequency|Format|Example
254 -|A|YYYY|2010
255 -|D|YYYY-MM-DD|2010-01-01
256 -|I|YYYY-MM-DDThh:mm:ss|2010-01T20:22:00
257 -|M|YYYY-MM|2010-01
258 -|Q|YYYY-Qn|2010-Q1
259 -|S|YYYY-Sn|2010-S1
260 -|T|YYYY-Tn|2010-T1
261 -|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
262 262  
263 263  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.
264 264  
... ... @@ -271,36 +271,36 @@
271 271  
272 272  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.
273 273  
274 -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:
275 275  
276 -|English (en)|Australia (AU)|en-AU
277 -|English (en)|Canada (CA)|en-CA
278 -|English (en)|United Kingdom (GB)|en-GB
279 -|English (en)|United States (US)|en-US
280 -|Estonian (et)|Estonia (EE)|et-EE
281 -|Finnish (fi)|Finland (FI)|fi-FI
282 -|French (fr)|Belgium (BE)|fr-BE
283 -|French (fr)|Canada (CA)|fr-CA
284 -|French (fr)|France (FR)|fr-FR
285 -|French (fr)|Luxembourg (LU)|fr-LU
286 -|French (fr)|Switzerland (CH)|fr-CH
287 -|German (de)|Austria (AT)|de-AT
288 -|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
289 289  
290 -[[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
291 291  
292 -|German (de)|Luxembourg (LU)|de-LU
293 -|German (de)|Switzerland (CH)|de-CH
294 -|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]]
295 -|Greek (el)|Greece (GR)|el-GR
296 -|Hebrew (iw)|Israel (IL)|iw-IL
297 -|Hindi (hi)|India (IN)|hi-IN
298 -|Hungarian (hu)|Hungary (HU)|hu-HU
299 -|Icelandic (is)|Iceland (IS)|is-IS
300 -|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]]
301 -|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]]
302 -|Italian (it)|Italy (IT)|it-IT
303 -
304 304  Examples
305 305  
306 306  22/06/1981 would be described as dd/MM/YYYY, with locale en-GB
... ... @@ -315,32 +315,30 @@
315 315  
316 316  The following pattern letters are defined (all other characters from 'A' to 'Z' and from 'a' to 'z' are reserved):
317 317  
318 -|Letter|Date or Time Component|Presentation|Examples
319 -|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
320 -|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
321 -|yyyy|Year Full (upper case is Year of Week)|Year|1996
322 -|MM|Month number in year starting with 1|Month|07
323 -|MMM|Month name short|Month|Jul
324 -|MMMM|Month name full|Month|July
325 -|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
326 -|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
327 -|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
328 -|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
329 -|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
330 -|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
331 331  
332 -[[image:SDMX 3-0-0 SECTION 6 FINAL-1.0_en_59eee18f.gif||alt="Shape9" height="1" width="192"]]
333 -
334 -|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
335 -|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
336 -|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
337 -|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
338 -|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
339 -|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
340 -|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
341 -|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
342 -|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
343 -
344 344  The model is illustrated below:
345 345  
346 346  [[image:SDMX 3-0-0 SECTION 6 FINAL-1.0_en_295af259.jpg||height="265" width="477"]]
... ... @@ -361,17 +361,16 @@
361 361  * microsecond
362 362  * nanosecond
363 363  
364 -|Numerical datetime systems|Base|Period
365 -|(((
357 +(% style="width:573.294px" %)
358 +|(% style="width:276px" %)**Numerical datetime systems**|(% style="width:117px" %)**Base**|(% style="width:177px" %)**Period**
359 +|(% style="width:276px" %)(((
366 366  Epoch Time (UNIX)
367 -
368 368  Milliseconds since 01 Jan 1970
369 -)))|1970|millisecond
370 -|(((
362 +)))|(% style="width:117px" %)1970|(% style="width:177px" %)millisecond
363 +|(% style="width:276px" %)(((
371 371  Windows System Time
372 -
373 373  Milliseconds since 01 Jan 1601
374 -)))|1601|millisecond
366 +)))|(% style="width:117px" %)1601|(% style="width:177px" %)millisecond
375 375  
376 376  The example above illustrates numerical based datetime mapping rules for two commonly used time standards.
377 377  
... ... @@ -393,41 +393,34 @@
393 393  
394 394  The main use case is setting the value of Observation Attributes in the target dataset.
395 395  
396 -|Rule|Source|Target
397 -|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" %)(((
398 398  If
399 -
400 400  INDICATOR=XULADS; and TIME_PERIOD=2007.
401 -)))|(((
393 +)))|(% style="width:315px" %)(((
402 402  Set
403 -
404 404  OBS_CONF=F
405 405  )))
406 -|2|(((
397 +|(% style="width:92px" %)2|(% style="width:377px" %)(((
407 407  If
408 -
409 409  INDICATOR=XULADS; and TIME_PERIOD=2008.
410 -)))|(((
400 +)))|(% style="width:315px" %)(((
411 411  Set
412 -
413 413  OBS_CONF=F
414 414  )))
415 -|3|(((
404 +|(% style="width:92px" %)3|(% style="width:377px" %)(((
416 416  If
417 -
418 418  INDICATOR=XULADS; and TIME_PERIOD=2009.
419 -)))|(((
407 +)))|(% style="width:315px" %)(((
420 420  Set
421 -
422 422  OBS_CONF=F
423 423  )))
424 -|4|(((
411 +|(% style="width:92px" %)4|(% style="width:377px" %)(((
425 425  If
426 -
427 427  INDICATOR=XULADS; and TIME_PERIOD=2010.
428 -)))|(((
414 +)))|(% style="width:315px" %)(((
429 429  Set
430 -
431 431  OBS_CONF=**C**
432 432  )))
433 433  
... ... @@ -441,27 +441,22 @@
441 441  
442 442  By specifying validity periods, the example from Section 13.8 can be re-written using two rules as follows:
443 443  
444 -|Rule|Source|Target
445 -|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" %)(((
446 446  If
447 -
448 448  INDICATOR=XULADS.
449 -
450 450  Validity Period start period=2007 end period=2009
451 -)))|(((
435 +)))|(% style="width:328px" %)(((
452 452  Set
453 -
454 454  OBS_CONF=F
455 455  )))
456 -|2|(((
439 +|(% style="width:93px" %)2|(% style="width:385px" %)(((
457 457  If
458 -
459 459  INDICATOR=XULADS.
460 -
461 461  Validity Period start period=2010
462 -)))|(((
443 +)))|(% style="width:328px" %)(((
463 463  Set
464 -
465 465  OBS_CONF=F** **
466 466  )))
467 467  
... ... @@ -473,31 +473,8 @@
473 473  
474 474  === 13.10.1 Many to one mapping (N-1) ===
475 475  
476 -|Source|Map To
477 -|(((
478 -**FREQ**="A"
456 +[[image:1747377208446-496.png]]
479 479  
480 -ADJUSTMENT="N"
481 -
482 -**REF_AREA**="PL"
483 -
484 -**COUNTERPART_AREA**="W0"
485 -
486 -REF_SECTOR="S1"
487 -
488 -COUNTERPART_SECTOR="S1" ACCOUNTING_ENTRY="B"
489 -
490 -STO="B5G"
491 -)))|(((
492 -FREQ="A"
493 -
494 -REF_AREA="PL"
495 -
496 -COUNTERPART_AREA="W0"
497 -
498 -INDICATOR="IND_ABC"
499 -)))
500 -
501 501  The bold Dimensions map from source to target verbatim. The mapping simply specifies:
502 502  
503 503  FREQ => FREQ
... ... @@ -522,28 +522,24 @@
522 522  
523 523  The following representation mapping can be used to explicitly map each age to an output code.
524 524  
525 -:
526 -
527 527  (((
528 -|Source Input Free Text|Desired Output Code Id
529 -|0|A
530 -|1|A
531 -|2|A
532 -|3|B
533 -|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
534 534  )))
535 535  
536 536  If this mapping takes advantage of regular expressions it can be expressed in two 3464 rules:
537 537  
538 -[[image:SDMX 3-0-0 SECTION 6 FINAL-1.0_en_8c1afe2b.gif||alt="Shape10" height="1" width="302"]]
539 -
540 540  __Regular Expression __Desired Output
541 541  
542 -:
543 -
544 544  (((
545 -|[0-2]|A
546 -|[3-4]|B
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
547 547  )))
548 548  
549 549  === 13.10.3 Observation Attributes for Time Period ===
... ... @@ -550,21 +550,18 @@
550 550  
551 551  This use case is where a specific observation for a specific time period has an attribute 3468 value.
552 552  
553 -:
554 -
555 555  (((
556 -|Input INDICATOR|Input TIME_PERIOD|Output OBS_CONF
557 -|XULADS|2008|C
558 -|XULADS|2009|C
559 -|XULADS|2010|C
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
560 560  )))
561 561  
562 562  __Or using a validity period on the Representation Mapping__:
563 563  
564 -[[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
516 +Input INDICATOR Valid From/ Valid To Output OBS_CONF XULADS 2008/2010 C
565 565  
566 -XULADS 2008/2010 C
567 -
568 568  === 13.10.4 Time mapping ===
569 569  
570 570  This use case is to create a time period from an input that does not respect SDMXTime Formats.
... ... @@ -571,20 +571,15 @@
571 571  
572 572  The Component Mapping from SYS_TIME to TIME_PERIOD specifies itself as a time mapping with the following details:
573 573  
574 -:
575 -
576 576  (((
577 -|Source Value|Source Mapping|Target Frequency|Output
578 -|18/07/1981|dd/MM/yyyy|A|1981
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
579 579  )))
580 580  
581 581  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.
582 582  
583 -[[image:SDMX 3-0-0 SECTION 6 FINAL-1.0_en_dbe68698.gif||alt="Shape12" height="1" width="273"]]
584 584  
585 -:
586 -::
587 -
588 588  (((
589 589  |Source Value|Source Mapping|Target Frequency Output Dimension
590 590  
... ... @@ -608,7 +608,7 @@
608 608  
609 609  Dimension
610 610  
611 -[[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
556 + 1981 yyyy D – End of Period 1981-12-31
612 612  
613 613  When the start of year is April 1^^st^^ the Structure Map has YearStart=04-01:
614 614  
1747377208446-496.png
Author
... ... @@ -1,0 +1,1 @@
1 +XWiki.helena
Size
... ... @@ -1,0 +1,1 @@
1 +28.0 KB
Content