Fusion-CSV-Series - Revision history

Mnelson at 08:49, 29 September 2022

2022-09-29T08:49:48Z

Mnelson at 09:40, 24 June 2020

2020-06-24T09:40:50Z

Mnelson at 09:40, 24 June 2020

2020-06-24T09:40:35Z

Mnelson: Created page with "Category:SdmxDataFormat =Overview= The Fusion-CSV-Series Data format predated SDMX-CSV and is not an official SDMX format. The format displays each series in its own..."

2020-06-24T09:38:12Z

Created page with "Category:SdmxDataFormat =Overview= The Fusion-CSV-Series Data format predated SDMX-CSV and is not an official SDMX format. The format displays each series in its own..."

New page

[[Category:SdmxDataFormat]]

=Overview=
The Fusion-CSV-Series Data format predated [[SDMX-CSV]] and is not an official SDMX format. The format displays each series in its own column. The series is either shown in 'Short code' format 'D:BGN:EUR:SP00:A' where each part fo the short code is linked to a Dimension value. For example D:BGN:EUR would be decoded as 'D' in the Frequency Dimension = Daily, 'BGN' in the Currency Dimension is Bulgarian Lev, and EUR is Europe in the Country Dimension. An alternative view of the series is where each Dimension is decoded in its own Row. When the short code is decoded, series Attributes are included in the output. When the short code is not decoded, attributes are omitted.

[[File:Csv-series-decoded.png|thumb|CSV Series with Series Short Code Decoded]]

Fusion-CSV-Series can be used as an export format for the Fusion Registry, and an export format for the Fusion Edge Server and Fusion Data Browser. Fusion-CSV-Series can not be used as a data import format.

=Parameters=
The following URL parameters can be used in a RESTful query for Fusion-CSV-TS data.

* format = csv-series
* delimiter =comma | tab | semicolon | space (comma is default)
* labels = id | both (id is default)

Example
https://demo.metadatatechnology.com/FusionRegistry/ws/public/sdmxapi/rest/data/WB,GCI,1.0/GHA.GCI..?format=csv-series&labels=both&delimiter=tab

=Example Output=
An example query using the format request parameters, [[Data_Formats|HTTP Accept Headers]] can also be used to define the same format. 
https://demo.metadatatechnology.com/FusionRegistry/ws/public/sdmxapi/rest/data/WB,GCI,1.0/GHA.GCI..?format=csv-series&labels=both

An example dataset with IDs only, spaces have been added to this example to assist readability.
<pre>
Time Period, GHA:GCI:RANK:A, GHA:GCI:VALUE:A
2008, 102, 3.616139933
2009, 114, 3.448062477
2010, 114, 3.55568976
</pre>

The same dataset in Fusion-CSV with lables included. Note, labels columns are only included if the Dimension, Attribute, or Measure is Coded, if it is not, then only one column is output - this can be seen in the table below where both TIME_PERIOD and OBS_VALUE are only single columns.

<pre>
Reference Area, GHA:Ghana, GHA:Ghana,
Indicator, GCI:Global Competitiveness Index, GCI:Global Competitiveness Index
Sub Indicator, RANK:Rank, VALUE:Value
Frequency, A:Annual, A:Annual
Time Period, GHA:GCI:RANK:A, GHA:GCI:VALUE:A
2008, 102, 3.616139933
2009, 114, 3.448062477
2010, 114, 3.55568976
</pre>

← Older revision		Revision as of 08:49, 29 September 2022
Line 1:		Line 1:
		+	see [https://wiki.sdmxcloud.org/Category:SdmxDataFormat Data Formats]
	[[Category:SdmxDataFormat]]		[[Category:SdmxDataFormat]]
	=Overview=		=Overview=

@@ Line 1: / Line 1: @@
 [[Category:SdmxDataFormat]]
 =Overview=
 The Fusion-CSV-Series Data format predated [[SDMX-CSV]] and is not an official SDMX format.  The format displays each series in its own column.  The series is either shown in 'Short code' format 'D:BGN:EUR:SP00:A' where each part fo the short code is linked to a Dimension value.  For example D:BGN:EUR would be decoded as 'D' in the Frequency Dimension = Daily, 'BGN' in the Currency Dimension is Bulgarian Lev, and EUR is Europe in the Country Dimension.  An alternative view of the series is where each Dimension is decoded in its own Row.  When the short code is decoded, series Attributes are included in the output.  When the short code is not decoded, attributes are omitted.

@@ Line 4: / Line 4: @@
 The Fusion-CSV-Series Data format predated [[SDMX-CSV]] and is not an official SDMX format.  The format displays each series in its own column.  The series is either shown in 'Short code' format 'D:BGN:EUR:SP00:A' where each part fo the short code is linked to a Dimension value.  For example D:BGN:EUR would be decoded as 'D' in the Frequency Dimension = Daily, 'BGN' in the Currency Dimension is Bulgarian Lev, and EUR is Europe in the Country Dimension.  An alternative view of the series is where each Dimension is decoded in its own Row.  When the short code is decoded, series Attributes are included in the output.  When the short code is not decoded, attributes are omitted.
-[[File:Csv-series-decoded.png|thumb|CSV Series with Series Short Code Decoded]]
+[[File:Csv-series-decoded2.png|thumb|CSV Series with Series Short Code Decoded]]
 Fusion-CSV-Series can be used as an export format for the Fusion Registry, and an export format for the Fusion Edge Server and Fusion Data Browser.  Fusion-CSV-Series can not be used as a data import format.