Fusion Fame Mapper

From Fusion Registry Wiki
Revision as of 09:27, 28 February 2022 by Glenn (talk | contribs) (Create and maintain a mapped dataflows mapping rules)
Jump to navigation Jump to search

Overview

Fusion Fame Mapper is a decoupled Fusion Registry user interface for maintaining rules mapping FAME-style datasets characterised by a single dimension to multi-dimensional dataflows. These mapped dataflows are similar in some respects to SQL views, however, rules must be defined setting the dimension and attribute values for each individual series.

Compatibility: Fusion Registry 11.0 and later.

FusionFameMapper 1.png

Operating procedures

Add a new mapped dataflow

Step 1 Create a Dataflow structure for the mapped dataflow
If it does not already exist, create the Dataflow structure using the required multi-dimensional DSD. Do not create a provision agreement - that process happens automatically in Step 2.

Step 2 Add a dataflow mapping Use the Add button to add a new dataflow mapping

The Mapped Source is an existing dataflow linked to data store which follows the Fame model of a single dimension called SERIES_CODE or similar.
The Mapped Target is the multi-dimensional dataflow.

Create and maintain a mapped dataflows mapping rules

Each mapped dataflow consists of a list of rules describing the dimension and attributes values for each of its series.

Step 1 Export the dataflow mapping to Excel
Select the dataflow mapping from the list and export the list of rules to an Excel workbook using the Export button.

Search the list of dataflows using the quick filter.

Step 2 Add and modify series mapping rules in the Excel workbook
The Excel workbook has one row per series with the first column the SERIES_CODE or identifier of the Fame series to be mapped. The remaining columns are the dimensions and attributes for the series in the multi-dimensional mapped dataflow.

FusionFameMapper Excel.png