Working with the Outline Load Utility
The Outline Load utility can be used to import metadata and data for Account, Period, Year, Scenario, Version, Currency, Entity, user-defined dimensions, attributes, UDAs, exchange rates, Smart Lists, and planning unit hierarchies from a flat file or a relational data source. You can also export metadata and data to a flat file or export metadata to a relational data source using the Outline Load utility.
Note:
To import or export data or metadata without using a command line, see Working with Planning Import and Export. Oracle Hyperion Planning Import and Export supports only imports or exports to or from a flat file.
Use these general steps to load information with the Outline Load utility:
-
When loading data, set the
DIRECT_DATA_LOAD
andDATA_LOAD_FILE_PATH
system properties. -
Optional: Create a command properties file (
.properties
) that contains command line arguments. -
Create a load file for each dimension or set of data that you want to load.
-
Test the load files, and then run the utility.
For detailed instructions, see these topics:
-
Optional: Clear any temporary files that were generated during the load. See Clearing EPM Oracle Instance Tmp Directory Files.