You use the Data Load dialog box to load data into databases and members into outlines.
The Data Load dialog box is used for aggregate and block storage databases. However, aggregate and block storage databases use different processes to load data and build dimensions. See the Oracle Essbase Database Administrator's Guide and block storage.
Data loads from Essbase Server computers process faster than data loads from client computers (because data need not be transported over the network from the client to the server computer). Therefore, you should move a data source to the server computer and then load its data.
From the following columns of the of the Data Load dialog box, you perform the described actions:
Data Source Type—Select “SQL” (to set the data source as an SQL database) or “Data files” (to set the data source as a file, including text and spreadsheet files).
Mode—Select “Load only” (to load data), “Build only” (to build dimensions), or “Both” (to load data and build dimensions).
Data Source—Select a data file, and click Find Data File.
Rules File—Select a rules file, and click Find Rules File.
The SQL User Name and SQL Password columns, in which you enter your username and password are available only if the data source type is SQL, you enter your username and password on the SQL database.
If Abort on Error, Execute in background, ad Deferred-restructure dimension build are not selected, you can enter information in the following columns:
Error File—Specify the path to the error file (after selecting a data source and rules file). If no path is specified, errors are written to EAS_HOME\client\dataload.err on the machine where Administration Services Console is running.
Overwrite—Overwrite the contents of an existing error file. This enables you to correct the outline and use the error file as a data source to load the earlier rejected records.
“Preparing Aggregate Storage Databases” in the Oracle Essbase Database Administrator's Guide
“Understanding Data Loading and Dimension Building (block storage)” in the Oracle Essbase Database Administrator's Guide
For a data load:
alter database (MaxL) in the Oracle Essbase Technical Reference
import data (MaxL) in the Oracle Essbase Technical Reference
import (ESSCMD) in the Oracle Essbase Technical Reference
loaddata (ESSCMD) in the Oracle Essbase Technical Reference
For a dimension build:
import dimensions (MaxL) in the Oracle Essbase Technical Reference
builddim (ESSCMD) in the Oracle Essbase Technical Reference
alter system kill request (MaxL) in the Oracle Essbase Technical Reference