FDMEE - The future of Hyperion Integrations
Co Author : Payal Kapoor(firstname.lastname@example.org)
In previous part we discussed the recently launched tool FDMEE (Financial Data Quality Management, Enterprise Edition) that was introduced in the EPM release, 220.127.116.11.
In this part we are going to cover some great mapping features introduced in FDMEE that were not available in its predecessor FDM.
FDMEE Mappings: Mapping module of FDMEE allows a user to map the source and target values in different ways. There are 5 different types of mappings available:
1. Explicit: For each source value there is a target value mapped using this mapping type.
2. Between: It maps the range of source values to a target value.
3. In: It maps a non-sequential list of source values to a target value.
4. Multi-Dimension: This new feature has been added in FDMEE to enable it to map a combination of source values to a target value. E.g. A target account value can be derived based on a combination of source account and entity value.
5. Like: This mapping uses the wild characters to match a string in the source value and maps it to a target value.
Using the Multi-Dimension mapping feature, various complex mappings can be created in a few clicks.
The above example shows the account dimension members getting mapped based on combination of account member and user defined dimension member.
Bulk mappings can also be created in FDMEE using Map Loader. It is a standard excel template that is now available for download directly from Data Load Mapping screen. The
format is similar to the one in FDM. Using this template, all the source and target values for a dimension can be imported in one go.
Another way to maintain the bulk mappings is through export/import of mappings in Data Load Mapping screen. An xml file is generated using the export that is editable and then can be imported to apply the bulk changes.
In addition to above functionalities, mappings can also be exported to a flat file (excel) directly from the Data Load Mapping screen.
FDMEE also has a mapping script that can be used to implement complex mapping logic. Anything that cannot be implemented directly using the above mapping types can be done using a mapping script.
Jython is the scripting language in FDMEE for most of the scripts - including mapping scripts.
Mapping scripts are written inside the "Like" mappings in the following manner:
Source value: *
Target value: #SCRIPT
Script: Click on the Expression Editor - the script logic is written there.