Overview

Mapping Scripts are used to build mapping logic to derive target members based on multiple source columns and IF THEN logic. Mapping scripts are added in the Data Load Mapping screen, and are available for: Between, IN, Like types. They are stored in the TDATAMAP table.

When you use Oracle Hyperion Enterprise Performance Management System Lifecycle Management to export mapping rules, any related mapping scripts are included.

Additionally, Oracle Hyperion Financial Data Quality Management, Enterprise Edition supports the export and import of mapping scripts in a text file. This support includes both Jython and SQL scripts. The scripts are enclosed in a <!SCRIPT> tag.

Note:

The column on which the script resides must be updated for the script to run. This means that you cannot update a different column based on the script/current column value unless you change both.