Performing Data Loads or Dimension Builds

When you use Administration Services to perform a data load or dimension build, you can execute the load or build in the background so that you can continue working during the load or build. You can then check the status of the background process to see when the load or build has completed. See “Loading Data and Building Dimensions” in the Oracle Essbase Administration Services Online Help.

If you are using multiple data sources in a dimension build, to reduce total processing time you can perform a deferred-restructure dimension build. See Performing Deferred-Restructure Dimension Builds.

Note:

If you are loading data into a transparent partition, follow the same steps as for loading data into a local database.

  To load data or build dimensions, use a tool:

Tool

Topic

Location

Administration Services

Loading Data and Building Dimensions

Oracle Essbase Administration Services Online Help

MaxL

For data loading: import data

For dimension building: import dimensions

Oracle Essbase Technical Reference

ESSCMD

For data loading: IMPORT

For dimension building: BUILDDIM

Oracle Essbase Technical Reference