FusionXL FXLData - RETIRED - Revision history

Vmurrell at 11:09, 17 November 2025

2025-11-17T11:09:04Z

2021-09-08T13:00:12Z

Glenn moved page FusionXL FXLData to FusionXL FXLData - RETIRED without leaving a redirect: Replaced by new FXLData add-in

2021-04-19T17:33:50Z

‎Round Function

2021-04-19T17:32:28Z

2020-12-09T14:03:38Z

‎Series Identification

2020-12-09T13:59:57Z

‎Series Identification

2020-12-09T13:57:48Z

‎Include Series Key Column

2020-12-09T13:55:11Z

‎Label Function

2020-12-09T13:52:34Z

‎Dimension In Header Columns

2020-12-09T13:51:45Z

‎Dimension on Columns

← Older revision		Revision as of 11:09, 17 November 2025
Line 1:		Line 1:
		+	[[Category:RetiredFunctionality]]
	== Overview ==		== Overview ==
	The =FXLData() formula is used to retrieve specified series from the Fusion Registry to which FusionXL is currently connected directly into a worksheet.		The =FXLData() formula is used to retrieve specified series from the Fusion Registry to which FusionXL is currently connected directly into a worksheet.

← Older revision		Revision as of 17:33, 19 April 2021
Line 267:		Line 267:


−	[https://wiki.sdmxcloud.org/index.php?title=Main_Page~~&action=edit~~&section=11 Back to Main Page]	+	[https://wiki.sdmxcloud.org/index.php?title=Main_Page&section=11 Back to Main Page]

← Older revision		Revision as of 17:32, 19 April 2021
Line 265:		Line 265:

	'''Default Behaviour''' halfup		'''Default Behaviour''' halfup
		+
		+
		+	[https://wiki.sdmxcloud.org/index.php?title=Main_Page&action=edit&section=11 Back to Main Page]

@@ Line 101: / Line 101: @@
 == Series Identification ==
 [[File:FusionXL ShortCode.png|thumb|In the Fusion Data Browser the series identification is called the Short Code]]
 The series identification is the SDMX Series Key, for example '''D.RON.EUR.SP00.A'''.  This is the combination of Dimension values for each dimension, for example the series key is shown in BOLD in the following SDMX query.  Note it is also valid to include colon separators, for example '''D:RON:EUR:SP00:A'''

@@ Line 100: / Line 100: @@
 == Series Identification ==
 The series identification is the SDMX Series Key, for example '''D.RON.EUR.SP00.A'''.  This is the combination of Dimension values for each dimension, for example the series key is shown in BOLD in the following SDMX query.  Note it is also valid to include colon separators, for example '''D:RON:EUR:SP00:A'''
@@ Line 118: / Line 119: @@
 When the series key includes multiple series, the dataset will display as a row per series.  Take note when creating a selection zone in the worksheet.
 == Start Period and End Period ==

← Older revision	Revision as of 13:00, 8 September 2021
(No difference)

← Older revision		Revision as of 13:57, 9 December 2020
Line 124:		Line 124:

	== Include Series Key Column ==		== Include Series Key Column ==
		+	[[File:FusionXL SeriesColumn.png\|thumb\|Showing the series column - where each series identifier is a join of the dimension values (joined by colon)]]
	This can be useful if multiple series are being returned from a single FXLData request (i.e. the serie key contains wildcards or multiple selections). A column is added to the output which includes the series key for the data.		This can be useful if multiple series are being returned from a single FXLData request (i.e. the serie key contains wildcards or multiple selections). A column is added to the output which includes the series key for the data.

@@ Line 170: / Line 170: @@
 == Label Function ==
 This function is only relevant when the dimension breakdown is included.  The 3 valid values are:
 * id - output the ID of the dimension and reported value only
@@ Line 186: / Line 187: @@
 | A || Annual || DE || Germany || 19.4
 |}
 == Dimension In Header Columns ==

← Older revision		Revision as of 13:52, 9 December 2020
Line 189:		Line 189:

	== Dimension In Header Columns ==		== Dimension In Header Columns ==
		+	[[File:FusionXL DimAtObs.png\|thumb\|Showing geo in the header columns]]
	Specifies which Dimension values will be presented in the columns. The default value if not specified is TIME_PERIOD, which results with each row showing a series and the corresponding time periods make up the columns.		Specifies which Dimension values will be presented in the columns. The default value if not specified is TIME_PERIOD, which results with each row showing a series and the corresponding time periods make up the columns.

← Older revision		Revision as of 13:51, 9 December 2020
Line 188:		Line 188:


−	== Dimension on Columns ==	+	== Dimension In Header Columns ==
	Specifies which Dimension values will be presented in the columns. The default value if not specified is TIME_PERIOD, which results with each row showing a series and the corresponding time periods make up the columns.		Specifies which Dimension values will be presented in the columns. The default value if not specified is TIME_PERIOD, which results with each row showing a series and the corresponding time periods make up the columns.