Skip to Content
Last modified by Artur on 2025/09/10 11:19
From version 2.1
edited by Helena
on 2025/05/23 17:10
Change comment: There is no comment for this version
To version 2.2
edited by Helena
on 2025/05/27 13:31
Change comment: There is no comment for this version

Summary

Details

Page properties
Content
... ... @@ -48,7 +48,7 @@
48 48  
49 49  Once data have been aggregated from the micro-data (Step 5.7 of the GSBPM) they will be stored in some format such as a relational database or data warehouse (Oracle, etc.) or in some processing format (SAS, SPSS), or in Excel spreadsheets or similar format. This will depend on the internal system and tools used within the organization, and is different in different organizations.
50 50  
51 -In order to capture the aggregates in a standard [[SDMX>>doc:sdmx:Glossary.Statistical data and metadata exchange.WebHome]] format, we must first look at the required data structures as dictated by the collecting agency. In our example, we will use the Effective Exchange Rates data structure developed by the ECB^^[[(% class="wikiinternallink wikiinternallink wikiinternallink wikiinternallink wikiinternallink wikiinternallink wikiinternallink wikiinternallink" %)^^4^^>>path:#sdfootnote4sym||name="sdfootnote4anc"]](%%)^^. Below is an example of the type of data which is contained in a [[data set>>doc:sdmx:Glossary.Data set.WebHome]] structured according to this [[DSD>>doc:sdmx:Glossary.Data structure definition.WebHome]].
51 +In order to capture the aggregates in a standard [[SDMX>>doc:sdmx:Glossary.Statistical data and metadata exchange.WebHome]] format, we must first look at the required data structures as dictated by the collecting agency. In our example, we will use the Effective Exchange Rates data structure developed by the ECB^^[[(% class="wikiinternallink wikiinternallink wikiinternallink wikiinternallink wikiinternallink wikiinternallink wikiinternallink wikiinternallink wikiinternallink" %)^^4^^>>path:#sdfootnote4sym||name="sdfootnote4anc"]](%%)^^. Below is an example of the type of data which is contained in a [[data set>>doc:sdmx:Glossary.Data set.WebHome]] structured according to this [[DSD>>doc:sdmx:Glossary.Data structure definition.WebHome]].
52 52  
53 53  [[image:SDMX_2-1_User_Guide_draft_0-1_html_e5d197f835ebb755.jpg||data-xwiki-image-style-alignment="center" height="529" width="575"]]
54 54  
... ... @@ -73,7 +73,7 @@
73 73  
74 74  The view here shows a number of very important things:
75 75  
76 -The ID, Agency, and (% style="color:#e74c3c" %)version(%%) of the [[DSD>>doc:sdmx:Glossary.Data structure definition.WebHome]] are displayed at the top of the screen. Below this, there is a listing of statistical (% style="color:#e74c3c" %)concepts(%%) which are used as [[dimensions>>doc:sdmx:Glossary.Dimension.WebHome]]. (Frequency, [[Currency>>doc:sdmx:Glossary.Currency.WebHome]], Exchange Rate Type, etc.) Each of these (% style="color:#e74c3c" %)concepts(%%) will be taken from some authoritative source, and descriptions and definitions can be obtained from the organization which publishes and maintains the [[DSD>>doc:sdmx:Glossary.Data structure definition.WebHome]]. In many cases, these (% style="color:#e74c3c" %)concepts(%%) will be the standard (% style="color:#e74c3c" %)concepts(%%) defined in the [[SDMX>>doc:sdmx:Glossary.Statistical data and metadata exchange.WebHome]] Cross-Domain Statistical (% style="color:#e74c3c" %)Concepts(%%) document (which can be obtained at [[__www.__>>url:http://www.sdmx.org/]][[sdmx>>doc:sdmx:Glossary.Statistical data and metadata exchange.WebHome]].org[[)>>url:http://www.sdmx.org/]]. In other cases, they may be formally defined and documented by the maintaining agency which publishes the [[DSD>>doc:sdmx:Glossary.Data structure definition.WebHome]]. It is important to understand the definition of these (% style="color:#e74c3c" %)concepts(%%), as they may be slightly different from those used by the NSO or Central Bank, but in most cases they will likely be very similar or the same as the (% style="color:#e74c3c" %)concepts(%%) already used at the national (% style="color:#e74c3c" %)level(%%) for this data.
76 +The ID, Agency, and (% style="color:#e74c3c" %)version(%%) of the [[DSD>>doc:sdmx:Glossary.Data structure definition.WebHome]] are displayed at the top of the screen. Below this, there is a listing of statistical (% style="color:#e74c3c" %)concepts(%%) which are used as [[dimensions>>doc:sdmx:Glossary.Dimension.WebHome]]. (Frequency, [[Currency>>doc:sdmx:Glossary.Currency.WebHome]], Exchange Rate Type, etc.) Each of these (% style="color:#e74c3c" %)concepts(%%) will be taken from some authoritative source, and descriptions and definitions can be obtained from the organization which publishes and maintains the [[DSD>>doc:sdmx:Glossary.Data structure definition.WebHome]]. In many cases, these (% style="color:#e74c3c" %)concepts(%%) will be the standard (% style="color:#e74c3c" %)concepts(%%) defined in the [[SDMX>>doc:sdmx:Glossary.Statistical data and metadata exchange.WebHome]] Cross-Domain Statistical (% style="color:#e74c3c" %)Concepts(%%) document (which can be obtained at [[__www.__sdmx.org>>https://xwiki:www.sdmx.org]]). In other cases, they may be formally defined and documented by the maintaining agency which publishes the [[DSD>>doc:sdmx:Glossary.Data structure definition.WebHome]]. It is important to understand the definition of these (% style="color:#e74c3c" %)concepts(%%), as they may be slightly different from those used by the NSO or Central Bank, but in most cases they will likely be very similar or the same as the (% style="color:#e74c3c" %)concepts(%%) already used at the national (% style="color:#e74c3c" %)level(%%) for this data.
77 77  
78 78  The (% style="color:#e74c3c" %)concepts(%%) used as [[Dimensions>>doc:sdmx:Glossary.Dimension.WebHome]] each take a value which has a standard [[representation>>doc:sdmx:Glossary.Representation.WebHome]]. In most cases, this [[representation>>doc:sdmx:Glossary.Representation.WebHome]] will be a codelist – a standard classification which must be used to identify and describe the observations. In the righthand part of the screen, we can see which codelist is used to represent each (% style="color:#e74c3c" %)concept(%%) used as a [[dimension>>doc:sdmx:Glossary.Dimension.WebHome]]. For example, the Frequency [[dimension>>doc:sdmx:Glossary.Dimension.WebHome]] uses a codelist called “CL_FREQ” (% style="color:#e74c3c" %)version(%%) 1.0:
79 79