Fusion Registry® Enterprise Release 9.2
Discover what’s new in the latest release
What is Fusion Registry 9?
New features in Fusion Registry 9.2
Excel Data Reporting Templates
Excel Data Reporting Templates is a new feature for Fusion Registry 9.2 that simplifies manual data reporting processes by supplying data providers with personalised Excel data reporting forms to complete.
The layout of each form is based on a template defined by the data collecting organisation, and created using Fusion Registry's template design tool. The designer can choose from a range of configuration options including setting specific cell colours to identify important attributes such as observation confidentiality. They can also define validation rules.
A unique form is generated for each Dataflow that a Data Provider is required to report data for. If Reporting Constraints have been defined, Excel's cell protection functions are used to restrict the observations that can be entered. This not only simplifies the process for the data provider, but also reduces the risk of data being reported against the wrong codes.
The generated spreadsheets are simple Excel workbooks which use only standard Excel features and formulas. No macros, VBA or addins are used which could violate information security policies.
Validation Schemes define additional validation rules that are applied when time series data for a particular Dataflow is loaded or registered.
Rules can take two forms:
Implicit rules are based on aggregation hierarchies such as hierarchical geographical codelists. They are useful for checking that the value reported for a geographical region, for instance, matches the sum of the values reported for the individual members.
Explicit rules, by contrast, are defined using expressions written in Metadata Technology's validation language. Each rule operates on a specific dimension and takes the form of a relational equality or inequality statement along the lines of '[A] = [B] + [C]' or '[A] >= [D] + ([F]*2)'.
[A],[B],[C] etc are dimension codes. There's a detailed description in the Fusion Registry Validation Schemes user guide.
Below is an example operating on a notional COUNTRY dimension:
The dataset will be valid if observations for the EU as a whole match those for the EEA, plus Norway, Ireland and Liechtenstein.
Fusion Reporting Node
Fusion Reporting Node simplifies and automates the reporting process where data collecting organisations need a controlled and efficient way to collect data from multiple distributed providers.
How does it work?
Each data provider has access to a Fusion Reporting Node instance which can be run on premises, or delivered as a cloud service.
Data providers upload the reporting data to their Fusion Reporting Nodes where it is validated and automatically appears in the data collector's Fusion Registry 9 Virtual Data Repository. The data actually remains on the distributed Fusion Reporting Nodes and is retrieved on demand in real time which avoids the overhead of a traditional ETL approach.
Fusion Reporting Node accepts data in a variety of formats including Excel and CSV, and can even supply reporters with Excel spreadsheet forms to complete.
If run on premises, Fusion Reporting Node can also take reporting data directly from existing MySQL, SQL Server or Oracle databases.
Enhanced Dataset Data Browser
Fusion Registry 9’s enhanced data browser provides end-users with a powerful tool for exploring, searching, visualising and downloading data
- Explore the data library by dataset, category or data provider
- Free text search
- Enhanced pivot table with time and dimension filters
- Mini 'sparkline' style and full line chart visualisations for time series
- Export selected data in SDMX-ML, SDMX-EDI, Excel and CSV