There are several ways to load data into the database.
. For an overview, see this video:
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.
You can also open the Navigator, , 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:
To load data into Essbase using Profitability and Cost Management:
- Click , and then Database. Click the Data Load tab (Figure 8-2).
Figure 8-2 Data Load Screen
- 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.
- In the Load Files area, select files to load. Use the Actions menu or the buttons to perform the following tasks:
Add Row or button — Displays Browse buttons so you can select a data file or rule file to load
Delete Row or button — Removes the selected row from the table of files to load
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.
- 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 ,=.+;).