https://wiki.sdmxcloud.org/api.php?action=feedcontributions&feedformat=atom&user=VmurrellFusion Registry Wiki - User contributions [en]2026-05-03T09:35:28ZUser contributionsMediaWiki 1.32.0https://wiki.sdmxcloud.org/index.php?title=FXLDataLookup_and_FXLDataPeriod_Functions&diff=8235FXLDataLookup and FXLDataPeriod Functions2026-04-20T17:22:46Z<p>Vmurrell: /* Parse error */</p>
<hr />
<div>[[Category:Functions Reference FXLData]] <br />
Introduced in H1.3.0.03 (January 2026). <br />
<br />
== Fusion XL Data - FXLDataLookup and FXLDataPeriod Formulas ==<br />
=== Context ===<br />
To date, FXLData has been used primarily to generate data cubes in Excel from a Fusion Registry by applying user‑defined selection criteria. The add‑in issues SDMX REST queries to the Fusion Registry and renders the results as a structured grid, typically one series per row (time across columns) or one series per column, so analysts can work with a familiar worksheet layout.<br />
<br />
=== Problem ===<br />
The current workflow is geared to building full grids/cubes from Fusion Registry; getting a single value or a small ad‑hoc slice often means running a broader query and then indexing/filtering the filled grid, which adds unnecessary steps for simple asks. <br />
<br />
=== Solution ===<br />
2 New Formulas have been introduced:<br />
<br />
* 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. <br />
* 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).<br />
<br />
==== FXLDataLookup Formula ====<br />
FXLDataLookup reads values from an existing root grid on a specified worksheet and returns the measures for the given series key(s) and period(s) as a <br />
* single value<br />
* short list<br />
* or small table<br />
depending on how many items and periods you pass.<br />
<br />
===== Syntax =====<br />
FXLDataLookup(items, periods, sheetName, [autoRefresh], [errorMessages])<br />
<br />
===== Parameters =====<br />
<br />
'''items''' <br />
* A single series key (text) <br />
* a range of keys <br />
* or an expression combining series keys and numbers with supported operators. <br />
'''periods'''<br />
* A single period<br />
* a range of periods<br />
* a wildcard (e.g., "2001*")<br />
'''sheetName''' - The worksheet containing the root grid with the expected header/layout<br />
'''[autoRefresh]''' <br />
* OPTIONAL, Defaults to FALSE <br />
* TRUE/FALSE. When TRUE, forces updates only if Excel is not in automatic calculation mode. <br />
'''[errorMessages]''' <br />
* OPTIONAL, Defaults to FALSE <br />
* TRUE/FALSE. When TRUE, returns descriptive messages (e.g., “Key Not Found”, “Non‑numeric Value”, “Divide By Zero”, “Invalid Power”, “Parse Error”).<br />
<br />
===== Supported Operators - items parameter =====<br />
'''Arithmetic'''<br />
* + (add) <br />
* - (subtract) <br />
* * (multiply) <br />
* / (divide) <br />
* ^ (power) <br />
* Standard arithmetic precedence applies; <br />
* parentheses can be used to control evaluation order <br />
<br />
'''Unary signs:'''<br />
* leading -<br />
* and + are supported<br />
<br />
'''Exponent constraint''': for ^, the right‑hand exponent must be numeric, either a literal or a cell reference to a numeric value; using a series key on the right‑hand side raises Invalid Power. The left‑hand/base may be a series key.<br />
<br />
===== Wildcards - periods parameter =====<br />
'''Period wildcards''' let you pass a pattern like "2001*"; the function returns that period and all later periods already present in the referenced root grid (e.g., 2001, 2002, 2003).<br />
<br />
==== FXLDataPeriod Formula ====<br />
FXLDataPeriod scans an existing root grid on a specified worksheet and returns the SDMX period(s) available in that grid, either the minimum, the maximum, or both, depending on the mode you pass.<br />
<br />
===== Syntax =====<br />
FXLDataPeriod(sheetName, [what], [errorMessages])<br />
<br />
===== Parameters =====<br />
'''sheetName''' - The worksheet containing the root grid with the expected header/layout<br />
'''what'''<br />
* OPTIONAL, Defaults to BOTH<br />
* MIN - returns the first period<br />
* MAX - returns the last period<br />
* BOTH - returns both the first and last periods<br />
'''errorMessages''' <br />
* OPTIONAL, Defaults to FALSE <br />
* TRUE/FALSE. When TRUE, returns descriptive messages (e.g., “Grid Not Found”).<br />
<br />
=== FXLDataLookup Examples ===<br />
<br />
The examples below are based on the following root grid sheet.<br />
<br />
[[File:Example-spreadsheet.png|1000px]]<br />
<br />
[[:File:Example-Spreadsheet-V2.zip | Example Spreadsheet]] Download and extract from the zip file to obtain an Excel version of the spreadsheet.<br />
<br />
==== Basics ====<br />
Single value (one series + one period)<br />
<br />
=FXLDataLookup("SE1:STERLING:ENGLAND","2002","RootGrid")<br />
<br />
'''Result''': 99<br />
<br />
'''Why''': Pulls the 2002 value for the series key.<br />
<br />
---------------------------------------------------------------------------------------------------------<br />
==== Multiple series (range) for one period ====<br />
=FXLDataLookup(RootGrid!G5:G8,"2002","RootGrid")<br />
'''Result (row‑wise):'''<br />
<br />
* SC1:STERLING:CHINA → 14<br />
* SG1:STERLING:GERMANY → 333<br />
* EI1:EURO:IRELAND → 15<br />
* EG1:EURO:GERMANY → 26<br />
<br />
=FXLDataLookup(RootGrid!G5:G8,"2002","RootGrid")<br />
'''Result (row‑wise):'''<br />
<br />
SC1:STERLING:CHINA → 14<br />
SG1:STERLING:GERMANY → 333<br />
EI1:EURO:IRELAND → 15<br />
EG1:EURO:GERMANY → 26<br />
<br />
---------------------------------------------------------------------------------------------------------<br />
==== Multiple series × multiple periods (ranges) ====<br />
=FXLDataLookup(RootGrid!G5:G8, RootGrid!I2:J2, "RootGrid")<br />
<br />
'''Result (examples):'''<br />
<br />
* 2002 → 14, 333, 15, 26<br />
* 2003 → 45, 55, 12, 45<br />
<br />
---------------------------------------------------------------------------------------------------------<br />
==== Auto‑refresh on (even if Excel calc mode is Manual) ====<br />
=FXLDataLookup("SE1:STERLING:ENGLAND","2002","RootGrid",TRUE)<br />
<br />
'''Result''': 99 (same value; it just auto‑refreshes) [FXLDataLookupSamples | Excel]<br />
<br />
===== Arithmetic with series =====<br />
<br />
Addition<br />
=FXLDataLookup("SE1:STERLING:ENGLAND+EG1:EURO:GERMANY","2002","RootGrid")<br />
<br />
Result: 125 (99 + 26) <br />
<br />
---------------------------------------------------------------------------------------------------------<br />
'''Subtraction'''<br />
=FXLDataLookup("SE1:STERLING:ENGLAND-EG1:EURO:GERMANY","2002","RootGrid")<br />
<br />
'''Result''': 73 (99 − 26) <br />
<br />
---------------------------------------------------------------------------------------------------------<br />
'''Multiplication'''<br />
=FXLDataLookup("SE1:STERLING:ENGLAND*EG1:EURO:GERMANY","2002","RootGrid")<br />
<br />
Result: 2574 (99 × 26)<br />
<br />
---------------------------------------------------------------------------------------------------------<br />
'''Division'''<br />
=FXLDataLookup("SE1:STERLING:ENGLAND/EG1:EURO:GERMANY","2002","RootGrid")<br />
<br />
'''Result''': 3.81 (99 ÷ 26) <br />
<br />
===== Order of operations, exponent, parentheses, unary =====<br />
'''Exponent with numeric literal'''<br />
=FXLDataLookup("SE1:STERLING:ENGLAND*2^2","2002","RootGrid")<br />
<br />
'''Result''': 396 (99 × 2²)<br />
<br />
---------------------------------------------------------------------------------------------------------<br />
'''Parentheses respected'''<br />
=FXLDataLookup("(SE1:STERLING:ENGLAND)*(10-2)","2002","RootGrid")<br />
<br />
Result: 792 (99 × (10−2)) <br />
<br />
---------------------------------------------------------------------------------------------------------<br />
'''Unary minus'''<br />
=FXLDataLookup("-SE1:STERLING:ENGLAND*2","2002","RootGrid")<br />
<br />
'''Result''': -198 (−99 × 2) <br />
<br />
---------------------------------------------------------------------------------------------------------<br />
'''Unary plus'''<br />
=FXLDataLookup("+(SE1:STERLING:ENGLAND-10000)","2002","RootGrid")<br />
<br />
'''Result''': -9901 (+(99−10000)) <br />
<br />
---------------------------------------------------------------------------------------------------------<br />
'''Multiple operands in one go'''<br />
=FXLDataLookup("SE1:STERLING:ENGLAND*SE1:STERLING:ENGLAND-SI1:STERLING:IRELAND/EG1:EURO:GERMANY","2002","RootGrid")<br />
<br />
'''Result''': 9799.62<br />
<br />
---------------------------------------------------------------------------------------------------------<br />
===== Wildcards (period expansion) =====<br />
'''Expand 2001* to all matching periods'''<br />
<br />
=FXLDataLookup(RootGrid!G5:G8, "2001*", "RootGrid")<br />
<br />
'''Result''' (grid excerpt):<br />
<br />
* 2001 → 16, 76, 11, 11<br />
* 2002 → 14, 333, 15, 26<br />
* 2003 → 45, 55, 12, 45<br />
(Order aligns with series in RootGrid!G5:G8)<br />
<br />
===== Period helpers (using SDMXPeriod(...) inside) =====<br />
'''Min period'''<br />
<br />
=FXLDataLookup("SE1:STERLING:ENGLAND", SDMXPeriod("RootGrid","MIN"), "RootGrid")<br />
<br />
Result: 13 (value at min period 2001) <br />
<br />
---------------------------------------------------------------------------------------------------------<br />
'''Max period'''<br />
<br />
=FXLDataLookup("SE1:STERLING:ENGLAND", SDMXPeriod("RootGrid","MAX"), "RootGrid")<br />
<br />
'''Result''': 45 (value at max period 2003)<br />
<br />
---------------------------------------------------------------------------------------------------------<br />
'''Min and Max (2‑cell spill)'''<br />
<br />
=FXLDataLookup("SE1:STERLING:ENGLAND", SDMXPeriod("RootGrid"), "RootGrid")<br />
<br />
'''Result''' (two cells): 13, 45 <br />
<br />
'''Errors''' <br />
'''Sheet not found'''<br />
=FXLDataLookup("SE1:STERLING:ENGLAND","2002","NonExistantRootGrid",FALSE,TRUE)<br />
<br />
'''Result''': Sheet Not Found <br />
<br />
---------------------------------------------------------------------------------------------------------<br />
'''Key not found (typo in series key)'''<br />
<br />
=FXLDataLookup("SE1:STERLING:ENGLANlD","2002","RootGrid",FALSE,TRUE)<br />
<br />
'''Result''': Key Not Found <br />
<br />
---------------------------------------------------------------------------------------------------------<br />
'''Non‑numeric value in grid'''<br />
<br />
=FXLDataLookup("SI1:STERLING:IRELAND","2003","RootGrid",FALSE,TRUE)<br />
<br />
'''Result''': Non-numeric Value SI1:STERLING:IRELAND (cell value is g) <br />
<br />
---------------------------------------------------------------------------------------------------------<br />
'''Grid not found (bad RootGrid layout)'''<br />
<br />
=FXLDataLookup("SE1:STERLING:ENGLAND","2002","RootGridAlternate",FALSE,TRUE)<br />
<br />
'''Result''': Grid Not Found (header row not on row 2)<br />
<br />
---------------------------------------------------------------------------------------------------------<br />
'''Divide by zero'''<br />
<br />
=FXLDataLookup("SE1:STERLING:ENGLAND/(EG1:EURO:GERMANY-26)","2002","RootGrid",FALSE,TRUE)<br />
<br />
'''Result''': Divide By Zero (26−26 = 0) [FXLDataLookupSamples | Excel]<br />
<br />
---------------------------------------------------------------------------------------------------------<br />
'''Invalid power'''<br />
<br />
=FXLDataLookup("SE1:STERLING:ENGLAND^(EG1:EURO:GERMANY-26)","2002","RootGrid",FALSE,TRUE)<br />
<br />
'''Result''': Invalid Power (exponent expression based on series key is invalid, use a numeric literal or numeric cell) <br />
<br />
---------------------------------------------------------------------------------------------------------<br />
'''Parse error (operator typo)'''<br />
<br />
=FXLDataLookup("SE1:STERLING:ENGLAND**SE1:STERLING:ENGLAND-SI1:STERLING:IRELAND/EG1:EURO:GERMANY","2002","RootGrid",FALSE,TRUE)<br />
<br />
'''Result''': Parse Error<br />
<br />
---------------------------------------------------------------------------------------------------------<br />
<br />
=== FXLDataPeriod Examples ===<br />
The examples below are based on the following root grid sheet.<br />
<br />
[[File:Root-grid.png|1000px]]<br />
<br />
===== Minimum period (single value) =====<br />
<br />
=SDMXPeriod("RootGrid","MIN")<br />
<br />
'''Result''': 2001<br />
Why: Returns the earliest (minimum) SDMX period available on the root grid sheet.<br />
<br />
---------------------------------------------------------------------------------------------------------<br />
===== Maximum period (single value) =====<br />
<br />
=SDMXPeriod("RootGrid","MAX")<br />
<br />
'''Result''': 2003<br />
Why: Returns the latest (maximum) SDMX period available on the root grid sheet.<br />
<br />
---------------------------------------------------------------------------------------------------------<br />
===== Range (min and max — two‑cell spill) =====<br />
<br />
=SDMXPeriod("RootGrid")<br />
<br />
'''Result''' (two cells): 2001, 2003<br />
'''Why''': Returns both the MIN and MAX SDMX periods from the root grid sheet. <br />
<br />
---------------------------------------------------------------------------------------------------------<br />
===== Error: sheet not found =====<br />
<br />
=SDMXPeriod("NonExistantRootGrid",,TRUE)<br />
<br />
'''Result''': Sheet Not Found<br />
'''Why''': The specified sheet name doesn’t exist, so the function returns a “Sheet Not Found” error.<br />
<br />
---------------------------------------------------------------------------------------------------------<br />
<br />
=== Troubleshooting ===<br />
===== MIN period isn’t the earliest in the grid =====<br />
<br />
'''Why''': SDMXPeriod("…","MIN") returns the first period it finds in the grid header, which is typically (but not guaranteed to be) the earliest.<br />
<br />
'''Fix''': Sort your period headers left→right so the earliest period is first. <br />
<br />
---------------------------------------------------------------------------------------------------------<br />
===== MAX period isn’t the latest in the grid =====<br />
<br />
'''Why''': SDMXPeriod("…","MAX") returns the last period it finds in the grid header, which is typically (but not guaranteed to be) the latest.<br />
<br />
'''Fix''': Sort your period headers left→right so the latest period is last. <br />
<br />
---------------------------------------------------------------------------------------------------------<br />
===== FXLDataLookup or SDMXPeriod behaves oddly in “vertical mode” =====<br />
<br />
'''Why''': Both functions expect a horizontal grid (periods across columns) like the RootGrid examples; vertical layouts aren’t supported.<br />
<br />
'''Fix''': Render the root grid with periods in the header row and values beneath them.<br />
<br />
---------------------------------------------------------------------------------------------------------<br />
===== Grid not found ===== <br />
<br />
'''Why''': The grid header (dimensions + period labels) must be on row 2 of the root sheet; otherwise the grid isn’t detected.<br />
<br />
'''Fix''': Move headers to row 2 on the root sheet. <br />
<br />
---------------------------------------------------------------------------------------------------------<br />
===== Sheet not found =====<br />
<br />
'''Why''': The sheet name you passed doesn’t match an actual worksheet.<br />
<br />
'''Fix''': Use the exact sheet name that exists in the workbook. <br />
<br />
---------------------------------------------------------------------------------------------------------<br />
===== Key not found =====<br />
<br />
Why: The series key is misspelled or doesn’t exist in the root grid’s Series column.<br />
Fix: Copy–paste the key from the grid (avoid typos) and ensure the root grid includes full series keys. <br />
<br />
---------------------------------------------------------------------------------------------------------<br />
===== Expected multiple cells, but only one cell returned =====<br />
<br />
'''Why''': Multi‑cell (“spilled”) results require a modern Excel (later than 2016) that supports dynamic arrays.<br />
<br />
---------------------------------------------------------------------------------------------------------<br />
===== Invalid power =====<br />
<br />
'''Why''': The right‑hand side of ^ must be a numeric literal or a reference to a numeric cell; a series‑derived expression/key is invalid (see example using …^(EG1:EURO:GERMANY-26)).<br />
<br />
'''Fix''': Replace the exponent with a number (e.g., ^2) or a cell that contains a number. <br />
<br />
---------------------------------------------------------------------------------------------------------<br />
===== Non‑numeric value in grid =====<br />
<br />
'''Why''': The target cell in the root grid holds text (e.g., g), so numeric calculation fails.<br />
<br />
'''Fix''': Correct the source cell to a number or point the formula to a numeric period.<br />
<br />
---------------------------------------------------------------------------------------------------------<br />
===== Divide by zero =====<br />
<br />
'''Why''': Your denominator evaluates to 0 (e.g., EG1:EURO:GERMANY - 26 = 0).<br />
<br />
'''Fix''': Choose a non‑zero reference.<br />
<br />
---------------------------------------------------------------------------------------------------------<br />
===== Parse error =====<br />
<br />
'''Why''': The items/expression string has a syntax error (operator typo, or missing parenthesis).<br />
<br />
'''Fix''': Check operators and parentheses; compare against a working example and re‑enter carefully.<br />
<br />
===== Operations on multiple reference cells ===== <br />
Require using ampersands and quotes.<br />
'''Why''': When performing operations like summing or multiplying without ampersands and quotes, Excel evaluates the referenced cells before passing the value to FXLDataLookup, which results in an incorrect input for the formula.<br />
<br />
'''Fix''': Use ampersands and quotes, e.g. FXLDataLookup(E1&"+"&F1;D1;"דוגמאות";FALSE;TRUE)<br />
<br />
This ensures the first parameter is passed as a string and correctly processed by the formula.</div>Vmurrellhttps://wiki.sdmxcloud.org/index.php?title=Release_Plans&diff=8234Release Plans2026-04-01T13:43:40Z<p>Vmurrell: /* P2.0.1.00_RFS_31.07.26 Estimated Release Date July 31, 2026 - Patch */</p>
<hr />
<div>__NOTOC__<br />
Please refer to the Change Log(s) and Release Notes for more detail.<br />
<br />
==P1.3.1.00_RFS_29.05.26 Estimated release date May 25, 2026 - Patch ==<br />
Provisional contents:<br><br />
<br />
RFS-2602 - [Fusion Security Manager]: Modification to security rules.<br><br />
<br />
RFS-1869 - [Fusion Data Browser]: Implementation of Cookies Privacy Policy<br><br />
<br />
RFS-2614 - [Fusion Data Browser]: Comments - need to be available in 2 languages<br><br />
<br />
RFS-2615 - [Fusion Data Browser]: Editing Languages in Pre Defined Queries - not working as expected.<br><br />
<br />
RFS-2674 - [Fusion Registry]: Modification to Validation B and PRE_BREAK_VALUE<br><br />
<br />
RFS-2675 - [Fusion Registry]: Modification to Attachment Constraints<br />
<br />
RFS-2676 - [Fusion Registry]: Mapping Modification<br><br />
<br />
RFS-2677 [Fusion Registry]: Structure Set Modification<br />
<br />
RFS-425 - [Fusion Data Browser]: Change method of Language Selection <br />
<br />
== R2.0.0.00_RFS_26.06.26 Estimated release date June 6, 2026 - Full Release ==<br />
<br />
===Fusion Registry ===<br />
* Upgrade from Spring 5 to Spring 7<br />
* Support pop up box introduced [[Support_Tab| read more]]<br />
* Database consistency checker web service [[Database_Consistency_Web_Service| read more]]<br />
* Semantic and Non-Semantic structure versions - ability to co-exist<br />
* Bulk Actions to include Hierarchy Associations<br />
* Loading structures - ability to skip invalid structures [[Load_Structures#Submitting_Invalid_Structures| read more]]<br />
<br />
===Fusion Data Browser ===<br />
* Implementation of loading indicator<br />
<br />
=== FXLData Enhancements ===<br />
* Introduction of login functionality<br />
* Introduction of System Properties reporter<br />
* Support for hierarchical structures in the query builder<br />
* Improved medium verbosity logging: limited to API request URLs and response codes<br />
* Alignment of result grid data order with selected codes in the query builder<br />
<br />
==P2.0.1.00_RFS_31.07.26 Estimated Release Date July 31, 2026 - Patch ==<br />
Customer driven enhancements to Fusion Data Browser.<br />
<br />
====Plus Miscellaneous bug fixes and minor enhancements, full details of which will be available in the Release Notes and Change Logs. ====</div>Vmurrellhttps://wiki.sdmxcloud.org/index.php?title=Release_Plans&diff=8233Release Plans2026-04-01T13:40:17Z<p>Vmurrell: </p>
<hr />
<div>__NOTOC__<br />
Please refer to the Change Log(s) and Release Notes for more detail.<br />
<br />
==P1.3.1.00_RFS_29.05.26 Estimated release date May 25, 2026 - Patch ==<br />
Provisional contents:<br><br />
<br />
RFS-2602 - [Fusion Security Manager]: Modification to security rules.<br><br />
<br />
RFS-1869 - [Fusion Data Browser]: Implementation of Cookies Privacy Policy<br><br />
<br />
RFS-2614 - [Fusion Data Browser]: Comments - need to be available in 2 languages<br><br />
<br />
RFS-2615 - [Fusion Data Browser]: Editing Languages in Pre Defined Queries - not working as expected.<br><br />
<br />
RFS-2674 - [Fusion Registry]: Modification to Validation B and PRE_BREAK_VALUE<br><br />
<br />
RFS-2675 - [Fusion Registry]: Modification to Attachment Constraints<br />
<br />
RFS-2676 - [Fusion Registry]: Mapping Modification<br><br />
<br />
RFS-2677 [Fusion Registry]: Structure Set Modification<br />
<br />
RFS-425 - [Fusion Data Browser]: Change method of Language Selection <br />
<br />
== R2.0.0.00_RFS_26.06.26 Estimated release date June 6, 2026 - Full Release ==<br />
<br />
===Fusion Registry ===<br />
* Upgrade from Spring 5 to Spring 7<br />
* Support pop up box introduced [[Support_Tab| read more]]<br />
* Database consistency checker web service [[Database_Consistency_Web_Service| read more]]<br />
* Semantic and Non-Semantic structure versions - ability to co-exist<br />
* Bulk Actions to include Hierarchy Associations<br />
* Loading structures - ability to skip invalid structures [[Load_Structures#Submitting_Invalid_Structures| read more]]<br />
<br />
===Fusion Data Browser ===<br />
* Implementation of loading indicator<br />
<br />
=== FXLData Enhancements ===<br />
* Introduction of login functionality<br />
* Introduction of System Properties reporter<br />
* Support for hierarchical structures in the query builder<br />
* Improved medium verbosity logging: limited to API request URLs and response codes<br />
* Alignment of result grid data order with selected codes in the query builder<br />
<br />
==P2.0.1.00_RFS_31.07.26 Estimated Release Date July 31, 2026 - Patch ==<br />
Contents to be confirmed.<br />
<br />
====Plus Miscellaneous bug fixes and minor enhancements, full details of which will be available in the Release Notes and Change Logs. ====</div>Vmurrellhttps://wiki.sdmxcloud.org/index.php?title=Release_Plans&diff=8232Release Plans2026-04-01T13:07:18Z<p>Vmurrell: </p>
<hr />
<div>__NOTOC__<br />
Please refer to the Change Log(s) and Release Notes for more detail.<br />
<br />
==P1.3.1.00_RFS_29.05.26 Estimated release date May 25, 2026 - Patch ==<br />
Provisional contents:<br />
RFS-2602 - Modification to FSM security rules.<br />
RFS-1869 - [Fusion Data Browser]: Implementation of Cookies Privacy Policy<br />
RFS-2614 - [Fusion Data Browser]: Comments - need to be available in 2 languages<br />
RFS-2615 - [Fusion Data Browser]: Editing Languages in Pre Defined Queries - not working as expected.<br />
<br />
== R2.0.0.00_RFS_26.06.26 Estimated release date June 6, 2026 - Full Release ==<br />
<br />
===Fusion Registry ===<br />
* Upgrade from Spring 5 to Spring 7<br />
* Support pop up box introduced [[Support_Tab| read more]]<br />
* Database consistency checker web service [[Database_Consistency_Web_Service| read more]]<br />
* Semantic and Non-Semantic structure versions - ability to co-exist<br />
* Bulk Actions to include Hierarchy Associations<br />
* Loading structures - ability to skip invalid structures [[Load_Structures#Submitting_Invalid_Structures| read more]]<br />
<br />
===Fusion Data Browser ===<br />
* Implementation of loading indicator<br />
<br />
=== FXLData Enhancements ===<br />
* Introduction of login functionality<br />
* Introduction of System Properties reporter<br />
* Support for hierarchical structures in the query builder<br />
* Improved medium verbosity logging: limited to API request URLs and response codes<br />
* Alignment of result grid data order with selected codes in the query builder<br />
<br />
==P2.0.1.00_RFS_31.07.26 Estimated Release Date July 31, 2026 - Patch ==<br />
Contents to be confirmed.<br />
<br />
====Plus Miscellaneous bug fixes and minor enhancements, full details of which will be available in the Release Notes and Change Logs. ====</div>Vmurrellhttps://wiki.sdmxcloud.org/index.php?title=FXLData_Change_Log&diff=8231FXLData Change Log2026-03-12T15:32:45Z<p>Vmurrell: </p>
<hr />
<div>__NOTOC__<br />
'''Excel Command'''<br><br />
=FXLDataVersion("changelog")<br />
<br />
= H1.3.0.04_RFS_13.03.26 Released March 13, 2026 - Hotfix ==<br />
RFS-2610 - Enhancement - While computing the aggregates, an issue occurred due to the presence of non‑numeric values in the OBS_VALUES field - SUP-307250<br />
<br />
= H1.3.0.03_RFS_30.01.26 - Released 30.01.2026 =<br />
RFS-2094: - Improvement - Some users were experiencing performance issues when Excel was closed after using FXLData.<br />
<br />
RFS-2486: - Enhancement - new functions FXLDataLookUp and FXLDataPeriod introduced. [https://wiki.sdmxcloud.org/FXLData_-_New_Functions Read more in this article.]<br />
<br />
RFS-1906: - Improvement - Changes to streamline diagnostic tool and introduction of System Info button.<br />
<br />
RFS-2516: - Compatibility - The components that have changed since H1.3.0.02<br />
[https://wiki.sdmxcloud.org/What%27s_new#Compatability Read more in this article.]<br />
* FXL Data<br />
* and Fusion Data Browser<br />
<br />
= H1.3.0.02_RFS_08.12.25 - Released on December 8, 2025 =<br />
RFS-1866: - Improvement - Optimized the automatic reference clean-up logic to process only the requisite first cell of FXLData named ranges, reducing runtime dramatically.<br />
<br />
RFS-1838: - Bug Fix - Start/End period and more filters not working in FXLData with auto aggregations<br />
= H1.3.0.01_RFS_10.10.25 - Released on October 9, 2025 =<br />
RFS-1860: - Bug Fix - Performance improvement for large datasets.<br />
<br />
RFS-1830: Bug Fix - Filters for start date and end date incorrectly applied for the v1 endpoint when having the min parameter passed in the request.<br />
<br />
== R.3_RFS_29.08.2025 (Due for Release August 29, 2025) ==<br />
<br />
RFS-1761: Prevent 'Unable to refresh' error when resultant grid has one row.<br><br />
<br />
RFS-1746: Fixed an issue where non-selectable parent code labels in hierarchical code lists were unnecessarily truncated despite available space.<br><br />
<br />
RFS-277: Fix introduced to enforce edit state on the query builder form.<br><br />
<br />
RFS-1548: Fixed issue where clearing search text caused dropdown error due to attempting to select a non-existent first item.<br><br />
<br />
RFS-1549: Added cleanup behaviour that removes surplus rows and columns within a defined margin after any FXL data formula runs. This improves performance and stability, particularly when switching between horizontal and vertical views.<br><br />
<br />
RFS-274: Text that includes line breaks (such as paragraphs) is now correctly imported into a single cell, rather than being split across multiple rows.<br><br />
<br />
RFS-1474: Hide start/end date labels in Query Builder and REST Arguments screens when dates can't be precomputed.<br><br />
<br />
RFS-1531: Wizard dropdown fix for dataflow name rendering in right to left mode.<br><br />
<br />
RFS-283: Introduction of the Rest Arguments Builder Form.<br><br />
<br />
RFS-1262: Remove truncation and introduce pagination to Query Builder screen.<br><br />
<br />
RFS-279: Request for enhanced ability of FXLData to view/show dataflow names in query builder selection.<br />
<br />
RFS-1617: The max series parameter was always returning one additional result.<br />
<br />
RFS-1626: The order measure rest parameter was not operating correctly and had no effect on the ordering of the time csv-series or csv-ts formats. This issue has been resolved but limited to cases in which the time period is the selected.<br />
<br />
RFS-1568: Incorrect horizontal values displayed when custom locale separators, rather than English, were used.<br />
<br />
RFS-1460: The label =name was not working as expected.<br />
<br />
RFS-1072: A new section has been added ribbon enabling the user to enable logging for diagnostic purposes. Two levels are available, medium and high. For high verbosity logs are unlimited, hence it is advised not to use this option unless absolutely necessary and for brief periods.<br />
<br />
== H1.2.0.04_RFS_04.07.2025 (Released July 4, 2025) ==<br />
<br />
RFS-1565 - Bug Fix - addressed issue with horizontal amounts losing their decimal point resulting in multiplication of values when custom locale separators used (other than English defaults).<br />
<br />
== H1.2.0.02_RFS_07.03.2025 (Released March 7, 2025) ==<br />
<br />
RFS-279 - Enhancement - ability to view Dataflows in the Query builder by Name or ID. [[FXL_Data_changes_in_Hotfix_March_2025| Click here for more information]].<br />
<br />
== H1.2.0.01_RFS_20.02.25 (Released February 20, 2025) ==<br />
<br />
RFS-1359 - Bug Fix - Changing the Daily Format back to original state was not working as expected. Due to other changes in FXLData, this has now been rectified via the Refresh button. Support Ticket - 409849. <br />
<br />
RFS-1324 - Bug Fix - The TimeSeriesFormat parameter was available to the FXLData and FXLDataV formulas but was absent in other variations such as: - FXLDataUrl -<br />
FXLDataUrlV - FXLDataUrlFact. The TimeSeriesFormat parameter was made available to all variations of the FXLData formula. Support Ticket - 397682. <br />
<br />
RFS-902 - Tool Upgrade - A new section was added to the plugin ribbon. The user can enable /disable diagnostic, and decide on the level of verbosity (medium/high) For<br />
medium verbosity logs are limited to 40000 characters to prevent memory issues(around 15-20 request logs). For high verbosity logs are unlimited, hence it is<br />
advised not to use this option unless absolutely necessary and for brief periods. Please also be aware of any sensitive information that the logs will render before sharing. [[FXL_Data_changes_in_Hotfix_February_2025| Click here from more information.]]<br />
<br />
RFS-878 - Bug Fix - Unable to extract data using Excel 2016.- Issue fixed and compatibility is supported from Excel 2016 to 2020. Support Ticket - 378098.<br />
<br />
RFS-772 - Improvement - Changed =FXLDataVersion("changelog") to show changlog starting from the newest changes instead of starting from the oldest.<br />
<br />
RFS-382 - Bug Fix - Previously it was observed that in some scenarios registry returned a 404 rather than a 401 http response to fxl data when a user was unauthenticated. This caused fxl data to suppress the login dialog and offer no means for the user to remedy the situation. - Now, if FXL Data detects a 404 response it will display the login prompt on the first try thus providing the user an opportunity to enter valid credentials and continue with the successful processing of web service interactions with registry.<br />
<br />
RFS-278 - Bug Fix - Previously, inconsistencies were observed between horizontal and vertical mode. - This has been resolved. Support Ticket - 333871.<br />
<br />
RFS-109 - Change - Automatic Refresh could cause performance issues with large datasets - The automatic process has been removed and now, Refreshes must be performed manually. Support Ticket - 334024 & 397658.<br />
<br />
== R1.1.0.00_RFS_05.07.24 ==<br />
* RFS-262: Improved performance of the dataflow selection on the wizard form<br />
* RFS-280: Introduced a feature that facilitates the conversion of the received TIME_FORMATs to daily<br />
<br />
== 1.2.6 (24 February 2023) ==<br />
* FXLData: Fixed bug returning the incorrect number of series for 'basket' queries (virtual dataflows)<br />
* FXLData: Fixed bug incorrectly reporting the number of available / retrieved series in the resultset header<br />
<br />
== Version 1.2.5 (23 February 2023) ==<br />
* FXLData: fixed bug in [user]@ syntax handler that mangled the URL if an @ symbol is used in the Dataflow ID for instance<br />
* Legacy Mode: modified application event handling to make control over automatic calculation more robust<br />
* Fusion Registry refreshable Excel workbooks: fixed bug preventing workbooks from being refreshed on open<br />
<br />
== Version 1.2.4 (18 November 2022) ==<br />
* FXLData: show the REST data API url in the header<br />
* FXLData: add 'nocc' client-side REST Argument to restrict the resultset time periods to only those with observation values when startPeriod and / or endPeriod are specified<br />
<br />
== Version 1.2.3 (14 November 2022) ==<br />
* Legacy Mode: bug fix displaying N/A under certain circumstances<br />
<br />
== Version 1.2.2 (11 November 2022) ==<br />
* Legacy Mode: bug fix preventing display of datasets with only a single row<br />
<br />
== Version 1.2.1 (08 November 2022) ==<br />
* Legacy Mode: change automatic calculation option to 'off' by default to address general worksheet performance issues<br />
<br />
== Version 1.2.0 (05 July 2022) ==<br />
* Legacy Mode: add Ribbon function to disable automatic calculation to speed bulk changes to worksheets such as deleting large numbers of cells<br />
<br />
== Version 1.1.2 (27 June 2022) ==<br />
* Wizard: fix dataflow search<br />
<br />
== Version 1.1.1 (09 June 2022) ==<br />
* Refreshable worksheets: modified automatic refresh on open to improve reliability of refreshable worksheets<br />
<br />
== Version 1.1.0 (30 May 2022) ==<br />
* FXLData: Support 'un' parameter to force login on refreshable worksheets<br />
<br />
== Version 1.0.1 (16 May 2022) ==<br />
* FXLData: Fixed invalid availability query syntax when working with Fusion Registry 11 and SDMX 3.0<br><br />
<br />
== Version 1.0.0 (13 May 2022) ==<br />
First Public Release<br />
1.0.1 (16 May 2022)<br />
* FXLData: Fixed invalid availability query syntax when working with Fusion Registry 11 and SDMX 3.0<br />
<br />
------------------------------------------------------------------------------------------------<br />
== Beta Versions ==<br />
Beta 0.3.3<br />
* Authentication issues fixed<br />
Beta 0.3.4<br />
* Modified parameterised variants to allow no dataflow and a dataflow/series key to be specified in the expression<br />
Beta 0.3.5<br />
* JSON / POST data query support for series baskets<br />
Beta 0.3.6<br />
* Vertical JSON / POST support<br />
Beta 0.3.7<br />
* Fixed bug in URL validator which rejected URLs where the host contains hyphens<br />
* Fixed bug where URL's of the form crash the API call http://@hostname<br />
Beta 0.3.8<br />
* Add workaround for 'aggregate' queries where the availability query does not return the correct series_count<br />
* =FXLDataV() now takes the same arguments as =FXLData() to ease switching between horizontal and vertical presentations - some arguments are ignored though<br />
Beta 0.4.0<br />
* Add ribbon bar Wizard<br />
Beta 0.4.1<br />
* Wizard: Removed redundant ribbon bar components<br />
* Wizard: Added dataflow dropdown refresh<br />
Beta 0.4.2<br />
* Wizard: Added defence against JSON being supplied as a literal Expression value - Excel doesn't support that<br />
* Wizard: Added tool tips<br />
* Wizard: Corrected tab order<br />
Beta 0.4.3<br />
* Wizard: Improved handling of FXLData function execution errors when inserting the function into a sheet<br />
Beta 0.4.4<br />
* Wizard: Added checks to verify the correct version of Excel is being used (Microsoft 365 Excel Sept 2018 or later)<br />
Beta 0.5.0<br />
* FXLData / Wizard / Refresh: add support for pre-Excel 2018 'legacy mode' where the result array is iterated and inserting into the cells on ribbon button click<br />
Beta 0.5.1<br />
* FXLData: Added data query caching to improve performance particularly on legacy refresh where the same query may be executed multiple times<br />
Beta 0.5.2<br />
* Purge Cache: Added 'Purge Cache' function to the ribbon bar<br />
Beta 0.5.3<br />
* Legacy Mode: legacy functions now automatically refresh on change without using the Ribbon 'Refresh' emulating the behaviour of normal Excel functions to some extent<br />
* Legacy Mode: added error handling for stack overflows on legacy 'evaulate' where the formula length exceeds the 255 character limit<br />
Beta 0.5.4<br />
* Ribbon: Added control over automatic refresh in legacy mode<br />
* FXLData: Improved caching to avoid caching error results<br />
* Legacy Mode: Modified application event handling to avoid triggering refresh events where not needed<br />
Beta 0.5.5<br />
* Wizard: check each Dataflow for access rights before adding to the dropdown to ensure the list only contains Dataflows for which the user has permissions<br />
Beta 0.5.6<br />
* FXLData: Fixed issues with FXLDaatV returning the incorrect number of series (removed paging which is not relevant for vertical and corrected series calcs when using calculated measures)<br />
* FXLData: Removed API paging due to limited benefit<br />
* FXLData: Fixed bug resulting in 'Query Error - 0 series retrieved of 0' due to paging errors<br />
* Wizard: Query Builder - added clear selection button<br />
* Wizard: Query Builder - show series count for entire dataflow on initialisation<br />
* Wizard: Query Builder - removed irrelevant TIME_PERIOD tab<br />
* Wizard: Added REST arguments syntax help<br />
* Legacy Mode: Stopped screen updating during refresh to improve performance<br />
Beta 0.5.7<br />
* Wizard: Query Builder enhanced to grey-out invalid codes as selections are made<br />
* Wizard: Improved query builder refresh performance<br />
* Wizard: Improved 'unapplied changes' indicator<br />
* Wizard: Improved REST API help popup<br />
Beta 0.5.8<br />
* FXLData: Trap and gracefully handled Registry data query errors that return no data, but result in HTTP 500 and 'Index:0, Size:0' responses<br />
* Refresh: Added Refresh Sheet option<br />
* Ribbon: Moved Refresh and Calculations to Ribbon menus<br />
Beta 0.6.0<br />
* Legacy Mode: Modified legacy mode dynamic array emulation to improve performance to that comparable with actual dynamic arrays (legacyRefreshCell refactor - assign resultset arrary directly to range.value instead of iterating one cell at a time)<br />
* Legacy Mode: Application events initialised in the FXLData Workbook Open event<br />
* Legacy Mode: Automatic calculation defaulted on true in the FXLData Workbook Open event which improves reliability by avoiding reliance on ribbon initialisation to perform that task<br />
* FXLData: Corrected duplication of double quotes where they appear in component labels<br />
Beta 0.6.1<br />
* Addin: Forces Excel to execute the FXLData formula in cell B2 on workbook open ensuring that refreshable workbooks generated by Fusion Registry refresh as expected on open<br />
Beta 0.7.0<br />
* FXLData: Fusion Registry 11 support<br />
* FXLData: Authentication exception handling bug fixed in all four of the fxldata query execution functions - URL h and v, POST h and v<br />
* FXLData: Added freshness timestamp to the resultset metrics<br />
* Wizard: Do not show the wizard for FXLDataURL or FXLDataURLV functions as it is designed for use only with the parameterised function variants<br />
Beta 0.7.2<br />
* FXLData: SDMX 3.0 availability API support<br />
Beta 0.7.3<br />
* FXLData: Added FXLDataUrlFact() function<br />
Beta 0.7.4<br />
* FXLDataUrlFact: Added defence against errors caused where the availability query incorrectly indicates data is available, and the data query returns none<br />
* FXLDataUrlFact: Added gzip accept encoding to XML dataset GET<br />
* FXLData: Weakened the URL syntax check to avoid FXLDataURL refreshable sheet calls being rejected as bad URL because of spaces in the 'saveAs' parameter<br />
Beta 0.7.5<br />
* FXLData: Fixed issue preventing refreshable worksheets refreshing on open in legacy mode<br />
* FXLData: Fixed FXLDataUrlFact bug where the wrong number of output columns was estimated under certain circumstances<br />
Beta 0.7.6<br />
* Wizard: Added 'Purge Cache on Apply' option<br />
* Legacy Mode: Fixed bug in legacy mode refresh where resultsets in the same cell on different sheets are deleted on refresh<br />
Beta 0.7.7<br />
* Legacy Mode: Changed refresh to clear the contents of the range rather than clear all thus preserving user-applied formatting<br />
* Legacy Mode: Fixed refresh bug which left redundant ranges where a FXLdata formula was moved, deleted or over written <br />
* Legacy Mode: Changed refresh behaviour to not delete the range content when an FXLData formula is moved, deleted or over written<br />
Beta 0.7.8<br />
* Legacy Mode: Modified sub legacyRefreshCell() to exit immediately if the cell does not contain an FXLData function<br />
* FXLData: FXLDATA-2 Vertical presentation fails with an 'subscript out of range' inline error when the resultset has one series<br />
Beta 0.7.9<br />
* Wizard: Added dataflow quick filter<br />
* Legacy Mode: Removed the Ribbon Bar option to control automatic refresh on change because setting to 'manual' prevented workbook and sheet refresh because named ranges were not being created<br />
* Legacy Mode: Fixed 'refreshselectedcell' bug whereby a named range was not being created if the function returns an error thus preventing subsequent workbook and sheet refresh operations<br />
Beta 0.7.10<br />
* Wizard: Date format syntax help added<br />
* Wizard: Corrected date format validation bug that reported dates of the form '01/01/2010' as valid<br />
* Wizard: Corrected bug that incorrectly evaluated date values in existing formulas on wizard startup<br />
Beta 0.7.11<br />
* Legacy Mode: Changed legacy mode to use 'worksheet' scoped named ranges rather the 'workbook' to avoid confusion when worksheets are duplicated<br />
* Legacy Mode: Modified legacy refresh to use worksheet.evaluate rather than application.evaluation to ensure formulas run within the correct worksheet context - fixes unexpected workbook refresh results due to the formulas on other worksheets being evaluated in the current worksheet context<br />
Beta 0.7.11<br />
* FXLData: Bug fix to availability query to correctly set the format=sdmx-2.1 - resolves problem in Fusion Registry 11.0.0 where the query was being rejected with HTTP 406 due to invalid format specifier</div>Vmurrellhttps://wiki.sdmxcloud.org/index.php?title=Change_Log_FR_-_V11_and_subsequent_releases&diff=8230Change Log FR - V11 and subsequent releases2026-03-12T15:29:56Z<p>Vmurrell: </p>
<hr />
<div>[[Category:Fusion Registry Change Logs]]<br />
[[Category:ChangeLogFR]]<br />
__NOTOC__<br />
<br />
= H1.3.0.04_RFS_13.03.26 Released March 13, 2026 - Hotfix ==<br />
RFS-2518 - Bug Fix - If the git information was not present or the url was not readable the application was logging repeatedly an error when reading the product information.<br />
Support Reference - SUP-303838<br />
<br />
= H1.3.0.02_RFS_10.10.25 - Released on December 12, 2025 =<br />
RFS-1901 - Improvement - Performance improvements when computing complex aggregates for big data sets<br />
<br />
= H1.3.0.01_RFS_10.10.25 - Released on October 9, 2025 =<br />
RFS-1722 - Enhancement - Performance improvements to generation of temporary (MVS) files.<br />
<br />
= R1.3.0.00_RFS_29.08.25 - Released on August 29, 2025 =<br />
RFS-1516 - Enhancement - Publication Table Editor allows the user to add only 150 rows in order to ensure performance. The limit has been increased to 350<br />
<br />
RFS-1523 - Bug Fix - Publication Tables - content within a loop did not iterate through the full range of defined dimensions. This issue has been fixed.<br />
<br />
RFS-1461 - Bug Fix - Where an Oracle database was in use, it was possible to have duplicate email subscriptions stored causing multiple email notifications. This has been resolved by converting all email addresses to lower case with duplicates not allowed.<br />
<br />
RFS-1443 - Bug Fix - In Publication Tables, added footnotes sometimes appeared in the middle of the table when exporting the table in Excel format. A bug was fixed that was causing footnotes to be written to the middle of the table in Publication Tables when exported in Excel format.<br />
<br />
RFS-1439 - Bug Fix - Remove Footnote Note button in Publication tables was not operational.<br />
<br />
RFS-1380 - Bug Fix - Temporary .mvs file were not always being deleted resulting in unnecessary disk usage. Changes have been made to improve the handling of .mvs and other temporary files to ensure they are deleted as appropriate.<br />
<br />
RFS-1378 - Bug Fix - Issue with operations on the Input Stream throwing an NPE. This issue has been resolved.<br />
<br />
RFS-1326 - Bug Fix - It was observed that there was inconsistent structure rendering taking place on some API responses from Fusion Registry after the cache had been cleared from the registry. A targeted fix for this issue at the point of cache clearing was applied.<br />
<br />
RFS-1284 - Bug Fix - Delete Language button not working in Codelists. Issue resolved.<br />
<br />
RFS-1278 - Bug Fix - Email notifications feature sends emails with 'null' in the subject and email content. The system now uses the name 'Fusion Registry' when this is not set. <br />
<br />
RFS-1258 - Bug Fix - Fresh install of the Registry, install page is headed with "Fusion Registry 11 - Install" making this out of date with the current product name and version. The heading on the install pages on a fresh install of the Registry now reads "Fusion Registry".<br />
<br />
RFS-1256 Fusion Registry V10.9.11 - Bug Fix - Two email notifications for structure submission and structure deletion events were issued and emails in different casings were also creating two subscriptions with the same email in different casings. The system has been modified so only one notification is sent per structure submission or structure deletion event.<br />
<br />
RFS-1189 - Bug Fix - Data Formats - Inconsistent behaviour in formats that do not support multiple measures. Standard messaging implemented.<br />
<br />
RFS-1182 - Bug Fix - If a large number of Provision Agreements existed, the Home Page was slow to load. Changes were made to the way the Home Page loads which has significantly improved performance.<br />
<br />
= H1.2.0.03_RFS_12.03.25 (Released March 12, 2025) =<br />
RFS-1443 - Enhancement - Issue with the placement of footnotes within Publication Tables. Support Ticket 415617.<br />
<br />
RFS-1054 - Enhancement - Change requested to the Fusion CSV Flat data format. A new CSV data format was added. It can be referenced by adding format=csv-bis as a query parameter to the data query URL. The new format orders data by time period (i.e. 2020, 2020M1, 2020Q2, 2021, 2021Q2, 2021M2) and also permanently adds the series short code as a column (e.g. CHN:BT:EX).<br />
<br />
= H1.2.0.01_RFS_20.02.25 (Released February 20, 2025) =<br />
<br />
== Changes ==<br />
RFS-1378 - Bug Fix - Previously, an error could occur which caused an NPE. This has been addressed. Support Ticket - 411382.<br />
<br />
RFS-1326 - Bug Fix - Previously, it was observed that there was inconsistent structure rendering taking place on some API responses from Fusion Registry after the cache had been cleared. A targeted fix for this issue at the point of cache clearing was applied.<br />
<br />
RFS-1182 - Bug Fix - Previously, if a large number of Provision Agreements existed, the Home Page was slow to load. This has been addressed. Support Ticket - 355829 & 404512.<br />
<br />
= R1.1.2.00_RFS_31.01.25 (Released January 31, 2025) =<br />
== Changes ==<br />
{| class="wikitable"<br />
|-<br />
! Jira Ticket !! Type !! Description !! Solution<br />
|-<br />
| RFS-1044 || Enhancement|| Previously, Fusion Data Store would throw an exception when attempting to append new measures to existing observations, which was inconsistent with SQL data sources that support such appends. || Added the ability to append new measures to existing observations within the Fusion Data Store.<br />
|-<br />
| RFS-1211 || Enhancement || Update the default data formats from 2.1 to 3.0. || The default data format has been updated from *SDMX-Compact-2.1* to {*}SDMX-Compact-3.0{*}, which introduces support for multi-measures. The previous format is still available and can be accessed via the web service dropdown or by specifying the {{"format"}} parameter in the URL. The Quick Convert feature is still using SDMX-Compact-2.1 format, and will be changed according to the changes in open-source in the future.<br />
|-<br />
| RFS-1233 || Bug Fix || Display issues found on Chrome || Change required following Chromium update release in November 2024. [https://wiki.sdmxcloud.org/Data_Structure_issue_November_2024 more information here.]<br />
|-<br />
| RFS-682 || Change|| Issue with Validation schemes and OBS_VALUE data type setting. || Numeric values formatting changed to plain string, as validation was not correctly interpreting scientific notation.<br />
|-<br />
| RFS-705 || Change || Out of date branding in the Info area.|| Regnology branding now displayed in the Info area.<br />
|-<br />
| RFS-706 || Change || Out of date branding on the Home Page footer line. || Regnology branding now displayed in the footer.<br />
|-<br />
| RFS-79 || New Feature|| Web Services Data || New fields in Web Services Data page to allow the user to specify the period. [https://wiki.sdmxcloud.org/Web_Services_-_GUI_-_Data More information here]<br />
|-<br />
| RFS-844 ||Enhancement|| Introduction of Multiple Measures || [https://wiki.sdmxcloud.org/Support_for_Multiple_Measures Support for data, Phase A]<br />
|-<br />
| RFS907 || Enhancement|| New Feature|| Loading Structures. This option is now available on every page.<br />
|}<br />
<br />
[[File:RFS-ReleaseNotes-R1.2.0.00 RFS 30.01.25.pdf |Release Notes]]<br />
<br />
== R1.1.0.00_RFS_05.07.24 (Released 15.07.2024) ==<br />
<br />
This release was delivered by Regnology and the Version numbering has changed along with the ticket numbering system (RFS) used to display changes below. <br><br />
<br />
[[File:RFS-ReleaseNotes-R1.1.0.00 RFS 05.07.24 1 .pdf]]<br />
<br />
== Changes ==<br />
RFS-493 - Tableau Connector. [[Tableau_Connector | New connector released.]] This has resulted in behavioural changes for the Observational Value [[Tableau_Connector#Observation_Value | - more information available here.]]<br />
<br />
== Bug Fixes: ==<br />
<br />
RFS-580 - Web Services Query ] Problem with "completecube" parameter when using the Data Query Web Service when multiple values are provided. <br><br />
RFS-514 - Problem with Publication tables when series queries with wild cards present.<br><br />
RFS-436 - Web Services -Data - System unable to process large volumes of data when Excel Export selected resulting in a need to re-boot. This has been resolved by implemented the Series and Observation limit in the Admin -Server Settings - XLSX format. <br><br />
RFS-433 - Registry Managed Database - Temporary Table unavailable causing data load failure.<br><br />
RFS-287 - Download Structures - Warning message when trying to download non SDMX structures in SDMX format missing. Message implemented - JSON format should be used.<br><br />
<br />
==Version 11.13.0 (Released: 2024/02/08)==<br />
Based on FMR 11.14.1<br><br />
<br />
'''Change:'''<br><br />
RFS-22: Creating "flat CSV" no longer includes unecessary Sibling Group entries at the start of the file<br><br />
<br />
'''Improvements:'''<br><br />
RFS-181: Support for SDMX-ML v3.0 Data<br><br />
RFS-39: Update vulnerable third-party dependencies<br><br />
<br />
'''Bug Fixes:'''<br><br />
RFS-163: Data Web Service contains duplicate entry for "Excel"<br><br />
RFS-164: Data Web Service contains unstyled text label<br><br />
RFS-76: "lastUpdated" parameter not working correctly on Data Query for external databases<br><br />
<br />
==Version 11.12.3 (Released: 2023/11/24)==<br />
Based on FMR 11.13.0<br><br />
<br />
'''Bug Fix:'''<br><br />
FR11-217: Concurrent modification exception in cache<br />
<br />
==Version 11.12.2 (Released: 2023/11/22)==<br />
Based on FMR 11.13.0<br><br />
<br />
'''Change:'''<br><br />
FR11-216: REST query which results in no data now returns a 404 with an SDMX error message, was previously an empty dataset<br><br />
<br />
'''Bug Fix:'''<br><br />
FR11-215: Publication Tables: 'includePeriod' REST query parameter returns no data when multiple Dataflows are used and 1 has no data<br><br />
<br />
==Version 11.12.1 (Released: 2023/11/21)==<br />
Based on FMR 11.13.0<br><br />
<br />
'''Improvement:'''<br><br />
FR11-211: Improvements to the "Test Mapping" feature<br><br />
<br />
'''Bug Fix:'''<br><br />
FR11-214: Registry can consume all connections to an External Data Store<br><br />
<br />
==Version 11.12.0 (Released: 2023/11/20)==<br />
Based on FMR 11.13.0<br><br />
<br />
'''New Features:'''<br><br />
FR11-210: Publication Table: Calculation expression to support default value when no Observation found<br><br />
FR11-213: Publication Tables: Calculation expression to support default value if no reported value found<br><br />
<br />
'''Bug Fix:'''<br><br />
FR11-212: Publication Table: Formatting issue using partial keys - returns 400 exception<br><br />
<br />
==Version 11.11.0 (Released: 2023/11/03)==<br />
'''New Features:'''<br><br />
FR11-206: Create aggregate series using linked Hierarchy<br><br />
FR11-207: Data Query detail parameter; added 'raw' as a new value to support export of data with no calcualted values via hierarchical aggregations<br><br />
<br />
'''Bug Fixes:'''<br><br />
FR11-208: In a Generated Reporting Template permit format modification on Observation Cells<br><br />
FR11-209: Publication Table: Issue applying formatting rules across multiple Dataflows<br><br />
<br />
==Version 11.10.1 (Released: 2023/09/15)==<br />
'''Bug Fix:'''<br><br />
FR11-205: saveas=[filename].zip from v1 SDMX web service results in a corrupt zip<br><br />
<br />
==Version 11.10.0 (Released: 2023/09/11)==<br />
Based on FMR 11.10.1<br />
<br />
'''New Features:'''<br><br />
FR11-195: Publication Tables: Allow dependant variables to be overridden from the API<br><br />
FR11-197: Default response formats in v2 web service are now configurable<br><br />
FR11-203: Kafa: new topic to publish structure transaction events to<br><br />
FR11-204: Kafa: new topic to publish reference metadata events to<br><br />
<br />
'''Change:'''<br><br />
FR11-202: Structure Format response is no longer auto detected if not explicitly set (takes value from default setting)<br><br />
<br />
'''Improvement:'''<br><br />
FR11-198: Querying for data by observation attributes<br><br />
<br />
'''Bug Fixes:'''<br><br />
FR11-199: saveas=zip is not working on v2 API<br><br />
FR11-200: Publication table: Formatting cells ignores UNIT_MULT when it is reported as a dataset level attribute<br><br />
FR11-201: Publication table: Conditional Formatting being applied when condition references a Component which is not present in DSD<br><br />
<br />
==Version 11.9.6 (Released: 2023/08/25)==<br />
'''Changes:'''<br><br />
FR11-163: Validator: "Missing Attributes" renamed to "Missing Components" and reports on missing Measures<br><br />
FR11-164: Add "Output Required" UI control to Structure Mapping<br><br />
FR110188: Adding a observation formatting rule treats comma separeted component ids as an AND operator (was OR)<br><br />
<br />
'''Improvements:'''<br><br />
FR11-146: Update Apache POI to version 5<br><br />
FR11-147: Update Commons-fileupload third-party dependency<br><br />
FR11-148: Update Spring dependencies<br><br />
FR11-149: Update Jettison third-party dependency<br><br />
FR11-150: Web Service to refresh caches<br><br />
FR11-158: Merging a Codelist should merge Locale information<br><br />
FR11-160: Update Spring and Jackson Dependencies<br><br />
FR11-161: Implment caching on publication tables<br><br />
FR11-167: Improve Mapping functionality so that it can perform Validation<br><br />
FR11-171: Portal File system sweep - allow files to be placed in root of sweep directory<br><br />
FR11-173: Update Kryo to version 5.5.0<br><br />
FR11-174: Publication Tables - not formatting numbers with scientific notation<br><br />
FR11-175: Components with Time based Mappings cannot be edited in the Structure Map Wizard<br><br />
FR11-176: Support Custom Plugins<br><br />
FR11-190: Add SDMX-JSON v2 to the UI<br><br />
FR11-191: Restore Fusion Security as an authentication mechanism<br><br />
FR11-192: FMR#481: Duplicated group IDs for schema queries in SDMX-JSON<br><br />
FR11-193: Mapped Datasets Configuration - new option "Output Required"<br><br />
<br />
'''Bug Fixes:'''<br><br />
FR11-151: Item Validity not returning most recent entry prior to today's date<br><br />
FR11-152: Subscript out of range error with FusionXL when carriage return is in the name of a structure<br><br />
FR11-153: No transactions returned on SDMX Transactions page when using date slider<br><br />
FR11-155: Publicaiton Table Editor: Dependent Variables, remove variable button does not work<br><br />
FR11-156: Publication Table availabililty algorithm modified to better calculate default values when using multiple dataflows<br><br />
FR11-157: FusionXL resolve carriage returns in concept names<br><br />
FR11-159: Cross references not updated correctly when structure already exists<br><br />
FR11-162: Update Vulnerable Dependencies for FMR 11.7.0<br><br />
FR11-165: Validating Generic Data can result in IllegalElement error<br><br />
FR11-166: FMR#418 - Conversion and mapping services fail to read SDMX CSV 2.0 format files with BOM<br><br />
FR11-168: CSV-TS data format outputting names as labels does not output labels in last Dimension/Attribute column<br><br />
FR11-169: RegEx Capture Groups for Representation Map only support 0-9 (\10 and above does not work)<br><br />
<br />
==Version 11.9.5 (Released: 2023/03/08)==<br />
'''Change:'''<br><br />
FR11-140: Modification of interpration of SDMX-CSV V2 row https://github.com/bis-med-it/fmr/issues/349<br><br />
<br />
'''Improvement:'''<br><br />
FR11-145: Fusion Excel Export Data API now takes an additional 'attachment' parameter<br><br />
<br />
'''Bug Fixes:'''<br><br />
FR11-137: Removal of dependencies: gson, protobuf, closure, args4j<br><br />
FR11-138: Unable to load Structure File when Mapping refers to DSD with ValueList coded dimension https://github.com/bis-med-it/fmr/issues/359<br><br />
FR11-141: Caching in reference metadata requests https://github.com/bis-med-it/fmr/issues/356<br><br />
FR11-142: Parsing EDI fails to detect malformed period https://github.com/bis-med-it/fmr/issues/362<br><br />
FR11-143: EDI REL segment must be followed by ARR segment https://github.com/bis-med-it/fmr/issues/322<br><br />
FR11-144: Publication Table - Calculations which contain missing values should not output a value<br><br />
<br />
==Version 11.9.4 (Released: 2023/02/17)==<br />
'''Bug Fixes'''<br><br />
FR11-135: Publication Table - calculated values could come back as enginnering string when standard form is requested<br><br />
FR11-136: Regression mapped data store was not mapping rows with null attribute values<br><br />
<br />
==Version 11.9.3 (Released: 2023/02/16)==<br />
'''Bug Fixes:'''<br><br />
FR11-129: Temporary "MV" files not being cleared up after data transformation https://github.com/bis-med-it/fmr/issues/346 <br><br />
<br />
'''Improvements:'''<br><br />
FR11-131: Improve Performance of large Codelists which have Item Validity https://github.com/bis-med-it/fmr/issues/353 <br><br />
FR11-133: Improve linking to external datasource by auto detecting foreign key <br><br />
<br />
==Version 11.9.2 (Released: 2023/02/13)==<br />
'''Change:'''<br><br />
FR11-132: Supported 'latest' in v2 query to prevent errors in connected tools<br><br />
<br />
==Version 11.9.1 (Released: 2023/02/10)==<br />
'''Bug Fix:'''<br><br />
FR11-128: Security rule on OBS Attribute blocks observation when value is null<br><br />
<br />
==Version 11.9.0 (Released: 2023/02/03)==<br />
'''Improvements:'''<br><br />
FR11-117: Provide option to skip Validation phase in Transform Web Service https://github.com/bis-med-it/fmr/issues/237<br><br />
FR11-120: Publication Table - apply number formatting to calculated cells<br><br />
FR11-121: Publication Table - Apply number scaling before calculations<br><br />
<br />
'''Change:'''<br><br />
FR11-118: Use the public fastUtil library https://github.com/bis-med-it/fmr/issues/338<br><br />
<br />
'''Bug Fixes:'''<br><br />
FR11-116: Timezone issue with REST API resulting in no data<br><br />
FR11-119: Codelists with Annotations not being correctly parsed in SDMX-JSON https://github.com/bis-med-it/fmr/issues/345<br><br />
FR11-123: EDI should prevent Quadruplet attributes in Footnote Section https://github.com/bis-med-it/fmr/issues/347<br><br />
FR11-124: EDI file missing mandatory Period Information validates successfully https://github.com/bis-med-it/fmr/issues/348<br><br />
FR11-125: Improve validation of EDI DTM segment https://github.com/bis-med-it/fmr/issues/351<br><br />
FR11-126: Publication Table - decimal places (fixed) truncated trailing zero places when locale was also set<br><br />
FR11-127: Duplicate elements in SDMX CSV result in unexpected output https://github.com/bis-med-it/fmr/issues/342 <br><br />
<br />
==Version 11.8.2 (Released: 2023/01/17)==<br />
'''Improvements:'''<br><br />
FR11-108: Prevent contradictory excel mappings (generted from Fame Metadata Manager) worksheets being uploaded to Registry<br><br />
FR11-109: Flag contradictory excel mappings (generted from Fame Metadata Manager) in generated worksheet <br><br />
FR11-134: Improve Metrics Report with IncUnmappedReport option <br><br />
<br />
'''Changes:'''<br><br />
FR11-111: Change ID Generation of Representation Map from FusionFameMapper xlsx files.<br><br />
FR11-115: Ensure Implicit Mappings in Structure Maps validate codelists for valid intersection <br><br />
<br />
'''Bug Fixes:'''<br><br />
FR11-107: Parent codes should be included in reference partial<br><br />
FR11-110: Complete Cube web service feature outputs empty measure values (not 0 values)<br><br />
FR11-112: Data export formats excel-ts and excel-series can miss observations in output series if series contains observations with no measure values and no attribute values<br><br />
FR11-113: Fix 'too much recursion' error with reverse engineer data structure with large number of Dimensions<br><br />
FR11-114: Validate submission of Structure Map's Implicit mappings to ensure Coded mappings have a valid intersection from source to target <br><br />
<br />
==Version 11.8.1 (Released: 2023/01/11)==<br />
'''Bug Fixes:'''<br><br />
FR11-101: Unable to import Codelists with multiple levels of inheritence in same submission as structures that use inherited codes<br><br />
FR11-102: Bulk actions - detail=raw is ignored<br><br />
FR11-103: REST query: detail=raw is not applied to referenced codelists<br><br />
FR11-104: IncValid output may contain empty series when it should not be generated<br><br />
FR11-105: Annotations are ignored when importing 2.1 XML Hierarchical Codelists<br><br />
FR11-106: format=csv-series null pointer<br><br />
<br />
==Version 11.8.0 (Released: 2022/12/21)==<br />
'''Important Note for MySQL users:''' due to changes in the distribution of the MySQL connector (change FR11-94 below), please read [[Install_MySQL#Installing_MySQL_5.7|this article]].<br />
<br />
'''New Feature:'''<br><br />
FR11-98: Publication Table - support a scaling function applied to numerical observations<br />
<br />
'''Improvement:'''<br><br />
FR11-93: Improve Performance of Viewing a Hierarchy https://wiki.sdmxcloud.org/Publication_Table#Formatting_Numerical_Observation_Values<br />
<br />
'''Changes:'''<br><br />
FR11-91: Validation and Transformation should preserve original format unless output format specified <br><br />
https://wiki.sdmxcloud.org/Data_Validation_Web_Service#HTTP_Headers see Accept Header<br><br />
https://wiki.sdmxcloud.org/Data_Transformation_Web_Service#HTTP_Headers see Accept Header<br><br />
FR11-94: Remove MySQL Connector https://wiki.sdmxcloud.org/Install_MySQL#Installing_MySQL_5.7<br />
<br />
'''Bug Fixes:'''<br><br />
FR11-89: Support dataset attribute consolidation (detection of duplicates)<br><br />
FR11-90: Observation deletions are no longer written in EDI format<br><br />
FR11-92: NPE when publishing EDI data from Command Line<br><br />
FR11-95: Publication Table - UI changes table definition (looses column) when clicking preview table <br><br />
FR11-96: Publication Table - Preview table error when table heading Rowspan > 1<br><br />
FR11-97: Publication Table - bug fix on formatting obs which removed values from output table<br><br />
FR11-99: Publication Table - Scientific Notation shows NaN in UI and is not applied to observation values<br><br />
FR11-100: Refreshable workbook - issue security challenge when connecting to private server<br><br />
FMR11-207: Transforming Data with "Delete" action can leave erroneous output in EDI format<br><br />
FMR11-217: Publication Tables: Numerical Observation, "Add Rule" button does not work<br><br />
FMR11-224: Failure to report unmapped data when using TIME_PERIOD mapping<br><br />
<br />
==Version 11.7.2 (Released: 2022/11/22)==<br />
'''Change:'''<br><br />
FR11-84 - In SDMX CSV, SERIES_KEY and OBS_KEY will output with the quote marks around the whole key<br><br />
<br />
'''Bug Fixes:'''<br><br />
FR11-80 - Validation on Group ID should ignore case<br><br />
FR11-82 - Size of column in Portal Table not large enough to contain Data Source ID<br><br />
FR11-85 - When loading via Registry UI, Data file with Duplicate Series results in MV Store Error<br><br />
FR11-86 - Viewing a Representation Map has issue with "valid from" on Mappings<br><br />
<br />
==Version 11.7.1 (Released: 2022/11/15)==<br />
'''New Feature:'''<br><br />
FR11-83 - Support Categorise Publication Table via the UI<br><br />
<br />
==Version 11.7.0 (Released: 2022/11/11)==<br />
'''New Feature:'''<br><br />
FR11-78 - Publication Table Support Numerical Observation formatting<br><br />
<br />
'''Bug Fixes:'''<br><br />
FR11-79 - Fix an issue when "edi.datagroup.identifier" specified with value of asterisk<br><br />
FR11-80 - Validation on Group ID should ignore case<br><br />
FR11-81 - Data Portal - ESTAT Connector fix<br><br />
<br />
==Version 11.6.0 (Released: 2022/11/31)==<br />
'''New Features:'''<br><br />
FR11-76 - [[Audit_Web_Services#Search_Structure_Queries|Audit Structure Queries]]<br> <br />
FR11-77 - [[Audit_Web_Services#Search_Data_Queries|Audit Data Queries]]<br><br />
<br />
'''Improvements:'''<br><br />
FR11-75 - Support for extended UTF-8 characters https://github.com/MEDIT-Org/fmr/issues/297 <br> <br />
<br />
'''Change:'''<br><br />
FR11-65 - Update FontAwesome to use Version 6<br><br />
<br />
'''Bug Fixes:'''<br><br />
FR11-71 - Corrected issue with Dynamic Attributes<br><br />
FR11-72 - Version Drop-Down not Displayed when Selected Item on Page Load<br><br />
FR11-74 - Security Group Web Service does not output UTF-8 characters<br><br />
FR11-65 - Update Web Services "structure" page so the plus symbol is used for "latest"<br />
<br />
==Version 11.5.2 (Released: 2022/10/14)==<br />
'''New Feature:'''<br><br />
FMR11-194 - Publication Table - support casting dates more then once in same expression<br><br />
<br />
'''Improvement:'''<br><br />
FMR11-202 - Update dependencies: Hibernate, Spring-Kafka, Jettison and Jersey https://github.com/MEDIT-Org/fmr/issues/294<br><br />
<br />
'''Bug Fixes:'''<br><br />
FR11-66 - "Metadata Provider Scheme" not listed on Web Service -> Structures page<br> <br />
FR11-67 - "Metadata Provider Wizard" does not allow Providers to start with a numeric yet the SDMX Standard allows this<br> <br />
FR11-68 - "Metadata Provider Scheme" not listed on Cross References page<br> <br />
FR11-69 - Attaching Reference Metadata to Items in an item scheme fails to add link (cache issue)<br> <br />
FMR11-189 - Behaviour of web service resolving multiple Codelist inheritance with "details=raw" https://github.com/MEDIT-Org/fmr/issues/257<br><br />
FMR11-196 - Unable to read Excel Spreadsheet where all Frequencies are Formulas<br> <br />
FMR11-197 - Request for Codelist in SDMX-JSON, "details=raw", references="children" doesn't return children as raw https://github.com/MEDIT-Org/fmr/issues/257<br> <br />
FMR11-198 - Request for Codelist in SDMX-JSON, "details=raw", references="descendants" doesn't return descendants https://github.com/MEDIT-Org/fmr/issues/257<br> <br />
FMR11-199 - "Metadata Provider Scheme" not listed on Web Service -> Structures page <br> <br />
FMR11-200 - "Metadata Provider Wizard" does not allow Providers to start with a numeric yet the SDMX Standard allows this<br> <br />
FMR11-201 - "Metadata Provider Scheme" not listed on Cross References page <br> <br />
FMR11-203 - Attaching Reference Metadata to Items in an item scheme fails to add link (cache issue) <br> <br />
FMR11-205 - Version Number not Displayed when Selected Item on Page Load<br><br />
<br />
==Version 11.5.1.1 (Released: 2022/10/10)==<br />
'''Change:'''<br> <br />
FR11-73 - Modify SQL to ensure GMT Timezone is used<br><br />
<br />
==Version 11.5.1 (Released: 2022/10/05)==<br />
'''New Features:'''<br> <br />
FR11-60 - Publication Table - support casting dates more then once in same expression<br><br />
FR11-61 - orderMeasure web service parameter to sort observations by date asc/desc<br><br />
<br />
==Version 11.5.0 (Released: 2022/09/28)==<br />
'''New Features:'''<br> <br />
FMR11-187/FR11-53 - Support recovery of structure transactions from backup on installation [[Backup_and_Restore|FMRCL]] https://github.com/MEDIT-Org/fmr/issues/277 <br> <br />
FR11-52 - Support variable number of max arguments to a SQL IN statement<br> <br />
FR11-58 - Support import of datafile containing mulitple datasets<br><br />
<br />
'''Improvements:'''<br> <br />
FMR11-183 - Update dependencies https://github.com/MEDIT-Org/fmr/issues/277<br> <br />
FR11-48 - Update third-party dependencies: apache-jstl, commons-dcp2, joda-time, spring, tika-core<br> <br />
FR11-45 - Add Version Number to Provision Agreement Selector in Data Source Manager Modal<br> <br />
<br />
'''Bug Fixes:'''<br> <br />
FMR11-181/FR11-46 - SDMX CSV v 2.0 Data Format does not report its format https://github.com/MEDIT-Org/fmr/issues/110<br> <br />
FMR11-184/FR11-49 - Support '*' for structure type in REST API https://github.com/MEDIT-Org/fmr/issues/273<br> <br />
FMR11-185/FR11-51 - Failure on Compare Revision shows Stack Trace https://github.com/MEDIT-Org/fmr/issues/278<br> <br />
FMR11-186/FR11-55 - SDMX-JSON Writer not outputting DSD as stub https://github.com/MEDIT-Org/fmr/issues/274<br> <br />
FR11-50 - FameMapper code is creating Excel files in temporary storage which are not deleted<br> <br />
FR11-54 - EDI data not fully consolidated when publishing data via web service<br><br />
<br />
==Version 11.4.3 (Released: 2022/09/13)==<br />
'''New Features:'''<br> <br />
FMR11-174 - Publication Tables: Formatting of Missing Values support ObsValue=NaN https://github.com/MEDIT-Org/fmr/issues/253<br> <br />
FMR11-175 - Support Reading of Reference Metadata (with restrictions) in version 2.1 SDMX https://github.com/MEDIT-Org/fmr/issues/250<br> <br />
<br />
'''Improvement:'''<br> <br />
FMR11-182 - Modify ID generation strategy for importing Reference Metadata at v2.1<br> <br />
<br />
'''Bug Fixes:'''<br> <br />
FR11-39 - OBS_PRE_BREAK validation corrected<br> <br />
FR11-43 - SDMX DSD output may include invalid attribute "isMultiLingual"<br> <br />
FR11-44 - SQL Server does not delete temporary tables<br> <br />
FMR11-169 - SDMX CSV v1 Data Reader does not allow header fields (row 1) to be double quoted <br> <br />
FMR11-170 - Bulk Export - spelling mistake on Raw help text<br> <br />
FMR11-171 - Order of revisions not as expected<br> <br />
FMR11-176 - OBS_PRE_BREAK validation corrected<br> <br />
FMR11-178 - Quadruplet in EDI vs the other formats in the context of data consolidation or integration https://github.com/MEDIT-Org/fmr/issues/118<br> <br />
FMR11-179 - SDMX DSD output may include invalid attribute "isMultiLingual" https://github.com/MEDIT-Org/fmr/issues/255<br><br />
<br />
==Version 11.4.2 (Released: 2022/08/19)==<br />
'''Bug Fixes:'''<br><br />
FR11-30 - Fusion Security Manager will not accept AD group names longer than 30 characters<br><br />
FR11-34 - Updated third-party dependencies<br><br />
<br />
==Version 11.4.1 (Released: 2022/08/10)==<br />
'''Bug Fixes:'''<br><br />
FR11-21 - Issue loading data into SQL Server in Registry managed table <br />
FR11-26 - Bulk Export - spelling mistake on Raw help text<br><br />
FR11-27 - Order of revisions not as expected<br><br />
FR11-28 - JNDI Registry Managed Database - unable to load data<br><br />
FR11-25 - SDMX CSV v1 Data Reader does not allow header fields (row 1) to be double quoted<br><br />
<br />
==Version 11.4.0 (Released: 2022/07/22)==<br />
'''New Feature:'''<br><br />
FR11-18 - Support Reference Metadata https://wiki.sdmxcloud.org/Reference_Metadata<br><br />
<br />
'''Improvement:'''<br><br />
FMR11-146 - Dependency updates<br><br />
FMR11-159 - Add "Raw" option to Download structures and remove "Include internal settings"<br><br />
FMR11-160 - Allow a Concept Representation to be a ValueList<br><br />
<br />
'''Bug Fixes:'''<br><br />
FR11-14 - Issue loading Data Constraint with a Component element under Cube Region element<br><br />
FR11-17 - Attribute variable does not work in table heading<br><br />
FR11-19 - Increase max size of security group ID from 30 to 100 characters<br><br />
FMR11-162 - SERIES_KEY column should be reserved for series keys<br><br />
FMR11-161 - Issue loading Data Constraint with a Component element under Cube Region element<br><br />
FMR11-163 - Attribute variable does not work in table heading<br><br />
FMR11-166 - Duplicate attribute is not detected anymore in FMR<br><br />
FMR11-167 - Publication Table - Array Variables fail to save<br><br />
FMR11-168 - Error encountered whist attempting to deserialize structure<br><br />
<br />
==Version 11.3.0 (Released: 2022/07/06)==<br />
'''New Feature:'''<br> <br />
FR11-10/FMR11-153 - [[Synchronise_structural_metadata_between_environments|Environment Synchronisation - compare the structural metadata content with that from another Registry, push or pull changes]]<br />
<br />
'''Improvement:'''<br><br />
FMR11-158 - [[Publication_Table#Footnotes|Publication Table: Footnotes support]]<br />
<br />
'''Bug Fixes:'''<br><br />
FMR11-152 - Comma not being processed correctly in Web Service query for ItemBeans<br> <br />
FMR11-154 - Unexpected structure validation error from FMR<br><br />
FMR11-155 - Structure validation errors are not detected anymore in FMR<br><br />
FMR11-156 - v2 structure REST API does not support queries for multiple items using the comma syntax<br><br />
FMR11-157 - Typo in header of Representation Maps page<br><br />
<br />
==Version 11.2.0 (Released: 2022/06/27)==<br />
'''New Feature:'''<br><br />
[FMR11-150] Specify the validation and transformation behaviour when duplicate observations are found - [[Data_Transformation_Web_Service#HTTP_Headers|https://wiki.sdmxcloud.org/Data_Transformation_Web_Service#HTTP_Headers]]<br><br />
<br />
'''Bug Fixes:'''<br><br />
[FR11-3] Schema Query in structure format does not work<br><br />
[FR11-4] Fusion Cache ignoring parameters like normalise freq on V1 data queries<br><br />
[FR11-5] Data Point Security - allow rule against a series attribute value that does not exist in the dataset restricts all data<br><br />
[FR11-8] Comma not being processed correctly in Web Service query for ItemBeans<br><br />
[FMR11-141] Re-opening of Alternate Half year Issue<br><br />
[FMR11-143] TIME_FORMAT not being generated correctly<br><br />
[FMR11-144] Problem with Date data type when reverse engineering a DSD from a CSV dataset<br><br />
[FMR11-145] Problem with Description data type when reverse engineering a DSD from a CSV dataset<br><br />
[FMR11-147] DSD Wizard step 3 - not allowing Enumerated Representation <br><br />
[FMR11-148] Schema Query in Structure Format does not work<br><br />
<br />
'''Improvement:<br>'''<br />
[FMR11-140] Revert xsi:type=SiblingType, change the schema to output the Group as Sibling not SiblingType -<br />
<br />
==Version 11.1.0 (Released: 2022/06/01)==<br />
'''New Feature:'''<br><br />
[[Publication_Table|Publication Tables]]<br><br />
[FR-5130] [https://wiki.sdmxcloud.org/Publication_Table#Looping_Rows Publication Table - Support Dynamic Rows]<br><br />
[FR-5131] [https://wiki.sdmxcloud.org/Publication_Table#Formatting_Missing_Observations Publication Table - Format rules on cells with no data ]<br><br />
[FR-5132] [https://wiki.sdmxcloud.org/Publication_Table#Dependent_Dimension_Variable Publication Table - Rules to derive a Dimension Value from another Dimenison's value]<br><br />
[FR-5133] [https://wiki.sdmxcloud.org/Publication_Table#Anchor_Rows Publication Table - Option to output rows with no data ] <br><br />
[FR-5134] [https://wiki.sdmxcloud.org/Publication_Table_Web_Services#Materialise_Publication_Table Publication Table - Ouput Materialised Table in Excel ]<br><br />
<br />
'''Improvement:'''<br><br />
[FR-5129] - Support for MySQL 8 and above<br><br />
<br />
==Version 11.0.0 (Released: 2022/05/22)==<br />
'''Changes and New Features:'''<br><br />
* Change to the SDMX 3.0 information model as Fusion Registry’s internal metadata object model<br />
* SDMX 3.0 REST API support<br />
* Backward compatibility for SDMX 2.1 and 2.0 structures and formats<br />
* Backward compatibility with SDMX 2.1 REST API (REST API v1 specification)<br />
* Improved data and metadata access control<br />
* Granular control over admin rights<br />
* Fusion Portal – scheduled and on demand data and structure loads<br />
* Refreshable Excel data format<br />
* JNDI database connection option<br />
* Publication Tables - publish curated but dynamic user interactive web data tables that show precisely the statistics required even if they come from multiple different data sets<br />
<br />
'''Breaking Changes from Fusion Registry 10:'''<br><br />
* Change to the operating database schema - upgrading from Fusion Registry 10 to Fusion Registry 11 requires a fresh install and migration of the metadata, data and settings. A change has been made to the operating database schema. The upgrade process must be followed carefully when [https://wiki.sdmxcloud.org/Upgrading_from_FR_V10_to_FR_V11 upgrading to Version 11.]<br />
* Environment sync function temporarily removed.<br />
* The Metadata Reports function has been temporarily removed.<br />
* Fusion Security support deprecated - Active Directory and LDAP are the supported authentication services in Fusion Registry 11.<br />
* Content Security is no longer supported in Version 11, the functionality has been replaced by [https://wiki.sdmxcloud.org/Main_Page#Fusion_Security_Manager_Topics| Fusion Security Manager]<br />
* Structure Sets are replaced by Structure and Representation Maps.<br />
* Hierarchical Codelists are replaced by Hierarchies.</div>Vmurrellhttps://wiki.sdmxcloud.org/index.php?title=Release_Plans&diff=8229Release Plans2026-03-12T15:24:59Z<p>Vmurrell: </p>
<hr />
<div>__NOTOC__<br />
Please refer to the Change Log(s) and Release Notes for more detail.<br />
== H1.3.0.04_RFS_13.03.26 Released March 13, 2026 - Hotfix==<br />
<br />
* Enhancement to the aggregation functionality in FXL Data.<br />
* Fix to prevent spurious errors in the Registry log file.<br />
<br />
==P1.3.1.00_RFS_29.05.26 Estimated release date May 25, 2026 - Patch ==<br />
Contents to be confirmed.<br />
<br />
== R2.0.0.00_RFS_26.06.26 Estimated release date June 6, 2026 - Full Release ==<br />
<br />
===Fusion Registry ===<br />
* Upgrade from Spring 5 to Spring 7<br />
* Support pop up box introduced [[Support_Tab| read more]]<br />
* Database consistency checker web service [[Database_Consistency_Web_Service| read more]]<br />
* Semantic and Non-Semantic structure versions - ability to co-exist<br />
* Bulk Actions to include Hierarchy Associations<br />
* Loading structures - ability to skip invalid structures [[Load_Structures#Submitting_Invalid_Structures| read more]]<br />
<br />
===Fusion Data Browser ===<br />
* Implementation of loading indicator<br />
<br />
=== FXLData Enhancements ===<br />
* Introduction of login functionality<br />
* Introduction of System Properties reporter<br />
* Support for hierarchical structures in the query builder<br />
* Improved medium verbosity logging: limited to API request URLs and response codes<br />
* Alignment of result grid data order with selected codes in the query builder<br />
<br />
==P2.0.1.00_RFS_31.07.26 Estimated Release Date July 31, 2026 - Patch ==<br />
Contents to be confirmed.<br />
<br />
====Plus Miscellaneous bug fixes and minor enhancements, full details of which will be available in the Release Notes and Change Logs. ====</div>Vmurrellhttps://wiki.sdmxcloud.org/index.php?title=Release_Plans&diff=8228Release Plans2026-03-12T15:23:36Z<p>Vmurrell: </p>
<hr />
<div>__NOTOC__<br />
<br />
== H1.3.0.04_RFS_13.03.26 Released March 13, 2026 - Hotfix==<br />
<br />
* Enhancement to the aggregation functionality in FXL Data.<br />
* Fix to prevent spurious errors in the Registry log file.<br />
<br />
==P1.3.1.00_RFS_29.05.26 Estimated release date May 25, 2026 - Patch ==<br />
Contents to be confirmed.<br />
<br />
== R2.0.0.00_RFS_26.06.26 Estimated release date June 6, 2026 - Full Release ==<br />
<br />
===Fusion Registry ===<br />
* Upgrade from Spring 5 to Spring 7<br />
* Support pop up box introduced [[Support_Tab| read more]]<br />
* Database consistency checker web service [[Database_Consistency_Web_Service| read more]]<br />
* Semantic and Non-Semantic structure versions - ability to co-exist<br />
* Bulk Actions to include Hierarchy Associations<br />
* Loading structures - ability to skip invalid structures [[Load_Structures#Submitting_Invalid_Structures| read more]]<br />
<br />
===Fusion Data Browser ===<br />
* Implementation of loading indicator<br />
<br />
=== FXLData Enhancements ===<br />
* Introduction of login functionality<br />
* Introduction of System Properties reporter<br />
* Support for hierarchical structures in the query builder<br />
* Improved medium verbosity logging: limited to API request URLs and response codes<br />
* Alignment of result grid data order with selected codes in the query builder<br />
<br />
==P2.0.1.00_RFS_31.07.26 Estimated Release Date July 31, 2026 - Patch ==<br />
Contents to be confirmed.<br />
<br />
====Plus Miscellaneous bug fixes and minor enhancements, full details of which will be available in the Release Notes and Change Logs. ====</div>Vmurrellhttps://wiki.sdmxcloud.org/index.php?title=Main_Page&diff=8227Main Page2026-03-12T15:15:31Z<p>Vmurrell: /* Release Plans */</p>
<hr />
<div>{{DISPLAYTITLE:<span style="opacity:0;position:absolute;">{{FULLPAGENAME}}</span>}}<br />
__NOTOC__<br />
<span style="font-size:2.0rem;">Regnology Fusion Statistics Knowledge Base</span><br><br />
==SDMX Statistical Data Warehouse==<br />
<br />
Regnology Fusion Statistics is for central banks, international organisations, national statistics offices, development banks and regional statistics authorities who need an enterprise SDMX statistical data warehouse for storage of aggregated time series, data cataloguing and public dissemination. '''Reade more''' about SDMX here: [https://www.regnology.net/en/resources/regulatory-topics/sdmx/ What is SDMX?].<br />
<br />
Click here to see a visual representation of the [[Fusion_Registry_Core_Software_Stack|Fusion Registry Core Software Stack.]] Click here to read more about [[Fusion_Registry_Overview| Key Use Cases.]]<br />
<br />
== Release Plans ==<br />
<br />
[[Release_Plans| Click here to view our future plans for Regnology Fusion Statistics.]]<br />
.<br />
<br />
==What's new?==<br />
[[What%27s_new| Click here to access more information on changes implemented in Releases and Hot Fixes from January 2025 onwards.]]<br />
<br />
== How to download a new version==<br />
[[File:How to obtain a Release-aug-2025.pdf | Click here to download instructions on how to uses the delivery software.]]'''<br />
<br />
==Open Source Software (OSS) / Third Party Components==<br />
[[Open_Source_Software_(OSS)_/_Third_Party_Components|Click here for more details.]]<br />
<br />
==Components and Modules==<br />
Regnology Fusion Statistics consists of a number of modules centered on the Fusion Registry core data warehouse engine, including a secure high-performance data dissemination server and a configurable data explorer and analytics tool for data consumers and analysts. <br />
<br />
Fusion Registry has an integrated SDMX structural metadata registry that is 100% compatible with Fusion Metadata Registry.<br />
<br />
[[File:Modules-Oct23.png|900px]]<br />
<br />
==Fusion Registry Topics==<br />
SDMX statistical data engine and structural metadata registry. The main statistical engine for data collection, integration, processing, storage, query execution and time-series calculations. It provides an SDMX-compliant data and metadata REST API. The integrated SDMX structural metadata registry acts as the central repository, authoring and maintenance tool for all of the structures including Codelists, Concepts and Data Structure Definitions.<br />
<br />
{| class="wikitable"<br />
|-<br />
| [[:Fusion_Registry_Overview|'''Overview''']]|| What is Fusion Registry?<br />
|-<br />
| | [[Fusion_Registry_-_Install,_Update_and_Configure |''' Fusion Registry Install, Update and Configure ''']]|| How to install, update and configure the Registry <br />
|-<br />
| [[:Category:SDMX Structures|'''SDMX Structures''']]|| Detailed explanations of the main SDMX structural metadata artefacts <br />
|-<br />
| [[:Category:Structural Metadata|'''Structure Maintenance''']]|| How to maintain the SDMX Structures<br />
|-<br />
| [[:Category:Reference_Metadata|'''Reference Metadata''']] || Guidance on working with SDMX 3.0 reference metadata in Fusion Registry 11<br />
|-<br />
| [[:Category:How To|'''How to and other Features''']] || Guidance on specific tasks using Fusion Registry<br />
|-<br />
| [[:Category:SdmxDataFormat|'''Data Formats''']] || A description of supported Data Formats<br />
|-<br />
| [[:Category:RegistrySecurity|'''Security''']] || Authentication and Authorisation Features<br />
|-<br />
| [[:Category:WebService|'''Web Services''']] || Registry Web Services<br />
|-<br />
| [[:Category:ChangeLogFR|'''Change Logs''']] || Change Logs for Registry 11 and Registry 10<br />
|-<br />
| [[:Category:RetiredFunctionality|'''Retired Functionality''']] || Functionality no longer valid in V11<br />
|}<br />
<br />
==Fusion Portal Topics==<br />
Fusion Portal is a web application made up of HTML, JavaScript, Images, and CSS files. The Portal allows you to call data from SDMX Webservices and other sources which enables you to obtain data from the data provider and import it directly into Fusion Registry.<br />
<br />
{| class="wikitable"<br />
|-<br />
| [[:Category:Fusion_Portal_Install |'''Installation and Configuration''']]|| How to install and Configure the Data Portal<br />
|-<br />
| [[:Category:Data Portal Functions |'''How to and other Features''']] || Guidance on using Data Portal<br />
|-<br />
| [[:Category:CRON-DP |'''Cron''' ]] || Using Cron to schedule regular synchronisations<br />
|-<br />
| [[Portal_Web_Services|'''Web Services''']] || List of Web Services specific to the Data Portal<br />
|-<br />
| [[Change_Log_Fusion_Portal|'''Change Logs''']] || Change Logs for Fusion Portal<br />
|}<br />
<br />
==Fusion Security Manager Topics==<br />
Available in Fusion Registry 11, a user interface which allows authorisation and rules to be created which explicitly permit or deny a security group access to a resource. The default behaviour of is to make everything private. In order to make structures and data public, specific security rules must be defined to grant access.<br />
{| class="wikitable"<br />
|-<br />
| [[:Category:FSM_Install |'''Installation and Configuration''']]|| How to install and Configure Fusion Security Manager<br />
|-<br />
| [[Fusion_Security_Manager_(FR_V11) |'''How to and other Features''']] || Guidance on using Fusion Security Manager<br />
|-<br />
| [[Change_Log_Fusion_Security_Manager|'''Change Logs''']] || Change Logs for Fusion Security Manager.<br />
|}<br />
<br />
==Fusion Fame Mapper Topics ==<br />
Web tool for creating and maintaining Fusion Registry FAME to SDMX series mappings.<br />
{| class="wikitable"<br />
|-<br />
| [[:Category:FFM Install |'''Installation and Configuration''']]|| How to install and Configure Fusion Fame Mapper<br />
|-<br />
| [[Fusion_Fame_Mapper |'''How to and other Features''']] || Guidance on using Fame Mapper<br />
|-<br />
| [[Change_Log_Fusion_Fame_Mapper|'''Change Logs''']] || Change Logs for Fame Mapper<br />
|}<br />
<br />
==Fusion Data Browser Topics==<br />
Web tool for data consumers to explore the Fusion Registry data catalogue, create charts and tables, and download data.<br />
<br />
{| class="wikitable"<br />
|-<br />
| [[Fusion_Data_Browser |'''Overview ''']]|| What is Fusion Data Browser?<br />
|-<br />
| [[A_beginners_guide_to_Fusion_Data_Browser |'''Getting Started''']]|| Non-technical guide for using Fusion Data Browser<br />
|-<br />
| [[Anatomy_of_the_Data_Browser |'''Anatomy of the Data Browser''']]|| Technical guide detailing techniques and solutions<br />
|-<br />
| [[:Category:FDB Install and Configure |'''Installation and Configuration''']]|| How to install and Configure the Data Browser<br />
|-<br />
| [[:Category:Fusion Data Browser |'''How to and Functions''']] || Using Fusion Data Browser<br />
|-<br />
| [[Change_Log_Fusion_Data_Browser|'''Change Logs''']] || Change Logs for Fusion Data Browser<br />
|-<br />
| [[:Category:Fusion Registry Data Browser|'''Retired Functionality''']] || Functionality no longer available in V11<br />
|}<br />
<br />
==FusionXL Topics==<br />
FusionXL is an addin for Microsoft Excel which connects to a Fusion Registry server for both data and structure retrieval, and maintenance.<br />
{| class="wikitable"<br />
|-<br />
| [[FusionXL_Install|'''Installation''']] || How to Install Fusion XL and connect to a Fusion Registry server<br />
|-<br />
| [[Security in FXL |'''Security in FXL''']] || How to set up rules to apply to FusionXL from Version 11<br />
|-<br />
| [[FusionXL_DataBAuthor|'''Data Author''']] || Create datasets and load datasets for the purpose of data authoring, validation, conversion, and publishing<br />
|-<br />
| [[FusionXL_StructureExplorer|'''Structure Explorer''']] || Create, Retrieve and Modify Structures using the Excel Ribbon<br />
|-<br />
| [[FusionXL_Change_Log|'''Change Logs''']] || Change Logs for FusionXL<br />
|-<br />
| [[FusionXL_DataExplorer|'''Retired Functionality''']] || Functionality no longer available in V3<br />
|-<br />
|}<br />
<br />
==FXLData Topics==<br />
FusionXLData is an addin for Microsoft Excel which connects to a Fusion Registry server for exploring the data catalogue, and downloading data directly into a spreadsheet.<br />
<br />
'''In August 2025''' a major upgrade has taken place, click her to read [[FXLData_what%27s_new_in_R1.3%3F|about the changes and new features]]<br />
{| class="wikitable"<br />
|-<br />
| [[Overview_FXLData|'''Overview''']] || What is FXLData?<br />
|-<br />
| [[:Category:Getting_Started_FXLData|'''Getting Started''']] || How to download, install and configure FXLData<br />
|-<br />
| [[:Category:Functions Reference FXLData|'''Functions Reference''']] || How to use the Parameter functions in FXLData<br />
|-<br />
| [[FXLData_Wizard|'''Data Wizard''']] || using the ribbon tool to build and edit functions<br />
|-<br />
| [[:Category:How to and other features in FXLData | '''How to and other features''']] || How to use FXLData<br />
|-<br />
| [[Troubleshooting_-_FXLData|'''Troubleshooting''']] || How to resolve common problems<br />
|-<br />
| [[FXLData_Change_Log|'''Change Logs''']] || Change Logs for FXLData.<br />
<br />
|}<br />
<br />
==Fusion Edge Server Topics ==<br />
A light-weight high-performance data and metadata REST API server designed to be deployed in clusters in the DMZ or at the network edge for scalable, fault-tolerant public data dissemination use cases.<br />
{| class="wikitable"<br />
|-<br />
| [[Fusion_Edge_Server|'''Overview''']] || What is Fusion Edge Server?<br />
|-<br />
| [[:Category:FESInstall|'''Installation''']] || How to install Fusion Edge Server<br />
|-<br />
| [[Edge_Server_Environment|'''Environment''']] || Edge Server environment<br />
|-<br />
| [[Fusion_Edge_Compiler|'''Compiler''']] || Edge Server Compiler<br />
|-<br />
| [[Edge_Server_Data_Preperation_Web_Service|'''Web Services''']] || Data Preparation Web Services <br />
|-<br />
| [[:Category:How_to_FES|'''How to and Other Features''']] || Using Fusion Edge Server<br />
|-<br />
| [[:Category:ChangeLogFES|'''Change Logs''']] || Change Logs for Fusion Edge Server<br />
<br />
|}<br />
<br />
==Command Line Tools ==<br />
{| class="wikitable"<br />
|-<br />
| [[Fusion_Transformer|'''Fusion Transformer''']] || Fusion Transformer is a command-line application providing transformations between SDMX and GESMES data files and structure files.<br />
|-<br />
| [[Fusion_Registry_Command_Line|'''Fusion Registry Command Line''']] || Windows and Linux command line interface.<br />
A command line interface to Fusion Registry's REST API providing utility scripts for loading structures, data and metadata, validating data, exporting content and deleting content.<br />
|-<br />
| [[Backup_and_Restore|'''FMRCL''']] || Tool to assist with Backup up and Restoring Structures.<br />
|-<br />
|}<br />
==Database Recovery==<br />
{| class="wikitable"<br />
|-<br />
| [[Oracle_Schema_backup_on_AWS|'''Oracle Schema Backup and Restore on AWS''']] || Information on possible ways to backup and restore a DB schema using oracle tools <br />
|}</div>Vmurrellhttps://wiki.sdmxcloud.org/index.php?title=What%27s_new&diff=8226What's new2026-03-09T16:39:27Z<p>Vmurrell: </p>
<hr />
<div>==March 2026 R1.3.0.04 ==<br />
<br />
=== Compatibility ===<br />
<br />
[[File:H1.04 - compatability.png|800px]]<br />
<br />
==March 2026 R1.3.0.03==<br />
[[FXLData - New Functions |Please refer to this article which details the new functions introduced in FXLData version H1.3.0.03.]]<br />
<br />
=== Compatibility ===<br />
<br />
The components that have changed since H1.3.0.02 are<br />
* FXL Data<br />
* and Fusion Data Browser.<br />
Below is the complete list of Fusion Registry versions compatible with each other component for H1.3.0.03<br />
{| class="wikitable"<br />
|-<br />
! Module !! Version (s)<br />
|-<br />
| FXL Data || H1.3.0.02, H1.3.0.03<br />
|-<br />
| Fusion Data Browser|| H1.3.0.02, H1.3.0.03<br />
|-<br />
| Fusion Security Manager|| H1.3.0.02, H1.3.0.03<br />
|-<br />
| Fusion Portal|| H1.3.0.02, H1.3.0.03<br />
|-<br />
| Fusion FAME Mapper|| H1.3.0.02, H1.3.0.03<br />
|}<br />
<br />
==August 2025 - R1.3.00==<br />
[[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.]]<br />
<br />
==July 4, 2025 - H1.2.04==<br />
[[FXLData_Change_Log#H1.2.0.04_RFS_04.07.2025_.28Released_July_4.2C_2025.29 | Please see the change log for FXLData]]<br />
<br />
==March 12, 2025 - H1.2.03==<br />
[[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]]<br />
<br />
[[File:RFS-ReleaseNotes-H1.2.0.03 RFS 12.03.25.pdf |Release Notes]]<br />
<br />
==March 7, 2025 - H1.2.02==<br />
[[FXLData_Change_Log| Please see the change log for FXLData]]<br />
<br />
[[File:PDD - Enhanced Dataflow Selection Fusion Excel Data Wizard – English.pdf |Enhanced Dataflow selection in FXLData]]<br />
<br />
==February 20, 2025 - H1.2.01==<br />
[[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]]<br />
<br />
[[FXLData_Change_Log| Please see the change log for FXLData]]<br />
<br />
[[File:RFS-ReleaseNotes-H1.2.0.01 RFS 20.02.25 (1).pdf |Release Notes]]<br />
<br />
==January 30, 2025 - R1.2.0==<br />
<br />
[[Support for Multiple Measures| Support for Multiple Measures]]<br><br />
<br />
[[Web Services - GUI - Data| Web Services - GUI-Data - change to default SDMX version and ability to set a query period.]]<br />
<br />
[[File:RFS-ReleaseNotes-R1.2.0.00 RFS 30.01.25.pdf |Release Notes]]</div>Vmurrellhttps://wiki.sdmxcloud.org/index.php?title=File:H1.04_-_compatability.png&diff=8225File:H1.04 - compatability.png2026-03-09T16:38:16Z<p>Vmurrell: </p>
<hr />
<div></div>Vmurrellhttps://wiki.sdmxcloud.org/index.php?title=What%27s_new&diff=8224What's new2026-03-09T16:34:16Z<p>Vmurrell: </p>
<hr />
<div>==March 2026 R1.3.0.03==<br />
[[FXLData - New Functions |Please refer to this article which details the new functions introduced in FXLData version H1.3.0.03.]]<br />
<br />
=== Compatibility ===<br />
<br />
The components that have changed since H1.3.0.02 are<br />
* FXL Data<br />
* and Fusion Data Browser.<br />
Below is the complete list of Fusion Registry versions compatible with each other component for H1.3.0.03<br />
{| class="wikitable"<br />
|-<br />
! Module !! Version (s)<br />
|-<br />
| FXL Data || H1.3.0.02, H1.3.0.03<br />
|-<br />
| Fusion Data Browser|| H1.3.0.02, H1.3.0.03<br />
|-<br />
| Fusion Security Manager|| H1.3.0.02, H1.3.0.03<br />
|-<br />
| Fusion Portal|| H1.3.0.02, H1.3.0.03<br />
|-<br />
| Fusion FAME Mapper|| H1.3.0.02, H1.3.0.03<br />
|}<br />
<br />
==August 2025 - R1.3.00==<br />
[[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.]]<br />
<br />
==July 4, 2025 - H1.2.04==<br />
[[FXLData_Change_Log#H1.2.0.04_RFS_04.07.2025_.28Released_July_4.2C_2025.29 | Please see the change log for FXLData]]<br />
<br />
==March 12, 2025 - H1.2.03==<br />
[[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]]<br />
<br />
[[File:RFS-ReleaseNotes-H1.2.0.03 RFS 12.03.25.pdf |Release Notes]]<br />
<br />
==March 7, 2025 - H1.2.02==<br />
[[FXLData_Change_Log| Please see the change log for FXLData]]<br />
<br />
[[File:PDD - Enhanced Dataflow Selection Fusion Excel Data Wizard – English.pdf |Enhanced Dataflow selection in FXLData]]<br />
<br />
==February 20, 2025 - H1.2.01==<br />
[[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]]<br />
<br />
[[FXLData_Change_Log| Please see the change log for FXLData]]<br />
<br />
[[File:RFS-ReleaseNotes-H1.2.0.01 RFS 20.02.25 (1).pdf |Release Notes]]<br />
<br />
==January 30, 2025 - R1.2.0==<br />
<br />
[[Support for Multiple Measures| Support for Multiple Measures]]<br><br />
<br />
[[Web Services - GUI - Data| Web Services - GUI-Data - change to default SDMX version and ability to set a query period.]]<br />
<br />
[[File:RFS-ReleaseNotes-R1.2.0.00 RFS 30.01.25.pdf |Release Notes]]</div>Vmurrellhttps://wiki.sdmxcloud.org/index.php?title=Release_Plans&diff=8223Release Plans2026-03-09T13:36:31Z<p>Vmurrell: </p>
<hr />
<div>__NOTOC__<br />
<br />
== R2.0.0.00_RFS_26.06.26 estimated release date June 6, 2026 ==<br />
<br />
===Fusion Registry ===<br />
* Upgrade from Spring 5 to Spring 7<br />
* Support pop up box introduced [[Support_Tab| read more]]<br />
* Database consistency checker web service [[Database_Consistency_Web_Service| read more]]<br />
* Semantic and Non-Semantic structure versions - ability to co-exist<br />
* Bulk Actions to include Hierarchy Associations<br />
* Loading structures - ability to skip invalid structures [[Load_Structures#Submitting_Invalid_Structures| read more]]<br />
<br />
===Fusion Data Browser ===<br />
* Implementation of loading indicator<br />
<br />
=== FXLData Enhancements ===<br />
* Introduction of login functionality<br />
* Introduction of System Properties reporter<br />
* Support for hierarchical structures in the query builder<br />
* Improved medium verbosity logging: limited to API request URLs and response codes<br />
* Alignment of result grid data order with selected codes in the query builder<br />
<br />
<br />
====Plus Miscellaneous bug fixes and minor enhancements, full details of which will be available in the Release Notes and Change Logs. ====</div>Vmurrellhttps://wiki.sdmxcloud.org/index.php?title=Release_Plans&diff=8222Release Plans2026-02-25T17:21:11Z<p>Vmurrell: /* Fusion Registry */</p>
<hr />
<div>__NOTOC__<br />
== Version 26.2.0.00_RSH-FS_28.05.26 estimated release date May 28, 2026 ==<br />
<br />
===Fusion Registry ===<br />
* Upgrade from Spring 5 to Spring 7<br />
* Support pop up box introduced [[Support_Tab| read more]]<br />
* Database consistency checker web service [[Database_Consistency_Web_Service| read more]]<br />
* Semantic and Non-Semantic structure versions - ability to co-exist<br />
* Bulk Actions to include Hierarchy Associations<br />
* Loading structures - ability to skip invalid structures [[Load_Structures#Submitting_Invalid_Structures| read more]]<br />
<br />
===Fusion Data Browser ===<br />
* Implementation of loading indicator<br />
<br />
=== FXLData Enhancements ===<br />
* Introduction of login functionality<br />
* Introduction of System Properties reporter<br />
* Support for hierarchical structures in the query builder<br />
* Improved medium verbosity logging: limited to API request URLs and response codes<br />
* Alignment of result grid data order with selected codes in the query builder<br />
<br />
<br />
====Plus Miscellaneous bug fixes and minor enhancements, full details of which will be available in the Release Notes and Change Logs. ====</div>Vmurrellhttps://wiki.sdmxcloud.org/index.php?title=Release_Plans&diff=8221Release Plans2026-02-24T12:52:23Z<p>Vmurrell: /* Fusion Registry */</p>
<hr />
<div>__NOTOC__<br />
== Version 26.2.0.00_RSH-FS_28.05.26 estimated release date May 28, 2026 ==<br />
<br />
===Fusion Registry ===<br />
* Spring?<br />
* Support pop up box introduced [[Support_Tab| read more]]<br />
* Database consistency checker web service [[Database_Consistency_Web_Service| read more]]<br />
* Semantic and Non-Semantic structure versions - ability to co-exist<br />
* Bulk Actions to include Hierarchy Associations<br />
* Loading structures - ability to skip invalid structures [[Load_Structures#Submitting_Invalid_Structures| read more]]<br />
<br />
===Fusion Data Browser ===<br />
* Implementation of loading indicator<br />
<br />
=== FXLData Enhancements ===<br />
* Introduction of login functionality<br />
* Introduction of System Properties reporter<br />
* Support for hierarchical structures in the query builder<br />
* Improved medium verbosity logging: limited to API request URLs and response codes<br />
* Alignment of result grid data order with selected codes in the query builder<br />
<br />
<br />
====Plus Miscellaneous bug fixes and minor enhancements, full details of which will be available in the Release Notes and Change Logs. ====</div>Vmurrellhttps://wiki.sdmxcloud.org/index.php?title=Support_Tab&diff=8220Support Tab2026-02-24T12:44:55Z<p>Vmurrell: </p>
<hr />
<div>[[Category:How_To]]<br />
<br />
Due to be released in Version Version 26.2.0.00_RSH-FS_28.05.26, a new feature called the "Support Tab" will be introduced.<br />
<br />
This graphical control appears on the right-hand side of most pages within the Registry. When clicked, it opens a pop-up modal designed to provide users with guidance on addressing any issues they may encounter. The content op this modal can be set by the system administrators and it supports HTML. However it is restricted to a maximum of 4,000 characters and external images are not supported..<br />
<br />
==Appearance==<br />
After content is added to the Support Tab, a new control will be displayed on the right-hand side of most screens. Clicking it opens a modal containing the predefined content. Users can dismiss the modal by clicking anywhere outside of the modal or by pressing the Escape key on their keyboard. The content remains the same across all pages, as the Support Tab feature does not allow for page-specific text variations.<br />
<br />
[[File:SupportTab-Control.png|The Support Tab control|500px]]<br />
[[File:SupportTab-Modal.png|Sample contents of the Support Tab Modal|500px]]<br><br />
<br />
==Setting Content==<br />
<br />
The contents of the Support Tab can be set on the Registry settings page: Settings -> General Settings. Simply enter the text or HTML in the field labelled "Support Text" and click the "Apply Settings" button.<br />
<br />
[[File:SupportTab-Setting.png|Setting the content of the support tab|1000px]]</div>Vmurrellhttps://wiki.sdmxcloud.org/index.php?title=Load_Structures&diff=8219Load Structures2026-02-24T08:17:45Z<p>Vmurrell: /* Submitting Invalid Structures */</p>
<hr />
<div>[[Category:How_To]]<br />
=Overview=<br />
Structures can be loaded into the registry in a number of ways but first you have to have some to load. If you already have structures to load, please skip to the '''Loading Structures''' Section below.<br />
<br />
=Obtaining Structures=<br />
<br />
All structures must be compliant with the SDMX Standard. <br />
<br />
Whilst you can easily create Structure from scratch, there are a number of other options available.<br />
<br />
==Using Export Structures options in another Registry==<br />
Please see this article [[Using_Bulk_Actions_to_Export_Structures|which explains how to do this]].<br />
<br />
==Using Web Services option in another Registry==<br />
Structures can be obtained using the Web Service option from another Registry. The image below shows the Demo Site with Web Services and Structure selected.<br />
<br />
[[File:LS1.png|Web Service Page in metadata Technology's Demo site|1000px]]<br><br />
<br />
You can use the selection boxes to define what you want and then you can either download the structures OR copy the URL to use when uploading.<br />
<br />
==Using Environmental Sync==<br />
<br />
See this article [[Synchronise_structural_metadata_between_FMR_environments|for more information on how to do this]].<br />
<br />
=Loading Structures=<br />
<br />
==Before you start==<br />
* To Load a Structure(s) you do need to be logged in to the Registry.<br />
* To successfully load a Structure make sure that the owning Agency already exists (select '''Organisation''' from the main menu then '''Agencies''').<br />
<br />
==Loading a Structure==<br />
On most pages of the Registry, at the top right of the page you will see the Load Structures button (as long as you are logged in).<br />
<br />
[[File:LS0.png|200px]]<br><br />
<br />
Once this button is clicked the Upload option will open as shown in the image below.<br />
<br />
[[File:LS2.png|Loading using a File|400px]]<br><br />
<br />
Either search for and a select file (individual files or Zip files can be used) using Windows Explorer '''OR''' select the URL button which will display an additional field for you to enter a URL location of the structure. <br />
<br />
See the [[Load_Structures#Using_Web_Services_option_in_another_Registry|Web Services]] option above for more details on how to obtain an appropriate URL as shown in the example below.<br />
<br />
[[File:LS3.png|Loading using an URL|400px]]<br><br />
<br />
==Import Actions==<br />
<br />
Before the structures are imported you have further options available:<br />
===Append===<br />
A structure file loaded with action 'Append' may only add new structures and may not overwrite any existing structures.<br />
<br />
===Replace===<br />
A structure file loaded with action 'Replace' may add new structures to the Registry, and can also replace existing structures with new ones. Replace is the default selection.<br />
<br />
===Merge=== <br />
A structure file loaded with action 'Merge' may add new structures and replace existing structures - however for [[Item_Scheme|Item Schemes]] (Codelists, Concept Schemes, Agency Schemes, Data Provider Schemes) the items submitted will be added to the existing scheme. For example if a Codelist exists with Codes A, B, and C, and the same Codelist is submitted with Codes B and X, then the resulting Codelist will have Codes A, B, C, X - the Merge submission has Replaced Code B and Added code X to the Codelist.<br />
<br />
===Full Replace===<br />
A structure file loaded with action 'Full Replace' will remove all existing structures from the Registry and replace them with the contents of the loaded file. This is a useful feature when you are copying structures from one environment to another.<br />
<br />
==Upload Successful==<br />
Once the import process has finished, you will see a Submission report as shown in the example below. You can also '''Abort''' the process from here.<br />
<br />
[[File:LS4.png|Submission Report|400px]]<br><br />
<br />
If you '''Confirm''' the structure will be loaded into the relevant area where you can view and edit it.<br />
<br />
'''Note''': if you are uploading a large number of Structures it can take a little while before the structures are visible. A good way of checking is to Navigate to the bulk Actions page.<br />
<br />
==Upload Unsuccessful==<br />
If for whatever reason the upload fails, you will be presented with an error message advising you what the problem was, similar to the one shown below.<br />
<br />
[[File:LS5.png|Example Error Message|1000px]]<br><br />
<br />
==Submitting Invalid Structures==<br />
From Version 26.2.0.00_RSH-FS_28.05.26, by default the Upload functionality will "skip" structures that are deemed to be invalid. The advantage of this is that if a structure file containing invalid structures is submitted, the valid structures can be submitted to the Registry without the invalid structures preventing this. There are 2 types of invalidity check performed in the FMR:<br />
<br />
* Missing cross-references - where a structure refers to another structure that does not exist in either the Registry, nor the structure file itself.<br />
* Failing business validation - where a structure is invalid against the schema. For example, submitting partial structures, or the submission of a DataConstraint with Role specified as 'Actual' which is not supported.<br />
<br />
Structures that are not covered by this are structures that cannot be constructed from the submitted file, for example due to invalid XML.<br />
<br />
When a structure file is submitted with invalid structures, the submission report is shown as usual, along with a warning message and an extra button is also displayed ('View Invalid Structures'). Clicking this button will display a modal stating the structures that have failed validation and their reason for failure.<br />
<br />
Please remember that the Registry enforces structural integrity and if a valid structure is invalidated by one of its descendants, it can not be loaded and will be deemed invalid. For example: a Dataflow that refers to a Data Structure that refers to a Concept Scheme which has an invalid reference (e.g. a Concept refers to a Codelist that does not exist), the Registry will prevent any of those structures being loaded. All failing structures would be listed in the validation report. This is illustrated in the example below, where a structure file was loaded which contains 2 Codelists, 3 Concept Schemes, 1 DataStructure and 1 Dataflow. One of the Concept Schemes references an invalid Codelist which is referenced by the DataStructure and Dataflow, thus these structures are not considered valid and can not be loaded until a change is made to the Concept Scheme with the invalid reference.<br />
<br />
[[File:SubmissionWithWarnings.png|Submission with structures failing validation|400px]]<br />
[[File:FailingValidation.png|List of structures that have failed validation|652px]]<br><br />
<br />
===Common Problems===<br />
* No change detected from the structure already present<br />
* Incorrect file type<br />
* Owning Agency not present</div>Vmurrellhttps://wiki.sdmxcloud.org/index.php?title=File:FailingValidation.png&diff=8218File:FailingValidation.png2026-02-24T08:17:24Z<p>Vmurrell: </p>
<hr />
<div></div>Vmurrellhttps://wiki.sdmxcloud.org/index.php?title=File:SubmissionWithWarnings.png&diff=8217File:SubmissionWithWarnings.png2026-02-24T08:16:34Z<p>Vmurrell: </p>
<hr />
<div></div>Vmurrellhttps://wiki.sdmxcloud.org/index.php?title=Load_Structures&diff=8216Load Structures2026-02-24T08:14:09Z<p>Vmurrell: </p>
<hr />
<div>[[Category:How_To]]<br />
=Overview=<br />
Structures can be loaded into the registry in a number of ways but first you have to have some to load. If you already have structures to load, please skip to the '''Loading Structures''' Section below.<br />
<br />
=Obtaining Structures=<br />
<br />
All structures must be compliant with the SDMX Standard. <br />
<br />
Whilst you can easily create Structure from scratch, there are a number of other options available.<br />
<br />
==Using Export Structures options in another Registry==<br />
Please see this article [[Using_Bulk_Actions_to_Export_Structures|which explains how to do this]].<br />
<br />
==Using Web Services option in another Registry==<br />
Structures can be obtained using the Web Service option from another Registry. The image below shows the Demo Site with Web Services and Structure selected.<br />
<br />
[[File:LS1.png|Web Service Page in metadata Technology's Demo site|1000px]]<br><br />
<br />
You can use the selection boxes to define what you want and then you can either download the structures OR copy the URL to use when uploading.<br />
<br />
==Using Environmental Sync==<br />
<br />
See this article [[Synchronise_structural_metadata_between_FMR_environments|for more information on how to do this]].<br />
<br />
=Loading Structures=<br />
<br />
==Before you start==<br />
* To Load a Structure(s) you do need to be logged in to the Registry.<br />
* To successfully load a Structure make sure that the owning Agency already exists (select '''Organisation''' from the main menu then '''Agencies''').<br />
<br />
==Loading a Structure==<br />
On most pages of the Registry, at the top right of the page you will see the Load Structures button (as long as you are logged in).<br />
<br />
[[File:LS0.png|200px]]<br><br />
<br />
Once this button is clicked the Upload option will open as shown in the image below.<br />
<br />
[[File:LS2.png|Loading using a File|400px]]<br><br />
<br />
Either search for and a select file (individual files or Zip files can be used) using Windows Explorer '''OR''' select the URL button which will display an additional field for you to enter a URL location of the structure. <br />
<br />
See the [[Load_Structures#Using_Web_Services_option_in_another_Registry|Web Services]] option above for more details on how to obtain an appropriate URL as shown in the example below.<br />
<br />
[[File:LS3.png|Loading using an URL|400px]]<br><br />
<br />
==Import Actions==<br />
<br />
Before the structures are imported you have further options available:<br />
===Append===<br />
A structure file loaded with action 'Append' may only add new structures and may not overwrite any existing structures.<br />
<br />
===Replace===<br />
A structure file loaded with action 'Replace' may add new structures to the Registry, and can also replace existing structures with new ones. Replace is the default selection.<br />
<br />
===Merge=== <br />
A structure file loaded with action 'Merge' may add new structures and replace existing structures - however for [[Item_Scheme|Item Schemes]] (Codelists, Concept Schemes, Agency Schemes, Data Provider Schemes) the items submitted will be added to the existing scheme. For example if a Codelist exists with Codes A, B, and C, and the same Codelist is submitted with Codes B and X, then the resulting Codelist will have Codes A, B, C, X - the Merge submission has Replaced Code B and Added code X to the Codelist.<br />
<br />
===Full Replace===<br />
A structure file loaded with action 'Full Replace' will remove all existing structures from the Registry and replace them with the contents of the loaded file. This is a useful feature when you are copying structures from one environment to another.<br />
<br />
==Upload Successful==<br />
Once the import process has finished, you will see a Submission report as shown in the example below. You can also '''Abort''' the process from here.<br />
<br />
[[File:LS4.png|Submission Report|400px]]<br><br />
<br />
If you '''Confirm''' the structure will be loaded into the relevant area where you can view and edit it.<br />
<br />
'''Note''': if you are uploading a large number of Structures it can take a little while before the structures are visible. A good way of checking is to Navigate to the bulk Actions page.<br />
<br />
==Upload Unsuccessful==<br />
If for whatever reason the upload fails, you will be presented with an error message advising you what the problem was, similar to the one shown below.<br />
<br />
[[File:LS5.png|Example Error Message|1000px]]<br><br />
<br />
===Submitting Invalid Structures===<br />
From Version 26.2.0.00_RSH-FS_28.05.26, by default the Upload functionality will "skip" structures that are deemed to be invalid. The advantage of this is that if a structure file containing invalid structures is submitted, the valid structures can be submitted to the Registry without the invalid structures preventing this. There are 2 types of invalidity check performed in the FMR:<br />
<br />
* Missing cross-references - where a structure refers to another structure that does not exist in either the Registry, nor the structure file itself.<br />
* Failing business validation - where a structure is invalid against the schema. For example, submitting partial structures, or the submission of a DataConstraint with Role specified as 'Actual' which is not supported.<br />
<br />
Structures that are not covered by this are structures that cannot be constructed from the submitted file, for example due to invalid XML.<br />
<br />
When a structure file is submitted with invalid structures, the submission report is shown as usual, along with a warning message and an extra button is also displayed ('View Invalid Structures'). Clicking this button will display a modal stating the structures that have failed validation and their reason for failure.<br />
<br />
Please remember that the Registry enforces structural integrity and if a valid structure is invalidated by one of its descendants, it can not be loaded and will be deemed invalid. For example: a Dataflow that refers to a Data Structure that refers to a Concept Scheme which has an invalid reference (e.g. a Concept refers to a Codelist that does not exist), the Registry will prevent any of those structures being loaded. All failing structures would be listed in the validation report. This is illustrated in the example below, where a structure file was loaded which contains 2 Codelists, 3 Concept Schemes, 1 DataStructure and 1 Dataflow. One of the Concept Schemes references an invalid Codelist which is referenced by the DataStructure and Dataflow, thus these structures are not considered valid and can not be loaded until a change is made to the Concept Scheme with the invalid reference.<br />
<br />
[[File:SubmissionWithWarnings.png|Submission with structures failing validation|400px]]<br />
[[File:FailingValidation.png|List of structures that have failed validation|652px]]<br><br />
<br />
<br />
<br />
===Common Problems===<br />
* No change detected from the structure already present<br />
* Incorrect file type<br />
* Owning Agency not present</div>Vmurrellhttps://wiki.sdmxcloud.org/index.php?title=Release_Plans&diff=8215Release Plans2026-02-23T14:56:49Z<p>Vmurrell: /* Fusion Registry */</p>
<hr />
<div>__NOTOC__<br />
== Version 26.2.0.00_RSH-FS_28.05.26 estimated release date May 28, 2026 ==<br />
<br />
===Fusion Registry ===<br />
* Spring?<br />
* Support pop up box introduced [[Support_Tab| read more]]<br />
* Database consistency checker web service [[Database_Consistency_Web_Service| read more]]<br />
* Semantic and Non-Semantic structure versions - ability to co-exist<br />
* Bulk Actions to include Hierarchy Associations<br />
* Loading structures - ability to skip invalid structures<br />
<br />
===Fusion Data Browser ===<br />
* Implementation of loading indicator<br />
<br />
=== FXLData Enhancements ===<br />
* Introduction of login functionality<br />
* Introduction of System Properties reporter<br />
* Support for hierarchical structures in the query builder<br />
* Improved medium verbosity logging: limited to API request URLs and response codes<br />
* Alignment of result grid data order with selected codes in the query builder<br />
<br />
<br />
====Plus Miscellaneous bug fixes and minor enhancements, full details of which will be available in the Release Notes and Change Logs. ====</div>Vmurrellhttps://wiki.sdmxcloud.org/index.php?title=Database_Consistency_Web_Service&diff=8214Database Consistency Web Service2026-02-23T14:52:43Z<p>Vmurrell: Created page with "Category:WebService =Overview= The Registry (Version 11), stores maintainable structures in a number of forms within its database. It is extremely unlikely that these form..."</p>
<hr />
<div>[[Category:WebService]]<br />
=Overview=<br />
The Registry (Version 11), stores maintainable structures in a number of forms within its database. It is extremely unlikely that these formats become inconsistent, but a mechanism exists to check that the various formats are consistent. This mechanism is a simple Web Service that can be invoked by any user with administration privileges. This Web Service is available in Version 26.2.0.00_RSH-FS_28.05.26 and later.<br />
<br />
==Detail==<br />
The Fusion Metadata Registry stores structure metadata in the following tables:<br />
* '''registry_maintainable_ser''': this table stores the Java serialised form of each individual metadata structure. There serialised objects are loaded on application startup, since it is faster than constructing a new Java object from the XML.<br />
* '''registry_maintainable_sdmx''': this table stores the SDMX-ML form of the individual metadata structure. This table is a backup for the "serialised" table. If an structure cannot be deserialsed, then the structure is obtained from this table.<br />
* '''tx_backup''': this table stores the SDMX-ML form of structures, grouped together by the transaction they were submitted within rather than storing each structure individually.<br />
<br />
When a new structure is submitted, or an existing structure is modified, each of the above 3 tables will be updated.<br />
<br />
==Check Database Consistency Web Service==<br />
{| class="wikitable"<br />
|-<br />
|style="background-color:#eaecf0"|<b>Entry Point</b>|| <b> /ws/secure/structure/databaseconsistency</b><br />
|-<br />
|style="background-color:#eaecf0"|<b>Access</b>|| <span style='color:green'><b>Secure</b></span><br />
|-<br />
|style="background-color:#eaecf0"|<b>Http Method</b>|| GET<br />
|-<br />
|style="background-color:#eaecf0"|<b>Response Format</b>|| JSON<br />
|-<br />
|style="background-color:#eaecf0"|<b>Response Statuses</b>|| <p><b>200</b> - Success</p><br />
<p><b>400</b> - Unauthorized</p><br />
|}<br />
<br />
Note: Because the service has to communicate with the database, it may take a while to run. The time taken depends upon the speed of connection to the database and the number of structural metadata within your Registry. If you wish to see the progress of the Web Service inspect the Fusion Registry log. The process will write a number of log statements (at INFO level) which will state the number of the current item being checked, along with the total number of items to process. <br />
<br />
==Example Output==<br />
The Web Service produces JSON output stating the following:<br />
* is the database consistent<br />
* the number of maintainables that were checked<br />
* a JSON Array listing the URNs of Maintainable Structures that differ in the table 'registry_maintainable_sdmx'<br />
* a JSON Array listing the URNs of Maintainable Structures that differ in the table 'tx_backup'<br />
<br />
An example of the full output:<br />
<pre><br />
{<br />
"Consistency": false,<br />
"MaintainablesChecked": 2053,<br />
"DifferingSdmx": [<br />
"[]"<br />
],<br />
"DifferingTxn": [<br />
"[urn:sdmx:org.sdmx.infomodel.codelist.Codelist=SDMX:AAA(1.0)]"<br />
]<br />
}<br />
</pre><br />
<br />
This shows that the database is not consistent, and that 2,053 items were checked. Since the field 'DifferingSdmx' has an empty JSON array, the items in the table 'registry_maintainable_sdmx' do not differ to the metadata in memory. The field 'DifferingTxn" has a JSON array containing a single URN for the codelist SDMX:AAA(1.0). This means that the codelist stored in the table 'tx_backup' is not consistent with the codelist held in memory.<br />
<br />
To determine what the differences are, please refer to the log file of the Registry. An example of output stating the difference is:<br />
<br />
WARN qtp258754732-94 io.sdmx.core.fmr.manager.report.DatabaseConsistencyChecker - Difference exists for : urn:sdmx:org.sdmx.infomodel.codelist.Codelist=SDMX:AAA(1.0)<br />
WARN qtp258754732-94 io.sdmx.core.fmr.manager.report.DatabaseConsistencyChecker - [EDIT,urn:sdmx:org.sdmx.infomodel.codelist.Codelist=SDMX:AAA(1.0),Name,AAA,AAA-Updated]<br />
<br />
This shows that for this codelist, there is a difference ('EDIT') for the property ''''Name'''' and that in memory the codelist name is ''''AAA'''' but in the database it is stored as ''''AAA-Updated''''.<br />
<br />
==Examples==<br />
An example of the consistency checker being invoked:<br />
<br />
https://example.registry.com/ws/secure/structure/databaseconsistency<br />
<br />
==Known Issues==<br />
If your system has codelists which use inheritance to inherit from other codelists, you may receive reports stating that differences exists. This is a known issue and will be addressed in a later release.</div>Vmurrellhttps://wiki.sdmxcloud.org/index.php?title=Support_Tab&diff=8213Support Tab2026-02-21T14:12:56Z<p>Vmurrell: </p>
<hr />
<div>[[Category:How_To]]<br />
<br />
Due to be released in Version Version 26.2.0.00_RSH-FS_28.05.26, a new feature called the "Support Tab" will be introduced.<br />
<br />
This graphical control appears on the right-hand side of most pages within the Registry. When clicked, it opens a pop-up modal designed to provide users with guidance on addressing any issues they may encounter. The content op this modal can be set by the system administrators and it supports HTML. However it is restricted to a maximum of 4,000 characters.<br />
<br />
==Appearance==<br />
After content is added to the Support Tab, a new control will be displayed on the right-hand side of most screens. Clicking it opens a modal containing the predefined content. Users can dismiss the modal by clicking anywhere outside of the modal or by pressing the Escape key on their keyboard. The content remains the same across all pages, as the Support Tab feature does not allow for page-specific text variations.<br />
<br />
[[File:SupportTab-Control.png|The Support Tab control|500px]]<br />
[[File:SupportTab-Modal.png|Sample contents of the Support Tab Modal|500px]]<br><br />
<br />
==Setting Content==<br />
<br />
The contents of the Support Tab can be set on the Registry settings page: Settings -> General Settings. Simply enter the text or HTML in the field labelled "Support Text" and click the "Apply Settings" button.<br />
<br />
[[File:SupportTab-Setting.png|Setting the content of the support tab|1000px]]</div>Vmurrellhttps://wiki.sdmxcloud.org/index.php?title=Release_Plans&diff=8212Release Plans2026-02-21T12:26:40Z<p>Vmurrell: /* Fusion Registry */</p>
<hr />
<div>__NOTOC__<br />
== Version 26.2.0.00_RSH-FS_28.05.26 estimated release date May 28, 2026 ==<br />
<br />
===Fusion Registry ===<br />
* Spring?<br />
* Support pop up box introduced [[Support_Tab| read more]]<br />
* Database consistency checker web service<br />
* Semantic and Non-Semantic structure versions - ability to co-exist<br />
* Bulk Actions to include Hierarchy Associations<br />
* Loading structures - ability to skip invalid structures<br />
<br />
===Fusion Data Browser ===<br />
* Implementation of loading indicator<br />
<br />
=== FXLData Enhancements ===<br />
* Introduction of login functionality<br />
* Introduction of System Properties reporter<br />
* Support for hierarchical structures in the query builder<br />
* Improved medium verbosity logging: limited to API request URLs and response codes<br />
* Alignment of result grid data order with selected codes in the query builder<br />
<br />
<br />
====Plus Miscellaneous bug fixes and minor enhancements, full details of which will be available in the Release Notes and Change Logs. ====</div>Vmurrellhttps://wiki.sdmxcloud.org/index.php?title=Release_Plans&diff=8211Release Plans2026-02-21T12:24:18Z<p>Vmurrell: /* FXLData Enhancements */</p>
<hr />
<div>__NOTOC__<br />
== Version 26.2.0.00_RSH-FS_28.05.26 estimated release date May 28, 2026 ==<br />
<br />
===Fusion Registry ===<br />
* Spring?<br />
* Support pop up box introduced<br />
* Database consistency checker web service<br />
* Semantic and Non-Semantic structure versions - ability to co-exist<br />
* Bulk Actions to include Hierarchy Associations<br />
* Loading structures - ability to skip invalid structures<br />
<br />
===Fusion Data Browser ===<br />
* Implementation of loading indicator<br />
<br />
=== FXLData Enhancements ===<br />
* Introduction of login functionality<br />
* Introduction of System Properties reporter<br />
* Support for hierarchical structures in the query builder<br />
* Improved medium verbosity logging: limited to API request URLs and response codes<br />
* Alignment of result grid data order with selected codes in the query builder<br />
<br />
<br />
====Plus Miscellaneous bug fixes and minor enhancements, full details of which will be available in the Release Notes and Change Logs. ====</div>Vmurrellhttps://wiki.sdmxcloud.org/index.php?title=Release_Plans&diff=8210Release Plans2026-02-21T12:22:27Z<p>Vmurrell: /* Version 26.2.0.00_RSH-FS_28.05.26 estimated release date May 28, 2026 */</p>
<hr />
<div>__NOTOC__<br />
== Version 26.2.0.00_RSH-FS_28.05.26 estimated release date May 28, 2026 ==<br />
<br />
===Fusion Registry ===<br />
* Spring?<br />
* Support pop up box introduced<br />
* Database consistency checker web service<br />
* Semantic and Non-Semantic structure versions - ability to co-exist<br />
* Bulk Actions to include Hierarchy Associations<br />
* Loading structures - ability to skip invalid structures<br />
<br />
===Fusion Data Browser ===<br />
* Implementation of loading indicator<br />
<br />
=== FXLData Enhancements ===<br />
* Introduction of login functionality<br />
* Introduction of System Properties reporter<br />
* Support for hierarchical structures in the query builder<br />
* Improved medium verbosity logging: limited to API request URLs and response codes<br />
* Alignment of result grid data order with selected codes in the query builder</div>Vmurrellhttps://wiki.sdmxcloud.org/index.php?title=Release_Plans&diff=8209Release Plans2026-02-21T12:01:04Z<p>Vmurrell: /* Version 26.2.0.00_RSH-FS_28.05.26 estimated release date May 28, 2026 */</p>
<hr />
<div>__NOTOC__<br />
== Version 26.2.0.00_RSH-FS_28.05.26 estimated release date May 28, 2026 ==<br />
<br />
===Fusion Registry ===<br />
* Spring6 Framework Upgrade<br />
* Support pop up box introduced<br />
* Database consistency checker web service<br />
* Semantic and Non-Semantic structure versions - ability to co-exist<br />
* Bulk Actions to include Hierarchy Associations<br />
* Loading structures - ability to skip invalid structures<br />
<br />
===Fusion Data Browser ===<br />
* Implementation of loading indicator<br />
<br />
=== FXLData Enhancements ===<br />
* Introduction of login functionality<br />
* Introduction of System Properties reporter<br />
* Support for hierarchical structures in the query builder<br />
* Improved medium verbosity logging: limited to API request URLs and response codes<br />
* Alignment of result grid data order with selected codes in the query builder</div>Vmurrellhttps://wiki.sdmxcloud.org/index.php?title=File:SupportTab-Setting.png&diff=8208File:SupportTab-Setting.png2026-02-20T12:35:48Z<p>Vmurrell: </p>
<hr />
<div></div>Vmurrellhttps://wiki.sdmxcloud.org/index.php?title=File:SupportTab-Modal.png&diff=8207File:SupportTab-Modal.png2026-02-20T12:34:13Z<p>Vmurrell: </p>
<hr />
<div></div>Vmurrellhttps://wiki.sdmxcloud.org/index.php?title=File:SupportTab-Control.png&diff=8206File:SupportTab-Control.png2026-02-20T12:32:49Z<p>Vmurrell: </p>
<hr />
<div></div>Vmurrellhttps://wiki.sdmxcloud.org/index.php?title=Support_Tab&diff=8205Support Tab2026-02-19T16:54:24Z<p>Vmurrell: </p>
<hr />
<div>[[Category:How_To]]<br />
<br />
Due to be released in Version Version 26.2.0.00_RSH-FS_28.05.26, a new feature called the "Support Tab" will be introduced.<br />
<br />
This graphical control appears on the right-hand side of most pages within the Registry. When clicked, it opens a pop-up modal designed to provide users with guidance on addressing any issues they may encounter. The content op this modal can be set by the system administrators and it supports HTML. However it is restricted to a maximum of 4,000 characters.<br />
<br />
'''To do''', obtain images and upload : https://fmrwiki.sdmxcloud.org/Support_Tab<br />
==Appearance==<br />
After content is added to the Support Tab, a new control will be displayed on the right-hand side of most screens. Clicking it opens a modal containing the predefined content. Users can dismiss the modal by clicking anywhere outside of the modal or by pressing the Escape key on their keyboard. The content remains the same across all pages, as the Support Tab feature does not allow for page-specific text variations.<br />
<br />
[[File:SupportTab-Control.png|The Support Tab control|500px]]<br />
[[File:SupportTab-Modal.png|Sample contents of the Support Tab Modal|500px]]<br><br />
<br />
==Setting Content==<br />
<br />
The contents of the Support Tab can be set on the Registry settings page: Settings -> General Settings. Simply enter the text or HTML in the field labelled "Support Text" and click the "Apply Settings" button.<br />
<br />
[[File:SupportTab-Setting.png|Setting the content of the support tab|1000px]]</div>Vmurrellhttps://wiki.sdmxcloud.org/index.php?title=Support_Tab&diff=8204Support Tab2026-02-19T16:53:48Z<p>Vmurrell: Created page with "Category:How_To Due to be released in Version Version 26.2.0.00_RSH-FS_28.05.26, a new feature called the "Support Tab" will be introduced. This graphical control appear..."</p>
<hr />
<div>[[Category:How_To]]<br />
<br />
Due to be released in Version Version 26.2.0.00_RSH-FS_28.05.26, a new feature called the "Support Tab" will be introduced.<br />
<br />
This graphical control appears on the right-hand side of most pages within the Registry. When clicked, it opens a pop-up modal designed to provide users with guidance on addressing any issues they may encounter. The content op this modal can be set by the system administrators and it supports HTML. However it is restricted to a maximum of 4,000 characters.<br />
==Appearance==<br />
After content is added to the Support Tab, a new control will be displayed on the right-hand side of most screens. Clicking it opens a modal containing the predefined content. Users can dismiss the modal by clicking anywhere outside of the modal or by pressing the Escape key on their keyboard. The content remains the same across all pages, as the Support Tab feature does not allow for page-specific text variations.<br />
<br />
[[File:SupportTab-Control.png|The Support Tab control|500px]]<br />
[[File:SupportTab-Modal.png|Sample contents of the Support Tab Modal|500px]]<br><br />
<br />
==Setting Content==<br />
<br />
The contents of the Support Tab can be set on the Registry settings page: Settings -> General Settings. Simply enter the text or HTML in the field labelled "Support Text" and click the "Apply Settings" button.<br />
<br />
[[File:SupportTab-Setting.png|Setting the content of the support tab|1000px]]</div>Vmurrellhttps://wiki.sdmxcloud.org/index.php?title=Release_Plans&diff=8203Release Plans2026-02-17T09:29:53Z<p>Vmurrell: /* Version 26.2.0.00_RSH-FS_28.05.26 estimated release date May 28, 2026 */</p>
<hr />
<div>__NOTOC__<br />
== Version 26.2.0.00_RSH-FS_28.05.26 estimated release date May 28, 2026 ==<br />
* Spring6 Framework Upgrade<br />
* Bug Fixes and minor enhancements (full details of which will be provided in the Release notes and change log.)<br />
<br />
===Fusion Data Browser ===<br />
* Implementation of loading indicator<br />
<br />
=== FXLData Enhancements ===<br />
* Introduction of login functionality<br />
* Support for hierarchical structures in the query builder<br />
* Improved medium verbosity logging: limited to API request URLs and response codes<br />
* Alignment of result grid data order with selected codes in the query builder</div>Vmurrellhttps://wiki.sdmxcloud.org/index.php?title=Main_Page&diff=8202Main Page2026-02-17T09:28:06Z<p>Vmurrell: /* Release Plans */</p>
<hr />
<div>{{DISPLAYTITLE:<span style="opacity:0;position:absolute;">{{FULLPAGENAME}}</span>}}<br />
__NOTOC__<br />
<span style="font-size:2.0rem;">Regnology Fusion Statistics Knowledge Base</span><br><br />
==SDMX Statistical Data Warehouse==<br />
<br />
Regnology Fusion Statistics is for central banks, international organisations, national statistics offices, development banks and regional statistics authorities who need an enterprise SDMX statistical data warehouse for storage of aggregated time series, data cataloguing and public dissemination. '''Reade more''' about SDMX here: [https://www.regnology.net/en/resources/regulatory-topics/sdmx/ What is SDMX?].<br />
<br />
Click here to see a visual representation of the [[Fusion_Registry_Core_Software_Stack|Fusion Registry Core Software Stack.]] Click here to read more about [[Fusion_Registry_Overview| Key Use Cases.]]<br />
<br />
== Release Plans ==<br />
'''February 2026''' - [https://email.regnology.net/harmonized-release-cycle-nomenclature-for-the-regnology-supervisory-hub-rsh?ecid=&utm_source=hs_email&utm_medium=email&_hsenc=p2ANqtz-8k1x3QloJAxsbKWXoazbn6M6u-uMRLRREeIqMPkgKjwI_utAAuoyTsjykx3n633VJ-vcX4| Important announcement regarding Relace Cycle and Release naming convention.]<br />
<br />
[[Release_Plans| Click here to view our future plans for Regnology Fusion Statistics.]]<br />
.<br />
<br />
==What's new?==<br />
[[What%27s_new| Click here to access more information on changes implemented in Releases and Hot Fixes from January 2025 onwards.]]<br />
<br />
== How to download a new version==<br />
[[File:How to obtain a Release-aug-2025.pdf | Click here to download instructions on how to uses the delivery software.]]'''<br />
<br />
==Open Source Software (OSS) / Third Party Components==<br />
[[Open_Source_Software_(OSS)_/_Third_Party_Components|Click here for more details.]]<br />
<br />
==Components and Modules==<br />
Regnology Fusion Statistics consists of a number of modules centered on the Fusion Registry core data warehouse engine, including a secure high-performance data dissemination server and a configurable data explorer and analytics tool for data consumers and analysts. <br />
<br />
Fusion Registry has an integrated SDMX structural metadata registry that is 100% compatible with Fusion Metadata Registry.<br />
<br />
[[File:Modules-Oct23.png|900px]]<br />
<br />
==Fusion Registry Topics==<br />
SDMX statistical data engine and structural metadata registry. The main statistical engine for data collection, integration, processing, storage, query execution and time-series calculations. It provides an SDMX-compliant data and metadata REST API. The integrated SDMX structural metadata registry acts as the central repository, authoring and maintenance tool for all of the structures including Codelists, Concepts and Data Structure Definitions.<br />
<br />
{| class="wikitable"<br />
|-<br />
| [[:Fusion_Registry_Overview|'''Overview''']]|| What is Fusion Registry?<br />
|-<br />
| | [[Fusion_Registry_-_Install,_Update_and_Configure |''' Fusion Registry Install, Update and Configure ''']]|| How to install, update and configure the Registry <br />
|-<br />
| [[:Category:SDMX Structures|'''SDMX Structures''']]|| Detailed explanations of the main SDMX structural metadata artefacts <br />
|-<br />
| [[:Category:Structural Metadata|'''Structure Maintenance''']]|| How to maintain the SDMX Structures<br />
|-<br />
| [[:Category:Reference_Metadata|'''Reference Metadata''']] || Guidance on working with SDMX 3.0 reference metadata in Fusion Registry 11<br />
|-<br />
| [[:Category:How To|'''How to and other Features''']] || Guidance on specific tasks using Fusion Registry<br />
|-<br />
| [[:Category:SdmxDataFormat|'''Data Formats''']] || A description of supported Data Formats<br />
|-<br />
| [[:Category:RegistrySecurity|'''Security''']] || Authentication and Authorisation Features<br />
|-<br />
| [[:Category:WebService|'''Web Services''']] || Registry Web Services<br />
|-<br />
| [[:Category:ChangeLogFR|'''Change Logs''']] || Change Logs for Registry 11 and Registry 10<br />
|-<br />
| [[:Category:RetiredFunctionality|'''Retired Functionality''']] || Functionality no longer valid in V11<br />
|}<br />
<br />
==Fusion Portal Topics==<br />
Fusion Portal is a web application made up of HTML, JavaScript, Images, and CSS files. The Portal allows you to call data from SDMX Webservices and other sources which enables you to obtain data from the data provider and import it directly into Fusion Registry.<br />
<br />
{| class="wikitable"<br />
|-<br />
| [[:Category:Fusion_Portal_Install |'''Installation and Configuration''']]|| How to install and Configure the Data Portal<br />
|-<br />
| [[:Category:Data Portal Functions |'''How to and other Features''']] || Guidance on using Data Portal<br />
|-<br />
| [[:Category:CRON-DP |'''Cron''' ]] || Using Cron to schedule regular synchronisations<br />
|-<br />
| [[Portal_Web_Services|'''Web Services''']] || List of Web Services specific to the Data Portal<br />
|-<br />
| [[Change_Log_Fusion_Portal|'''Change Logs''']] || Change Logs for Fusion Portal<br />
|}<br />
<br />
==Fusion Security Manager Topics==<br />
Available in Fusion Registry 11, a user interface which allows authorisation and rules to be created which explicitly permit or deny a security group access to a resource. The default behaviour of is to make everything private. In order to make structures and data public, specific security rules must be defined to grant access.<br />
{| class="wikitable"<br />
|-<br />
| [[:Category:FSM_Install |'''Installation and Configuration''']]|| How to install and Configure Fusion Security Manager<br />
|-<br />
| [[Fusion_Security_Manager_(FR_V11) |'''How to and other Features''']] || Guidance on using Fusion Security Manager<br />
|-<br />
| [[Change_Log_Fusion_Security_Manager|'''Change Logs''']] || Change Logs for Fusion Security Manager.<br />
|}<br />
<br />
==Fusion Fame Mapper Topics ==<br />
Web tool for creating and maintaining Fusion Registry FAME to SDMX series mappings.<br />
{| class="wikitable"<br />
|-<br />
| [[:Category:FFM Install |'''Installation and Configuration''']]|| How to install and Configure Fusion Fame Mapper<br />
|-<br />
| [[Fusion_Fame_Mapper |'''How to and other Features''']] || Guidance on using Fame Mapper<br />
|-<br />
| [[Change_Log_Fusion_Fame_Mapper|'''Change Logs''']] || Change Logs for Fame Mapper<br />
|}<br />
<br />
==Fusion Data Browser Topics==<br />
Web tool for data consumers to explore the Fusion Registry data catalogue, create charts and tables, and download data.<br />
<br />
{| class="wikitable"<br />
|-<br />
| [[Fusion_Data_Browser |'''Overview ''']]|| What is Fusion Data Browser?<br />
|-<br />
| [[A_beginners_guide_to_Fusion_Data_Browser |'''Getting Started''']]|| Non-technical guide for using Fusion Data Browser<br />
|-<br />
| [[Anatomy_of_the_Data_Browser |'''Anatomy of the Data Browser''']]|| Technical guide detailing techniques and solutions<br />
|-<br />
| [[:Category:FDB Install and Configure |'''Installation and Configuration''']]|| How to install and Configure the Data Browser<br />
|-<br />
| [[:Category:Fusion Data Browser |'''How to and Functions''']] || Using Fusion Data Browser<br />
|-<br />
| [[Change_Log_Fusion_Data_Browser|'''Change Logs''']] || Change Logs for Fusion Data Browser<br />
|-<br />
| [[:Category:Fusion Registry Data Browser|'''Retired Functionality''']] || Functionality no longer available in V11<br />
|}<br />
<br />
==FusionXL Topics==<br />
FusionXL is an addin for Microsoft Excel which connects to a Fusion Registry server for both data and structure retrieval, and maintenance.<br />
{| class="wikitable"<br />
|-<br />
| [[FusionXL_Install|'''Installation''']] || How to Install Fusion XL and connect to a Fusion Registry server<br />
|-<br />
| [[Security in FXL |'''Security in FXL''']] || How to set up rules to apply to FusionXL from Version 11<br />
|-<br />
| [[FusionXL_DataBAuthor|'''Data Author''']] || Create datasets and load datasets for the purpose of data authoring, validation, conversion, and publishing<br />
|-<br />
| [[FusionXL_StructureExplorer|'''Structure Explorer''']] || Create, Retrieve and Modify Structures using the Excel Ribbon<br />
|-<br />
| [[FusionXL_Change_Log|'''Change Logs''']] || Change Logs for FusionXL<br />
|-<br />
| [[FusionXL_DataExplorer|'''Retired Functionality''']] || Functionality no longer available in V3<br />
|-<br />
|}<br />
<br />
==FXLData Topics==<br />
FusionXLData is an addin for Microsoft Excel which connects to a Fusion Registry server for exploring the data catalogue, and downloading data directly into a spreadsheet.<br />
<br />
'''In August 2025''' a major upgrade has taken place, click her to read [[FXLData_what%27s_new_in_R1.3%3F|about the changes and new features]]<br />
{| class="wikitable"<br />
|-<br />
| [[Overview_FXLData|'''Overview''']] || What is FXLData?<br />
|-<br />
| [[:Category:Getting_Started_FXLData|'''Getting Started''']] || How to download, install and configure FXLData<br />
|-<br />
| [[:Category:Functions Reference FXLData|'''Functions Reference''']] || How to use the Parameter functions in FXLData<br />
|-<br />
| [[FXLData_Wizard|'''Data Wizard''']] || using the ribbon tool to build and edit functions<br />
|-<br />
| [[:Category:How to and other features in FXLData | '''How to and other features''']] || How to use FXLData<br />
|-<br />
| [[Troubleshooting_-_FXLData|'''Troubleshooting''']] || How to resolve common problems<br />
|-<br />
| [[FXLData_Change_Log|'''Change Logs''']] || Change Logs for FXLData.<br />
<br />
|}<br />
<br />
==Fusion Edge Server Topics ==<br />
A light-weight high-performance data and metadata REST API server designed to be deployed in clusters in the DMZ or at the network edge for scalable, fault-tolerant public data dissemination use cases.<br />
{| class="wikitable"<br />
|-<br />
| [[Fusion_Edge_Server|'''Overview''']] || What is Fusion Edge Server?<br />
|-<br />
| [[:Category:FESInstall|'''Installation''']] || How to install Fusion Edge Server<br />
|-<br />
| [[Edge_Server_Environment|'''Environment''']] || Edge Server environment<br />
|-<br />
| [[Fusion_Edge_Compiler|'''Compiler''']] || Edge Server Compiler<br />
|-<br />
| [[Edge_Server_Data_Preperation_Web_Service|'''Web Services''']] || Data Preparation Web Services <br />
|-<br />
| [[:Category:How_to_FES|'''How to and Other Features''']] || Using Fusion Edge Server<br />
|-<br />
| [[:Category:ChangeLogFES|'''Change Logs''']] || Change Logs for Fusion Edge Server<br />
<br />
|}<br />
<br />
==Command Line Tools ==<br />
{| class="wikitable"<br />
|-<br />
| [[Fusion_Transformer|'''Fusion Transformer''']] || Fusion Transformer is a command-line application providing transformations between SDMX and GESMES data files and structure files.<br />
|-<br />
| [[Fusion_Registry_Command_Line|'''Fusion Registry Command Line''']] || Windows and Linux command line interface.<br />
A command line interface to Fusion Registry's REST API providing utility scripts for loading structures, data and metadata, validating data, exporting content and deleting content.<br />
|-<br />
| [[Backup_and_Restore|'''FMRCL''']] || Tool to assist with Backup up and Restoring Structures.<br />
|-<br />
|}<br />
==Database Recovery==<br />
{| class="wikitable"<br />
|-<br />
| [[Oracle_Schema_backup_on_AWS|'''Oracle Schema Backup and Restore on AWS''']] || Information on possible ways to backup and restore a DB schema using oracle tools <br />
|}</div>Vmurrellhttps://wiki.sdmxcloud.org/index.php?title=Main_Page&diff=8201Main Page2026-02-17T09:27:19Z<p>Vmurrell: /* Release Plans */</p>
<hr />
<div>{{DISPLAYTITLE:<span style="opacity:0;position:absolute;">{{FULLPAGENAME}}</span>}}<br />
__NOTOC__<br />
<span style="font-size:2.0rem;">Regnology Fusion Statistics Knowledge Base</span><br><br />
==SDMX Statistical Data Warehouse==<br />
<br />
Regnology Fusion Statistics is for central banks, international organisations, national statistics offices, development banks and regional statistics authorities who need an enterprise SDMX statistical data warehouse for storage of aggregated time series, data cataloguing and public dissemination. '''Reade more''' about SDMX here: [https://www.regnology.net/en/resources/regulatory-topics/sdmx/ What is SDMX?].<br />
<br />
Click here to see a visual representation of the [[Fusion_Registry_Core_Software_Stack|Fusion Registry Core Software Stack.]] Click here to read more about [[Fusion_Registry_Overview| Key Use Cases.]]<br />
<br />
== Release Plans ==<br />
[https://email.regnology.net/harmonized-release-cycle-nomenclature-for-the-regnology-supervisory-hub-rsh?ecid=&utm_source=hs_email&utm_medium=email&_hsenc=p2ANqtz-8k1x3QloJAxsbKWXoazbn6M6u-uMRLRREeIqMPkgKjwI_utAAuoyTsjykx3n633VJ-vcX4| Important announcement regarding Relace Cycle and Release naming convention.]<br />
<br />
[[Release_Plans| Click here to view our future plans for Regnology Fusion Statistics.]]<br />
.<br />
<br />
==What's new?==<br />
[[What%27s_new| Click here to access more information on changes implemented in Releases and Hot Fixes from January 2025 onwards.]]<br />
<br />
== How to download a new version==<br />
[[File:How to obtain a Release-aug-2025.pdf | Click here to download instructions on how to uses the delivery software.]]'''<br />
<br />
==Open Source Software (OSS) / Third Party Components==<br />
[[Open_Source_Software_(OSS)_/_Third_Party_Components|Click here for more details.]]<br />
<br />
==Components and Modules==<br />
Regnology Fusion Statistics consists of a number of modules centered on the Fusion Registry core data warehouse engine, including a secure high-performance data dissemination server and a configurable data explorer and analytics tool for data consumers and analysts. <br />
<br />
Fusion Registry has an integrated SDMX structural metadata registry that is 100% compatible with Fusion Metadata Registry.<br />
<br />
[[File:Modules-Oct23.png|900px]]<br />
<br />
==Fusion Registry Topics==<br />
SDMX statistical data engine and structural metadata registry. The main statistical engine for data collection, integration, processing, storage, query execution and time-series calculations. It provides an SDMX-compliant data and metadata REST API. The integrated SDMX structural metadata registry acts as the central repository, authoring and maintenance tool for all of the structures including Codelists, Concepts and Data Structure Definitions.<br />
<br />
{| class="wikitable"<br />
|-<br />
| [[:Fusion_Registry_Overview|'''Overview''']]|| What is Fusion Registry?<br />
|-<br />
| | [[Fusion_Registry_-_Install,_Update_and_Configure |''' Fusion Registry Install, Update and Configure ''']]|| How to install, update and configure the Registry <br />
|-<br />
| [[:Category:SDMX Structures|'''SDMX Structures''']]|| Detailed explanations of the main SDMX structural metadata artefacts <br />
|-<br />
| [[:Category:Structural Metadata|'''Structure Maintenance''']]|| How to maintain the SDMX Structures<br />
|-<br />
| [[:Category:Reference_Metadata|'''Reference Metadata''']] || Guidance on working with SDMX 3.0 reference metadata in Fusion Registry 11<br />
|-<br />
| [[:Category:How To|'''How to and other Features''']] || Guidance on specific tasks using Fusion Registry<br />
|-<br />
| [[:Category:SdmxDataFormat|'''Data Formats''']] || A description of supported Data Formats<br />
|-<br />
| [[:Category:RegistrySecurity|'''Security''']] || Authentication and Authorisation Features<br />
|-<br />
| [[:Category:WebService|'''Web Services''']] || Registry Web Services<br />
|-<br />
| [[:Category:ChangeLogFR|'''Change Logs''']] || Change Logs for Registry 11 and Registry 10<br />
|-<br />
| [[:Category:RetiredFunctionality|'''Retired Functionality''']] || Functionality no longer valid in V11<br />
|}<br />
<br />
==Fusion Portal Topics==<br />
Fusion Portal is a web application made up of HTML, JavaScript, Images, and CSS files. The Portal allows you to call data from SDMX Webservices and other sources which enables you to obtain data from the data provider and import it directly into Fusion Registry.<br />
<br />
{| class="wikitable"<br />
|-<br />
| [[:Category:Fusion_Portal_Install |'''Installation and Configuration''']]|| How to install and Configure the Data Portal<br />
|-<br />
| [[:Category:Data Portal Functions |'''How to and other Features''']] || Guidance on using Data Portal<br />
|-<br />
| [[:Category:CRON-DP |'''Cron''' ]] || Using Cron to schedule regular synchronisations<br />
|-<br />
| [[Portal_Web_Services|'''Web Services''']] || List of Web Services specific to the Data Portal<br />
|-<br />
| [[Change_Log_Fusion_Portal|'''Change Logs''']] || Change Logs for Fusion Portal<br />
|}<br />
<br />
==Fusion Security Manager Topics==<br />
Available in Fusion Registry 11, a user interface which allows authorisation and rules to be created which explicitly permit or deny a security group access to a resource. The default behaviour of is to make everything private. In order to make structures and data public, specific security rules must be defined to grant access.<br />
{| class="wikitable"<br />
|-<br />
| [[:Category:FSM_Install |'''Installation and Configuration''']]|| How to install and Configure Fusion Security Manager<br />
|-<br />
| [[Fusion_Security_Manager_(FR_V11) |'''How to and other Features''']] || Guidance on using Fusion Security Manager<br />
|-<br />
| [[Change_Log_Fusion_Security_Manager|'''Change Logs''']] || Change Logs for Fusion Security Manager.<br />
|}<br />
<br />
==Fusion Fame Mapper Topics ==<br />
Web tool for creating and maintaining Fusion Registry FAME to SDMX series mappings.<br />
{| class="wikitable"<br />
|-<br />
| [[:Category:FFM Install |'''Installation and Configuration''']]|| How to install and Configure Fusion Fame Mapper<br />
|-<br />
| [[Fusion_Fame_Mapper |'''How to and other Features''']] || Guidance on using Fame Mapper<br />
|-<br />
| [[Change_Log_Fusion_Fame_Mapper|'''Change Logs''']] || Change Logs for Fame Mapper<br />
|}<br />
<br />
==Fusion Data Browser Topics==<br />
Web tool for data consumers to explore the Fusion Registry data catalogue, create charts and tables, and download data.<br />
<br />
{| class="wikitable"<br />
|-<br />
| [[Fusion_Data_Browser |'''Overview ''']]|| What is Fusion Data Browser?<br />
|-<br />
| [[A_beginners_guide_to_Fusion_Data_Browser |'''Getting Started''']]|| Non-technical guide for using Fusion Data Browser<br />
|-<br />
| [[Anatomy_of_the_Data_Browser |'''Anatomy of the Data Browser''']]|| Technical guide detailing techniques and solutions<br />
|-<br />
| [[:Category:FDB Install and Configure |'''Installation and Configuration''']]|| How to install and Configure the Data Browser<br />
|-<br />
| [[:Category:Fusion Data Browser |'''How to and Functions''']] || Using Fusion Data Browser<br />
|-<br />
| [[Change_Log_Fusion_Data_Browser|'''Change Logs''']] || Change Logs for Fusion Data Browser<br />
|-<br />
| [[:Category:Fusion Registry Data Browser|'''Retired Functionality''']] || Functionality no longer available in V11<br />
|}<br />
<br />
==FusionXL Topics==<br />
FusionXL is an addin for Microsoft Excel which connects to a Fusion Registry server for both data and structure retrieval, and maintenance.<br />
{| class="wikitable"<br />
|-<br />
| [[FusionXL_Install|'''Installation''']] || How to Install Fusion XL and connect to a Fusion Registry server<br />
|-<br />
| [[Security in FXL |'''Security in FXL''']] || How to set up rules to apply to FusionXL from Version 11<br />
|-<br />
| [[FusionXL_DataBAuthor|'''Data Author''']] || Create datasets and load datasets for the purpose of data authoring, validation, conversion, and publishing<br />
|-<br />
| [[FusionXL_StructureExplorer|'''Structure Explorer''']] || Create, Retrieve and Modify Structures using the Excel Ribbon<br />
|-<br />
| [[FusionXL_Change_Log|'''Change Logs''']] || Change Logs for FusionXL<br />
|-<br />
| [[FusionXL_DataExplorer|'''Retired Functionality''']] || Functionality no longer available in V3<br />
|-<br />
|}<br />
<br />
==FXLData Topics==<br />
FusionXLData is an addin for Microsoft Excel which connects to a Fusion Registry server for exploring the data catalogue, and downloading data directly into a spreadsheet.<br />
<br />
'''In August 2025''' a major upgrade has taken place, click her to read [[FXLData_what%27s_new_in_R1.3%3F|about the changes and new features]]<br />
{| class="wikitable"<br />
|-<br />
| [[Overview_FXLData|'''Overview''']] || What is FXLData?<br />
|-<br />
| [[:Category:Getting_Started_FXLData|'''Getting Started''']] || How to download, install and configure FXLData<br />
|-<br />
| [[:Category:Functions Reference FXLData|'''Functions Reference''']] || How to use the Parameter functions in FXLData<br />
|-<br />
| [[FXLData_Wizard|'''Data Wizard''']] || using the ribbon tool to build and edit functions<br />
|-<br />
| [[:Category:How to and other features in FXLData | '''How to and other features''']] || How to use FXLData<br />
|-<br />
| [[Troubleshooting_-_FXLData|'''Troubleshooting''']] || How to resolve common problems<br />
|-<br />
| [[FXLData_Change_Log|'''Change Logs''']] || Change Logs for FXLData.<br />
<br />
|}<br />
<br />
==Fusion Edge Server Topics ==<br />
A light-weight high-performance data and metadata REST API server designed to be deployed in clusters in the DMZ or at the network edge for scalable, fault-tolerant public data dissemination use cases.<br />
{| class="wikitable"<br />
|-<br />
| [[Fusion_Edge_Server|'''Overview''']] || What is Fusion Edge Server?<br />
|-<br />
| [[:Category:FESInstall|'''Installation''']] || How to install Fusion Edge Server<br />
|-<br />
| [[Edge_Server_Environment|'''Environment''']] || Edge Server environment<br />
|-<br />
| [[Fusion_Edge_Compiler|'''Compiler''']] || Edge Server Compiler<br />
|-<br />
| [[Edge_Server_Data_Preperation_Web_Service|'''Web Services''']] || Data Preparation Web Services <br />
|-<br />
| [[:Category:How_to_FES|'''How to and Other Features''']] || Using Fusion Edge Server<br />
|-<br />
| [[:Category:ChangeLogFES|'''Change Logs''']] || Change Logs for Fusion Edge Server<br />
<br />
|}<br />
<br />
==Command Line Tools ==<br />
{| class="wikitable"<br />
|-<br />
| [[Fusion_Transformer|'''Fusion Transformer''']] || Fusion Transformer is a command-line application providing transformations between SDMX and GESMES data files and structure files.<br />
|-<br />
| [[Fusion_Registry_Command_Line|'''Fusion Registry Command Line''']] || Windows and Linux command line interface.<br />
A command line interface to Fusion Registry's REST API providing utility scripts for loading structures, data and metadata, validating data, exporting content and deleting content.<br />
|-<br />
| [[Backup_and_Restore|'''FMRCL''']] || Tool to assist with Backup up and Restoring Structures.<br />
|-<br />
|}<br />
==Database Recovery==<br />
{| class="wikitable"<br />
|-<br />
| [[Oracle_Schema_backup_on_AWS|'''Oracle Schema Backup and Restore on AWS''']] || Information on possible ways to backup and restore a DB schema using oracle tools <br />
|}</div>Vmurrellhttps://wiki.sdmxcloud.org/index.php?title=What%27s_new_in_R26.2.0.00_RSH-FS_28.05.26&diff=8200What's new in R26.2.0.00 RSH-FS 28.05.262026-02-16T12:44:04Z<p>Vmurrell: /* Extended Authentication Capabilities */</p>
<hr />
<div>[[Category:How to and other features in FXLData]]<br />
<br />
<br />
==Extended Authentication Capabilities==<br />
<br />
This option allows a user to Login to FXLData before they are actually required to do so. In the past the Login box would appear as an when it was required which could interrupt the users workflow.<br />
<br />
To use the feature, select Login from the FXLData Ribbon Bar.<br />
<br />
[[File:Sel-login-options.png|600px]]<br />
<br />
First, select the registry that you wish to access as shown in the example below.<br />
<br />
[[File:Login-8080.png|600px]]<br />
<br />
Click Login, the Excel login box will appear, enter your credentials in the usual way.<br />
<br />
Successful authentication will be confirmed as shown in the image below.<br />
<br />
[[File:Login-success.png|600px]]<br />
<br />
<br />
=== Troubleshooting ===<br />
* Scenario 1:<br />
You select a registry and click Login, but the feedback box says:“You are logged into {registryUrl} as {userId}.”<br />
This indicates that you are already authenticated with the selected registry.<br />
If you need to log in as a different user, you will have to restart Excel.<br />
Switching accounts within the same Excel session is not supported in the first phase of this feature.<br />
<br />
* Scenario 2:<br />
<br />
You click Login, but no login prompt appears and the feedback box says: “Login Failed.”<br />
In this case, the most likely cause is an authentication configuration issue within the registry.<br />
To resolve this, please contact your registry administrator or raise a ticket with Regnology for assistance</div>Vmurrellhttps://wiki.sdmxcloud.org/index.php?title=What%27s_new_in_R26.2.0.00_RSH-FS_28.05.26&diff=8199What's new in R26.2.0.00 RSH-FS 28.05.262026-02-16T12:31:18Z<p>Vmurrell: </p>
<hr />
<div>[[Category:How to and other features in FXLData]]<br />
<br />
<br />
==Extended Authentication Capabilities==<br />
<br />
This option allows a user to Login to FXLData before they are actually required to do so. In the past the Login box would appear as an when it was required which could interrupt the users workflow.<br />
<br />
To use the feature, select Login from the FXLData Tool Bar.<br />
<br />
[[File:Sel-login-options.png|600px]]<br />
<br />
First, select the registry that you wish to access as shown in the example below.<br />
<br />
[[File:Login-8080.png|600px]]<br />
<br />
Click Login, the Excel login box will appear, enter your credentials in the usual way.<br />
<br />
Successful authentication will be confirmed as shown in the image below.<br />
<br />
[[File:Login-success.png|600px]]<br />
<br />
<br />
=== Troubleshooting ===<br />
* Scenario 1:<br />
You select a registry and click Login, but the feedback box says:“You are logged into {registryUrl} as {userId}.”<br />
This indicates that you are already authenticated with the selected registry.<br />
If you need to log in as a different user, you will have to restart Excel.<br />
Switching accounts within the same Excel session is not supported in the first phase of this feature.<br />
<br />
* Scenario 2:<br />
<br />
You click Login, but no login prompt appears and the feedback box says: “Login Failed.”<br />
In this case, the most likely cause is an authentication configuration issue within the registry.<br />
To resolve this, please contact your registry administrator or raise a ticket with Regnology for assistance</div>Vmurrellhttps://wiki.sdmxcloud.org/index.php?title=File:Login-success.png&diff=8198File:Login-success.png2026-02-16T12:28:47Z<p>Vmurrell: </p>
<hr />
<div></div>Vmurrellhttps://wiki.sdmxcloud.org/index.php?title=File:Login-8080.png&diff=8197File:Login-8080.png2026-02-16T12:26:47Z<p>Vmurrell: </p>
<hr />
<div></div>Vmurrellhttps://wiki.sdmxcloud.org/index.php?title=File:Sel-login-options.png&diff=8196File:Sel-login-options.png2026-02-16T12:24:03Z<p>Vmurrell: </p>
<hr />
<div></div>Vmurrellhttps://wiki.sdmxcloud.org/index.php?title=FXLData_what%27s_new_in_R1.3.03&diff=8195FXLData what's new in R1.3.032026-02-16T12:19:44Z<p>Vmurrell: /* Functions */</p>
<hr />
<div>[[Category:How to and other features in FXLData]]<br />
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.<br />
<br />
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.<br />
<br />
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.<br />
<br />
Remember - to use these changes the FXLData add-in must be installed, follow the installation instructions found [[Downlad_and_Installation_FXLData |here.]]<br />
<br />
== FXLData Tab ==<br />
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.<br />
<br />
[[File:Appearance.png|800px]]<br />
<br />
=== [[Legacy Mode - FXLData |Legacy Mode]] ===<br />
The need for Legacy mode has been superseded by the removal of the Automatic Calculation facility. The Refresh button now works as expected and will perform an update on request.<br />
<br />
As part of the change you will notice that the ampersand is inserted into the query shown in the formula bar.<br />
<br />
'''Example:''' <br />
@FXLData("https://demo.metadatatechnology.com/FusionRegistry","WB,WDI_POVERTY,1.0",".SI_DST_02ND_20+SI_DST_03RD_20+SI_DST_04TH_20.",100,,,,"id","TRUE","FALSE","TRUE","FALSE","")<br />
<br />
=== Refresh ===<br />
FXLData no longer uses the normal Excel calculations in Microsoft 365. As a result, if a change is made as described here [[Refresh - FXLData#Refresh| Refresh article]] a manual refresh is necessary.<br />
<br />
The Refresh option is no longer restricted to older versions of Excel, the options available are detailed [[Refresh - FXLData#Office 2010-2019 Excel and Microsoft 365 Excel working in legacy Mode|here.]]<br />
<br />
Note that if the formula itself is deleted, you will also need to delete any returned data.<br />
<br />
=== Diagnostic Tool ===<br />
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.<br />
<br />
[[File:Diagnostic tool.png|1000px]]<br />
<br />
== FXLData Wizard ==<br />
<br />
===Dataflow Selection===<br />
<br />
A new selection box has been added to make it easier to select a dataflow.<br />
<br />
[[File:Dataflow selection.png|1000px]]<br />
<br />
===Selecting Items===<br />
[[File:Codelist display.png|1000px]]<br />
<br />
===Rest Arguments===<br />
<br />
The Wizard (available from the FXL Data tab) now includes a button to select the Rest Arguments Builder. Which can be used to specify additional SDMX query arguments that are not available through other options in the User Interface, such as round=2 for rounding numeric values. It is intended for the advanced user who needs finer control over the query behaviour.<br />
<br />
[[File:Rest-argument-builder-button.png|1000-px]]<br />
<br />
To use the Builder, select a dataflow and then click on the Builder button.<br />
<br />
Click the button to access the builder.<br />
<br />
[[File:Rest-argument-builder.png|1200-px]]<br />
<br />
'''Apply Button'''<br />
<br />
When the Apply button is pressed in the REST Arguments Builder, it performs the following action:<br />
<br />
* It populates the REST Args box on the main Wizard screen with the constructed query string based on the enabled and valid arguments.<br />
* It does not execute the FXLData function or retrieve any data at this stage.<br />
* To actually run the query and fetch data into Excel, the user must return to the Wizard screen and press its Apply button.<br />
This separation ensures the user can review and finalize their full query setup before triggering data retrieval.<br />
<br />
====Interaction with the Wizard====<br />
'''Existing Arguments'''<br />
<br />
If the wizard already contains rest arguments when the Builder is opened, it will attempt to interpret and reconstruct the existing argument as accurately as possible.<br />
<br />
[[File:Rest-arguments-box.png|1200-px]]<br />
<br />
'''Arguments handled via the Wizard'''<br />
<br />
* startperiod <br />
* endperiod <br />
* max <br />
* time-format-frequency-id<br />
<br />
=== Other point to note ===<br />
==== Functions ====<br />
The TimeFormatFrequencyID parameter is now available when using the Functions:<br />
* FXLDataURL<br />
* FXLDataURLV<br />
* FXLDataURLFact<br />
<br />
[[File:TimeFormatFrequencyID.png|500px]]<br />
<br />
===== New Functions introduced =====<br />
<br />
These options are available but are currently in beta test. <br />
<br />
[[FXLDataLookup_and_FXLDataPeriod_Functions |You can read more in this article.]]<br />
<br />
===== System Properties =====<br />
A new option is available on the FXL Data tab which, when selected, will display information as shown in the example aside.<br />
<br />
[[File:Click-sys-info-ER.png|thumb]]<br />
<br />
=== Refresh ===<br />
FXLData no longer uses the normal Excel calculations in Microsoft 365. As a result, if a change is made as describe here [[Refresh - FXLData#Refresh| Refresh article]] a manual refresh is necessary.<br />
<br />
The Refresh option is no longer restricted to older versions of Excel, the options available are detailed [[Refresh - FXLData#Office 2010-2019 Excel and Microsoft 365 Excel working in legacy Mode|here.]]<br />
<br />
Note that if the formula itself is deleted, you will also need to delete any returned data.</div>Vmurrellhttps://wiki.sdmxcloud.org/index.php?title=File:Click-sys-info-ER.png&diff=8194File:Click-sys-info-ER.png2026-02-16T12:17:34Z<p>Vmurrell: </p>
<hr />
<div></div>Vmurrellhttps://wiki.sdmxcloud.org/index.php?title=What%27s_new_in_R26.2.0.00_RSH-FS_28.05.26&diff=8193What's new in R26.2.0.00 RSH-FS 28.05.262026-02-16T12:07:50Z<p>Vmurrell: Created page with "Category:How to and other features in FXLData Coming soon."</p>
<hr />
<div>[[Category:How to and other features in FXLData]]<br />
Coming soon.</div>Vmurrellhttps://wiki.sdmxcloud.org/index.php?title=FXLData_what%27s_new_in_R1.3.03&diff=8192FXLData what's new in R1.3.032026-02-16T12:01:29Z<p>Vmurrell: /* Functions */</p>
<hr />
<div>[[Category:How to and other features in FXLData]]<br />
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.<br />
<br />
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.<br />
<br />
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.<br />
<br />
Remember - to use these changes the FXLData add-in must be installed, follow the installation instructions found [[Downlad_and_Installation_FXLData |here.]]<br />
<br />
== FXLData Tab ==<br />
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.<br />
<br />
[[File:Appearance.png|800px]]<br />
<br />
=== [[Legacy Mode - FXLData |Legacy Mode]] ===<br />
The need for Legacy mode has been superseded by the removal of the Automatic Calculation facility. The Refresh button now works as expected and will perform an update on request.<br />
<br />
As part of the change you will notice that the ampersand is inserted into the query shown in the formula bar.<br />
<br />
'''Example:''' <br />
@FXLData("https://demo.metadatatechnology.com/FusionRegistry","WB,WDI_POVERTY,1.0",".SI_DST_02ND_20+SI_DST_03RD_20+SI_DST_04TH_20.",100,,,,"id","TRUE","FALSE","TRUE","FALSE","")<br />
<br />
=== Refresh ===<br />
FXLData no longer uses the normal Excel calculations in Microsoft 365. As a result, if a change is made as described here [[Refresh - FXLData#Refresh| Refresh article]] a manual refresh is necessary.<br />
<br />
The Refresh option is no longer restricted to older versions of Excel, the options available are detailed [[Refresh - FXLData#Office 2010-2019 Excel and Microsoft 365 Excel working in legacy Mode|here.]]<br />
<br />
Note that if the formula itself is deleted, you will also need to delete any returned data.<br />
<br />
=== Diagnostic Tool ===<br />
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.<br />
<br />
[[File:Diagnostic tool.png|1000px]]<br />
<br />
== FXLData Wizard ==<br />
<br />
===Dataflow Selection===<br />
<br />
A new selection box has been added to make it easier to select a dataflow.<br />
<br />
[[File:Dataflow selection.png|1000px]]<br />
<br />
===Selecting Items===<br />
[[File:Codelist display.png|1000px]]<br />
<br />
===Rest Arguments===<br />
<br />
The Wizard (available from the FXL Data tab) now includes a button to select the Rest Arguments Builder. Which can be used to specify additional SDMX query arguments that are not available through other options in the User Interface, such as round=2 for rounding numeric values. It is intended for the advanced user who needs finer control over the query behaviour.<br />
<br />
[[File:Rest-argument-builder-button.png|1000-px]]<br />
<br />
To use the Builder, select a dataflow and then click on the Builder button.<br />
<br />
Click the button to access the builder.<br />
<br />
[[File:Rest-argument-builder.png|1200-px]]<br />
<br />
'''Apply Button'''<br />
<br />
When the Apply button is pressed in the REST Arguments Builder, it performs the following action:<br />
<br />
* It populates the REST Args box on the main Wizard screen with the constructed query string based on the enabled and valid arguments.<br />
* It does not execute the FXLData function or retrieve any data at this stage.<br />
* To actually run the query and fetch data into Excel, the user must return to the Wizard screen and press its Apply button.<br />
This separation ensures the user can review and finalize their full query setup before triggering data retrieval.<br />
<br />
====Interaction with the Wizard====<br />
'''Existing Arguments'''<br />
<br />
If the wizard already contains rest arguments when the Builder is opened, it will attempt to interpret and reconstruct the existing argument as accurately as possible.<br />
<br />
[[File:Rest-arguments-box.png|1200-px]]<br />
<br />
'''Arguments handled via the Wizard'''<br />
<br />
* startperiod <br />
* endperiod <br />
* max <br />
* time-format-frequency-id<br />
<br />
=== Other point to note ===<br />
==== Functions ====<br />
The TimeFormatFrequencyID parameter is now available when using the Functions:<br />
* FXLDataURL<br />
* FXLDataURLV<br />
* FXLDataURLFact<br />
<br />
[[File:TimeFormatFrequencyID.png|500px]]<br />
<br />
===== New Functions introduced =====<br />
<br />
These options are available but are currently in beta test. <br />
<br />
[[FXLDataLookup_and_FXLDataPeriod_Functions |You can read more in this article.]]<br />
<br />
=== Refresh ===<br />
FXLData no longer uses the normal Excel calculations in Microsoft 365. As a result, if a change is made as describe here [[Refresh - FXLData#Refresh| Refresh article]] a manual refresh is necessary.<br />
<br />
The Refresh option is no longer restricted to older versions of Excel, the options available are detailed [[Refresh - FXLData#Office 2010-2019 Excel and Microsoft 365 Excel working in legacy Mode|here.]]<br />
<br />
Note that if the formula itself is deleted, you will also need to delete any returned data.</div>Vmurrellhttps://wiki.sdmxcloud.org/index.php?title=FXLData_what%27s_new_in_R1.3.03&diff=8190FXLData what's new in R1.3.032026-02-16T11:57:34Z<p>Vmurrell: Vmurrell moved page FXLData what's new in R1.3.3 to FXLData what's new in R1.3.03</p>
<hr />
<div>[[Category:How to and other features in FXLData]]<br />
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.<br />
<br />
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.<br />
<br />
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.<br />
<br />
Remember - to use these changes the FXLData add-in must be installed, follow the installation instructions found [[Downlad_and_Installation_FXLData |here.]]<br />
<br />
== FXLData Tab ==<br />
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.<br />
<br />
[[File:Appearance.png|800px]]<br />
<br />
=== [[Legacy Mode - FXLData |Legacy Mode]] ===<br />
The need for Legacy mode has been superseded by the removal of the Automatic Calculation facility. The Refresh button now works as expected and will perform an update on request.<br />
<br />
As part of the change you will notice that the ampersand is inserted into the query shown in the formula bar.<br />
<br />
'''Example:''' <br />
@FXLData("https://demo.metadatatechnology.com/FusionRegistry","WB,WDI_POVERTY,1.0",".SI_DST_02ND_20+SI_DST_03RD_20+SI_DST_04TH_20.",100,,,,"id","TRUE","FALSE","TRUE","FALSE","")<br />
<br />
=== Refresh ===<br />
FXLData no longer uses the normal Excel calculations in Microsoft 365. As a result, if a change is made as described here [[Refresh - FXLData#Refresh| Refresh article]] a manual refresh is necessary.<br />
<br />
The Refresh option is no longer restricted to older versions of Excel, the options available are detailed [[Refresh - FXLData#Office 2010-2019 Excel and Microsoft 365 Excel working in legacy Mode|here.]]<br />
<br />
Note that if the formula itself is deleted, you will also need to delete any returned data.<br />
<br />
=== Diagnostic Tool ===<br />
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.<br />
<br />
[[File:Diagnostic tool.png|1000px]]<br />
<br />
== FXLData Wizard ==<br />
<br />
===Dataflow Selection===<br />
<br />
A new selection box has been added to make it easier to select a dataflow.<br />
<br />
[[File:Dataflow selection.png|1000px]]<br />
<br />
===Selecting Items===<br />
[[File:Codelist display.png|1000px]]<br />
<br />
===Rest Arguments===<br />
<br />
The Wizard (available from the FXL Data tab) now includes a button to select the Rest Arguments Builder. Which can be used to specify additional SDMX query arguments that are not available through other options in the User Interface, such as round=2 for rounding numeric values. It is intended for the advanced user who needs finer control over the query behaviour.<br />
<br />
[[File:Rest-argument-builder-button.png|1000-px]]<br />
<br />
To use the Builder, select a dataflow and then click on the Builder button.<br />
<br />
Click the button to access the builder.<br />
<br />
[[File:Rest-argument-builder.png|1200-px]]<br />
<br />
'''Apply Button'''<br />
<br />
When the Apply button is pressed in the REST Arguments Builder, it performs the following action:<br />
<br />
* It populates the REST Args box on the main Wizard screen with the constructed query string based on the enabled and valid arguments.<br />
* It does not execute the FXLData function or retrieve any data at this stage.<br />
* To actually run the query and fetch data into Excel, the user must return to the Wizard screen and press its Apply button.<br />
This separation ensures the user can review and finalize their full query setup before triggering data retrieval.<br />
<br />
====Interaction with the Wizard====<br />
'''Existing Arguments'''<br />
<br />
If the wizard already contains rest arguments when the Builder is opened, it will attempt to interpret and reconstruct the existing argument as accurately as possible.<br />
<br />
[[File:Rest-arguments-box.png|1200-px]]<br />
<br />
'''Arguments handled via the Wizard'''<br />
<br />
* startperiod <br />
* endperiod <br />
* max <br />
* time-format-frequency-id<br />
<br />
=== Other point to note ===<br />
==== Functions ====<br />
The TimeFormatFrequencyID parameter is now available when using the Functions:<br />
* FXLDataURL<br />
* FXLDataURLV<br />
* FXLDataURLFact<br />
<br />
[[File:TimeFormatFrequencyID.png|500px]]<br />
<br />
=== Refresh ===<br />
FXLData no longer uses the normal Excel calculations in Microsoft 365. As a result, if a change is made as describe here [[Refresh - FXLData#Refresh| Refresh article]] a manual refresh is necessary.<br />
<br />
The Refresh option is no longer restricted to older versions of Excel, the options available are detailed [[Refresh - FXLData#Office 2010-2019 Excel and Microsoft 365 Excel working in legacy Mode|here.]]<br />
<br />
Note that if the formula itself is deleted, you will also need to delete any returned data.</div>Vmurrellhttps://wiki.sdmxcloud.org/index.php?title=FXLData_what%27s_new_in_R1.3.3&diff=8191FXLData what's new in R1.3.32026-02-16T11:57:34Z<p>Vmurrell: Vmurrell moved page FXLData what's new in R1.3.3 to FXLData what's new in R1.3.03</p>
<hr />
<div>#REDIRECT [[FXLData what's new in R1.3.03]]</div>Vmurrellhttps://wiki.sdmxcloud.org/index.php?title=FXLData_what%27s_new_in_R1.3.03&diff=8188FXLData what's new in R1.3.032026-02-16T11:57:12Z<p>Vmurrell: Vmurrell moved page FXLData what's new in R1.3? to FXLData what's new in R1.3.3</p>
<hr />
<div>[[Category:How to and other features in FXLData]]<br />
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.<br />
<br />
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.<br />
<br />
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.<br />
<br />
Remember - to use these changes the FXLData add-in must be installed, follow the installation instructions found [[Downlad_and_Installation_FXLData |here.]]<br />
<br />
== FXLData Tab ==<br />
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.<br />
<br />
[[File:Appearance.png|800px]]<br />
<br />
=== [[Legacy Mode - FXLData |Legacy Mode]] ===<br />
The need for Legacy mode has been superseded by the removal of the Automatic Calculation facility. The Refresh button now works as expected and will perform an update on request.<br />
<br />
As part of the change you will notice that the ampersand is inserted into the query shown in the formula bar.<br />
<br />
'''Example:''' <br />
@FXLData("https://demo.metadatatechnology.com/FusionRegistry","WB,WDI_POVERTY,1.0",".SI_DST_02ND_20+SI_DST_03RD_20+SI_DST_04TH_20.",100,,,,"id","TRUE","FALSE","TRUE","FALSE","")<br />
<br />
=== Refresh ===<br />
FXLData no longer uses the normal Excel calculations in Microsoft 365. As a result, if a change is made as described here [[Refresh - FXLData#Refresh| Refresh article]] a manual refresh is necessary.<br />
<br />
The Refresh option is no longer restricted to older versions of Excel, the options available are detailed [[Refresh - FXLData#Office 2010-2019 Excel and Microsoft 365 Excel working in legacy Mode|here.]]<br />
<br />
Note that if the formula itself is deleted, you will also need to delete any returned data.<br />
<br />
=== Diagnostic Tool ===<br />
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.<br />
<br />
[[File:Diagnostic tool.png|1000px]]<br />
<br />
== FXLData Wizard ==<br />
<br />
===Dataflow Selection===<br />
<br />
A new selection box has been added to make it easier to select a dataflow.<br />
<br />
[[File:Dataflow selection.png|1000px]]<br />
<br />
===Selecting Items===<br />
[[File:Codelist display.png|1000px]]<br />
<br />
===Rest Arguments===<br />
<br />
The Wizard (available from the FXL Data tab) now includes a button to select the Rest Arguments Builder. Which can be used to specify additional SDMX query arguments that are not available through other options in the User Interface, such as round=2 for rounding numeric values. It is intended for the advanced user who needs finer control over the query behaviour.<br />
<br />
[[File:Rest-argument-builder-button.png|1000-px]]<br />
<br />
To use the Builder, select a dataflow and then click on the Builder button.<br />
<br />
Click the button to access the builder.<br />
<br />
[[File:Rest-argument-builder.png|1200-px]]<br />
<br />
'''Apply Button'''<br />
<br />
When the Apply button is pressed in the REST Arguments Builder, it performs the following action:<br />
<br />
* It populates the REST Args box on the main Wizard screen with the constructed query string based on the enabled and valid arguments.<br />
* It does not execute the FXLData function or retrieve any data at this stage.<br />
* To actually run the query and fetch data into Excel, the user must return to the Wizard screen and press its Apply button.<br />
This separation ensures the user can review and finalize their full query setup before triggering data retrieval.<br />
<br />
====Interaction with the Wizard====<br />
'''Existing Arguments'''<br />
<br />
If the wizard already contains rest arguments when the Builder is opened, it will attempt to interpret and reconstruct the existing argument as accurately as possible.<br />
<br />
[[File:Rest-arguments-box.png|1200-px]]<br />
<br />
'''Arguments handled via the Wizard'''<br />
<br />
* startperiod <br />
* endperiod <br />
* max <br />
* time-format-frequency-id<br />
<br />
=== Other point to note ===<br />
==== Functions ====<br />
The TimeFormatFrequencyID parameter is now available when using the Functions:<br />
* FXLDataURL<br />
* FXLDataURLV<br />
* FXLDataURLFact<br />
<br />
[[File:TimeFormatFrequencyID.png|500px]]<br />
<br />
=== Refresh ===<br />
FXLData no longer uses the normal Excel calculations in Microsoft 365. As a result, if a change is made as describe here [[Refresh - FXLData#Refresh| Refresh article]] a manual refresh is necessary.<br />
<br />
The Refresh option is no longer restricted to older versions of Excel, the options available are detailed [[Refresh - FXLData#Office 2010-2019 Excel and Microsoft 365 Excel working in legacy Mode|here.]]<br />
<br />
Note that if the formula itself is deleted, you will also need to delete any returned data.</div>Vmurrellhttps://wiki.sdmxcloud.org/index.php?title=FXLData_what%27s_new_in_R1.3%3F&diff=8189FXLData what's new in R1.3?2026-02-16T11:57:12Z<p>Vmurrell: Vmurrell moved page FXLData what's new in R1.3? to FXLData what's new in R1.3.3</p>
<hr />
<div>#REDIRECT [[FXLData what's new in R1.3.3]]</div>Vmurrellhttps://wiki.sdmxcloud.org/index.php?title=Change_Log_FR_-_V11_and_subsequent_releases&diff=8187Change Log FR - V11 and subsequent releases2026-02-12T13:19:32Z<p>Vmurrell: /* Version 11.4.3 (Released: 2022/09/13) */</p>
<hr />
<div>[[Category:Fusion Registry Change Logs]]<br />
[[Category:ChangeLogFR]]<br />
__NOTOC__<br />
<br />
= H1.3.0.02_RFS_10.10.25 - Released on December 12, 2025 =<br />
RFS-1901 - Improvement - Performance improvements when computing complex aggregates for big data sets<br />
<br />
= H1.3.0.01_RFS_10.10.25 - Released on October 9, 2025 =<br />
RFS-1722 - Enhancement - Performance improvements to generation of temporary (MVS) files.<br />
<br />
= R1.3.0.00_RFS_29.08.25 - Released on August 29, 2025 =<br />
RFS-1516 - Enhancement - Publication Table Editor allows the user to add only 150 rows in order to ensure performance. The limit has been increased to 350<br />
<br />
RFS-1523 - Bug Fix - Publication Tables - content within a loop did not iterate through the full range of defined dimensions. This issue has been fixed.<br />
<br />
RFS-1461 - Bug Fix - Where an Oracle database was in use, it was possible to have duplicate email subscriptions stored causing multiple email notifications. This has been resolved by converting all email addresses to lower case with duplicates not allowed.<br />
<br />
RFS-1443 - Bug Fix - In Publication Tables, added footnotes sometimes appeared in the middle of the table when exporting the table in Excel format. A bug was fixed that was causing footnotes to be written to the middle of the table in Publication Tables when exported in Excel format.<br />
<br />
RFS-1439 - Bug Fix - Remove Footnote Note button in Publication tables was not operational.<br />
<br />
RFS-1380 - Bug Fix - Temporary .mvs file were not always being deleted resulting in unnecessary disk usage. Changes have been made to improve the handling of .mvs and other temporary files to ensure they are deleted as appropriate.<br />
<br />
RFS-1378 - Bug Fix - Issue with operations on the Input Stream throwing an NPE. This issue has been resolved.<br />
<br />
RFS-1326 - Bug Fix - It was observed that there was inconsistent structure rendering taking place on some API responses from Fusion Registry after the cache had been cleared from the registry. A targeted fix for this issue at the point of cache clearing was applied.<br />
<br />
RFS-1284 - Bug Fix - Delete Language button not working in Codelists. Issue resolved.<br />
<br />
RFS-1278 - Bug Fix - Email notifications feature sends emails with 'null' in the subject and email content. The system now uses the name 'Fusion Registry' when this is not set. <br />
<br />
RFS-1258 - Bug Fix - Fresh install of the Registry, install page is headed with "Fusion Registry 11 - Install" making this out of date with the current product name and version. The heading on the install pages on a fresh install of the Registry now reads "Fusion Registry".<br />
<br />
RFS-1256 Fusion Registry V10.9.11 - Bug Fix - Two email notifications for structure submission and structure deletion events were issued and emails in different casings were also creating two subscriptions with the same email in different casings. The system has been modified so only one notification is sent per structure submission or structure deletion event.<br />
<br />
RFS-1189 - Bug Fix - Data Formats - Inconsistent behaviour in formats that do not support multiple measures. Standard messaging implemented.<br />
<br />
RFS-1182 - Bug Fix - If a large number of Provision Agreements existed, the Home Page was slow to load. Changes were made to the way the Home Page loads which has significantly improved performance.<br />
<br />
= H1.2.0.03_RFS_12.03.25 (Released March 12, 2025) =<br />
RFS-1443 - Enhancement - Issue with the placement of footnotes within Publication Tables. Support Ticket 415617.<br />
<br />
RFS-1054 - Enhancement - Change requested to the Fusion CSV Flat data format. A new CSV data format was added. It can be referenced by adding format=csv-bis as a query parameter to the data query URL. The new format orders data by time period (i.e. 2020, 2020M1, 2020Q2, 2021, 2021Q2, 2021M2) and also permanently adds the series short code as a column (e.g. CHN:BT:EX).<br />
<br />
= H1.2.0.01_RFS_20.02.25 (Released February 20, 2025) =<br />
<br />
== Changes ==<br />
RFS-1378 - Bug Fix - Previously, an error could occur which caused an NPE. This has been addressed. Support Ticket - 411382.<br />
<br />
RFS-1326 - Bug Fix - Previously, it was observed that there was inconsistent structure rendering taking place on some API responses from Fusion Registry after the cache had been cleared. A targeted fix for this issue at the point of cache clearing was applied.<br />
<br />
RFS-1182 - Bug Fix - Previously, if a large number of Provision Agreements existed, the Home Page was slow to load. This has been addressed. Support Ticket - 355829 & 404512.<br />
<br />
= R1.1.2.00_RFS_31.01.25 (Released January 31, 2025) =<br />
== Changes ==<br />
{| class="wikitable"<br />
|-<br />
! Jira Ticket !! Type !! Description !! Solution<br />
|-<br />
| RFS-1044 || Enhancement|| Previously, Fusion Data Store would throw an exception when attempting to append new measures to existing observations, which was inconsistent with SQL data sources that support such appends. || Added the ability to append new measures to existing observations within the Fusion Data Store.<br />
|-<br />
| RFS-1211 || Enhancement || Update the default data formats from 2.1 to 3.0. || The default data format has been updated from *SDMX-Compact-2.1* to {*}SDMX-Compact-3.0{*}, which introduces support for multi-measures. The previous format is still available and can be accessed via the web service dropdown or by specifying the {{"format"}} parameter in the URL. The Quick Convert feature is still using SDMX-Compact-2.1 format, and will be changed according to the changes in open-source in the future.<br />
|-<br />
| RFS-1233 || Bug Fix || Display issues found on Chrome || Change required following Chromium update release in November 2024. [https://wiki.sdmxcloud.org/Data_Structure_issue_November_2024 more information here.]<br />
|-<br />
| RFS-682 || Change|| Issue with Validation schemes and OBS_VALUE data type setting. || Numeric values formatting changed to plain string, as validation was not correctly interpreting scientific notation.<br />
|-<br />
| RFS-705 || Change || Out of date branding in the Info area.|| Regnology branding now displayed in the Info area.<br />
|-<br />
| RFS-706 || Change || Out of date branding on the Home Page footer line. || Regnology branding now displayed in the footer.<br />
|-<br />
| RFS-79 || New Feature|| Web Services Data || New fields in Web Services Data page to allow the user to specify the period. [https://wiki.sdmxcloud.org/Web_Services_-_GUI_-_Data More information here]<br />
|-<br />
| RFS-844 ||Enhancement|| Introduction of Multiple Measures || [https://wiki.sdmxcloud.org/Support_for_Multiple_Measures Support for data, Phase A]<br />
|-<br />
| RFS907 || Enhancement|| New Feature|| Loading Structures. This option is now available on every page.<br />
|}<br />
<br />
[[File:RFS-ReleaseNotes-R1.2.0.00 RFS 30.01.25.pdf |Release Notes]]<br />
<br />
== R1.1.0.00_RFS_05.07.24 (Released 15.07.2024) ==<br />
<br />
This release was delivered by Regnology and the Version numbering has changed along with the ticket numbering system (RFS) used to display changes below. <br><br />
<br />
[[File:RFS-ReleaseNotes-R1.1.0.00 RFS 05.07.24 1 .pdf]]<br />
<br />
== Changes ==<br />
RFS-493 - Tableau Connector. [[Tableau_Connector | New connector released.]] This has resulted in behavioural changes for the Observational Value [[Tableau_Connector#Observation_Value | - more information available here.]]<br />
<br />
== Bug Fixes: ==<br />
<br />
RFS-580 - Web Services Query ] Problem with "completecube" parameter when using the Data Query Web Service when multiple values are provided. <br><br />
RFS-514 - Problem with Publication tables when series queries with wild cards present.<br><br />
RFS-436 - Web Services -Data - System unable to process large volumes of data when Excel Export selected resulting in a need to re-boot. This has been resolved by implemented the Series and Observation limit in the Admin -Server Settings - XLSX format. <br><br />
RFS-433 - Registry Managed Database - Temporary Table unavailable causing data load failure.<br><br />
RFS-287 - Download Structures - Warning message when trying to download non SDMX structures in SDMX format missing. Message implemented - JSON format should be used.<br><br />
<br />
==Version 11.13.0 (Released: 2024/02/08)==<br />
Based on FMR 11.14.1<br><br />
<br />
'''Change:'''<br><br />
RFS-22: Creating "flat CSV" no longer includes unecessary Sibling Group entries at the start of the file<br><br />
<br />
'''Improvements:'''<br><br />
RFS-181: Support for SDMX-ML v3.0 Data<br><br />
RFS-39: Update vulnerable third-party dependencies<br><br />
<br />
'''Bug Fixes:'''<br><br />
RFS-163: Data Web Service contains duplicate entry for "Excel"<br><br />
RFS-164: Data Web Service contains unstyled text label<br><br />
RFS-76: "lastUpdated" parameter not working correctly on Data Query for external databases<br><br />
<br />
==Version 11.12.3 (Released: 2023/11/24)==<br />
Based on FMR 11.13.0<br><br />
<br />
'''Bug Fix:'''<br><br />
FR11-217: Concurrent modification exception in cache<br />
<br />
==Version 11.12.2 (Released: 2023/11/22)==<br />
Based on FMR 11.13.0<br><br />
<br />
'''Change:'''<br><br />
FR11-216: REST query which results in no data now returns a 404 with an SDMX error message, was previously an empty dataset<br><br />
<br />
'''Bug Fix:'''<br><br />
FR11-215: Publication Tables: 'includePeriod' REST query parameter returns no data when multiple Dataflows are used and 1 has no data<br><br />
<br />
==Version 11.12.1 (Released: 2023/11/21)==<br />
Based on FMR 11.13.0<br><br />
<br />
'''Improvement:'''<br><br />
FR11-211: Improvements to the "Test Mapping" feature<br><br />
<br />
'''Bug Fix:'''<br><br />
FR11-214: Registry can consume all connections to an External Data Store<br><br />
<br />
==Version 11.12.0 (Released: 2023/11/20)==<br />
Based on FMR 11.13.0<br><br />
<br />
'''New Features:'''<br><br />
FR11-210: Publication Table: Calculation expression to support default value when no Observation found<br><br />
FR11-213: Publication Tables: Calculation expression to support default value if no reported value found<br><br />
<br />
'''Bug Fix:'''<br><br />
FR11-212: Publication Table: Formatting issue using partial keys - returns 400 exception<br><br />
<br />
==Version 11.11.0 (Released: 2023/11/03)==<br />
'''New Features:'''<br><br />
FR11-206: Create aggregate series using linked Hierarchy<br><br />
FR11-207: Data Query detail parameter; added 'raw' as a new value to support export of data with no calcualted values via hierarchical aggregations<br><br />
<br />
'''Bug Fixes:'''<br><br />
FR11-208: In a Generated Reporting Template permit format modification on Observation Cells<br><br />
FR11-209: Publication Table: Issue applying formatting rules across multiple Dataflows<br><br />
<br />
==Version 11.10.1 (Released: 2023/09/15)==<br />
'''Bug Fix:'''<br><br />
FR11-205: saveas=[filename].zip from v1 SDMX web service results in a corrupt zip<br><br />
<br />
==Version 11.10.0 (Released: 2023/09/11)==<br />
Based on FMR 11.10.1<br />
<br />
'''New Features:'''<br><br />
FR11-195: Publication Tables: Allow dependant variables to be overridden from the API<br><br />
FR11-197: Default response formats in v2 web service are now configurable<br><br />
FR11-203: Kafa: new topic to publish structure transaction events to<br><br />
FR11-204: Kafa: new topic to publish reference metadata events to<br><br />
<br />
'''Change:'''<br><br />
FR11-202: Structure Format response is no longer auto detected if not explicitly set (takes value from default setting)<br><br />
<br />
'''Improvement:'''<br><br />
FR11-198: Querying for data by observation attributes<br><br />
<br />
'''Bug Fixes:'''<br><br />
FR11-199: saveas=zip is not working on v2 API<br><br />
FR11-200: Publication table: Formatting cells ignores UNIT_MULT when it is reported as a dataset level attribute<br><br />
FR11-201: Publication table: Conditional Formatting being applied when condition references a Component which is not present in DSD<br><br />
<br />
==Version 11.9.6 (Released: 2023/08/25)==<br />
'''Changes:'''<br><br />
FR11-163: Validator: "Missing Attributes" renamed to "Missing Components" and reports on missing Measures<br><br />
FR11-164: Add "Output Required" UI control to Structure Mapping<br><br />
FR110188: Adding a observation formatting rule treats comma separeted component ids as an AND operator (was OR)<br><br />
<br />
'''Improvements:'''<br><br />
FR11-146: Update Apache POI to version 5<br><br />
FR11-147: Update Commons-fileupload third-party dependency<br><br />
FR11-148: Update Spring dependencies<br><br />
FR11-149: Update Jettison third-party dependency<br><br />
FR11-150: Web Service to refresh caches<br><br />
FR11-158: Merging a Codelist should merge Locale information<br><br />
FR11-160: Update Spring and Jackson Dependencies<br><br />
FR11-161: Implment caching on publication tables<br><br />
FR11-167: Improve Mapping functionality so that it can perform Validation<br><br />
FR11-171: Portal File system sweep - allow files to be placed in root of sweep directory<br><br />
FR11-173: Update Kryo to version 5.5.0<br><br />
FR11-174: Publication Tables - not formatting numbers with scientific notation<br><br />
FR11-175: Components with Time based Mappings cannot be edited in the Structure Map Wizard<br><br />
FR11-176: Support Custom Plugins<br><br />
FR11-190: Add SDMX-JSON v2 to the UI<br><br />
FR11-191: Restore Fusion Security as an authentication mechanism<br><br />
FR11-192: FMR#481: Duplicated group IDs for schema queries in SDMX-JSON<br><br />
FR11-193: Mapped Datasets Configuration - new option "Output Required"<br><br />
<br />
'''Bug Fixes:'''<br><br />
FR11-151: Item Validity not returning most recent entry prior to today's date<br><br />
FR11-152: Subscript out of range error with FusionXL when carriage return is in the name of a structure<br><br />
FR11-153: No transactions returned on SDMX Transactions page when using date slider<br><br />
FR11-155: Publicaiton Table Editor: Dependent Variables, remove variable button does not work<br><br />
FR11-156: Publication Table availabililty algorithm modified to better calculate default values when using multiple dataflows<br><br />
FR11-157: FusionXL resolve carriage returns in concept names<br><br />
FR11-159: Cross references not updated correctly when structure already exists<br><br />
FR11-162: Update Vulnerable Dependencies for FMR 11.7.0<br><br />
FR11-165: Validating Generic Data can result in IllegalElement error<br><br />
FR11-166: FMR#418 - Conversion and mapping services fail to read SDMX CSV 2.0 format files with BOM<br><br />
FR11-168: CSV-TS data format outputting names as labels does not output labels in last Dimension/Attribute column<br><br />
FR11-169: RegEx Capture Groups for Representation Map only support 0-9 (\10 and above does not work)<br><br />
<br />
==Version 11.9.5 (Released: 2023/03/08)==<br />
'''Change:'''<br><br />
FR11-140: Modification of interpration of SDMX-CSV V2 row https://github.com/bis-med-it/fmr/issues/349<br><br />
<br />
'''Improvement:'''<br><br />
FR11-145: Fusion Excel Export Data API now takes an additional 'attachment' parameter<br><br />
<br />
'''Bug Fixes:'''<br><br />
FR11-137: Removal of dependencies: gson, protobuf, closure, args4j<br><br />
FR11-138: Unable to load Structure File when Mapping refers to DSD with ValueList coded dimension https://github.com/bis-med-it/fmr/issues/359<br><br />
FR11-141: Caching in reference metadata requests https://github.com/bis-med-it/fmr/issues/356<br><br />
FR11-142: Parsing EDI fails to detect malformed period https://github.com/bis-med-it/fmr/issues/362<br><br />
FR11-143: EDI REL segment must be followed by ARR segment https://github.com/bis-med-it/fmr/issues/322<br><br />
FR11-144: Publication Table - Calculations which contain missing values should not output a value<br><br />
<br />
==Version 11.9.4 (Released: 2023/02/17)==<br />
'''Bug Fixes'''<br><br />
FR11-135: Publication Table - calculated values could come back as enginnering string when standard form is requested<br><br />
FR11-136: Regression mapped data store was not mapping rows with null attribute values<br><br />
<br />
==Version 11.9.3 (Released: 2023/02/16)==<br />
'''Bug Fixes:'''<br><br />
FR11-129: Temporary "MV" files not being cleared up after data transformation https://github.com/bis-med-it/fmr/issues/346 <br><br />
<br />
'''Improvements:'''<br><br />
FR11-131: Improve Performance of large Codelists which have Item Validity https://github.com/bis-med-it/fmr/issues/353 <br><br />
FR11-133: Improve linking to external datasource by auto detecting foreign key <br><br />
<br />
==Version 11.9.2 (Released: 2023/02/13)==<br />
'''Change:'''<br><br />
FR11-132: Supported 'latest' in v2 query to prevent errors in connected tools<br><br />
<br />
==Version 11.9.1 (Released: 2023/02/10)==<br />
'''Bug Fix:'''<br><br />
FR11-128: Security rule on OBS Attribute blocks observation when value is null<br><br />
<br />
==Version 11.9.0 (Released: 2023/02/03)==<br />
'''Improvements:'''<br><br />
FR11-117: Provide option to skip Validation phase in Transform Web Service https://github.com/bis-med-it/fmr/issues/237<br><br />
FR11-120: Publication Table - apply number formatting to calculated cells<br><br />
FR11-121: Publication Table - Apply number scaling before calculations<br><br />
<br />
'''Change:'''<br><br />
FR11-118: Use the public fastUtil library https://github.com/bis-med-it/fmr/issues/338<br><br />
<br />
'''Bug Fixes:'''<br><br />
FR11-116: Timezone issue with REST API resulting in no data<br><br />
FR11-119: Codelists with Annotations not being correctly parsed in SDMX-JSON https://github.com/bis-med-it/fmr/issues/345<br><br />
FR11-123: EDI should prevent Quadruplet attributes in Footnote Section https://github.com/bis-med-it/fmr/issues/347<br><br />
FR11-124: EDI file missing mandatory Period Information validates successfully https://github.com/bis-med-it/fmr/issues/348<br><br />
FR11-125: Improve validation of EDI DTM segment https://github.com/bis-med-it/fmr/issues/351<br><br />
FR11-126: Publication Table - decimal places (fixed) truncated trailing zero places when locale was also set<br><br />
FR11-127: Duplicate elements in SDMX CSV result in unexpected output https://github.com/bis-med-it/fmr/issues/342 <br><br />
<br />
==Version 11.8.2 (Released: 2023/01/17)==<br />
'''Improvements:'''<br><br />
FR11-108: Prevent contradictory excel mappings (generted from Fame Metadata Manager) worksheets being uploaded to Registry<br><br />
FR11-109: Flag contradictory excel mappings (generted from Fame Metadata Manager) in generated worksheet <br><br />
FR11-134: Improve Metrics Report with IncUnmappedReport option <br><br />
<br />
'''Changes:'''<br><br />
FR11-111: Change ID Generation of Representation Map from FusionFameMapper xlsx files.<br><br />
FR11-115: Ensure Implicit Mappings in Structure Maps validate codelists for valid intersection <br><br />
<br />
'''Bug Fixes:'''<br><br />
FR11-107: Parent codes should be included in reference partial<br><br />
FR11-110: Complete Cube web service feature outputs empty measure values (not 0 values)<br><br />
FR11-112: Data export formats excel-ts and excel-series can miss observations in output series if series contains observations with no measure values and no attribute values<br><br />
FR11-113: Fix 'too much recursion' error with reverse engineer data structure with large number of Dimensions<br><br />
FR11-114: Validate submission of Structure Map's Implicit mappings to ensure Coded mappings have a valid intersection from source to target <br><br />
<br />
==Version 11.8.1 (Released: 2023/01/11)==<br />
'''Bug Fixes:'''<br><br />
FR11-101: Unable to import Codelists with multiple levels of inheritence in same submission as structures that use inherited codes<br><br />
FR11-102: Bulk actions - detail=raw is ignored<br><br />
FR11-103: REST query: detail=raw is not applied to referenced codelists<br><br />
FR11-104: IncValid output may contain empty series when it should not be generated<br><br />
FR11-105: Annotations are ignored when importing 2.1 XML Hierarchical Codelists<br><br />
FR11-106: format=csv-series null pointer<br><br />
<br />
==Version 11.8.0 (Released: 2022/12/21)==<br />
'''Important Note for MySQL users:''' due to changes in the distribution of the MySQL connector (change FR11-94 below), please read [[Install_MySQL#Installing_MySQL_5.7|this article]].<br />
<br />
'''New Feature:'''<br><br />
FR11-98: Publication Table - support a scaling function applied to numerical observations<br />
<br />
'''Improvement:'''<br><br />
FR11-93: Improve Performance of Viewing a Hierarchy https://wiki.sdmxcloud.org/Publication_Table#Formatting_Numerical_Observation_Values<br />
<br />
'''Changes:'''<br><br />
FR11-91: Validation and Transformation should preserve original format unless output format specified <br><br />
https://wiki.sdmxcloud.org/Data_Validation_Web_Service#HTTP_Headers see Accept Header<br><br />
https://wiki.sdmxcloud.org/Data_Transformation_Web_Service#HTTP_Headers see Accept Header<br><br />
FR11-94: Remove MySQL Connector https://wiki.sdmxcloud.org/Install_MySQL#Installing_MySQL_5.7<br />
<br />
'''Bug Fixes:'''<br><br />
FR11-89: Support dataset attribute consolidation (detection of duplicates)<br><br />
FR11-90: Observation deletions are no longer written in EDI format<br><br />
FR11-92: NPE when publishing EDI data from Command Line<br><br />
FR11-95: Publication Table - UI changes table definition (looses column) when clicking preview table <br><br />
FR11-96: Publication Table - Preview table error when table heading Rowspan > 1<br><br />
FR11-97: Publication Table - bug fix on formatting obs which removed values from output table<br><br />
FR11-99: Publication Table - Scientific Notation shows NaN in UI and is not applied to observation values<br><br />
FR11-100: Refreshable workbook - issue security challenge when connecting to private server<br><br />
FMR11-207: Transforming Data with "Delete" action can leave erroneous output in EDI format<br><br />
FMR11-217: Publication Tables: Numerical Observation, "Add Rule" button does not work<br><br />
FMR11-224: Failure to report unmapped data when using TIME_PERIOD mapping<br><br />
<br />
==Version 11.7.2 (Released: 2022/11/22)==<br />
'''Change:'''<br><br />
FR11-84 - In SDMX CSV, SERIES_KEY and OBS_KEY will output with the quote marks around the whole key<br><br />
<br />
'''Bug Fixes:'''<br><br />
FR11-80 - Validation on Group ID should ignore case<br><br />
FR11-82 - Size of column in Portal Table not large enough to contain Data Source ID<br><br />
FR11-85 - When loading via Registry UI, Data file with Duplicate Series results in MV Store Error<br><br />
FR11-86 - Viewing a Representation Map has issue with "valid from" on Mappings<br><br />
<br />
==Version 11.7.1 (Released: 2022/11/15)==<br />
'''New Feature:'''<br><br />
FR11-83 - Support Categorise Publication Table via the UI<br><br />
<br />
==Version 11.7.0 (Released: 2022/11/11)==<br />
'''New Feature:'''<br><br />
FR11-78 - Publication Table Support Numerical Observation formatting<br><br />
<br />
'''Bug Fixes:'''<br><br />
FR11-79 - Fix an issue when "edi.datagroup.identifier" specified with value of asterisk<br><br />
FR11-80 - Validation on Group ID should ignore case<br><br />
FR11-81 - Data Portal - ESTAT Connector fix<br><br />
<br />
==Version 11.6.0 (Released: 2022/11/31)==<br />
'''New Features:'''<br><br />
FR11-76 - [[Audit_Web_Services#Search_Structure_Queries|Audit Structure Queries]]<br> <br />
FR11-77 - [[Audit_Web_Services#Search_Data_Queries|Audit Data Queries]]<br><br />
<br />
'''Improvements:'''<br><br />
FR11-75 - Support for extended UTF-8 characters https://github.com/MEDIT-Org/fmr/issues/297 <br> <br />
<br />
'''Change:'''<br><br />
FR11-65 - Update FontAwesome to use Version 6<br><br />
<br />
'''Bug Fixes:'''<br><br />
FR11-71 - Corrected issue with Dynamic Attributes<br><br />
FR11-72 - Version Drop-Down not Displayed when Selected Item on Page Load<br><br />
FR11-74 - Security Group Web Service does not output UTF-8 characters<br><br />
FR11-65 - Update Web Services "structure" page so the plus symbol is used for "latest"<br />
<br />
==Version 11.5.2 (Released: 2022/10/14)==<br />
'''New Feature:'''<br><br />
FMR11-194 - Publication Table - support casting dates more then once in same expression<br><br />
<br />
'''Improvement:'''<br><br />
FMR11-202 - Update dependencies: Hibernate, Spring-Kafka, Jettison and Jersey https://github.com/MEDIT-Org/fmr/issues/294<br><br />
<br />
'''Bug Fixes:'''<br><br />
FR11-66 - "Metadata Provider Scheme" not listed on Web Service -> Structures page<br> <br />
FR11-67 - "Metadata Provider Wizard" does not allow Providers to start with a numeric yet the SDMX Standard allows this<br> <br />
FR11-68 - "Metadata Provider Scheme" not listed on Cross References page<br> <br />
FR11-69 - Attaching Reference Metadata to Items in an item scheme fails to add link (cache issue)<br> <br />
FMR11-189 - Behaviour of web service resolving multiple Codelist inheritance with "details=raw" https://github.com/MEDIT-Org/fmr/issues/257<br><br />
FMR11-196 - Unable to read Excel Spreadsheet where all Frequencies are Formulas<br> <br />
FMR11-197 - Request for Codelist in SDMX-JSON, "details=raw", references="children" doesn't return children as raw https://github.com/MEDIT-Org/fmr/issues/257<br> <br />
FMR11-198 - Request for Codelist in SDMX-JSON, "details=raw", references="descendants" doesn't return descendants https://github.com/MEDIT-Org/fmr/issues/257<br> <br />
FMR11-199 - "Metadata Provider Scheme" not listed on Web Service -> Structures page <br> <br />
FMR11-200 - "Metadata Provider Wizard" does not allow Providers to start with a numeric yet the SDMX Standard allows this<br> <br />
FMR11-201 - "Metadata Provider Scheme" not listed on Cross References page <br> <br />
FMR11-203 - Attaching Reference Metadata to Items in an item scheme fails to add link (cache issue) <br> <br />
FMR11-205 - Version Number not Displayed when Selected Item on Page Load<br><br />
<br />
==Version 11.5.1.1 (Released: 2022/10/10)==<br />
'''Change:'''<br> <br />
FR11-73 - Modify SQL to ensure GMT Timezone is used<br><br />
<br />
==Version 11.5.1 (Released: 2022/10/05)==<br />
'''New Features:'''<br> <br />
FR11-60 - Publication Table - support casting dates more then once in same expression<br><br />
FR11-61 - orderMeasure web service parameter to sort observations by date asc/desc<br><br />
<br />
==Version 11.5.0 (Released: 2022/09/28)==<br />
'''New Features:'''<br> <br />
FMR11-187/FR11-53 - Support recovery of structure transactions from backup on installation [[Backup_and_Restore|FMRCL]] https://github.com/MEDIT-Org/fmr/issues/277 <br> <br />
FR11-52 - Support variable number of max arguments to a SQL IN statement<br> <br />
FR11-58 - Support import of datafile containing mulitple datasets<br><br />
<br />
'''Improvements:'''<br> <br />
FMR11-183 - Update dependencies https://github.com/MEDIT-Org/fmr/issues/277<br> <br />
FR11-48 - Update third-party dependencies: apache-jstl, commons-dcp2, joda-time, spring, tika-core<br> <br />
FR11-45 - Add Version Number to Provision Agreement Selector in Data Source Manager Modal<br> <br />
<br />
'''Bug Fixes:'''<br> <br />
FMR11-181/FR11-46 - SDMX CSV v 2.0 Data Format does not report its format https://github.com/MEDIT-Org/fmr/issues/110<br> <br />
FMR11-184/FR11-49 - Support '*' for structure type in REST API https://github.com/MEDIT-Org/fmr/issues/273<br> <br />
FMR11-185/FR11-51 - Failure on Compare Revision shows Stack Trace https://github.com/MEDIT-Org/fmr/issues/278<br> <br />
FMR11-186/FR11-55 - SDMX-JSON Writer not outputting DSD as stub https://github.com/MEDIT-Org/fmr/issues/274<br> <br />
FR11-50 - FameMapper code is creating Excel files in temporary storage which are not deleted<br> <br />
FR11-54 - EDI data not fully consolidated when publishing data via web service<br><br />
<br />
==Version 11.4.3 (Released: 2022/09/13)==<br />
'''New Features:'''<br> <br />
FMR11-174 - Publication Tables: Formatting of Missing Values support ObsValue=NaN https://github.com/MEDIT-Org/fmr/issues/253<br> <br />
FMR11-175 - Support Reading of Reference Metadata (with restrictions) in version 2.1 SDMX https://github.com/MEDIT-Org/fmr/issues/250<br> <br />
<br />
'''Improvement:'''<br> <br />
FMR11-182 - Modify ID generation strategy for importing Reference Metadata at v2.1<br> <br />
<br />
'''Bug Fixes:'''<br> <br />
FR11-39 - OBS_PRE_BREAK validation corrected<br> <br />
FR11-43 - SDMX DSD output may include invalid attribute "isMultiLingual"<br> <br />
FR11-44 - SQL Server does not delete temporary tables<br> <br />
FMR11-169 - SDMX CSV v1 Data Reader does not allow header fields (row 1) to be double quoted <br> <br />
FMR11-170 - Bulk Export - spelling mistake on Raw help text<br> <br />
FMR11-171 - Order of revisions not as expected<br> <br />
FMR11-176 - OBS_PRE_BREAK validation corrected<br> <br />
FMR11-178 - Quadruplet in EDI vs the other formats in the context of data consolidation or integration https://github.com/MEDIT-Org/fmr/issues/118<br> <br />
FMR11-179 - SDMX DSD output may include invalid attribute "isMultiLingual" https://github.com/MEDIT-Org/fmr/issues/255<br><br />
<br />
==Version 11.4.2 (Released: 2022/08/19)==<br />
'''Bug Fixes:'''<br><br />
FR11-30 - Fusion Security Manager will not accept AD group names longer than 30 characters<br><br />
FR11-34 - Updated third-party dependencies<br><br />
<br />
==Version 11.4.1 (Released: 2022/08/10)==<br />
'''Bug Fixes:'''<br><br />
FR11-21 - Issue loading data into SQL Server in Registry managed table <br />
FR11-26 - Bulk Export - spelling mistake on Raw help text<br><br />
FR11-27 - Order of revisions not as expected<br><br />
FR11-28 - JNDI Registry Managed Database - unable to load data<br><br />
FR11-25 - SDMX CSV v1 Data Reader does not allow header fields (row 1) to be double quoted<br><br />
<br />
==Version 11.4.0 (Released: 2022/07/22)==<br />
'''New Feature:'''<br><br />
FR11-18 - Support Reference Metadata https://wiki.sdmxcloud.org/Reference_Metadata<br><br />
<br />
'''Improvement:'''<br><br />
FMR11-146 - Dependency updates<br><br />
FMR11-159 - Add "Raw" option to Download structures and remove "Include internal settings"<br><br />
FMR11-160 - Allow a Concept Representation to be a ValueList<br><br />
<br />
'''Bug Fixes:'''<br><br />
FR11-14 - Issue loading Data Constraint with a Component element under Cube Region element<br><br />
FR11-17 - Attribute variable does not work in table heading<br><br />
FR11-19 - Increase max size of security group ID from 30 to 100 characters<br><br />
FMR11-162 - SERIES_KEY column should be reserved for series keys<br><br />
FMR11-161 - Issue loading Data Constraint with a Component element under Cube Region element<br><br />
FMR11-163 - Attribute variable does not work in table heading<br><br />
FMR11-166 - Duplicate attribute is not detected anymore in FMR<br><br />
FMR11-167 - Publication Table - Array Variables fail to save<br><br />
FMR11-168 - Error encountered whist attempting to deserialize structure<br><br />
<br />
==Version 11.3.0 (Released: 2022/07/06)==<br />
'''New Feature:'''<br> <br />
FR11-10/FMR11-153 - [[Synchronise_structural_metadata_between_environments|Environment Synchronisation - compare the structural metadata content with that from another Registry, push or pull changes]]<br />
<br />
'''Improvement:'''<br><br />
FMR11-158 - [[Publication_Table#Footnotes|Publication Table: Footnotes support]]<br />
<br />
'''Bug Fixes:'''<br><br />
FMR11-152 - Comma not being processed correctly in Web Service query for ItemBeans<br> <br />
FMR11-154 - Unexpected structure validation error from FMR<br><br />
FMR11-155 - Structure validation errors are not detected anymore in FMR<br><br />
FMR11-156 - v2 structure REST API does not support queries for multiple items using the comma syntax<br><br />
FMR11-157 - Typo in header of Representation Maps page<br><br />
<br />
==Version 11.2.0 (Released: 2022/06/27)==<br />
'''New Feature:'''<br><br />
[FMR11-150] Specify the validation and transformation behaviour when duplicate observations are found - [[Data_Transformation_Web_Service#HTTP_Headers|https://wiki.sdmxcloud.org/Data_Transformation_Web_Service#HTTP_Headers]]<br><br />
<br />
'''Bug Fixes:'''<br><br />
[FR11-3] Schema Query in structure format does not work<br><br />
[FR11-4] Fusion Cache ignoring parameters like normalise freq on V1 data queries<br><br />
[FR11-5] Data Point Security - allow rule against a series attribute value that does not exist in the dataset restricts all data<br><br />
[FR11-8] Comma not being processed correctly in Web Service query for ItemBeans<br><br />
[FMR11-141] Re-opening of Alternate Half year Issue<br><br />
[FMR11-143] TIME_FORMAT not being generated correctly<br><br />
[FMR11-144] Problem with Date data type when reverse engineering a DSD from a CSV dataset<br><br />
[FMR11-145] Problem with Description data type when reverse engineering a DSD from a CSV dataset<br><br />
[FMR11-147] DSD Wizard step 3 - not allowing Enumerated Representation <br><br />
[FMR11-148] Schema Query in Structure Format does not work<br><br />
<br />
'''Improvement:<br>'''<br />
[FMR11-140] Revert xsi:type=SiblingType, change the schema to output the Group as Sibling not SiblingType -<br />
<br />
==Version 11.1.0 (Released: 2022/06/01)==<br />
'''New Feature:'''<br><br />
[[Publication_Table|Publication Tables]]<br><br />
[FR-5130] [https://wiki.sdmxcloud.org/Publication_Table#Looping_Rows Publication Table - Support Dynamic Rows]<br><br />
[FR-5131] [https://wiki.sdmxcloud.org/Publication_Table#Formatting_Missing_Observations Publication Table - Format rules on cells with no data ]<br><br />
[FR-5132] [https://wiki.sdmxcloud.org/Publication_Table#Dependent_Dimension_Variable Publication Table - Rules to derive a Dimension Value from another Dimenison's value]<br><br />
[FR-5133] [https://wiki.sdmxcloud.org/Publication_Table#Anchor_Rows Publication Table - Option to output rows with no data ] <br><br />
[FR-5134] [https://wiki.sdmxcloud.org/Publication_Table_Web_Services#Materialise_Publication_Table Publication Table - Ouput Materialised Table in Excel ]<br><br />
<br />
'''Improvement:'''<br><br />
[FR-5129] - Support for MySQL 8 and above<br><br />
<br />
==Version 11.0.0 (Released: 2022/05/22)==<br />
'''Changes and New Features:'''<br><br />
* Change to the SDMX 3.0 information model as Fusion Registry’s internal metadata object model<br />
* SDMX 3.0 REST API support<br />
* Backward compatibility for SDMX 2.1 and 2.0 structures and formats<br />
* Backward compatibility with SDMX 2.1 REST API (REST API v1 specification)<br />
* Improved data and metadata access control<br />
* Granular control over admin rights<br />
* Fusion Portal – scheduled and on demand data and structure loads<br />
* Refreshable Excel data format<br />
* JNDI database connection option<br />
* Publication Tables - publish curated but dynamic user interactive web data tables that show precisely the statistics required even if they come from multiple different data sets<br />
<br />
'''Breaking Changes from Fusion Registry 10:'''<br><br />
* Change to the operating database schema - upgrading from Fusion Registry 10 to Fusion Registry 11 requires a fresh install and migration of the metadata, data and settings. A change has been made to the operating database schema. The upgrade process must be followed carefully when [https://wiki.sdmxcloud.org/Upgrading_from_FR_V10_to_FR_V11 upgrading to Version 11.]<br />
* Environment sync function temporarily removed.<br />
* The Metadata Reports function has been temporarily removed.<br />
* Fusion Security support deprecated - Active Directory and LDAP are the supported authentication services in Fusion Registry 11.<br />
* Content Security is no longer supported in Version 11, the functionality has been replaced by [https://wiki.sdmxcloud.org/Main_Page#Fusion_Security_Manager_Topics| Fusion Security Manager]<br />
* Structure Sets are replaced by Structure and Representation Maps.<br />
* Hierarchical Codelists are replaced by Hierarchies.</div>Vmurrellhttps://wiki.sdmxcloud.org/index.php?title=Change_Log_Fusion_Data_Browser&diff=8186Change Log Fusion Data Browser2026-01-30T14:56:33Z<p>Vmurrell: /* H1.3.0.03._RFS_31.01.26 (Released TBA) */</p>
<hr />
<div>[[Category:Fusion Data Browser]]<br />
__NOTOC__<br />
== H1.3.0.03._RFS_31.01.26 - Released 30.01.2026 ==<br />
RFS-2094 - Fix - The dataflow categories set up in Fusion Registry were not reflected in Fusion Data Browser.<br />
<br />
== R1.1.2.00_RFS_31.01.25 (Released 31.01.2025) ==<br />
==Changes==<br />
RFS-429 - Fix to ensure corrects results of a search are returned irrespective of chosen locale. <br><br />
RFS-1024 - Copyright updated.<br />
<br><br />
<br />
== R1.1.0.00_RFS_05.07.24 (Released 15.07.2024) ==<br />
<br />
This release was delivered by Regnology and the Version numbering has changed along with the ticket numbering system (RFS) used to display changes below. This release includes some branding changes to move away from Metadata Technology branding such as the about page.<br><br />
<br />
==Enhancement==<br />
RFS-378 - The basket type data availability query was enhanced to not return dataflows in a deterministic order.<br><br />
RFS-377 - Confirmation notification added to advise when series have been added to a series basket.<br />
<br />
== Version 2.4.0 (Released: 2023/01/18) ==<br />
'''New Feature'''<br><br />
[FDB-164] Manage Dataflow modal - Support Max Decimals applied to all data queries for the Dataflow<br><br />
[FDB-165] Define how Obs with no reported value are displayed in Series List page<br><br />
[FDB-168] modify siteconfig.json - remove ExportFormats, SeriesList<br><br />
[FDB-166] remove seriesconfig.json create serieslistconfig.json to include Series List specific properties<br><br />
[FDB-167] remove chartconfig.json move time series properties to new file tschartconfig.json<br><br />
<br />
== Version 2.3.1 (Released: 2022/12/05) ==<br />
'''Improvement'''<br><br />
[FDB-157] Order filters by Dimension order<br><br />
<br />
'''Bug Fixes'''<br> <br />
[FDB-158] Search result - action buttons missing in search result page (intermittent)<br><br />
[FDB-159] Series list quick view concepts and values not displaying chosen language<br><br />
<br />
== Version 2.3.0 (Released: 2022/11/15) ==<br />
'''New Feature'''<br><br />
[FDB-155] Allow home page text to be modified<br><br />
<br />
'''Improvement'''<br><br />
[FDB-156] Encode user input in forms to prevent script injection <br><br />
<br />
'''Bug Fix'''<br><br />
[FDB-154] Quick filter - incorrect list can occur when using shared Concepts between Dataflows<br />
<br />
== Version 2.2.3 (Released: 2022/09/09) == <br />
'''New Feature'''<br><br />
[FDB-153] Search term can be passed in via the URL to load the browser on the search results page<br><br />
<br />
== Version 2.2.2 (Released: 2022/07/11) == <br />
'''Change'''<br><br />
[FDB-151] Have login model appear automatically when used against Fusion Registry in private mode<br><br />
<br />
'''Bug Fix'''<br><br />
[FDB-152] PDQ with multilingual name - edit only shows name in 1 language<br><br />
<br />
== Version 2.2.1 (Released: 2022/06/27) == <br />
'''Bug Fix'''<br><br />
[FDB-149] Did not show login option when used against Fusion Registry in private mode<br><br />
<br />
== Version 2.2.0 (Beta) (Released: 2022/06/21) ==<br />
'''New Feature'''<br><br />
[FDB-145] Added run query button to Manage Predefined Query page<br><br />
<br />
'''Improvement'''<br><br />
[FDB-146] Delete Predefined Query to remove all categorisations automatically<br><br />
<br />
'''Change'''<br><br />
[FBD-148] Login no longer forces a full page refresh<br><br />
<br />
'''Bug'''<br><br />
<br />
[FDB-147] Remove share button from series basket page<br><br />
== Version 2.1.0 (Released: 2022/06/13) ==<br />
'''New Feature'''<br><br />
<br />
[FDB-144] Dynamic Attribute Export Parameter to support show only obs/series/dataset attributes https://wiki.sdmxcloud.org/Data_Export_Configuration#Attribute_Parameters<br><br />
<br />
[FDB-143] PreDefined Query to appear under a Categorised Dataflow in the sidebar<br><br />
'''Improvement'''<br><br />
<br />
[FDB-141] Performance Improvement on initial load (less metadata transferred)<br><br />
<br />
'''Bug'''<br><br />
<br />
[FDB-142] Refresh page does no work in all environments (reqiured for login/change locale)<br><br />
<br />
[FDB-140] NPE when clicking save query if FR has an Agency Scheme with no agencies<br><br />
<br />
[FDB-134] Series basket - problems with Save basket box when you try and create a 4th Series Basket<br><br />
==Version 2.0.4 (Released: 2022/05/04)==<br />
'''Bug Fixes'''<br><br />
[FDB-139] Null pointer if SiteConfig includes DSD Attributes in the Sidebar configuration<br><br />
<br />
==Version 2.0.3 (Released: 2021/12/22)==<br />
Compatible with Fusion Edge Server v4.0.0<br />
<br />
==Version 2.0.2 (Released: 2021/12/22)==<br />
'''Bug Fix'''<br><br />
Setting date from and date to with calulations could cause a URL syntax error if calcuations set first<br><br />
'''Improvement'''<br><br />
Time series chart to include horizonal scroll when more then 15 time periods plotted<br><br />
<br />
== Version 2.0.1 (Released: 2021/12/22) ==<br />
<br />
Tooltips on buttons are now multilingual<br><br />
Removed unrequired query parameters from export URL<br />
<br />
== Version 1.5.3 (Released: 2020/10/27) ==<br />
'''New Feature'''<br><br />
[FDB-115] - Add configuration option to 'opt in' to include 'show all datasets' option in sidebar<br><br />
'''Improvement'''<br><br />
[FDB-116] - Remove export formats from sparkline as they do not align to databrowser configured formats<br />
<br />
== Version 1.5.2 (Released: 2020/10/19) ==<br />
'''New Feature'''<br><br />
[FDB-113] - Add start of period and end of period options for Frequency converstion<br><br />
'''Change'''<br><br />
[FDB-114] - Only show categories in sidebar, not category scheme<br><br />
<br />
== Version 1.5.1 (Released: 2020/10/05) ==<br />
'''Improvement'''<br><br />
[FDB-107] - Add tooltips titles to series list title/subtitle/footer text<br><br />
[FDB-108] - Order Dimension Quick Filters by DSD Order<br><br />
[FDB-110] - Order Caategorised Dataflows in sidebar by Id<br><br />
[FDB-111] - Move Pivot table controls from sidebar to modal<br><br />
'''Bug'''<br><br />
[FDB-112] - Metadata labels are not updating language on locale switch<br><br />
<br />
== Version 1.5.0 (Released: 2020/09/18) ==<br />
'''New Feature'''<br><br />
[FDB-102] - Data Export: Support Explicit inclusion/exclusion of specific attributes via configuration<br><br />
[FDB-105] - Release Fusion Embedded Server - required to display embedded charts<br><br />
'''Improvement'''<br><br />
[FDB-46] - Convert time series to different frequencies<br><br />
[FDB-47] - On-the-fly time series calculations<br><br />
[FDB-104] - Show cleaner error page when web service can not be contacted on page load<br><br />
[FDB-106] - Series List - Show number of selected series<br><br />
'''Bug'''<br><br />
[FDB-75] - Advanced filter does not match search result<br><br />
'''NOTE''': New Properties added to locale files<br><br />
<br />
== Version 1.5.0 (Released: 2020/09/18) ==<br />
'''New Feature'''<br><br />
[FDB-35] - XLSX Export - export series with different frequencies into separate sheets<br><br />
[FDB-36] - XLSX Tables Export - group series with common frequencies<br><br />
<br />
'''Bug'''<br><br />
[FDB-76] - Search results can return Attribute matches which result in uncaught exceptions when selected</div>Vmurrell