Perform Data Loads or Dimension Builds

You can load data or build dimensions when you build a cube from an application workbook, or afterwards using jobs in the Essbase web interface. You can also automate the job using CLI, MaxL, or REST API.

When you perform a data load or dimension build, the process runs 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.

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 Incremental Dimension Builds.

Note:

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

Essbase web interface

Load data or build dimensions using these Job types:

For data loading: Load Data
For dimension building: Build Dimension

Command Line Interface (CLI)

Load data or build dimensions using these CLI commands:

For data loading: Dataload
For dimension building: Dimbuild

MaxL

Load data or build dimensions using these MaxL statements:

For data loading: Import Data
For dimension building: Import Dimensions

REST API

Load data or build dimensions using REST API Job endpoints:

For data loading: Execute Job > Load Data
For dimension building: Execute Job > Build Dimensions