For general information about loading data, see Performing and Debugging Data Loads or Dimension Builds.
Aggregate storage databases facilitate analysis of very large dimensions containing up to a million or more members. To efficiently support loading data values into such large databases, Essbase:
Allows the processing of multiple data sources through temporary aggregate storage data load buffers
Allows you to control the percentage of resources a data load buffer uses
Allows an aggregate storage database to contain multiple slices of data (a query to the database accesses each slice, collecting all of the data cells)
Provides an incremental data load process that completes in a length of time that is proportional to the size of the incremental data
To load values to an aggregate storage databases, use a tool:
Tool | Topic | Location |
---|---|---|
Administration Services | Performing a Data Load or Dimension Build for Aggregate Storage Databases | Oracle Essbase Administration Services Online Help |
MaxL | alter database import data | Oracle Essbase Technical Reference |
ESSCMD | IMPORT LOADDB | Oracle Essbase Technical Reference |
Note: | If values have been calculated and stored through an aggregation, Essbase automatically updates higher-level stored values when data values are changed. No additional calculation step is necessary. The existence and size of an aggregation can affect the time it takes to perform a data load. See Aggregations. |
Note: | You cannot export data when loading data into a database. |