Difference between revisions of "Fusion-CSV-Series"
(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...") |
|||
| (2 intermediate revisions by the same user not shown) | |||
| Line 1: | Line 1: | ||
| + | see [https://wiki.sdmxcloud.org/Category:SdmxDataFormat Data Formats] | ||
[[Category:SdmxDataFormat]] | [[Category:SdmxDataFormat]] | ||
| − | |||
=Overview= | =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. | 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- | + | [[File:Csv-series-decoded2.png|thumb|CSV Series with Series Short Code Decoded]] |
| + | [[File:Csv-series.png|thumb|An example of CSV-Series showing short codes only]] | ||
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. | 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. | ||
Latest revision as of 00:49, 29 September 2022
see Data Formats
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.
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 Output
An example query using the format request parameters, 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.
Time Period, GHA:GCI:RANK:A, GHA:GCI:VALUE:A 2008, 102, 3.616139933 2009, 114, 3.448062477 2010, 114, 3.55568976
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.
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
