Then load and aggregate all the data from the source tables

182Oracle Essbase & Oracle OLAP: The Guide to Oracle’s Multidimensional Solution

The cube refresh methods are:

■ Complete Clear all data from the cube, then load and aggregate all the data from the source tables. All cubes can use this method.

■ Fast Solve Load all the detail data from the source tables, then aggregate only the new values. Compressed cubes and cube materialized views can use this method.

	NOTE Some of the cube refresh options in Oracle OLAP 11g are not available in Oracle OLAP 10g.