Changes for page 13 Structure Mapping

Summary

• Page properties (1 modified, 0 added, 0 removed)
• Attachments (0 modified, 3 added, 0 removed)
  • 1750074822764-573.png
  • 1750074865924-797.png
  • 1750074994887-415.png

Details

Page properties

Content

...	...	@@ -280,86 +280,86 @@
280	280
281	281	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}} A list of commonly used locales can be found in the Java supported locales: https://www.oracle.com/java/technologies/javase/jdk8-jre8-suported-locales.html{{/footnote}}. An indicative list of examples is presented in the following table:
282	282
283		-|English (en)|Australia (AU)|en-AU
284		-|English (en)|Canada (CA)|en-CA
285		-|English (en)|United Kingdom (GB)|en-GB
286		-|English (en)|United States (US)|en-US
287		-|Estonian (et)|Estonia (EE)|et-EE
288		-|Finnish (fi)|Finland (FI)|fi-FI
289		-|French (fr)|Belgium (BE)|fr-BE
290		-|French (fr)|Canada (CA)|fr-CA
291		-|French (fr)|France (FR)|fr-FR
292		-|French (fr)|Luxembourg (LU)|fr-LU
293		-|French (fr)|Switzerland (CH)|fr-CH
294		-|German (de)|Austria (AT)|de-AT
295		-|German (de)|Germany (DE)|de-DE
296		-|German (de)|Luxembourg (LU)|de-LU
297		-|German (de)|Switzerland (CH)|de-CH
298		-|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]]
299		-|Greek (el)|Greece (GR)|el-GR
300		-|Hebrew (iw)|Israel (IL)|iw-IL
301		-|Hindi (hi)|India (IN)|hi-IN
302		-|Hungarian (hu)|Hungary (HU)|hu-HU
303		-|Icelandic (is)|Iceland (IS)|is-IS
304		-|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]]
305		-|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]]
306		-|Italian (it)|Italy (IT)|it-IT
	283	+(% style="width:604.294px" %)
	284	+|(% style="width:172px" %)English (en)|(% style="width:216px" %)Australia (AU)|(% style="width:213px" %)en-AU
	285	+|(% style="width:172px" %)English (en)|(% style="width:216px" %)Canada (CA)|(% style="width:213px" %)en-CA
	286	+|(% style="width:172px" %)English (en)|(% style="width:216px" %)United Kingdom (GB)|(% style="width:213px" %)en-GB
	287	+|(% style="width:172px" %)English (en)|(% style="width:216px" %)United States (US)|(% style="width:213px" %)en-US
	288	+|(% style="width:172px" %)Estonian (et)|(% style="width:216px" %)Estonia (EE)|(% style="width:213px" %)et-EE
	289	+|(% style="width:172px" %)Finnish (fi)|(% style="width:216px" %)Finland (FI)|(% style="width:213px" %)fi-FI
	290	+|(% style="width:172px" %)French (fr)|(% style="width:216px" %)Belgium (BE)|(% style="width:213px" %)fr-BE
	291	+|(% style="width:172px" %)French (fr)|(% style="width:216px" %)Canada (CA)|(% style="width:213px" %)fr-CA
	292	+|(% style="width:172px" %)French (fr)|(% style="width:216px" %)France (FR)|(% style="width:213px" %)fr-FR
	293	+|(% style="width:172px" %)French (fr)|(% style="width:216px" %)Luxembourg (LU)|(% style="width:213px" %)fr-LU
	294	+|(% style="width:172px" %)French (fr)|(% style="width:216px" %)Switzerland (CH)|(% style="width:213px" %)fr-CH
	295	+|(% style="width:172px" %)German (de)|(% style="width:216px" %)Austria (AT)|(% style="width:213px" %)de-AT
	296	+|(% style="width:172px" %)German (de)|(% style="width:216px" %)Germany (DE)|(% style="width:213px" %)de-DE
	297	+|(% style="width:172px" %)German (de)|(% style="width:216px" %)Luxembourg (LU)|(% style="width:213px" %)de-LU
	298	+|(% style="width:172px" %)German (de)|(% style="width:216px" %)Switzerland (CH)|(% style="width:213px" %)de-CH
	299	+|(% style="width:172px" %)Greek (el)|(% style="width:216px" %)Cyprus (CY)|(% style="width:213px" %)el-CY(*)
	300	+|(% style="width:172px" %)Greek (el)|(% style="width:216px" %)Greece (GR)|(% style="width:213px" %)el-GR
	301	+|(% style="width:172px" %)Hebrew (iw)|(% style="width:216px" %)Israel (IL)|(% style="width:213px" %)iw-IL
	302	+|(% style="width:172px" %)Hindi (hi)|(% style="width:216px" %)India (IN)|(% style="width:213px" %)hi-IN
	303	+|(% style="width:172px" %)Hungarian (hu)|(% style="width:216px" %)Hungary (HU)|(% style="width:213px" %)hu-HU
	304	+|(% style="width:172px" %)Icelandic (is)|(% style="width:216px" %)Iceland (IS)|(% style="width:213px" %)is-IS
	305	+|(% style="width:172px" %)Indonesian (in)|(% style="width:216px" %)Indonesia (ID)|(% style="width:213px" %)in-ID(*)
	306	+|(% style="width:172px" %)Irish (ga)|(% style="width:216px" %)Ireland (IE)|(% style="width:213px" %)ga-IE(*)
	307	+|(% style="width:172px" %)Italian (it)|(% style="width:216px" %)Italy (IT)|(% style="width:213px" %)it-IT
