Difference between revisions of "SDMX-ML Structure Specific Data"

From FMR Knowledge Base
Jump to navigation Jump to search
(Overview)
 
(3 intermediate revisions by 2 users not shown)
Line 1: Line 1:
[[Category:SdmxDataFormat]]
+
[[Category:FMR Formats Reference]]
 
=Overview=
 
=Overview=
 
The Structure Specific data format (formally known as Compact format) is an official SDMX format.  It is known as one of the SDMX-ML formats, in that it is SDMX whose representation is in [https://www.w3.org/XML/ XML].
 
The Structure Specific data format (formally known as Compact format) is an official SDMX format.  It is known as one of the SDMX-ML formats, in that it is SDMX whose representation is in [https://www.w3.org/XML/ XML].
  
Unlike the [[SDMX-ML_Generic_Data|SDMX-ML Generic data format]], the XML Elements and XML Attributes are the based on the [[Data_Structure_Definition|Data Structure Definition]] that the data is being transmitted for, this provides two main benefits:
+
Unlike the [[SDMX-ML_Generic_Data|SDMX-ML Generic data format]], the XML Elements and XML Attributes are the based on the Data Structure Definition that the data is being transmitted for, this provides two main benefits:
 
# It is possible to validate that the dataset is reporting the correct values using a SDMX Schema
 
# It is possible to validate that the dataset is reporting the correct values using a SDMX Schema
 
# The dataset is more compact, in terms of the volume of information used to transmit the dataset.
 
# The dataset is more compact, in terms of the volume of information used to transmit the dataset.
Line 9: Line 9:
 
The SDMX-ML Structure Specific format was introduced in version 1.0 of the SDMX Specification, and exists in all subsequent releases, up to the current release of version 2.1.  In releases prior to 2.1 the data format was called 'Compact' data.
 
The SDMX-ML Structure Specific format was introduced in version 1.0 of the SDMX Specification, and exists in all subsequent releases, up to the current release of version 2.1.  In releases prior to 2.1 the data format was called 'Compact' data.
  
SDMX-ML Structure Specific can be used as both an import and export format for the Fusion Registry, and an export format for the Fusion Edge Server and Fusion Data Browser.
+
SDMX-ML Structure Specific can be used as both an import and export format for the Fusion Metadata Registry, and an export format for the Fusion Edge Server and Fusion Data Browser.
 
 
=Formatting Using Query Parameters=
 
The following URL parameters can be used in a RESTful query for to get Generic data. 
 
* format = sdmx-compact-2.1
 
* format = sdmx-compact-2.0
 
* format = sdmx-compact-1.0
 
 
 
<strong>Example</strong>
 
<i>https://demo.metadatatechnology.com/FusionRegistry/ws/public/sdmxapi/rest/data/WB,GCI,1.0/GHA.GCI..?format=sdmx-compact-2.1</i>
 
 
 
<strong>Note:</strong> The same formatting can be applied using [[Data_Formats|HTTP Accept Headers]] as opposed to query parameters.
 
  
 
=Example Output=
 
=Example Output=

Latest revision as of 04:48, 25 August 2022

Overview

The Structure Specific data format (formally known as Compact format) is an official SDMX format. It is known as one of the SDMX-ML formats, in that it is SDMX whose representation is in XML.

Unlike the SDMX-ML Generic data format, the XML Elements and XML Attributes are the based on the Data Structure Definition that the data is being transmitted for, this provides two main benefits:

  1. It is possible to validate that the dataset is reporting the correct values using a SDMX Schema
  2. The dataset is more compact, in terms of the volume of information used to transmit the dataset.

The SDMX-ML Structure Specific format was introduced in version 1.0 of the SDMX Specification, and exists in all subsequent releases, up to the current release of version 2.1. In releases prior to 2.1 the data format was called 'Compact' data.

SDMX-ML Structure Specific can be used as both an import and export format for the Fusion Metadata Registry, and an export format for the Fusion Edge Server and Fusion Data Browser.

Example Output

https://demo.metadatatechnology.com/FusionRegistry/ws/public/sdmxapi/rest/data/WB,GCI,1.0/GHA.GCI..?format=sdmx-compact-2.1

The output below shows a snippet of the XML - displaying two series definition with their respective observation values

 		<Series REF_AREA="GHA" INDICATOR="GCI" SUB_INDICATOR="RANK" FREQ="A">
			<Obs TIME_PERIOD="2008" OBS_VALUE="102"/>
			<Obs TIME_PERIOD="2009" OBS_VALUE="114"/>
			<Obs TIME_PERIOD="2010" OBS_VALUE="114"/>
			<Obs TIME_PERIOD="2011" OBS_VALUE="114"/>
			<Obs TIME_PERIOD="2012" OBS_VALUE="103"/>
			<Obs TIME_PERIOD="2013" OBS_VALUE="114"/>
			<Obs TIME_PERIOD="2014" OBS_VALUE="111"/>
			<Obs TIME_PERIOD="2015" OBS_VALUE="119"/>
			<Obs TIME_PERIOD="2016" OBS_VALUE="114"/>
			<Obs TIME_PERIOD="2017" OBS_VALUE="111"/>
		</Series>
		<Series REF_AREA="GHA" INDICATOR="GCI" SUB_INDICATOR="VALUE" FREQ="A">
			<Obs TIME_PERIOD="2008" OBS_VALUE="3.616139933"/>
			<Obs TIME_PERIOD="2009" OBS_VALUE="3.448062477"/>
			<Obs TIME_PERIOD="2010" OBS_VALUE="3.55568976"/>
			<Obs TIME_PERIOD="2011" OBS_VALUE="3.64915433"/>
			<Obs TIME_PERIOD="2012" OBS_VALUE="3.792629136"/>
			<Obs TIME_PERIOD="2013" OBS_VALUE="3.693773108"/>
			<Obs TIME_PERIOD="2014" OBS_VALUE="3.713529283"/>
			<Obs TIME_PERIOD="2015" OBS_VALUE="3.582722052"/>
			<Obs TIME_PERIOD="2016" OBS_VALUE="3.679439434"/>
			<Obs TIME_PERIOD="2017" OBS_VALUE="3.72270246361418"/>
		</Series>
.....


An example dataset with the returned detail set to series keys only
https://demo.metadatatechnology.com/FusionRegistry/ws/public/sdmxapi/rest/data/WB,GCI,1.0/GHA.GCI..?format=sdmx-compact-2.1&detail=serieskeysonly

The output below shows a snippet of the XML - displaying the two series returned from the query

	<Series REF_AREA="GHA" INDICATOR="GCI" SUB_INDICATOR="RANK" FREQ="A" />
	<Series REF_AREA="GHA" INDICATOR="GCI" SUB_INDICATOR="VALUE" FREQ="A" />