Positioning Data in the Same Order as the Outline

To improve performance of Essbase block storage data load, you can make the source data follow the same order as the order of sparse dimensions in the outline.

This section does not apply to aggregate storage databases.

The index is organized in the same order as the sparse dimensions in the outline. To further optimize the data source, with the sparse data combinations in the data source grouped together, arrange the data so that sparse dimensions are in the same order as the outline.

Essbase pages portions of the index in and out of memory as requested by the data load or other operations. Arranging the source data to match the order of entries in the index speeds the data load because it requires less paging of the index. Less paging results in fewer I/O operations.

The index cache size is used to determine how much of the index can be paged into memory. Adjusting the size of the index cache may also improve data load performance.

Note:

If the index cache size is large enough to hold the entire index in memory, positioning data in the same order as the outline does not affect the speed of data loads.