Downloading an Excel Template (Mapping Template)
Download and use the Maploader template to upload your mapping tables from Excel instead of
entering them by way of Data Integration. This feature
enables you to map members by selecting and importing them form your Excel mapping.
You can merge or replace mappings. it does not update map. It simply adds new
entries into the database. Excel mapping templates with correct formatting are
included in the
EPM_ORACLE_HOME/products/FinancialDataQuality/templates
directory.
The mapping template also includes a macro script that pulls Oracle Hyperion Financial Management dimensions directly from the target application to which you are connecting.
You must upload the Excel template to the Data Integration server, and then pick the Excel file as the file to load when you run the integration, or when prompted by the system if the file name is left blank. The system determines if the file being processed is an Excel file, and then reads the required formatting to load the file.
When working with a mapping template in Excel:
-
Do not have any blank lines in the map template.
-
You can insert lines in the template, but you must keep new lines in the designated area.
-
Each template supports a single dimension.
To download an Excel template: