Data Browser Export - Revision history

Vmurrell: /* Overview */

2024-10-30T10:22:38Z

‎Overview

Vmurrell at 13:22, 21 October 2024

2024-10-21T13:22:48Z

Vmurrell: /* Options */

2024-10-21T13:20:32Z

‎Options

Vmurrell: /* Example */

2024-10-21T13:20:10Z

‎Example

Vmurrell: /* Example */

2024-10-21T13:15:06Z

‎Example

Vmurrell: /* Options */

2024-10-21T13:14:13Z

‎Options

Vmurrell: /* Example */

2024-10-21T13:13:10Z

‎Example

Vmurrell: /* Example */

2024-10-21T13:11:22Z

‎Example

Vmurrell: /* Example */

2024-10-21T13:10:41Z

‎Example

Vmurrell: /* Options */

2024-10-21T13:09:15Z

‎Options

@@ Line 19: / Line 19: @@
 Every format allows you to specify a period and observation number as described [[Dataset_Period| in this article]].
-Every format allows you to apply Calculations to the Export, you can read more about [[Data_Browser_Calculations| in this article]].
+Every format allows you to apply Calculations to the Export, which you can read more about [[Data_Browser_Calculations| in this article]].
 Every format allows you to save the file or view the resulting query URL.

@@ Line 8: / Line 8: @@
 You can read more about Export Configuration [[Data_Browser_Configuration#Export_Configuration| in this article]].
 '''Formats available:'''
@@ Line 33: / Line 32: @@
 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===
+===Example CSV===
@@ Line 41: / Line 40: @@
 ==SDMX==
+===Options SDMX===
@@ Line 54: / Line 52: @@
-===Example===
+===Example SDMX===
@@ Line 62: / Line 60: @@
 ==Excel Series==
+===Options Excel Series===
@@ Line 72: / Line 69: @@
-===Example===
+===Example Excel Series===
@@ Line 80: / Line 77: @@
 ==Excel Time Series==
-===Options===
+===Options Excel Time Series===
@@ Line 92: / Line 89: @@
 Dimension at Observation - '''''to do'''''.
-===Example===
+===Example Excel Time Series===
@@ Line 100: / Line 97: @@
 ==Excel Table==
-===Options===
+===Options Excel Table===
@@ Line 115: / Line 112: @@
 ==Refreshable Excel==
-===Options===
+===Options Refreshable Excel===
@@ Line 126: / Line 123: @@
-===Example===
+===Example Refreshable Excel===
 In this example the query URL is https://demo11.metadatatechnology.com/FusionRegistry/sdmx/v2/data/dataflow/CD2030/CONSOLIDATED/1.0?c%5BREF_AREA%5D=ABW&data=&freqDim=DOMAIN&labels=both&locale=en&saveAs=CONSOLIDATED and produces this result.
 [[File:FDB-Export-Refreshable-example.png|800px]]

@@ Line 25: / Line 25: @@
 ==CSV==
-===Options===
+===Options CSV===
@@ Line 32: / Line 32: @@
 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===

← Older revision		Revision as of 13:20, 21 October 2024
Line 97:		Line 97:

	[[File:FDB-Export-Excel-Time-Series-example.png\|800px]]		[[File:FDB-Export-Excel-Time-Series-example.png\|800px]]
		+
		+
		+
		+	==Excel Table==
		+	===Options===
		+
		+
		+	[[File:FDB-Export-Excel-Tables.png\|600px]]
		+
		+
		+	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.
		+
		+
		+	[[File:FDB-Export-Excel-Table-example.png\|800px]]
		+
		+
		+	==Refreshable Excel==
		+	===Options===
		+
		+
		+	[[File:FDB-Export-Refreshable Excel.png\|600px]]
		+
		+
		+	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 creates a worksheet which will contain the query URL in Cell B1 and the FXLData query =FXLDataUrl in cell B2 together with the function which applies the function to the query URL. However for this to function you do need to have the Addin for FXLData installed. You can learn more about [[FXLData\|in this article]].
		+
		+
		+	===Example===
		+	In this example the query URL is https://demo11.metadatatechnology.com/FusionRegistry/sdmx/v2/data/dataflow/CD2030/CONSOLIDATED/1.0?c%5BREF_AREA%5D=ABW&data=&freqDim=DOMAIN&labels=both&locale=en&saveAs=CONSOLIDATED and produces this result.
		+
		+
		+	[[File:FDB-Export-Refreshable-example.png\|800px]]

← Older revision		Revision as of 13:15, 21 October 2024
Line 94:		Line 94:

	===Example===		===Example===
		+
		+
		+	[[File:FDB-Export-Excel-Time-Series-example.png\|800px]]

← Older revision		Revision as of 13:14, 21 October 2024
Line 92:		Line 92:

	Dimension at Observation - '''''to do'''''.		Dimension at Observation - '''''to do'''''.
		+
		+	===Example===

← Older revision		Revision as of 13:13, 21 October 2024
Line 77:		Line 77:

	[[File:FDB-Export-Excel-Series-example.png\|800px]]		[[File:FDB-Export-Excel-Series-example.png\|800px]]
		+
		+
		+	==Excel Time Series==
		+
		+	===Options===
		+
		+
		+	[[File:FDB-Export-Excel-Time-Series.png\|600px]]
		+
		+
		+	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'''''.

← Older revision		Revision as of 13:11, 21 October 2024
Line 76:		Line 76:


−	[[File:FDB-Export-Excel-Series-example.png.\|800px]]	+	[[File:FDB-Export-Excel-Series-example.png\|800px]]

← Older revision		Revision as of 13:10, 21 October 2024
Line 76:		Line 76:


−	[[File:FDB-Export-Excel~~-Time~~-Series-example.png\|800px]]	+	[[File:FDB-Export-Excel-Series-example.png.\|800px]]

← Older revision		Revision as of 13:09, 21 October 2024
Line 73:		Line 73:


−	===~~Options~~===	+	===Example===


	[[File:FDB-Export-Excel-Time-Series-example.png\|800px]]		[[File:FDB-Export-Excel-Time-Series-example.png\|800px]]