Fusion Registry Wiki - User contributions [en]

Troubleshooting - FXLData

2026-08-10T14:21:07Z

Vmurrell:

[[Category:How to and other features in FXLData]]
==The FXLData addin disappears or fails to load==
A possible cause is Windows file protection security settings blocking the FXLData.xlam file as it has originated from another computer. The following YouTube video explains how to solve the problem by disabling Windows protection on the file: https://www.youtube.com/watch?v=AhnOU-ulqNg

This article from microsoft also explains the process to unblock a macro:

https://support.microsoft.com/en-us/topic/a-potentially-dangerous-macro-has-been-blocked-0952faa0-37e7-4316-b61d-5b5ed6024216

== Unable to Retrieve Dataflows ==
If you are using version 11, R.1.0.00 or higher you may need to review your settings in Fusion Security Manager. If you are unsure how to do this, please create a support ticket.

==Data Point Deny rules failing to return results in Excel==
Include attributes in your formula.

[[File:Include-atts.png|500px]]

File:Include-atts.png

2026-08-10T14:20:29Z

Vmurrell:

Upgrading from Fusion Registry R1 series to Fusion Registry 2.0

2026-07-29T15:12:03Z

Vmurrell: Vmurrell moved page Upgrading from Fusion Registry R1 series to Fusion Registry 2.0FR1.2 to Upgrading from Fusion Registry R1 series to Fusion Registry 2.0 without leaving a redirect

[[Category:Updating_Fusion_Registry]]