307	307
	309	+~* - [[https:~~/~~/www.oracle.com/java/technologies/javase/jdk8-jre8-suported-locales.html#cldrlocale>>https://www.oracle.com/java/technologies/javase/jdk8-jre8-suported-locales.html#cldrlocale]]
	310	+
308	308	Examples
309	309
310	310	22/06/1981 would be described as dd/MM/YYYY, with locale en-GB
311		-
312	312	2008-mars-12 would be described as YYYY-MMM-DD, with locale fr-FR
313		-
314	314	22 July 1981 would be described as dd MMMM YYYY, with locale en-US
315		-
316	316	22 Jul 1981 would be described as dd MMM YYYY
317		-
318	318	2010 D62 would be described as YYYYDnn (day 62 of the year 2010)
319	319
320	320	The following pattern letters are defined (all other characters from 'A' to 'Z' and from 'a' to 'z' are reserved):
321	321
322		-|Letter|Date or Time Component|Presentation|Examples
323		-|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
324		-|yy|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}})|[[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
325		-|yyyy|Year Full (upper case is Year of Week)|Year|1996
326		-|MM|Month number in year starting with 1|Month|07
327		-|MMM|Month name short|Month|Jul
328		-|MMMM|Month name full|Month|July
329		-|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
330		-|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
331		-|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
332		-|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
333		-|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
334		-|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
335		-|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
336		-|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
337		-|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
338		-|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
339		-|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
340		-|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
341		-|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
342		-|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
343		-|n|(((
	321	+(% style="width:850.294px" %)
	322	+|(% style="width:125px" %)**Letter**|(% style="width:385px" %)**Date or Time Component**|(% style="width:180px" %)**Presentation**|(% style="width:157px" %)**Examples**
	323	+|(% style="width:125px" %)G|(% style="width:385px" %)Era designator|(% style="width:180px" %)Text|(% style="width:157px" %)AD
	324	+|(% style="width:125px" %)yy|(% style="width:385px" %)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:180px" %)Year|(% style="width:157px" %)96
	325	+|(% style="width:125px" %)yyyy|(% style="width:385px" %)Year Full (upper case is Year of Week)|(% style="width:180px" %)Year|(% style="width:157px" %)1996
	326	+|(% style="width:125px" %)MM|(% style="width:385px" %)Month number in year starting with 1|(% style="width:180px" %)Month|(% style="width:157px" %)07
	327	+|(% style="width:125px" %)MMM|(% style="width:385px" %)Month name short|(% style="width:180px" %)Month|(% style="width:157px" %)Jul
	328	+|(% style="width:125px" %)MMMM|(% style="width:385px" %)Month name full|(% style="width:180px" %)Month|(% style="width:157px" %)July
	329	+|(% style="width:125px" %)ww|(% style="width:385px" %)Week in year|(% style="width:180px" %)Number|(% style="width:157px" %)27
	330	+|(% style="width:125px" %)W|(% style="width:385px" %)Week in month|(% style="width:180px" %)Number|(% style="width:157px" %)2
	331	+|(% style="width:125px" %)DD|(% style="width:385px" %)Day in year|(% style="width:180px" %)Number|(% style="width:157px" %)189
	332	+|(% style="width:125px" %)dd|(% style="width:385px" %)Day in month|(% style="width:180px" %)Number|(% style="width:157px" %)10
	333	+|(% style="width:125px" %)F|(% style="width:385px" %)Day of week in month|(% style="width:180px" %)Number|(% style="width:157px" %)2
	334	+|(% style="width:125px" %)E|(% style="width:385px" %)Day name in week|(% style="width:180px" %)Text|(% style="width:157px" %)Tuesday; Tue
	335	+|(% style="width:125px" %)U|(% style="width:385px" %)Day number of week (1 = Monday, ..., 7 = Sunday)|(% style="width:180px" %)Number|(% style="width:157px" %)1
	336	+|(% style="width:125px" %)HH|(% style="width:385px" %)Hour in day (0-23)|(% style="width:180px" %)Number|(% style="width:157px" %)0
	337	+|(% style="width:125px" %)kk|(% style="width:385px" %)Hour in day (1-24)|(% style="width:180px" %)Number|(% style="width:157px" %)24
	338	+|(% style="width:125px" %)KK|(% style="width:385px" %)Hour in am/pm (0-11)|(% style="width:180px" %)Number|(% style="width:157px" %)0
	339	+|(% style="width:125px" %)hh|(% style="width:385px" %)Hour in am/pm (1-12)|(% style="width:180px" %)Number|(% style="width:157px" %)12
	340	+|(% style="width:125px" %)mm|(% style="width:385px" %)Minute in hour|(% style="width:180px" %)Number|(% style="width:157px" %)30
	341	+|(% style="width:125px" %)ss|(% style="width:385px" %)Second in minute|(% style="width:180px" %)Number|(% style="width:157px" %)55
	342	+|(% style="width:125px" %)S|(% style="width:385px" %)Millisecond|(% style="width:180px" %)Number|(% style="width:157px" %)978
	343	+|(% style="width:125px" %)n|(% style="width:385px" %)(((
344	344	Number of periods, used after a SDMX
345		-
346	346	Frequency Identifier such as M, Q, D (month, quarter, day)
347		-)))|[[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
	346	+)))|(% style="width:180px" %)Number|(% style="width:157px" %)12
348	348
349	349	The model is illustrated below:
350	350
	350	+[[image:1750074822764-573.png]]
351	351
352		-
353	353	**Figure 24 showing the component map mapping the SOURCE_DATE Dimension to the TIME_PERIOD dimension with the additional information on the component map to describe the time format?**
354	354
	354	+[[image:1750074865924-797.png]]
355	355
	356	+(% class="wikigeneratedid" id="HFigure25showinganinputdateformat2CwhoseoutputfrequencyisderivedfromtheoutputvalueoftheFREQDimension" %)
	357	+**Figure 25 showing an input date format, whose output frequency is derived from the output value of the FREQ Dimension**
356	356
357		-==== Figure 25 showing an input date format, whose output frequency is derived from the output value of the FREQ Dimension ====
	359	+=== 13.7.2 Numerical based datetime ===
358	358
359		-=== 13.3.6 Numerical based datetime ===
	361	+Where the source datetime input is purely numerical, the mapping rules are defined by the **Base** as a valid [[SDMX>>doc:sdmx:Glossary.Statistical data and metadata exchange.WebHome]] [[Time Period>>doc:sdmx:Glossary.Time period.WebHome]], and the **Period** which must take one of the following enumerated values:
360	360
361		-Where the source datetime input is purely numerical, the mapping rules are defined by the **Base** as a valid SDMX Time Period, and the **Period** which must take one of the following enumerated values:
362		-
363	363	* day
364	364	* second
365	365	* millisecond
...	...	@@ -366,75 +366,63 @@
366	366	* microsecond
367	367	* nanosecond
368	368
369		-|Numerical datetime systems|Base|Period
370		-|(((
	369	+(% style="width:545.294px" %)
	370	+|(% style="width:268px" %)Numerical datetime systems|(% style="width:121px" %)Base|(% style="width:153px" %)Period
	371	+|(% style="width:268px" %)(((
371	371	Epoch Time (UNIX)
372		-
373	373	Milliseconds since 01 Jan 1970
374		-)))|1970|millisecond
375		-|(((
	374	+)))|(% style="width:121px" %)1970|(% style="width:153px" %)millisecond
	375	+|(% style="width:268px" %)(((
376	376	Windows System Time
377		-
378	378	Milliseconds since 01 Jan 1601
379		-)))|1601|millisecond
	378	+)))|(% style="width:121px" %)1601|(% style="width:153px" %)millisecond
380	380
381	381	The example above illustrates numerical based datetime mapping rules for two commonly used time standards.
382	382
383	383	The model is illustrated below:
384	384
385		-[[image:1750072341491-790.jpeg]]
	384	+[[image:1750074994887-415.png]]
386	386
387		-**Figure 26 showing the component map mapping the SOURCE_DATE Dimension to the**
	386	+**Figure 26 showing the component map mapping the SOURCE_DATE Dimension to the TIME_PERIOD Dimension with the additional information on the component map to describe the numerical datetime system in use **
388	388
389		-==== TIME_PERIOD Dimension with the additional information on the component map to describe the numerical datetime system in use ====
	388	+=== 13.7.3 Mapping more complex time inputs ===
390	390
391		-=== Mapping more complex time inputs ===
	390	+[[VTL>>doc:sdmx:Glossary.Validation and transformation language.WebHome]] should be used for more complex time inputs that cannot be interpreted using the pattern based on numerical methods.
392	392
393		-VTL should be used for more complex time inputs that cannot be interpreted using the pattern based on numerical methods.
	392	+== 13.8 Using TIME_PERIOD in mapping rules ==
394	394
395		-== Using TIME_PERIOD in mapping rules ==
	394	+The source TIME_PERIOD [[Dimension>>doc:sdmx:Glossary.Dimension.WebHome]] can be used in conjunction with other input [[Dimensions>>doc:sdmx:Glossary.Dimension.WebHome]] to create discrete mapping rules where the output is conditional on the [[time period>>doc:sdmx:Glossary.Time period.WebHome]] value.
396	396
397		-The source TIME_PERIOD Dimension can be used in conjunction with other input Dimensions to create discrete mapping rules where the output is conditional on the time period value.
	396	+The main use case is setting the value of Observation [[Attributes>>doc:sdmx:Glossary.Attribute.WebHome]] in the target [[dataset>>doc:sdmx:Glossary.Data set.WebHome]].
398	398
399		-The main use case is setting the value of Observation Attributes in the target dataset.
400		-
401		-|Rule|Source|Target
402		-|1|(((
	398	+(% style="width:709.294px" %)
	399	+|(% style="width:103px" %)**Rule**|(% style="width:405px" %)**Source**|(% style="width:198px" %)**Target**
	400	+|(% style="width:103px" %)1|(% style="width:405px" %)(((
403	403	If
404		-
405	405	INDICATOR=XULADS; and TIME_PERIOD=2007.
406		-)))|(((
407		-Set
408		-
409		-OBS_CONF=F
	403	+)))|(% style="width:198px" %)(((
	404	+Set OBS_CONF=F
410	410	)))
411		-|2|(((
	406	+|(% style="width:103px" %)2|(% style="width:405px" %)(((
412	412	If
413		-
414	414	INDICATOR=XULADS; and TIME_PERIOD=2008.
415		-)))|Set OBS_CONF=F
416		-|3|(((
	409	+)))|(% style="width:198px" %)Set OBS_CONF=F
	410	+|(% style="width:103px" %)3|(% style="width:405px" %)(((
417	417	If
418		-
419	419	INDICATOR=XULADS; and TIME_PERIOD=2009.
420		-)))|(((
421		-Set
422		-
423		-OBS_CONF=F
	413	+)))|(% style="width:198px" %)(((
	414	+Set OBS_CONF=F
424	424	)))
425		-|4|(((
	416	+|(% style="width:103px" %)4|(% style="width:405px" %)(((
426	426	If
427		-
428	428	INDICATOR=XULADS; and TIME_PERIOD=2010.
429		-)))|(((
430		-Set
431		-
432		-OBS_CONF=**C**
	419	+)))|(% style="width:198px" %)(((
	420	+Set OBS_CONF=**C**
433	433	)))
434	434
435		-In the example above, OBS_CONF is an Observation Attribute.
	423	+In the example above, OBS_CONF is an Observation [[Attribute>>doc:sdmx:Glossary.Attribute.WebHome]].
436	436
437		-== 13. Time span mapping rules using validity periods ==
	425	+== 13.9 Time span mapping rules using validity periods ==
438	438
439	439	Creating discrete mapping rules for each TIME_PERIOD is impractical where rules need to cover a specific span of time regardless of frequency, and for high-frequency data.
440	440
...	...	@@ -442,25 +442,22 @@
442	442
443	443	By specifying validity periods, the example from Section 13.8 can be re-written using two rules as follows:
444	444
445		-|Rule|Source|Target
446		-|1|(((
	433	+(% style="width:516.294px" %)
	434	+|(% style="width:74px" %)Rule|(% style="width:215px" %)Source|(% style="width:223px" %)Target
	435	+|(% style="width:74px" %)1|(% style="width:215px" %)(((
447	447	If
448		-
449	449	INDICATOR=XULADS.
450		-
451		-
452		-Validity Period start period=2007 end period=2009
453		-)))|Set OBS_CONF=F
454		-|2|(((
	438	+Validity Period
	439	+start period=2007
	440	+end period=2009
	441	+)))|(% style="width:223px" %)Set OBS_CONF=F
	442	+|(% style="width:74px" %)2|(% style="width:215px" %)(((
455	455	If
456		-
457	457	INDICATOR=XULADS.
458		-
459		-
460		-Validity Period start period=2010
461		-)))|(((
	445	+Validity Period
	446	+start period=2010
	447	+)))|(% style="width:223px" %)(((
462	462	Set
463		-
464	464	OBS_CONF=F
465	465	)))
466	466
...	...	@@ -468,70 +468,61 @@
468	468
469	469	In Rule 2, no end period is specified so remains in effect from the start of the period (2010-01-01T00:00:00) until the end of time. Any observations reporting data for the Indicator XULADS that fall into that time range will have an OBS_CONF value of C.
470	470
471		-== 13. Mapping examples ==
	456	+In Rule 2, no end period is specified so remains in effect from the start of the period (2010-01-01T00:00:00) until the end of time. Any observations reporting data for the Indicator XULADS that fall into that time range will have an OBS_CONF value of C.
472	472
473		-=== 13. Many to one mapping (N-1) ===
	458	+== 13.10 Mapping examples ==
474	474
475		-|Source|Map To
476		-|(((
477		-**FREQ**="A"
	460	+=== 13.10.1 Many to one mapping (N3513 -1) ===
478	478
	462	+(% style="width:542.294px" %)
	463	+|(% style="width:274px" %)**Source**|(% style="width:265px" %)**Map To**
	464	+|(% style="width:274px" %)(((
	465	+(% style="color:#8e44ad" %)**FREQ**="A"
479	479	ADJUSTMENT="N"
480		-
481	481	**REF_AREA**="PL"
482		-
483	483	**COUNTERPART_AREA**="W0"
484		-
485	485	REF_SECTOR="S1"
486		-
487	487	COUNTERPART_SECTOR="S1"
488		-
489	489	ACCOUNTING_ENTRY="B"
490		-
491	491	STO="B5G"
492		-)))|(((
493		-FREQ="A"
494		-
	473	+)))|(% style="width:265px" %)(((
	474	+(% style="color:#8e44ad" %)FREQ="A"
495	495	REF_AREA="PL"
496		-
497	497	COUNTERPART_AREA="W0"
498		-INDICATOR="IND_ABC"
	477	+INDICATOR="IND_ABC"(%%)
499	499
500	500	)))
501	501
502		-The bold Dimensions map from source to target verbatim. The mapping simply specifies:
	481	+The bold [[Dimensions>>doc:sdmx:Glossary.Dimension.WebHome]] (% style="color:#e74c3c" %)map(%%) from source to target verbatim. The mapping simply specifies:
503	503
504		-FREQ => FREQ
	483	+> FREQ => FREQ
	484	+> REF_AREA=> REF_AREA
	485	+> COUNTERPART_AREA=> COUNTERPART _AREA
505	505
506		-REF_AREA=> REF_AREA
	487	+No [[Representation>>doc:sdmx:Glossary.Representation.WebHome]] Mapping is required. The source value simply copies across unmodified.
507	507
508		-COUNTERPART_AREA=> COUNTERPART _AREA
	489	+The remaining [[Dimensions>>doc:sdmx:Glossary.Dimension.WebHome]] all (% style="color:#e74c3c" %)map(%%) to the Indicator [[Dimension>>doc:sdmx:Glossary.Dimension.WebHome]]. This is an example of many [[Dimensions>>doc:sdmx:Glossary.Dimension.WebHome]] mapping to one [[Dimension>>doc:sdmx:Glossary.Dimension.WebHome]]. In this case a [[Representation>>doc:sdmx:Glossary.Representation.WebHome]] Mapping is required, and the mapping first describes the input 'partial key' and how this (% style="color:#e74c3c" %)maps(%%) to the target indicator:
509	509
510		-No Representation Mapping is required. The source value simply copies across unmodified.
	491	+> N:S1:S1:B:B5G => IND_ABC
511	511
512		-The remaining Dimensions all map to the Indicator Dimension. This is an example of many Dimensions mapping to one Dimension. In this case a Representation Mapping is required, and the mapping first describes the input 'partial key' and how this maps to the target indicator:
	493	+Where the key sequence is based on the order specified in the (% style="color:#e74c3c" %)mapping(%%) (i.e [[ADJUSTMENT>>doc:sdmx:Glossary.Adjustment.WebHome]], REF_SECTOR, etc will result in the first value N being taken from [[ADJUSTMENT>>doc:sdmx:Glossary.Adjustment.WebHome]] as this was the first item in the source [[Dimension>>doc:sdmx:Glossary.Dimension.WebHome]] list.
513	513
514		-N:S1:S1:B:B5G => IND_ABC
	495	+**Note**: The key order is NOT based on the [[Dimension>>doc:sdmx:Glossary.Dimension.WebHome]] order of the [[DSD>>doc:sdmx:Glossary.Data structure definition.WebHome]], as the (% style="color:#e74c3c" %)mapping(%%) needs to be resilient to the [[DSD>>doc:sdmx:Glossary.Data structure definition.WebHome]] changing.
515	515
516		-Where the key sequence is based on the order specified in the mapping (i.e ADJUSTMENT, REF_SECTOR, etc will result in the first value N being taken from ADJUSTMENT as this was the first item in the source Dimension list.
	497	+=== 13.10.2 Mapping other data types to Code Id ===
517	517
518		-**Note**: The key order is NOT based on the Dimension order of the DSD, as the mapping needs to be resilient to the DSD changing.
	499	+In the case where the incoming data type is not a string and not a [[code>>doc:sdmx:Glossary.Code.WebHome]] identifier i.e. the source [[Dimension>>doc:sdmx:Glossary.Dimension.WebHome]] is of type Integer and the target is Codelist. This is supported by the RepresentationMap. The RepresentationMap source can reference a Codelist, Valuelist, or be free text, the free text can include regular expressions.
519	519
520		-1.
521		-11.
522		-111. Mapping other data types to Code Id
	501	+The following [[representation>>doc:sdmx:Glossary.Representation.WebHome]] (% style="color:#e74c3c" %)mapping(%%) can be used to explicitly (% style="color:#e74c3c" %)map(%%) each [[age>>doc:sdmx:Glossary.Age.WebHome]] to an output [[code>>doc:sdmx:Glossary.Code.WebHome]].
523	523
524		-In the case where the incoming data type is not a string and not a code identifier i.e. the source Dimension is of type Integer and the target is Codelist. This is supported by the RepresentationMap. The RepresentationMap source can reference a Codelist, Valuelist, or be free text, the free text can include regular expressions.
	503	+(% style="width:402.294px" %)
	504	+|(% style="width:188px" %)**Source Input Free Text**|(% style="width:211px" %)**Desired Output Code Id**
	505	+|(% style="width:188px" %)0|(% style="width:211px" %)A
	506	+|(% style="width:188px" %)1|(% style="width:211px" %)A
	507	+|(% style="width:188px" %)2|(% style="width:211px" %)A
	508	+|(% style="width:188px" %)3|(% style="width:211px" %)B
	509	+|(% style="width:188px" %)4|(% style="width:211px" %)B
525	525
526		-The following representation mapping can be used to explicitly map each age to an output code.
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
534		-
535	535	If this mapping takes advantage of regular expressions it can be expressed in two rules:
536	536
537	537

1750074822764-573.png

Author

...	...	@@ -1,0 +1,1 @@
	1	+xwiki:XWiki.helena

Size

...	...	@@ -1,0 +1,1 @@
	1	+25.1 KB

Content

1750074865924-797.png

Author

...	...	@@ -1,0 +1,1 @@
	1	+xwiki:XWiki.helena

Size

...	...	@@ -1,0 +1,1 @@
	1	+46.8 KB

Content

1750074994887-415.png

Author

...	...	@@ -1,0 +1,1 @@
	1	+xwiki:XWiki.helena

Size

...	...	@@ -1,0 +1,1 @@
	1	+12.4 KB

Content