Difference between revisions of "Fusion Fame Mapper"
(→Create and maintain a mapped dataflows mapping rules) |
(→Create and maintain a mapped dataflows mapping rules) |
||
Line 17: | Line 17: | ||
The ''Mapped Target'' is the multi-dimensional dataflow. | The ''Mapped Target'' is the multi-dimensional dataflow. | ||
− | ==Create and maintain a mapped | + | ==Create and maintain the series mapping rules for a mapped dataflow== |
Each mapped dataflow consists of a list of rules describing the dimension and attributes values for each of its series. | Each mapped dataflow consists of a list of rules describing the dimension and attributes values for each of its series. | ||
Revision as of 09:27, 28 February 2022
Contents
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.
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 the series mapping rules for a mapped dataflow
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.