TABLE 3: Processing Times for MOLAP, HOLAP, and ROLAP Storage Modes
Storage Mode 0% Aggregation 30% Aggregation 60% Aggregation 90% Aggregation
MOLAP 30 minutes, 31 seconds 36 minutes 40 minutes 2 hours, 17 minutes
HOLAP 26 minutes, 24 seconds 34 minutes 35 minutes 2 hours, 16 minutes
ROLAP 1 minute, 29 seconds 48 minutes 1 hour, 28 minutes 5 hours, 14 minutes