Skip to Content
Last modified by Artur K. on 2026/05/29 14:28
From version 2.9
edited by Helena K.
on 2026/01/27 13:45
Change comment: There is no comment for this version
To version 1.3
edited by Helena K.
on 2026/01/27 13:32
Change comment: There is no comment for this version

Summary

Details

Page properties
Content
... ... @@ -4,33 +4,33 @@
4 4  
5 5  = 1. Problem Statement =
6 6  
7 -Time transformation is defined as a time-related operation performed on a time series, solely involving observations of that time series. Examples of such time transformations are growth rates, cumulative sums over several periods and moving averages.
7 +Time transformation is defined as a time-related operation performed on a time series, solely involving observations of that time series. Examples of such time transformations are growth rates, cumulative sums over several periods and moving averages.
8 8  
9 -To express a time transformation, three elements are required: the type of transformation, the number of periods involved and the length of each period. Even though in theory you could express the base value and the transformation applied, it is much more practical, and in many cases sufficient in statistical data exchange, to transmit the time-transformed values themselves.
9 +To express a time transformation, three elements are required: the type of transformation, the number of periods involved and the length of each period. Even though in theory you could express the base value and the transformation applied, it is much more practical, and in many cases sufficient in statistical data exchange, to transmit the time-transformed values themselves.
10 10  
11 -The operation to be coded can be expressed generically as such: For value //V// the transformation //T// was applied over //P// periods with frequency //F//.
11 +The operation to be coded can be expressed generically as such: For value //V// the transformation //T// was applied over //P// periods with frequency //F//.
12 12  
13 13  Examples:
14 14  
15 -|(% style="width:501px" %)**Statement**|(% style="width:303px" %)**T**|(% style="width:472px" %)**P**|(% style="width:454px" %)**F**
16 -|(% style="width:501px" %)Quarter on quarter growth rate|(% style="width:303px" %)Growth rate|(% style="width:472px" %)2|(% style="width:454px" %)Q
17 -|(% style="width:501px" %)Contribution to growth over 1 year (quarterly data)|(% style="width:303px" %)Contribution to growth|(% style="width:472px" %)4|(% style="width:454px" %)Q
18 -|(% style="width:501px" %)Contribution to growth over 1 year (annual data)|(% style="width:303px" %)Contribution to growth|(% style="width:472px" %)1|(% style="width:454px" %)A
19 -|(% style="width:501px" %)3 months moving average|(% style="width:303px" %)Moving average|(% style="width:472px" %)3|(% style="width:454px" %)M
20 -|(% style="width:501px" %)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}}|(% style="width:303px" %)Index|(% style="width:472px" %)1|(% style="width:454px" %)A
15 +|Statement|T|P|F
16 +|Quarter on quarter growth rate|Growth rate|2|Q
17 +|Contribution to growth over 1 year (quarterly data)|Contribution to growth|4|Q
18 +|Contribution to growth over 1 year (annual data)|Contribution to growth|1|A
19 +|3 months moving average|Moving average|3|M
20 +|Annual index (reference year=100)[[~[1~]>>path:#_ftn1]]|Index|1|A
21 21  
22 22  This guideline describes two methods that may be used to code a time transformation:
23 23  
24 -1. A normalised, multi-concept approach that is described in section SDMX CONCEPTS FOR TIME TRANSFORMATIONS. The overall time span involved in the time transformation depends on the number of periods stated and the frequency of a series.
25 -1. A denormalised, compound concept approach that is described in section COMPOUND CODING FOR TIME TRANSFORMATIONS. The overall time span involved in the time transformation does not necessarily depend on the number of periods stated and the frequency of a series.
24 +1. A normalised, multi-concept approach that is described in section SDMX CONCEPTS FOR TIME TRANSFORMATIONS. The overall time span involved in the time transformation depends on the number of periods stated and the frequency of a series.
25 +1. A denormalised, compound concept approach that is described in section COMPOUND CODING FOR TIME TRANSFORMATIONS. The overall time span involved in the time transformation does not necessarily depend on the number of periods stated and the frequency of a series.
26 26  
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.
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{{footnote}}http://sdmx.org/{{/footnote}}).
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]]).
30 30  
31 31  = 2. SDMX Concepts for Time Transformations =
32 32  
33 -SDMX defines two cross domain concepts for the purpose of coding time transformations: Time transformation type (ID TIMETRANS_TYPE) and time transformation periods (ID TIMETRANS_PER). The concept TIMETRANS_TYPE is coded with a cross domain code list. The concept TIMETRANS_PER is coded with a coded list of integers.
33 +SDMX defines two cross domain concepts for the purpose of coding time transformations: Time transformation type (ID TIMETRANS_TYPE) and time transformation periods (ID TIMETRANS_PER). The concept TIMETRANS_TYPE is coded with a cross domain code list. The concept TIMETRANS_PER is coded with a coded list of integers.
34 34  
35 35  == 2.1 Time Transformation Type ==
36 36  
... ... @@ -37,26 +37,29 @@
37 37  Definition: This concept provides coded information about time-related transformation types of time series.
38 38  
39 39  **Concept ID: **The concept ID is TIMETRANS_TYPE.
40 +
40 40  **Code List Name**: Code list for Time Transformation Type.
42 +
41 41  **Code List ID:** CL_TIMETRANS_TYPE.
44 +
42 42  **Established international standard(s) used as input for the code list**: None.
43 43  
44 44  **Version**: 1.0, 15 September 2016
45 45  
46 -|**Recommended code value**|(% style="width:309px" %)Recommended code description|(% style="width:1262px" %)Annotation
47 -|**N**|(% style="width:309px" %)Non transformed|(% style="width:1262px" %)TIMETRANS_PER is always 1, since a non-transformed number covers by definition a single period
48 -|**A**|(% style="width:309px" %)Average|(% style="width:1262px" %)Moving average, i.e. an operation that preserves the frequency of the series
49 -|**C**|(% style="width:309px" %)Cumulated sum|(% style="width:1262px" %)
50 -|**D**|(% style="width:309px" %)Difference|(% style="width:1262px" %)
51 -|**DD**|(% style="width:309px" %)Difference, second order|(% style="width:1262px" %)A second order difference is the delta of deltas
52 -|**F**|(% style="width:309px" %)Growth rate, flow over stock|(% style="width:1262px" %)
53 -|**FC**|(% style="width:309px" %)Contribution to growth, flow over stock|(% style="width:1262px" %)
54 -|**G**|(% style="width:309px" %)Growth rate|(% style="width:1262px" %)
55 -|**GC**|(% style="width:309px" %)Contribution to growth|(% style="width:1262px" %)
56 -|**I**|(% style="width:309px" %)Index|(% style="width:1262px" %)In the usual case, the index is fixed to 100 for a specific reference period, in most cases a year. It is recommended that the DSD contains an additional attribute BASE_PER (type ObservationalTimePeriod), which specifies the reference period of the index. In special cases (e.g. National Accounts chain linking), the index is fixed to a value different to 100 in the reference year. In these cases the BASE_PER attribute is even more important.
57 -|**LA**|(% style="width:309px" %)Annualised levels|(% style="width:1262px" %)This relates to stock versus flow series. For example, many countries publish their Quarterly National Accounts (QNA) at quarterly level, which means that annual Gross Domestic Product (GDP) is the sum of the four quarters, whereas some countries publish their QNA at annual level (e.g. US), which means that annual GDP is the average of the four quarters. In order to present quarterly data in comparable levels across countries and to derive zone aggregates, quarterly data expressed at quarterly levels are “transformed” to annual levels (i.e. multiplied by four) and have this code.
58 -|**S**|(% style="width:309px" %)Shifted|(% style="width:1262px" %)The time series was moved back or forth in time. This may for instance be used when non-calendar year series are aligned to the calendar year using certain estimation formulas.
59 -|**_O**|(% style="width:309px" %)Other transformation|(% style="width:1262px" %)This code is taken from the guidelines on generic codes, specifying "Other". In that context it should be used if more complex transformations are applied. An explanation of the transformation or a transformation script should be given in a comment field.
49 +|**Recommended code value**|Recommended code description|Annotation
50 +|**N**|Non transformed|TIMETRANS_PER is always 1, since a non-transformed number covers by definition a single period
51 +|**A**|Average|Moving average, i.e. an operation that preserves the frequency of the series
52 +|**C**|Cumulated sum|
53 +|**D**|Difference|
54 +|**DD**|Difference, second order|A second order difference is the delta of  deltas
55 +|**F**|Growth rate, flow over stock|
56 +|**FC**|Contribution to growth, flow over stock|
57 +|**G**|Growth rate|
58 +|**GC**|Contribution to growth|
59 +|**I**|Index|In the usual case, the index is fixed to 100 for a specific reference period, in most cases a year. It is recommended that the DSD contains an additional attribute BASE_PER (type ObservationalTimePeriod), which specifies the reference period of the index. In special cases (e.g. National Accounts chain linking), the index is fixed to a value different to 100 in the reference year. In these cases the BASE_PER attribute is even more important.
60 +|**LA**|Annualised levels|This relates to stock versus flow series.  For example, many countries publish their Quarterly National Accounts (QNA) at quarterly level, which means that annual Gross Domestic Product (GDP) is the sum of the four quarters, whereas some countries publish their QNA at annual level (e.g. US), which means that annual GDP is the average of the four quarters. In order to present quarterly data in comparable levels across countries and to derive zone aggregates, quarterly data expressed at quarterly levels are “transformed” to annual levels (i.e. multiplied by four) and have this code.
61 +|**S**|Shifted|The time series was moved back or forth in time. This may for instance be used when non-calendar year series are aligned to the calendar year using certain estimation formulas.
62 +|**_O**|Other transformation|This code is taken from the guidelines on generic codes, specifying "Other". In that context it should be used if more complex transformations are applied. An explanation of the transformation or a transformation script should be given in a comment field.
60 60  
61 61  == 2.2 Time Transformation Periods ==
62 62  
... ... @@ -63,47 +63,65 @@
63 63  Definition: This concept provides information about the number of periods used for a time-related transformation of the time series.
64 64  
65 65  **Concept ID: **The concept ID is TIMETRANS_PER.
69 +
66 66  **Code List Name**: Code list for Time Transformation Periods.
71 +
67 67  **Code List ID:** CL_TIMETRANS_PER.
73 +
68 68  **Established international standard(s) used as input for the code list**: None.
69 69  
70 70  **Version**: 1.0, 15 September 2016
71 71  
72 -(% style="width:1172.96px" %)
73 -|(% style="width:320px" %)**Recommended code value**|(% style="width:408px" %)**Recommended
74 -code description**|(% style="width:442px" %)**Annotation**
75 -|(% style="width:320px" %)**1**|(% style="width:408px" %)One|(% style="width:442px" %)
76 -|(% style="width:320px" %)**2**|(% style="width:408px" %)Two|(% style="width:442px" %)
77 -|(% style="width:320px" %)**etc.**|(% style="width:408px" %)etc.|(% style="width:442px" %)
78 +|**Recommended code value**|**Recommended
79 +code description**|**Annotation**
80 +|**1**|One|
81 +|**2**|Two|
82 +|**etc.**|etc.|
78 78  
79 -== 2.3 Relation of transformation coding to transformation rules ==
84 +1.
85 +11. Relation of transformation coding to transformation rules
80 80  
81 -Transformation can also be expressed with transformation rules using a syntax such as the Validation and Transformation Language (VTL). Following the transformation graph model behind VTL, the transformation coding suggested in this guideline can be seen complementary with using transformation rules in VTL. The idea is that a coded non-transformed time series is transformed using a VTL rule and the result is then coded again with transformation codes for further data exchange. This principle is shown in the graph below:
87 +Transformation can also be expressed with transformation rules using a syntax such as the Validation and Transformation Language (VTL). Following the transformation graph model behind VTL, the transformation coding suggested in this guideline can be seen complementary with using transformation rules in VTL. The idea is that a coded non-transformed time series is transformed using a VTL rule and the result is then coded again with transformation codes for further data exchange. This principle is shown in the graph below:
82 82  
83 -[[image:1769510498202-796.png]]
84 84  
85 -Using the two concepts as suggested above for coding the type of transformation applied and the number of periods covered will additionally ensure that the parameters used for the formula are directly used in the coding of the resulting series. Thus no complex mapping is needed. The transformation applied is linked to the transformation type concept and the number of periods used for the calculation is linked to the transformation periods concept.
90 +|(((
91 +Level series
92 +)))
86 86  
94 +|(((
95 +Transformed series
96 +)))
97 +
98 +|(((
99 +Transformation rule
100 +
101 +(VTL)
102 +)))
103 +
104 +
105 +
106 +Using the two concepts as suggested above for coding the type of transformation applied and the number of periods covered will additionally ensure that the parameters used for the formula are directly used in the coding of the resulting series. Thus no complex mapping is needed. The transformation applied is linked to the transformation type concept and the number of periods used for the calculation is linked to the transformation periods concept.
107 +
87 87  **Example:**
88 88  
89 -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}}
110 +The formula for a simple annual growth rate can be expressed as follows:[[~[3~]>>path:#_ftn3]]
90 90  
91 -[[image:1769510529532-579.png]]
112 +//GT= VT-VT-PVT-P//[[image:file:///C:/Users/axyli/AppData/Local/Temp/msohtmlclip1/01/clip_image001.png]]
92 92  
93 -A growth rate over P years in year T is the difference between the current year value and the value P years ago related to the value P years ago; with G being the growth rate, V being the absolute value, T being the time (year) and P the number of periods.
114 +à A growth rate over P years in year T is the difference between the current year value and the value P years ago related to the value P years ago; with G being the growth rate, V being the absolute value, T being the time (year) and P the number of periods.
94 94  
95 -The growth rate formula can be expressed in VTL and linked to transformation type G. The year T is linked to the respective year in the time series and the parameter P is linked to the transformation period concept.
116 +The growth rate formula can be expressed in VTL and linked to transformation type G. The year T is linked to the respective year in the time series and the parameter P is linked to the transformation period concept.
96 96  
97 97  **Example:**
98 98  
99 -|(% style="width:427px" %)**Year à**|(% style="width:230px" %)**2010**|(% style="width:365px" %)**2011**|(% style="width:386px" %)**2012**|(% style="width:322px" %)**2013**
100 -|(% style="width:427px" %)**GDP Level**|(% style="width:230px" %)500|(% style="width:365px" %)505|(% style="width:386px" %)510|(% style="width:322px" %)505
101 -|(% style="width:427px" %)**Growth rate,
102 -period on period**|(% style="width:230px" %) |(% style="width:365px" %)0.0100|(% style="width:386px" %)0.0099|(% style="width:322px" %)-0.0098
103 -|(% style="width:427px" %)**Formula**|(% style="width:230px" %) |(% style="width:365px" %)[[image:1769510625588-573.png]]|(% style="width:386px" %)[[image:1769510654674-828.png]]|(% style="width:322px" %)[[image:1769510676535-250.png]]
104 -|(% style="width:427px" %)**Growth rate,
105 -over 2 periods**|(% style="width:230px" %) |(% style="width:365px" %) |(% style="width:386px" %)0.0200|(% style="width:322px" %)0.0000
106 -|(% style="width:427px" %)**Formula**|(% style="width:230px" %) |(% style="width:365px" %) |(% style="width:386px" %)[[image:1769510701118-480.png]]|(% style="width:322px" %)[[image:1769510718908-350.png]]
120 +|**Year à**|**2010**|**2011**|**2012**|**2013**
121 +|**GDP Level**|500|505|510|505
122 +|**Growth rate,
123 +period on period**| |0.0100|0.0099|-0.0098
124 +|**Formula**| |//GT= V2011-V2011-1V2011-1//[[image:file:///C:/Users/axyli/AppData/Local/Temp/msohtmlclip1/01/clip_image002.png]]|//GT= V2012-V2012-1V2012-1//[[image:file:///C:/Users/axyli/AppData/Local/Temp/msohtmlclip1/01/clip_image003.png]]|//GT= V2013-V2013-1V2013-1//[[image:file:///C:/Users/axyli/AppData/Local/Temp/msohtmlclip1/01/clip_image004.png]]
125 +|**Growth rate,
126 +over 2 periods**| | |0.0200|0.0000
127 +|**Formula**| | |//GT= V2012-V2012-2V2012-2//[[image:file:///C:/Users/axyli/AppData/Local/Temp/msohtmlclip1/01/clip_image005.png]]|//GT= V2013-V2013-2V2013-2//[[image:file:///C:/Users/axyli/AppData/Local/Temp/msohtmlclip1/01/clip_image006.png]]
107 107  
108 108  When looking at the formulas, you can see that the same parameters that are used to call a transformation service can be used to code the resulting series, which makes it very easy for data processing systems to ensure consistency between calculations and coding of results:
109 109  
... ... @@ -123,9 +123,10 @@
123 123  period on period**|0.0100
124 124  |**Formula**|//GT= V2011-V2011-1V2011-1//[[image:file:///C:/Users/axyli/AppData/Local/Temp/msohtmlclip1/01/clip_image007.png]]
125 125  
126 -This is especially useful when only transformed series should be exchanged and level series or transformations are not subject to exchange. An example could be GDP growth rates, where for early estimates often level series are still under embargo, whereas growth rates are publishable.
147 +This is especially useful when only transformed series should be exchanged and level series or transformations are not subject to exchange. An example could be GDP growth rates, where for early estimates often level series are still under embargo, whereas growth rates are publishable.
127 127  
128 -== 2.4 Recommendation ==
149 +1.
150 +11. Recommendation
129 129  
130 130  Where possible, it is recommended to use the above solution with the two concepts TIMETRANS_TYPE and TIMETRANS_PER to express time transformations because:
131 131  
... ... @@ -133,23 +133,23 @@
133 133  * it is possible to add extra concepts if required without introducing ambiguity;
134 134  * the coded transformations can be linked directly with transformation formulas.
135 135  
136 -= 3. Compound coding for time transformations =
158 +1. Compound coding for time transformations
159 +11. Known Limitations
137 137  
138 -== 3.1 Known Limitations ==
161 +The normalised approach as presented above does not support the definition of mixed-frequency time transformations – like monthly series of annual growth rates – since there is only a single frequency dimension available. This also means that when annual growth rates are expressed in a quarterly dataset, the time transformation period would need to be modified (i.e. when frequency changes from A to Q, the number of periods need to be quadrupled).
139 139  
140 -The normalised approach as presented above does not support the definition of mixed-frequency time transformations – like monthly series of annual growth rates – since there is only a single frequency dimension available. This also means that when annual growth rates are expressed in a quarterly dataset, the time transformation period would need to be modified (i.e. when frequency changes from A to Q, the number of periods need to be quadrupled).
141 -
142 142  A "transformation frequency" might be added to keep the normalised approach also for those cases.
143 143  
144 -It also does not allow to directly code complex transformations, like transforming already transformed series (like the period-on-period growth rate of a four-period cumulative sum). For that case it is recommended to use the generic code "_O - Other" to specific that another transformation has been applied and provide the explanation or the transformation script in a comment field.
165 +It also does not allow to directly code complex transformations, like transforming already transformed series (like the period-on-period growth rate of a four-period cumulative sum). For that case it is recommended to use the generic code "_O - Other" to specific that another transformation has been applied and provide the explanation or the transformation script in a comment field.
145 145  
146 -However, both of these use cases may lead to a quite complex data structures or issues if various different complex transformations should be coded. Thus an alternative solution is presented in chapter 3 for cases where these use cases need to be covered and additional concepts should not be added to the data structure.
167 +However, both of these use cases may lead to a quite complex data structures or issues if various different complex transformations should be coded. Thus an alternative solution is presented in chapter 3 for cases where these use cases need to be covered and additional concepts should not be added to the data structure.
147 147  
148 148  In case the mixed frequencies or complex transformations as outlined above are needed in a simpler way and normalisation does not need to be strictly enforced, a composite code list CL_TIMETRANS may be created.
149 149  
150 -The number of periods in the code follows the frequency of the series unless stated otherwise. Example: code G3Y refers to a three-year growth rate, irrespective of the series frequency. For complex transformations, the codes that would be used for the respective transformations can be concatenated and separated by an underscore{{footnote}}Example:
151 -G1_C4 Growth rate, period on period, over 4-period cumulated sum{{/footnote}}.
171 +The number of periods in the code follows the frequency of the series unless stated otherwise. Example: code G3Y refers to a three-year growth rate, irrespective of the series frequency. For complex transformations, the codes that would be used for the respective transformations can be concatenated and separated by an underscore[[~[4~]>>path:#_ftn4]].
152 152  
173 +
174 +
153 153  Example for composite CL_TIMETRANS:
154 154  
155 155  |**Recommended code value**|**Recommended
... ... @@ -177,7 +177,7 @@
177 177  |FO3|Contribution to growth rate, flow over stock, over 3 periods|
178 178  |FO4|Contribution to growth rate, flow over stock, over 4 periods|
179 179  |FO6|Contribution to growth rate, flow over stock, over 6 periods|
180 -|FO12|Contribution to growth rate, flow over stock, over 12 periods|
202 +|FO12|Contribution to growth rate, flow over stock, over 12  periods|
181 181  |FO16|Contribution to growth rate, flow over stock, over 16 periods|
182 182  |G2|Growth rate, over two periods|Period on period
183 183  |G3|Growth rate over 3 periods|
... ... @@ -188,10 +188,10 @@
188 188  |GR|Growth rate, over reference year|
189 189  |GO2|Contribution to growth rate, over 2 periods|Period on period
190 190  |GO3|Contribution to growth rate, over 3 periods|
191 -|GO4|Contribution to growth rate, over 4 periods|
213 +|GO4|Contribution to growth rate, over  4 periods|
192 192  |GO6|Contribution to growth rate, over 6 periods|
193 193  |GO12|Contribution to growth rate, over 12 periods|
194 -|LA|Annualised levels|This relates to stock versus flow series. For example, many countries publish their QNA at quarterly level, which means that annual GDP is the sum of the four quarters, whereas some countries publish their QNA at annual level (e.g. US), which means that annual GDP is the average of the four quarters. In order to present quarterly data in comparable levels across countries and to derive zone aggregates, quarterly data expressed at quarterly levels are “transformed” to annual levels (i.e. multiplied by four) and have this code.
216 +|LA|Annualised levels|This relates to stock versus flow series.  For example, many countries publish their QNA at quarterly level, which means that annual GDP is the sum of the four quarters, whereas some countries publish their QNA at annual level (e.g. US), which means that annual GDP is the average of the four quarters. In order to present quarterly data in comparable levels across countries and to derive zone aggregates, quarterly data expressed at quarterly levels are “transformed” to annual levels (i.e. multiplied by four) and have this code.
195 195  |G1Y|Growth rate, over 1 year|
196 196  |F1Y|Growth rate, flow over stock, over 1 year|
197 197  |D1Y|Difference, over 1 year|
... ... @@ -199,16 +199,16 @@
199 199  |G4Y|Growth rate, over 4 years|
200 200  |GC5Y|Compound growth rate, over 5 years|
201 201  |GC10Y|Compound growth rate, over 10 years|
202 -|GO1Y|Contribution to growth rate, over 1 year|
224 +|GO1Y|Contribution to growth rate, over 1 year        |
203 203  |C1Y|Cumulated sum, over 1 year|
204 204  
205 -The use of codes like G3Y introduces redundancy in the code list. G3Y equals G36 for monthly data, G12 for quarterly data and G3 for annual data. Thus introducing such extensions should be well justified by solid use cases and DSD guidelines should explain which of the two possibilities (GxY or Gx) are preferred and why. Machine-to-machine queries, formulas, validation rules or coding templates may require mappings between those possibilities, taking into account both the frequency of a series and the transformation code.
227 +The use of codes like G3Y introduces redundancy in the code list. G3Y equals G36 for monthly data, G12 for quarterly data and G3 for annual data. Thus introducing such extensions should be well justified by solid use cases and DSD guidelines should explain which of the two possibilities (GxY or Gx) are preferred and why. Machine-to-machine queries, formulas, validation rules or coding templates may require mappings between those possibilities, taking into account both the frequency of a series and the transformation code.
206 206  
207 -= Annex: coded examples =
229 +1. Annex: coded examples
208 208  
209 209  The table below shows coding example using all 3 options lined out above.
210 210  
211 -|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
233 +|Statement|Normalised[[(% class="wikiinternallink" %)**~[5~]**>>path:#_ftn5]]|Type+Period|Type+Period+Freq
212 212  |Level series (non transformed data)|(((
213 213  FREQ=A or Q or M …
214 214  
... ... @@ -304,4 +304,16 @@
304 304  
305 305  ----
306 306  
307 -{{putFootnotes/}}
329 +[[~[1~]>>path:#_ftnref1]] 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).
330 +
331 +[[~[2~]>>path:#_ftnref2]] [[http:~~/~~/sdmx.org/>>url:http://sdmx.org/]]
332 +
333 +[[~[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.
334 +
335 +[[~[4~]>>path:#_ftnref4]] Example:
336 +
337 +|**G1_C4**|Growth rate, period on period, over 4-period cumulated sum
338 +
339 +
340 +
341 +[[~[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**.
1769510498202-796.png
Author
... ... @@ -1,1 +1,0 @@
1 -xwiki:XWiki.helena
Size
... ... @@ -1,1 +1,0 @@
1 -9.0 KB
Content
1769510529532-579.png
Author
... ... @@ -1,1 +1,0 @@
1 -xwiki:XWiki.helena
Size
... ... @@ -1,1 +1,0 @@
1 -1.8 KB
Content
1769510625588-573.png
Author
... ... @@ -1,1 +1,0 @@
1 -xwiki:XWiki.helena
Size
... ... @@ -1,1 +1,0 @@
1 -1.9 KB
Content
1769510654674-828.png
Author
... ... @@ -1,1 +1,0 @@
1 -xwiki:XWiki.helena
Size
... ... @@ -1,1 +1,0 @@
1 -1.9 KB
Content
1769510676535-250.png
Author
... ... @@ -1,1 +1,0 @@
1 -xwiki:XWiki.helena
Size
... ... @@ -1,1 +1,0 @@
1 -2.0 KB
Content
1769510701118-480.png
Author
... ... @@ -1,1 +1,0 @@
1 -xwiki:XWiki.helena
Size
... ... @@ -1,1 +1,0 @@
1 -1.8 KB
Content
1769510718908-350.png
Author
... ... @@ -1,1 +1,0 @@
1 -xwiki:XWiki.helena
Size
... ... @@ -1,1 +1,0 @@
1 -2.0 KB
Content
© Semantic R&D Group, 2026