Optimize Data Loads

33 Optimize Data Loads

You can improve the performance of data loads/imports to Essbase by minimizing the time spent on reading / parsing the data source and writing to the cube. Methods include grouping sparse member combinations, minimizing and repositioning source data, loading from the server, and loading in parallel.

Stages of Essbase Data Loads
Group Sparse Member Combinations
Make the Source Data as Small as Possible
Make Source Fields as Small as Possible
Position Data in the Same Order as the Outline
Load Data from Essbase Server
Parallel Data Load

Some information in this chapter applies only to block storage (BSO) databases, and is not relevant to aggregate storage. Also see Comparison of Aggregate and Block Storage.