32 Optimizing Data Loads

You can shorten the time it takes to load data by minimizing the time spent on reading and parsing the data source, as well as reading 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.