1. Administrator's Guide
  2. Importing and Exporting Data and Metadata
  3. Working with the Outline Load Utility
  4. Generating Load Files
  5. Generating a Metadata Load File

Generating a Metadata Load File

When loading metadata, the load file must contain a header record that lists the dimension, such as Account, and the member properties used by subsequent metadata records. For example, for Account, you can specify which account to load, a default alias, the operation to perform, and so on. Header records are case sensitive. They can appear in any order.

The next lines in the load file contain metadata records, listed in the order designated by the header record. Each metadata record contains a comma- or tab-separated list of property values that correspond to the header record entries. For detailed information on the properties available for each Oracle Hyperion Planning member, see Dimension Properties.

Example: This load file loads an Entity dimension with the required header record and three data records. The header record specifies the member to be loaded (Entity), the parent member (Parent) into which to load the member, and the Data Storage property to assign to the member. 

Entity, Parent, Data Storage
e1, Entity,
e2, ,
e1, e2, Shared

Using this load file would result in this outline, assuming that no other members exist:

Entity
 e1
 e2
  e1(Shared)

The first data record (e1, Entity) loads Entity member e1 as a child under the root member Entity. Unspecified values assume the default. For example, if data storage is not specified, it assumes the default value, Never Share. The next data record (e2, ,) loads Entity member e2 under the dimension root member because no parent is specified, and sets data storage to Never Share. The last data record (e1, e2, Shared) loads a shared member of e1 under member e2, and sets data storage to Shared.

When loading the Currency dimension with the Default Currency Symbol, if a currency is added without a symbol specified, the symbol is set to that of a pre-defined currency of the same name (or, if the name does not match a pre-defined currency, to the currency code of the currency being added).

To add comments to a load file, see Comments in Load Files.