File-Based Data Loads

File-based imports and write back are supported for those users who do not have a direct connection to their Enterprise Resource Planning (ERP) source data but have data available from their sources in a text file. Any file, whether it is a fixed width file or a delimited file, can be easily imported into the target EPM application. For example, you can take a trial balance report generated from your source system, and map it into Oracle Hyperion Financial Data Quality Management, Enterprise Edition by way of the import format feature. You can instruct the system where the account, entity, data values and so on reside in the file, as well as which rows to skip during the data import. This feature enables a business user to easily import data from any source, and requires limited technical help, if any, when loading into a target application.

You can also define data load rules which determine how you want to extract or write back data from an EPM system to a file system. For example, you may want to write back budget data.