Loading Data into Essbase

There are several ways to load data into the database.

. For an overview, see this video:

video cloud png Overview Video: Loading Data

Service Administrators and other users with appropriate provisioning can load data into Oracle Essbase using Profitability and Cost Management. Files to load typically contain input data such as amounts to be allocated and driver information.

Note:

You can also open the Navigator, Navigator button, and then select Data Management. For instructions, access help within Data Management or locate Data Management documentation in the User section of Books in the Library (Using Profitability and Cost Management Library.

The formats of files to load are the same as for Oracle Essbase Administration Services console:

  • Text File data object(.txt) — IEssOlapFileObject.TYPE_TEXT

  • Excel worksheet File data object(.xls) — IEssOlapFileObject.TYPE_EXCEL

For information about creating these files, see Understanding Data Loading and Dimension Building in Oracle Essbase Database Administrator's Guide, particularly Data Sources that Do Not Need a Rules File.

The following videos show how to use Data Management to load data into Profitability and Cost Management:

video cloud png Tutorial Video: Loading Data Files Using Data Management Part 1

video cloud png Tutorial Video: Loading Data Files Using Data Management Part 2

To load data into Essbase using Profitability and Cost Management:

  1. Click Navigator button, and then Database. Click the Data Load tab (Figure 8-2).

    Figure 8-2 Data Load Screen


    The Data Load screen displays the information described in the following steps.
  2. Indicate how to handle the data load:
    • Optional: Select Clear Database Before Load to clear all data in the active cube of the application. To retain existing data, do not select this setting.

    • Select whether to Add to Existing Values or Overwrite Existing Values.

  3. In the Load Files area, select files to load. Use the Actions menu or the buttons to perform the following tasks:
    • Add Row or Add button button — Displays Browse buttons so you can select a data file or rule file to load

    • Delete Row or Delete button button — Removes the selected row from the table of files to load

    Note:

    You can use the View menu to show, hide, and reorder columns in the table and detach the table to float it in a separate window.

  4. When files are selected, click Load to copy the files to the OLAP server and load data from the files into Essbase.

    You can use the Job Library to track the progress of the load.

Example 8-1 Notes

At least the first error for each file in the load is logged and displayed in the Job Library. Where possible, multiple errors per file are logged. The error describes which column is wrong and in which record. An error is logged if the outline is empty or the loaded file is empty, locked, exceeds size limits (2 GB for data files, 64 KB for rule files), or if the data file contains an error. Files must be either text files or Microsoft Excel files. File names must not exceed eight characters and should not contain spaces or certain characters (including ,=.+;[]).