Skip this section if you are loading data only or are using a single data source for a dimension build.
By default, each time you make changes to an outline, Essbase considers the type of change and restructures the database if needed. Restructuring the database rebuilds the database, which takes time, requires more disk space for its process, and can cause file defragmentation. For information about the types of changes and types of restructuring that can be required, see the following topics:
For block storage outlines, see Optimizing Database Restructuring.
For aggregate storage outlines, see Aggregate Storage Database Restructuring.
Deferred-restructure dimension builds, also known as incremental dimension builds, read multiple data sources for dimension builds and delay restructuring until all data sources have been processed. The following methods for performing deferred-restructure builds use different approaches to specifying the action:
Administration Services enables you to list all data sources in a single dialog box.
When the files listed are all dimension builds, a deferred-restructure dimension build option is available. Selecting this option delays restructuring until all sources have been processed. The outline is validated after each dimension build is processed. See “Loading Data and Building Dimensions” in the Oracle Essbase Administration Services Online Help.
MaxL enables you to include all of the data sources within one import database statement.
You can control whether outline validation is performed for each file. You must enable outline validation for the last file. See “import database” and “import dimension” in the MaxL section of the Oracle Essbase Technical Reference.
ESSCMD requires several commands:
BEGINCBUILDDIM, to indicate that a deferred-restructure dimension build is to be performed
INCBUILDDIM for each data source, to indicate that the data sources to be included in the dimension build
ENDBUILDDIM, to trigger restructuring, if needed
In all cases, the data sources are processed in the order in which they are listed.