Fusion-Excel-TS

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.

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 HTTP Accept Headers as opposed to using REST query parameters.

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