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

Loading Data

When loading data with the Outline Load utility, there are two ways to specify driver members. You can load to driver members that are specified on the Oracle Hyperion Planning Data Load Administration page, or you can specify driver members in the load file and run the utility with the /TR option.

If you load data with the /TR option, the load file must list the driver member and all other members under the Point-of-View column, regardless of their location on the form. For example, if Jan or Descendants (YearTotal) are columns in a form, they must be specified in the Point-of-View column. When using /TR, you can load one value per row in the load file. You can include multiple rows, but you can specify only one data value per row. See Generating Load Files.

Caution:

Following these steps can affect data in the database. The Planning DIRECT_DATA_LOAD system property enables data to be loaded directly to Oracle Essbase. In the current release, this property is set to true by default, and data is loaded directly into Essbase. To prevent data from being loaded directly into Essbase, set DIRECT_DATA_LOAD to false.

To load data with the Outline Load utility:

  1. Back up the application and application databases before loading information. See the Oracle Enterprise Performance Management System Backup and Recovery Guide.
  2. Set Planning System properties.
    1. Log in to the Planning application.
    2. Select Administration, then Application, then Properties, then click the System Properties tab.
    3. Set the DIRECT_DATA_LOAD and DATA_LOAD_FILE_PATH properties:

      • If DIRECT_DATA_LOAD is set to True, or if you do not specify a value for this property, information is loaded directly into Essbase while the load file records are processed. For this method to work correctly, the outlines maintained in Planning and Essbase must be synchronized. The load file must not specify any Planning outline changes unless they have already been refreshed to Essbase.

      • If DIRECT_DATA_LOAD is set to False, the Outline Load utility processes the load file that you created to generate a data file (.TXT) and rule file (.RUL). This way, the Planning and Essbase outlines do not need to be synchronized because data is not loaded at this time. You can refresh the changes at a convenient time to propagate the metadata changes to Essbase, and then load data directly into Essbase (for example, using Oracle Essbase Administration Services).

        In most cases, set DIRECT_DATA_LOAD to False, and set DATA_LOAD_PATH to the location and name that will be used for the generated data and rules files, for example, C:/myDirectory/App1.txt. Ensure that these properties are set in the System Properties tab in the Manage Properties page.

    4. Restart the Planning application server.
  3. If you want to load to driver members that are specified in Planning, set the driver members as described in this step. Otherwise, skip to the next step.
    1. Log on to the Planning application for which data will be loaded.
    2. Select Administration, and then Data Load Settings.
    3. Select a dimension from the Data Load Dimension list (such as Account). This is the dimension for which you want to load data. For example, it may appear as a row in a Planning form.
    4. Select a dimension from the Driver Dimension list (such as Period).
    5. Click the member selection icon to select members of the Driver Dimension (such as Jan, Feb, March). For example, these members may appear as columns in a Planning form.
  4. Generate a comma-separated load file. See Generating a Data Load File.
  5. Test the load file and run the utility.
    1. Locate the utility, installed in the planning1 directory.

      For the full path to planning1, see About EPM Oracle Instance.

    2. To confirm that the load file parses without any errors, run the utility using the /N parameter, and check the outline log file to be sure no error messages were generated. Running the utility with /N does not load data or metadata, but ensures that the load file parses successfully. For example, you could use this command line to check the load file for a Planning application called test:

      C:EPM_ORACLE_INSTANCE\Planning\planning1>OutlineLoad /A:test /U:admin /M /N /I:c:\outline1data3.csv /D:Entity /L:c:/outlineLoad.log /X:c:/outlineLoad.exc

    3. You can then run the utility from the command prompt without /N, using the case-sensitive command, one space, and the appropriate parameters. For example:

      C:\EPM_ORACLE_INSTANCE\Planning\planning1>OutlineLoad /A:test /U:admin /M /I:c:\outline1data3.csv /D:Entity /L:c:/outlineLoad.log /X:c:/outlineLoad.exc

      If you are loading data without specifying driver members within Planning, you can run the utility including /TR. For example:

      C:\EPM_ORACLE_INSTANCE\Planning\planning1>OutlineLoad /A:test /U:admin /M /N /I:c:\outline1data3.csv /TR /D:Entity /L:c:/outlineLoad.log /X:c:/outlineLoad.exc

      For detailed information on the parameters available for use with the Outline Load utility, see Dimension Properties.