Mnelson at 08:12, 9 June 2022

2022-06-09T08:12:52Z

Mnelson: Created page with "Category:SdmxDataFormat =Overview= The Fusion-Excel-TS format is not an official SDMX format. It has a similar layout to the Fusion-CSV-TS format, in that the default..."

2020-08-10T08:36:03Z

Created page with "Category:SdmxDataFormat =Overview= The Fusion-Excel-TS format is not an official SDMX format. It has a similar layout to the Fusion-CSV-TS format, in that the default..."

New page

[[Category:SdmxDataFormat]]
=Overview=
The Fusion-Excel-TS format is not an official SDMX format. It has a similar layout to the [[Fusion-CSV-TS]] format, in that the default layout is a time series per row, a different Dimension can be selected other then TIME_PERIOD to present each series by, in the same way as the Fusion-CSV-TS format.

The advantages over CSV is that Excel provides a few additional features which are now possible in CSV, these are:
* The ability to slice the data over a Dimension to output a worksheet per Dimension value, e.g slice by FREQ would output Annual Data in one worksheet, Monthly data in another, and so on.
* The ability to promote fixed values to a header, or eliminating them from the output, if the values for the Dimension are the same for the entire worksheet
* Excel's freeze pane feature is used to make the inner table scrollable while keeping the column and row headers in place
* The use of colour to style the output, making the data easier to read

Fusion-Excel-TS is an '''export format only''', supported by Fusion Registry, Fusion Edge Server and Fusion Data Browser.

Fusion-Excel-TS became available from Fusion Registry v10.4.5 onwards

=Formatting Using Query Parameters=
The following URL parameters can be used in a RESTful query for to get data in Excel format.

{| class="wikitable"
|-
! Query Parameter !! Values !! Description
|-
| format || excel-ts || Required to output the dataset in fusion-excel-series format
|-
| dimensionAtObservation || [dimension id] default TIME_PEREIOD for time series data || Defines which dimension is iterated over on the rows
|-
| detail || '''full''' or '''dataonly''' default full|| Use '''dataonly''' to exclude series attributes from the output
|-
| slice || [dimension id] default to N/A || If provided, an Excel worksheet will be created for each distinct value in the dataset for this Dimension
|-
| labels || '''id''' or '''name''' or '''both''' (id is default)|| Output Ids or the corresponding name, or id and name
|-
| fixed || '''keep''' or '''promote''' or '''remove''' (promote is default) || Describes how to handle Dimension or Series Attribute values which are the same for the whole dataset.
* '''keep''' - keep the values in the header
* '''promote''' - remove the values from the header, promote them to a high level 'fixed values' table
* '''remove''' - do not ouput Dimension lables when they have a fixed value
|}

Note: The same formatting can be applied using [[Data_Formats|HTTP Accept Headers]] as opposed to using REST query parameters.

=Example=

← Older revision		Revision as of 08:12, 9 June 2022
Line 39:		Line 39:

	=Example=		=Example=
		+	'''Time Series'''
		+	https://demo.metadatatechnology.com/FusionRegistry/sdmx/v2/data/dataflow/ECB/EXR/1.0/?c%5BFREQ%5D=A&c%5BCURRENCY%5D=ARS,AUD,BGN&format=excel-ts
		+
		+	'''Time in Rows - Currency in Columns'''
		+	https://demo.metadatatechnology.com/FusionRegistry/sdmx/v2/data/dataflow/ECB/EXR/1.0/?c%5BFREQ%5D=A&c%5BCURRENCY%5D=ARS,AUD,BGN&format=excel-ts&dimensionAtObservation=CURRENCY

Fusion-Excel-TS - Revision history

Mnelson at 08:12, 9 June 2022

Mnelson: Created page with "Category:SdmxDataFormat =Overview= The Fusion-Excel-TS format is not an official SDMX format. It has a similar layout to the Fusion-CSV-TS format, in that the default..."