Please refer to this article [[What%27s_new#August_2026_R2.0.0.00.]]

Upgrading from Fusion Registry R1 series to Fusion Registry 2.0

2026-07-29T15:11:37Z

Vmurrell: Vmurrell moved page Upgrading from FR R1 to FR1.2 to Upgrading from Fusion Registry R1 series to Fusion Registry 2.0FR1.2

[[Category:Updating_Fusion_Registry]]

Please refer to this article [[What%27s_new#August_2026_R2.0.0.00.]]

Upgrading from FR R1 to FR1.2

2026-07-29T15:11:37Z

Vmurrell: Vmurrell moved page Upgrading from FR R1 to FR1.2 to Upgrading from Fusion Registry R1 series to Fusion Registry 2.0FR1.2

#REDIRECT [[Upgrading from Fusion Registry R1 series to Fusion Registry 2.0FR1.2]]

Upgrading from Fusion Registry R1 series to Fusion Registry 2.0

2026-07-29T15:10:44Z

Vmurrell: Created page with "Category:Updating_Fusion_Registry Please refer to this article What%27s_new#August_2026_R2.0.0.00."

[[Category:Updating_Fusion_Registry]]

Please refer to this article [[What%27s_new#August_2026_R2.0.0.00.]]

What's new

2026-07-29T15:03:39Z

Vmurrell: /* August 2026 R2.0.0.00 */

=August 2026 R2.0.0.00=

===Migrating Regnology Fusion Statistics from Version 1.3 to Version 2.0 ===
Version 2.0 introduces significant changes.

This is a short guide for technical teams preparing to install or upgrade to the '''Spring Framework 7'''– based Fusion Registry.

For '''dependency detail''' and '''migration notes''', please open the attached PDF Document. [[File:Client-facing README.pdf]]

'''Fusion Registry — Client installation readiness (Spring 7)'''

== 1. What you must provide ==

{| class="wikitable"
|-
! Area !! Requirement
|-
| '''Java''' || '''JDK 17 or newer''' (LTS such as '''21''' recommended). JDK '''8''' and '''11''' are not sufficient for this release line.
|-
| '''Application server''' || A servlet container that implements '''Jakarta Servlet 6.1'''. '''Apache Tomcat 10+''' is the typical choice. '''Tomcat 9.x''' (and other servers stuck on <code>javax.*</code> / older Servlet APIs) must be upgraded or replaced before deployment.
|-
| '''JDBC drivers''' || Vendor JDBC drivers '''compatible with Java 17+''', matching your database major version. Align driver versions with your DBA — older drivers packaged for JDK 8 often cause runtime issues on newer JDKs.
|}

== 2. Tomcat upgrade (high level) ==

The Spring 7 stack uses the '''Jakarta EE 11/Servlet 6.1''' APIs (<code>jakarta.servlet.*</code>), rather than the legacy Java EE <code>javax.servlet.*</code>.

# Plan migration from '''Tomcat 9''' → '''Tomcat 10+''' (or another '''Servlet 6.1'''–certified server).
# Verify '''JVM options''' (<code>JAVA_HOME</code>, memory, encoding, timezone) on the new instance.
# Deploy only the '''new''' Registry WAR; do not mix '''old''' Spring 5 libraries on the shared Tomcat classpath.
# Re-test '''TLS''', '''reverse proxy''' (paths, headers, WebSockets if used), and '''JNDI''' datasource configuration if applicable.

== 3. Database connectors (JDBC) ==

Supported database platforms are those your contract and release notes specify (commonly '''MariaDB''', '''Oracle''', '''Microsoft SQL Server'''). For installation:

# '''Use a current JDBC driver''' from the database vendor, certified for '''JDK 17+''' and your '''supported''' database server version.
# Install the driver where your deployment model requires it ('''<code>$CATALINA_BASE/lib</code>''' for Tomcat-wide use, or follow your vendor runbook).
# '''Do not''' downgrade the driver to an old “JRE 8” artefact unless your support team explicitly approves it — classpath and TLS/cipher requirements often break on modern JDKs.
# Confirm '''connection URLs''', '''schemas''', '''collation/charset''', and '''pool sizing''' after the upgrade; Hibernate '''7.x''' / JPA '''3.2''' ride the same datasource configuration as in the technical brief.

== 4. Checklist — environment ready before installing the new Registry ==

Use this before first start in each environment (dev → test → prod).

=== Java and server ===

* ☐ '''JDK 17+''' installed; <code>java -version</code> matches the planned production JDK.
* ☐ '''Tomcat 10+''' (or equivalent '''Servlet 6.1''' server) installed and hardened (user, file permissions, logging).
* ☐ '''Tomcat service''' configured with sufficient '''heap''' and '''metaspace'''; garbage collector settings reviewed if you had custom tuning on JDK 8/11.
* ☐ '''File system''' paths for logs, temp, and Registry properties exist and are writable by the Tomcat user.

=== Database and JDBC ===

* ☐ '''Database version''' supported for this Registry release (confirm with release notes / your vendor).
* ☐ '''JDBC driver''' upgraded and tested against '''JDK 17+'''.
* ☐ '''Backup and restore''' procedure verified; a '''rollback''' snapshot exists before migration.
* ☐ '''Dedicated schema/user''' permissions unchanged or re-applied after any DBA maintenance.
* ☐ '''Character set / encoding''' aligned (e.g. UTF-8) end-to-end.

=== Security and networking ===

* ☐ '''TLS certificates''' valid on proxies and connectors; cipher suites acceptable to your security policy.
* ☐ '''Firewall''' rules allow app → DB, and clients → Registry as today.
* ☐ '''LDAP / SSO / OAuth''' (if used) endpoints and trust stores updated if URLs or certs changed during infra moves.

=== Application configuration ===

* ☐ '''<code>RegistryProperties</code>''' (or equivalent) points to the correct DB, LDAP, and paths for this environment.
* ☐ '''Secrets''' not embedded in old formats incompatible with the new image or systemd/tomcat layout.
* ☐ '''Smoke test plan''' agreed (login, structure browse, critical data/API flows).

=== Regression ===

* ☐ '''Staging''' run completed on JDK 17+ and Tomcat 10+ with production-like data volume where possible.
* ☐ '''Integration partners''' notified of cutover window if URLs or TLS fingerprints change.

== 5. After installation ==

* Monitor startup logs for '''<code>NoClassDefFoundError</code>''', '''<code>javax/</code>''' packages, or '''duplicate Spring/Hibernate''' JAR warnings (usually means classpath contamination).
* Keep the '''Spring 7 client brief''' (<code>docs/client-facing/README.md</code>) bookmarked for dependency versions (Spring '''7.0.x''', Spring Security '''7.0.x''', Hibernate '''7.2''', Jakarta Servlet '''6.1''', JPA '''3.2''').

=== Compatibility ===
Below is a summary of the component compatibility for each Fusion Registry version. The recommended version is R2.0.0.00.

[[File:R2 Compatability.png|400px]]

==May 2026 P1.3.1.00==

=== Compatibility ===
Below is a summary of the component compatibility for each Fusion Registry version. The recommended version is P1.3.1.00.

[[File:Compatability- May26-Patch.png|400px]]

===Upgrade Instructions===
The upgrade process for this release consists only of updating the relevant components.

No new installations or additional configurations are required since H1.3.0.03_RFS_30.01.26.

==March 2026 H1.3.0.04 ==

=== Compatibility ===

[[File:H1.04 - compatability.png|800px]]

==March 2026 H1.3.0.03==
[[FXLData - New Functions |Please refer to this article which details the new functions introduced in FXLData version H1.3.0.03.]]

=== Compatibility ===

The components that have changed since H1.3.0.02 are
* FXL Data
* and Fusion Data Browser.
Below is the complete list of Fusion Registry versions compatible with each other component for H1.3.0.03
{| class="wikitable"
|-
! Module !! Version (s)
|-
| FXL Data || H1.3.0.02, H1.3.0.03
|-
| Fusion Data Browser|| H1.3.0.02, H1.3.0.03
|-
| Fusion Security Manager|| H1.3.0.02, H1.3.0.03
|-
| Fusion Portal|| H1.3.0.02, H1.3.0.03
|-
| Fusion FAME Mapper|| H1.3.0.02, H1.3.0.03
|}

==August 2025 - R1.3.00==
[[FXLData_what%27s_new_in_R1.3%3F |Please refer to this article which summarises all the changes since the last main Release in January 2025 and the product specific change logs.]]

==July 4, 2025 - H1.2.04==
[[FXLData_Change_Log#H1.2.0.04_RFS_04.07.2025_.28Released_July_4.2C_2025.29 | Please see the change log for FXLData]]

==March 12, 2025 - H1.2.03==
[[Change_Log_FR_-_V11_and_subsequent_releases#H1.2.0.03_RFS_12.03.25_.28Released_March_12.2C_2025.29 | Please see the change log for Fusion Registry]]

[[File:RFS-ReleaseNotes-H1.2.0.03 RFS 12.03.25.pdf |Release Notes]]

==March 7, 2025 - H1.2.02==
[[FXLData_Change_Log| Please see the change log for FXLData]]

[[File:PDD - Enhanced Dataflow Selection Fusion Excel Data Wizard – English.pdf |Enhanced Dataflow selection in FXLData]]

==February 20, 2025 - H1.2.01==
[[Change_Log_FR_-_V11_and_subsequent_releases#H1.2.0.01_RFS_20.02.25_.28Released_February_20.2C_2025.29 | Please see the change log for Fusion Registry]]

[[FXLData_Change_Log| Please see the change log for FXLData]]

[[File:RFS-ReleaseNotes-H1.2.0.01 RFS 20.02.25 (1).pdf |Release Notes]]

==January 30, 2025 - R1.2.0==

[[Support for Multiple Measures| Support for Multiple Measures]] 

[[Web Services - GUI - Data| Web Services - GUI-Data - change to default SDMX version and ability to set a query period.]]

[[File:RFS-ReleaseNotes-R1.2.0.00 RFS 30.01.25.pdf |Release Notes]]

File:Client-facing README.pdf

2026-07-29T15:00:48Z

Vmurrell:

What's new

2026-07-29T12:26:18Z

Vmurrell: /* Migrating Regnology Fusion Statistics from Version 1.3 to Version 2.0 */

=August 2026 R2.0.0.00=

===Migrating Regnology Fusion Statistics from Version 1.3 to Version 2.0 ===
Version 2.0 introduces significant changes.

This is a short guide for technical teams preparing to install or upgrade to the '''Spring Framework 7'''– based Fusion Registry. For dependency detail and migration notes, see '''<code>docs/client-facing/README.md</code>''' (Spring 7 client technical brief). Click here to access a PDF version.[[File:RELEASE ENVIRONMENT UPGRADE.pdf| upgrade instructions to access a PDF version.]]

'''Fusion Registry — Client installation readiness (Spring 7)'''

== 1. What you must provide ==

{| class="wikitable"
|-
! Area !! Requirement
|-
| '''Java''' || '''JDK 17 or newer''' (LTS such as '''21''' recommended). JDK '''8''' and '''11''' are not sufficient for this release line.
|-
| '''Application server''' || A servlet container that implements '''Jakarta Servlet 6.1'''. '''Apache Tomcat 10+''' is the typical choice. '''Tomcat 9.x''' (and other servers stuck on <code>javax.*</code> / older Servlet APIs) must be upgraded or replaced before deployment.
|-
| '''JDBC drivers''' || Vendor JDBC drivers '''compatible with Java 17+''', matching your database major version. Align driver versions with your DBA — older drivers packaged for JDK 8 often cause runtime issues on newer JDKs.
|}

== 2. Tomcat upgrade (high level) ==

The Spring 7 stack uses the '''Jakarta EE 11/Servlet 6.1''' APIs (<code>jakarta.servlet.*</code>), rather than the legacy Java EE <code>javax.servlet.*</code>.

# Plan migration from '''Tomcat 9''' → '''Tomcat 10+''' (or another '''Servlet 6.1'''–certified server).
# Verify '''JVM options''' (<code>JAVA_HOME</code>, memory, encoding, timezone) on the new instance.
# Deploy only the '''new''' Registry WAR; do not mix '''old''' Spring 5 libraries on the shared Tomcat classpath.
# Re-test '''TLS''', '''reverse proxy''' (paths, headers, WebSockets if used), and '''JNDI''' datasource configuration if applicable.

== 3. Database connectors (JDBC) ==

Supported database platforms are those your contract and release notes specify (commonly '''MariaDB''', '''Oracle''', '''Microsoft SQL Server'''). For installation:

# '''Use a current JDBC driver''' from the database vendor, certified for '''JDK 17+''' and your '''supported''' database server version.
# Install the driver where your deployment model requires it ('''<code>$CATALINA_BASE/lib</code>''' for Tomcat-wide use, or follow your vendor runbook).
# '''Do not''' downgrade the driver to an old “JRE 8” artefact unless your support team explicitly approves it — classpath and TLS/cipher requirements often break on modern JDKs.
# Confirm '''connection URLs''', '''schemas''', '''collation/charset''', and '''pool sizing''' after the upgrade; Hibernate '''7.x''' / JPA '''3.2''' ride the same datasource configuration as in the technical brief.

== 4. Checklist — environment ready before installing the new Registry ==

Use this before first start in each environment (dev → test → prod).

=== Java and server ===

* ☐ '''JDK 17+''' installed; <code>java -version</code> matches the planned production JDK.
* ☐ '''Tomcat 10+''' (or equivalent '''Servlet 6.1''' server) installed and hardened (user, file permissions, logging).
* ☐ '''Tomcat service''' configured with sufficient '''heap''' and '''metaspace'''; garbage collector settings reviewed if you had custom tuning on JDK 8/11.
* ☐ '''File system''' paths for logs, temp, and Registry properties exist and are writable by the Tomcat user.

=== Database and JDBC ===

* ☐ '''Database version''' supported for this Registry release (confirm with release notes / your vendor).
* ☐ '''JDBC driver''' upgraded and tested against '''JDK 17+'''.
* ☐ '''Backup and restore''' procedure verified; a '''rollback''' snapshot exists before migration.
* ☐ '''Dedicated schema/user''' permissions unchanged or re-applied after any DBA maintenance.
* ☐ '''Character set / encoding''' aligned (e.g. UTF-8) end-to-end.

=== Security and networking ===

* ☐ '''TLS certificates''' valid on proxies and connectors; cipher suites acceptable to your security policy.
* ☐ '''Firewall''' rules allow app → DB, and clients → Registry as today.
* ☐ '''LDAP / SSO / OAuth''' (if used) endpoints and trust stores updated if URLs or certs changed during infra moves.

=== Application configuration ===

* ☐ '''<code>RegistryProperties</code>''' (or equivalent) points to the correct DB, LDAP, and paths for this environment.
* ☐ '''Secrets''' not embedded in old formats incompatible with the new image or systemd/tomcat layout.
* ☐ '''Smoke test plan''' agreed (login, structure browse, critical data/API flows).

=== Regression ===

* ☐ '''Staging''' run completed on JDK 17+ and Tomcat 10+ with production-like data volume where possible.
* ☐ '''Integration partners''' notified of cutover window if URLs or TLS fingerprints change.

== 5. After installation ==

* Monitor startup logs for '''<code>NoClassDefFoundError</code>''', '''<code>javax/</code>''' packages, or '''duplicate Spring/Hibernate''' JAR warnings (usually means classpath contamination).
* Keep the '''Spring 7 client brief''' (<code>docs/client-facing/README.md</code>) bookmarked for dependency versions (Spring '''7.0.x''', Spring Security '''7.0.x''', Hibernate '''7.2''', Jakarta Servlet '''6.1''', JPA '''3.2''').

=== Compatibility ===
Below is a summary of the component compatibility for each Fusion Registry version. The recommended version is R2.0.0.00.

[[File:R2 Compatability.png|400px]]

==May 2026 P1.3.1.00==

=== Compatibility ===
Below is a summary of the component compatibility for each Fusion Registry version. The recommended version is P1.3.1.00.

[[File:Compatability- May26-Patch.png|400px]]

===Upgrade Instructions===
The upgrade process for this release consists only of updating the relevant components.

No new installations or additional configurations are required since H1.3.0.03_RFS_30.01.26.

==March 2026 H1.3.0.04 ==

=== Compatibility ===

[[File:H1.04 - compatability.png|800px]]

==March 2026 H1.3.0.03==
[[FXLData - New Functions |Please refer to this article which details the new functions introduced in FXLData version H1.3.0.03.]]

=== Compatibility ===

The components that have changed since H1.3.0.02 are
* FXL Data
* and Fusion Data Browser.
Below is the complete list of Fusion Registry versions compatible with each other component for H1.3.0.03
{| class="wikitable"
|-
! Module !! Version (s)
|-
| FXL Data || H1.3.0.02, H1.3.0.03
|-
| Fusion Data Browser|| H1.3.0.02, H1.3.0.03
|-
| Fusion Security Manager|| H1.3.0.02, H1.3.0.03
|-
| Fusion Portal|| H1.3.0.02, H1.3.0.03
|-
| Fusion FAME Mapper|| H1.3.0.02, H1.3.0.03
|}

==August 2025 - R1.3.00==
[[FXLData_what%27s_new_in_R1.3%3F |Please refer to this article which summarises all the changes since the last main Release in January 2025 and the product specific change logs.]]

==July 4, 2025 - H1.2.04==
[[FXLData_Change_Log#H1.2.0.04_RFS_04.07.2025_.28Released_July_4.2C_2025.29 | Please see the change log for FXLData]]

==March 12, 2025 - H1.2.03==
[[Change_Log_FR_-_V11_and_subsequent_releases#H1.2.0.03_RFS_12.03.25_.28Released_March_12.2C_2025.29 | Please see the change log for Fusion Registry]]

[[File:RFS-ReleaseNotes-H1.2.0.03 RFS 12.03.25.pdf |Release Notes]]

==March 7, 2025 - H1.2.02==
[[FXLData_Change_Log| Please see the change log for FXLData]]

[[File:PDD - Enhanced Dataflow Selection Fusion Excel Data Wizard – English.pdf |Enhanced Dataflow selection in FXLData]]

==February 20, 2025 - H1.2.01==
[[Change_Log_FR_-_V11_and_subsequent_releases#H1.2.0.01_RFS_20.02.25_.28Released_February_20.2C_2025.29 | Please see the change log for Fusion Registry]]

[[FXLData_Change_Log| Please see the change log for FXLData]]

[[File:RFS-ReleaseNotes-H1.2.0.01 RFS 20.02.25 (1).pdf |Release Notes]]

==January 30, 2025 - R1.2.0==

[[Support for Multiple Measures| Support for Multiple Measures]] 

[[Web Services - GUI - Data| Web Services - GUI-Data - change to default SDMX version and ability to set a query period.]]

[[File:RFS-ReleaseNotes-R1.2.0.00 RFS 30.01.25.pdf |Release Notes]]

2026-07-29T11:42:15Z

Vmurrell: /* Fusion Registry — Client installation readiness (Spring 7) */

What's new

2026-07-29T11:35:05Z

Vmurrell: /* Upgrade Instructions */

=August 2026 R2.0.0.00=

===Upgrade Instructions===

= Fusion Registry — Client installation readiness (Spring 7) =

Short guide for technical teams preparing to install or upgrade to the '''Spring Framework 7'''–based Fusion Registry. For dependency detail and migration notes, see '''<code>docs/client-facing/README.md</code>''' (Spring 7 client technical brief).

----

== 1. What you must provide ==

=== Compatibility ===
Below is a summary of the component compatibility for each Fusion Registry version. The recommended version is R2.0.0.00.

[File:R2 Compatability.png|400px]]

==May 2026 P1.3.1.00==

=== Compatibility ===
Below is a summary of the component compatibility for each Fusion Registry version. The recommended version is P1.3.1.00.

[[File:Compatability- May26-Patch.png|400px]]

===Upgrade Instructions===
The upgrade process for this release consists only of updating the relevant components.

No new installations or additional configurations are required since H1.3.0.03_RFS_30.01.26.

==March 2026 H1.3.0.04 ==

=== Compatibility ===

[[File:H1.04 - compatability.png|800px]]

==March 2026 H1.3.0.03==
[[FXLData - New Functions |Please refer to this article which details the new functions introduced in FXLData version H1.3.0.03.]]

=== Compatibility ===

The components that have changed since H1.3.0.02 are
* FXL Data
* and Fusion Data Browser.
Below is the complete list of Fusion Registry versions compatible with each other component for H1.3.0.03
{| class="wikitable"
|-
! Module !! Version (s)
|-
| FXL Data || H1.3.0.02, H1.3.0.03
|-
| Fusion Data Browser|| H1.3.0.02, H1.3.0.03
|-
| Fusion Security Manager|| H1.3.0.02, H1.3.0.03
|-
| Fusion Portal|| H1.3.0.02, H1.3.0.03
|-
| Fusion FAME Mapper|| H1.3.0.02, H1.3.0.03
|}

==August 2025 - R1.3.00==
[[FXLData_what%27s_new_in_R1.3%3F |Please refer to this article which summarises all the changes since the last main Release in January 2025 and the product specific change logs.]]

==July 4, 2025 - H1.2.04==
[[FXLData_Change_Log#H1.2.0.04_RFS_04.07.2025_.28Released_July_4.2C_2025.29 | Please see the change log for FXLData]]

==March 12, 2025 - H1.2.03==
[[Change_Log_FR_-_V11_and_subsequent_releases#H1.2.0.03_RFS_12.03.25_.28Released_March_12.2C_2025.29 | Please see the change log for Fusion Registry]]

[[File:RFS-ReleaseNotes-H1.2.0.03 RFS 12.03.25.pdf |Release Notes]]

==March 7, 2025 - H1.2.02==
[[FXLData_Change_Log| Please see the change log for FXLData]]

[[File:PDD - Enhanced Dataflow Selection Fusion Excel Data Wizard – English.pdf |Enhanced Dataflow selection in FXLData]]

==February 20, 2025 - H1.2.01==
[[Change_Log_FR_-_V11_and_subsequent_releases#H1.2.0.01_RFS_20.02.25_.28Released_February_20.2C_2025.29 | Please see the change log for Fusion Registry]]

[[FXLData_Change_Log| Please see the change log for FXLData]]

[[File:RFS-ReleaseNotes-H1.2.0.01 RFS 20.02.25 (1).pdf |Release Notes]]

==January 30, 2025 - R1.2.0==

[[Support for Multiple Measures| Support for Multiple Measures]] 

[[Web Services - GUI - Data| Web Services - GUI-Data - change to default SDMX version and ability to set a query period.]]

[[File:RFS-ReleaseNotes-R1.2.0.00 RFS 30.01.25.pdf |Release Notes]]

What's new

2026-07-29T09:54:02Z

Vmurrell: /* August 2026 R2.0.0.00 */

=August 2026 R2.0.0.00=

===Upgrade Instructions===

Coming soon.

=== Compatibility ===
Below is a summary of the component compatibility for each Fusion Registry version. The recommended version is R2.0.0.00.

[File:R2 Compatability.png|400px]]

==May 2026 P1.3.1.00==

=== Compatibility ===
Below is a summary of the component compatibility for each Fusion Registry version. The recommended version is P1.3.1.00.

[[File:Compatability- May26-Patch.png|400px]]

===Upgrade Instructions===
The upgrade process for this release consists only of updating the relevant components.

No new installations or additional configurations are required since H1.3.0.03_RFS_30.01.26.

==March 2026 H1.3.0.04 ==

=== Compatibility ===

[[File:H1.04 - compatability.png|800px]]

==March 2026 H1.3.0.03==
[[FXLData - New Functions |Please refer to this article which details the new functions introduced in FXLData version H1.3.0.03.]]

=== Compatibility ===

The components that have changed since H1.3.0.02 are
* FXL Data
* and Fusion Data Browser.
Below is the complete list of Fusion Registry versions compatible with each other component for H1.3.0.03
{| class="wikitable"
|-
! Module !! Version (s)
|-
| FXL Data || H1.3.0.02, H1.3.0.03
|-
| Fusion Data Browser|| H1.3.0.02, H1.3.0.03
|-
| Fusion Security Manager|| H1.3.0.02, H1.3.0.03
|-
| Fusion Portal|| H1.3.0.02, H1.3.0.03
|-
| Fusion FAME Mapper|| H1.3.0.02, H1.3.0.03
|}

==August 2025 - R1.3.00==
[[FXLData_what%27s_new_in_R1.3%3F |Please refer to this article which summarises all the changes since the last main Release in January 2025 and the product specific change logs.]]

==July 4, 2025 - H1.2.04==
[[FXLData_Change_Log#H1.2.0.04_RFS_04.07.2025_.28Released_July_4.2C_2025.29 | Please see the change log for FXLData]]

==March 12, 2025 - H1.2.03==
[[Change_Log_FR_-_V11_and_subsequent_releases#H1.2.0.03_RFS_12.03.25_.28Released_March_12.2C_2025.29 | Please see the change log for Fusion Registry]]

[[File:RFS-ReleaseNotes-H1.2.0.03 RFS 12.03.25.pdf |Release Notes]]

==March 7, 2025 - H1.2.02==
[[FXLData_Change_Log| Please see the change log for FXLData]]

[[File:PDD - Enhanced Dataflow Selection Fusion Excel Data Wizard – English.pdf |Enhanced Dataflow selection in FXLData]]

==February 20, 2025 - H1.2.01==
[[Change_Log_FR_-_V11_and_subsequent_releases#H1.2.0.01_RFS_20.02.25_.28Released_February_20.2C_2025.29 | Please see the change log for Fusion Registry]]

[[FXLData_Change_Log| Please see the change log for FXLData]]

[[File:RFS-ReleaseNotes-H1.2.0.01 RFS 20.02.25 (1).pdf |Release Notes]]

==January 30, 2025 - R1.2.0==

[[Support for Multiple Measures| Support for Multiple Measures]] 

[[Web Services - GUI - Data| Web Services - GUI-Data - change to default SDMX version and ability to set a query period.]]

[[File:RFS-ReleaseNotes-R1.2.0.00 RFS 30.01.25.pdf |Release Notes]]

2026-06-29T15:44:59Z

Vmurrell:

FXLData System Info

2026-06-29T15:41:26Z

Vmurrell:

[[Category:How to and other features in FXLData]]

R1.3 introduced a new option, available on the FXL Data tab which, when selected, will display information as shown in the example aside.

[[File:Click-sys-info-ER.png|thumb]]

FXLData Diagnostics

2026-06-29T15:40:09Z

Vmurrell:

[[Category:How to and other features in FXLData]]
=== Diagnostic Tool ===
This feature has been introduced to help Regnology diagnose any issues encountered when using FXL Data. By default, the feature is switched off. When required, two options are available which supply different levels of detail. When the tool is enabled a log file will be created.

Enabling Diagnostics is memory intensive so please do not use it by default, use when needed and turn it off once done.

[[File:Diagnostic tool.png|1000px]]

FXLData Purge

2026-06-29T15:35:14Z

Vmurrell:

[[Category:How to and other features in FXLData]]

This option allows you to purge any data in the cache.

[[File:PURGE-CACHE.png|600px]]

2026-06-29T15:26:28Z

Vmurrell: /* FXL Data Version Version 1.3 onwards */

[[Category:How to and other features in FXLData]]
__NOTOC__
An Excel ribbon bar tool for interactively building and editing [[FXLData]] functions.
=Overview=
The FXLData Wizard is part of the add-in for Excel which provides a collection of functions for retrieving statistical data from a Fusion Registry directly into a worksheet.

The Wizard helps in the task of building and modifying =FXLData() and =FXLDataV() functions which take a number of parameters including the Fusion Registry to connect to, the Dataflow and a data query expression - typically an SDMX [[Series Key|series key]].

[[File:FXLData Wizard Ribbon 058.JPG|FXLData Excel ribbon]]

[[FXLData#Quick_Start|Installing]] the FXLData Excel add-in adds a FXLData menu option and the ƒ''x'' button to the ribbon to launch the Wizard.
* Select a blank cell in the worksheet and launch the Wizard to create a new FXLData function.
* Modify an existing =FXLData() or = FXLDataV() function by selecting the worksheet cell before launching the Wizard.

=Wizard=
==FXL Data Version Version 1.3 onwards==
[[File:Wizard-r1-3.png|1200px]]

===Selecting Items===
[[File:Codelist display.png|1000px]]

===Rest Argument Builder ===
[[FXLData_what%27s_new_in_R1.3%3F#Rest_Arguments | Click here to learn more about the new Rest Arguments Builder.]]

==FXL Data Version Version 1.0==
[[File:Wizard.png|1200px]]

=Guidance=
* All parameters can take either a literal value (e.g. a number or a text string), a cell reference (e.g. A4) or an Excel formula (e.g. sum(A4,A6))
* A parameter's result value is shown to the right which is just the literal, the contents of the referenced cell, or the result of the Excel formula
* Red indicates the value is not valid
* Use the '''Apply''' button to apply changes made in the Wizard to the worksheet
* The FXLData function is refreshed automatically everytime the Apply button is clicked
* The '''Registry URL''' is the base URL of the Fusion Registry data source - the same URL used to access the web user interface
* Use the '''+''' and '''-''' buttons to add and remove favourite Fusion Registries from the drop down list - the '''Def''' button sets the default
* The '''Dataflow''' can be either just the source Dataflow's ID (e.g. EXR) provided that is unique, or the fully-qualified Dataflow identifier (e.g. ECB,EXR,1.0)
* The Dataflow drop down provides an up to date list of all dataflows from the selected Fusion Registry that contain data
* The '''Data Expression''' defines precisely what series to retrieve using an SDMX Series Key or JSON packet describing a series basket that can be generated using Fusion Data Browser
* Use the keyword '''all''' for the Data Expression to retrieve all series for the selected Dataflow
* The '''Start Period''' and '''End Period''' select only observations between those dates which must be in [[SDMX Time Formats|SDMX time format]] - both are optional
* '''REST Args''' allows additional data [[Data Query Web Service|REST query arguments]] to be set such as rounding, calculated measures, dimension at observation and aggregations
* The REST Args expression must follow the standard syntax for URL parameters using '&' as a separator , e.g. ''round=2&attributes=UNIT''
* Favourite Rest Arg expressions can be saved and deleted using the '''+''' and '''-''' buttons - the '''?''' button provides help on the available arguments and their usage
* Daily Time Format check box - (introduced in July 2024) - '''Daily Time Format''' or YYYY-MM-DD both an Excel friendly and [[SDMX_Time_Formats |SDMX compatible format]]. For instance if Daily Time Format is checked and an underlying date is 2024 then 2024-12-31 will be rendered to Excel.

FXLData what changed in R1.3.0

2026-06-29T15:24:32Z

Vmurrell: /* Other point to note */

[[Category:How to and other features in FXLData]]
Since the last main release of FXL Data in July 2024, a number of changes and enhancements have been introduced. The changes address several issues identified by users including, to stablise the product, removing the difference between using the Legacy Mode features (these catered for users who used Microsoft Excel 2010-2019) and those using subsequent versions i.e., MS Office 365 and incorporating a number of great new features.

Some of these changes were made available via an optional Hot fixes but the Release of R1.3 brings all the changes together and includes a useful new feature as well as various bug fixes.

A summary of all the changes can be viewed in the Change Log [[FXLData_Change_Log | Change Log]] which shows which changes were made in which Hotfix and which are new in R1.3. This page summarises all the main changes as at Version 1.3.

Remember - to use these changes the FXLData add-in must be installed, follow the installation instructions found [[Downlad_and_Installation_FXLData |here.]]

== FXLData Tab ==
On opening Excel and enabling the latest version of the FX Data add-in, you will see several significant changes on the FXLData Tab within Excel.

[[File:Appearance.png|800px]]

=== Refresh ===
This article can now be found [[FXLData_Refresh|here]]

=== Diagnostic Tool ===
This article can now be found [[FXLData_Diagnostics| here]]

== FXLData Wizard ==

===Dataflow Selection===

A new selection box has been added to make it easier to select a dataflow.

[[File:Dataflow selection.png|1000px]]

===Selecting Items===
[[File:Codelist display.png|1000px]]

===Rest Arguments===

This article can now be found [[Rest_Arguments_Builder|here]]

=== Other point to note ===
===== System Properties =====
This article can now be found [[FXLData_System_Info|here]]

=== Refresh ===

This article can now be found [[FXLData_Refresh|here]]

Category:Functions Reference FXLData

2026-06-29T15:23:29Z

Vmurrell:

These functions take a number of separate arguments making them suitable for building sophisticated data models where Start Period, End Period and other parameters use cell references or Excel formulas.

[[File:Fxldata example1.PNG|thumb|Horizontal time-series example]]

Both the horizontal and 'V' vertical variants take the same arguments making it easy to switch between presentations.

These functions are also available from the Excel functions list.

[[File:FXLD-FUNCTIONS.png|300.px|FXLData on Functions List.]]

File:FXLD-FUNCTIONS.png

2026-06-29T15:23:06Z

Vmurrell:

FXLData what changed in R1.3.0

2026-06-29T13:44:41Z

Vmurrell: /* New Functions introduced */

[[Category:How to and other features in FXLData]]
Since the last main release of FXL Data in July 2024, a number of changes and enhancements have been introduced. The changes address several issues identified by users including, to stablise the product, removing the difference between using the Legacy Mode features (these catered for users who used Microsoft Excel 2010-2019) and those using subsequent versions i.e., MS Office 365 and incorporating a number of great new features.

Some of these changes were made available via an optional Hot fixes but the Release of R1.3 brings all the changes together and includes a useful new feature as well as various bug fixes.

A summary of all the changes can be viewed in the Change Log [[FXLData_Change_Log | Change Log]] which shows which changes were made in which Hotfix and which are new in R1.3. This page summarises all the main changes as at Version 1.3.

Remember - to use these changes the FXLData add-in must be installed, follow the installation instructions found [[Downlad_and_Installation_FXLData |here.]]

== FXLData Tab ==
On opening Excel and enabling the latest version of the FX Data add-in, you will see several significant changes on the FXLData Tab within Excel.

[[File:Appearance.png|800px]]

=== Refresh ===
This article can now be found [[FXLData_Refresh|here]]

=== Diagnostic Tool ===
This article can now be found [[FXLData_Diagnostics| here]]

== FXLData Wizard ==

===Dataflow Selection===

A new selection box has been added to make it easier to select a dataflow.

[[File:Dataflow selection.png|1000px]]

===Selecting Items===
[[File:Codelist display.png|1000px]]

===Rest Arguments===

This article can now be found [[Rest_Arguments_Builder|here]]

=== Other point to note ===
==== Functions ====
The TimeFormatFrequencyID parameter is now available when using the Functions:
* FXLDataURL
* FXLDataURLV
* FXLDataURLFact

[[File:TimeFormatFrequencyID.png|500px]]

===== System Properties =====
This article can now be found [[FXLData_System_Info|here]]

=== Refresh ===

This article can now be found [[FXLData_Refresh|here]]