Changes for page 13 Structure Mapping

Summary

• Page properties (1 modified, 0 added, 0 removed)

Details

Page properties

Content

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