Changes for page Guidelines on coding time transformations in SDMX
Last modified by Artur K. on 2026/05/29 14:28
Summary
-
Page properties (1 modified, 0 added, 0 removed)
Details
- Page properties
-
- Content
-
... ... @@ -12,12 +12,12 @@ 12 12 13 13 Examples: 14 14 15 -|Statement|T|P|F 15 +|**Statement**|**T**|**P**|**F** 16 16 |Quarter on quarter growth rate|Growth rate|2|Q 17 17 |Contribution to growth over 1 year (quarterly data)|Contribution to growth|4|Q 18 18 |Contribution to growth over 1 year (annual data)|Contribution to growth|1|A 19 19 |3 months moving average|Moving average|3|M 20 -|Annual index (reference year=100) [[~[1~]>>path:#_ftn1]]|Index|1|A20 +|Annual index (reference year=100){{footnote}}Note that for the case of an index, it is useful to specify the reference base period in an additional attribute (see concept BASE_PER specified in the SDMX Glossary).{{/footnote}}|Index|1|A 21 21 22 22 This guideline describes two methods that may be used to code a time transformation: 23 23 ... ... @@ -26,7 +26,7 @@ 26 26 27 27 Both of these methods are included as separate use cases as served by each method. The aim of this document is to demonstrate that guidance and a standard approach is available and promoted for each use case. The use cases are described in the related sections. 28 28 29 -Further recommended code values for expressing general statistical concepts such as "not applicable", etc., can be found in section “Generic codes” of the "Guidelines for the creation and management of SDMX Cross-Domain Code Lists" (to be found under “Guidelines” on the official SDMX website [[~[2~]>>path:#_ftn2]]).29 +Further recommended code values for expressing general statistical concepts such as "not applicable", etc., can be found in section “Generic codes” of the "Guidelines for the creation and management of SDMX Cross-Domain Code Lists" (to be found under “Guidelines” on the official SDMX website{{footnote}}http://sdmx.org/{{/footnote}}). 30 30 31 31 = 2. SDMX Concepts for Time Transformations = 32 32 ... ... @@ -104,7 +104,7 @@ 104 104 105 105 **Example:** 106 106 107 -The formula for a simple annual growth rate can be expressed as follows: [[~[3~]>>path:#_ftn3]]107 +The formula for a simple annual growth rate can be expressed as follows:{{footnote}}Note: often growth rates are expressed as percentage growth, in which case the value is multiplied with 100%. This is however not relevant for this guideline and is left out for simplicity.{{/footnote}} 108 108 109 109 //GT= VT-VT-PVT-P//[[image:file:///C:/Users/axyli/AppData/Local/Temp/msohtmlclip1/01/clip_image001.png]] 110 110 ... ... @@ -225,7 +225,7 @@ 225 225 226 226 The table below shows coding example using all 3 options lined out above. 227 227 228 -|Statement|Normalised [[(%class="wikiinternallink"%)**~[5~]**>>path:#_ftn5]]|Type+Period|Type+Period+Freq228 +|Statement|Normalised{{footnote}}For sake of readability the prefix TIMETRANS_ was not put in the table. The concepts are in fact called TIMETRANS_TYPE and TIMETRANS_PER.{{/footnote}}|Type+Period|Type+Period+Freq 229 229 |Level series (non transformed data)|((( 230 230 FREQ=A or Q or M … 231 231 ... ... @@ -321,16 +321,12 @@ 321 321 322 322 ---- 323 323 324 - [[~[1~]>>path:#_ftnref1]] Note that for the case of an index, it is useful to specify the reference baseperiod in an additionalattribute(see concept BASE_PER specified in the SDMX Glossary).324 +Example: 325 325 326 -[[~[2~]>>path:#_ftnref2]] [[http:~~/~~/sdmx.org/>>url:http://sdmx.org/]] 327 - 328 -[[~[3~]>>path:#_ftnref3]] Note: often growth rates are expressed as percentage growth, in which case the value is multiplied with 100%. This is however not relevant for this guideline and is left out for simplicity. 329 - 330 -[[~[4~]>>path:#_ftnref4]] Example: 331 - 332 332 |**G1_C4**|Growth rate, period on period, over 4-period cumulated sum 333 333 334 334 335 335 336 -[[~[5~]>>path:#_ftnref5]] For sake of readability the prefix **TIMETRANS_ **was not put in the table. The concepts are in fact called **TIMETRANS_TYPE** and **TIMETRANS_PER**. 330 +[[~[5~]>>path:#_ftnref5]] 331 + 332 +{{putFootnotes/}}