34 Optimizing Data Loads

You can improve the performance of data loads to Essbase databases by minimizing the time spent on reading / parsing the data source and writing to the cube.

• Understanding Data Loads

• Grouping Sparse Member Combinations

• Making the Data Source as Small as Possible

• Making Source Fields as Small as Possible

• Positioning Data in the Same Order as the Outline

• Loading from Essbase Server

• Using Parallel Data Load

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