Overview FXLData - Revision history

Vmurrell: /* Data Wizard */

2026-06-15T13:49:25Z

‎Data Wizard

Vmurrell: /* FXLDataPeriod */

2026-06-15T13:48:12Z

‎FXLDataPeriod

Vmurrell: /* FXLDataLookup */

2026-06-15T13:47:40Z

‎FXLDataLookup

Vmurrell: /* Functions taking a Fusion Registry data query URL */

2026-06-15T13:44:51Z

‎Functions taking a Fusion Registry data query URL

Vmurrell: /* Data Wizard */

2025-08-13T08:39:01Z

‎Data Wizard

Vmurrell: /* Data Wizard */

2025-08-13T08:33:13Z

‎Data Wizard

Grahamcassidy at 14:17, 28 July 2025

2025-07-28T14:17:57Z

Grahamcassidy: /* Functions taking a Fusion Registry data query URL */

2025-07-28T14:14:49Z

‎Functions taking a Fusion Registry data query URL

Grahamcassidy: /* Parameterised functions */

2025-07-28T14:10:15Z

‎Parameterised functions

Grahamcassidy at 14:03, 28 July 2025

2025-07-28T14:03:03Z

← Older revision		Revision as of 13:49, 15 June 2026
Line 89:		Line 89:

	[[FXLData_Wizard \|Read more about the Data Wizard here. ]]		[[FXLData_Wizard \|Read more about the Data Wizard here. ]]
		+
		+	==Rest Arguments Builder ==
		+	Add link when article in place.

@@ Line 73: / Line 73: @@
 ===FXLDataPeriod ===
-Returns the minimum and/or maximum SDMX periods found on a specified root grid so lookups can use dataset bounds without manual date handling (with sheet‑not‑found error handling).
+Returns the minimum and/or maximum SDMX periods found on a specified root grid so lookups can use dataset bounds without manual date handling (with sheet‑not‑found error handling). [[FXLDataPeriod_Function| click here for more information. ]]
 ==Administrative functions==

@@ Line 69: / Line 69: @@
 ===FXLDataLookup ===
-Retrieves targeted measures directly from an existing root grid, returning a single value, short list, or small table. It also supports simple arithmetic, period wildcards, optional auto‑refresh, and explicit error messages.
+Retrieves targeted measures directly from an existing root grid, returning a single value, short list, or small table. It also supports simple arithmetic, period wildcards, optional auto‑refresh, and explicit error messages. [[FXLDataLookup_Function| click here for more information. ]]
 ===FXLDataPeriod ===

@@ Line 64: / Line 64: @@
   =FXLDataUrlV("<nowiki>https://demo.metadatatechnology.com/FusionRegistry/ws/public/sdmxapi/rest/data/ECB,EXR,1.0/A.CAD+HUF+INR...E?round=2&labels=id</nowiki>",1000)
   =FXLDataUrlFact("<nowiki>https://demo.metadatatechnology.com/FusionRegistry/ws/public/sdmxapi/rest/data/ECB,EXR,1.0/.CAD+MXN+MYR...</nowiki>",20)
 ==Administrative functions==

← Older revision		Revision as of 08:39, 13 August 2025
Line 77:		Line 77:

	[[File:Wizard Version R1.3.png\|Wizard - August 2025\|600px]]		[[File:Wizard Version R1.3.png\|Wizard - August 2025\|600px]]
−

	[[FXLData_Wizard \|Read more about the Data Wizard here. ]]		[[FXLData_Wizard \|Read more about the Data Wizard here. ]]

@@ Line 76: / Line 76: @@
 In addition to the Parameterised functions a Data Wizard, is available as an Excel Ribbon Tool for interactively building and editing FXLData functions and comes as part of the add-in.
-[[File:Wizard Version R1.0.png|Wizard - July 2004|600px]]
+[[File:Wizard Version R1.3.png|Wizard - August 2025|600px]]
 [[FXLData_Wizard |Read more about the Data Wizard here. ]]

@@ Line 44: / Line 44: @@
 Returns the selected resultset in 'horizontal' time-series format with one series per row<br/>
 * Behaves in the same way as =FXLData() but takes a single mandatory argument: a fully-formed Fusion Registry data query URL
-* A single optional argument allows the maximum number of series to be set
+* The optional MaxSeries argument allows the maximum number of series to be set
 <span style="color:red;>'''=FXLDataUrlV'''( ''Url , [MaxSeries] , [TimeFormatFrequencyId] '' )</span><br/>
 Returns the selected resultset in 'vertical' format with one series per column<br/>
 * Behaves in the same way as =FXLDataV() but takes a single mandatory argument: a fully-formed Fusion Registry data query URL
-* A single optional argument allows the maximum number of series to be set
+* The optional MaxSeries argument allows the maximum number of series to be set
 <span style="color:red;>'''=FXLDataUrlFact'''( ''Url , [MaxSeries] , [TimeFormatFrequencyId] '' )</span><br/>
 Returns the selected resultset as a [https://en.wikipedia.org/wiki/Fact_table data warehouse style fact table]<br/>
 * Takes a single mandatory argument: a fully-formed Fusion Registry data query URL
-* A single optional argument allows the maximum number of series to be set
+* The optional MaxSeries argument allows the maximum number of series to be set
 * Returns one row per observation including all series and observation attributes
 * Following the traditional fact table model, only dimension and attributes codes are returned - there is not option to return code labels

@@ Line 26: / Line 26: @@
 * If Labels=both, setting IncludeAttributes=TRUE will show the breakdown of series / dataset attributes in the header
 * IncludeHeader controls whether the resultset metrics are shown at the top (e.g. 205/1276 series   1.78 seconds)
 '''''Examples'''''

@@ Line 20: / Line 20: @@
 Returns a selected dataset in 'vertical' format with one series per column
 * Three mandatory arguments: the base URL of the Fusion Registry, the Dataflow, a Series Key pattern specifying what series to return
-* A further nine optional arguments can be specified including: maximum number of series to retrieve, start / end period, and whether dimensions, attributes and metrics are shown
+* A further eleven optional arguments can be specified including: maximum number of series to retrieve, start / end period, and whether dimensions, attributes and metrics are shown
 * IncludeSeriesKey is ignored
 * IncludeBreakdown is ignored