The Sparsity Advisor analyzes the source data that has been mapped to a cube and determines the best implementation of the cube. You can override any of these recommendations before recreating the cube.
Dimension Order and Sparsity
Lists one or more dense dimensions first, then the sparse dimensions in order by size. The Sparsity Advisor does not optimize for data loading or time-based analysis. If you want to optimize for these tasks, then use the arrow keys to move Time to the top of the list.
Use Compression
Indicates whether the cube should use a regular composite or a compressed composite.
Data Type of Cube
The Sparsity Advisor does not make a recommendation for the data type. However, if the Sparsity Advisor recommends compression, then you must select a data type for the cube. That data type will be used for all measures in the cube.
Partition Cube
Indicates whether the cube should be partitioned. If it is, then the Sparsity Advisor also recommends the dimension, hierarchy, and level to be partitioned.
Recreate Cube
Deletes the existing cube and recreates it using the settings on this page. Any data previously loaded into the cube will be deleted also.
Cubes Property Sheet: Implementation Details
Copyright © 2003, 2007, Oracle. All rights reserved.