Difference between revisions of "Data Browser Export"

From Fusion Registry Wiki
Jump to navigation Jump to search
(Example)
(Options)
Line 92: Line 92:
  
 
Dimension at Observation - '''''to do'''''.
 
Dimension at Observation - '''''to do'''''.
 +
 +
===Example===

Revision as of 06:14, 21 October 2024

Overview

The Export facility is available in the Series List, the Table Chart and the Time Series chart.

Several Formats are available depending on the settings in the exportconfig.json file which defines which formats will be available and what parameters will be offered.

The options available also differ depending on the type of format selected and the structure of the Dataset selected.

You can read more about Export Configuration in this article.


Formats available:

  • CSV
  • SDMX
  • Excel Series
  • Excel Time Series
  • Excel Table
  • Refreshable Excel

Every format allows you to specify a period and observation number as described in this article.

Every format allows you to apply Calculations to the Export, you can read more about in this article.

Every format allows you to save the file or view the resulting query URL.

CSV

Options

FDB-Export-CSV.png


Note that in this example, the Data Structure does not include a Frequency Dimension. Fusion Data Browser will select an option, to change the option select one from the dropdown list.


Example

FDB-Export-csv-example.png


SDMX

Options

FDB-Export-SDMX.png


When you select type SDMX, you can include Attributes. Click on the dropdown and select which are to be included.

Note that in this example, the Data Structure does not include a Frequency Dimension. Fusion Data Browser will select an option, to change the option select one from the dropdown list.


Example

FDB-Export-sdmx-example.png


Excel Series

Options

FDB-Export-Excel-Series.png


Note that in this example, the Data Structure does not include a Frequency Dimension. Fusion Data Browser will select an option, to change the option select one from the dropdown list.


Example

FDB-Export-Excel-Series-example.png


Excel Time Series

Options

FDB-Export-Excel-Time-Series.png


Note that in this example, the Data Structure does not include a Frequency Dimension. Fusion Data Browser will select an option, to change the option select one from the dropdown list.

This option allows you to select a Dimension for ‘Slicing’ purposes in which case a worksheet will be output per slice value, e.g slice by FREQ would output Annual Data in one worksheet, Monthly data in another, and so on.

Dimension at Observation - to do.

Example