Loading Data into Aggregate Storage Databases

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:

  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.