For block storage databases, Essbase optimizes database performance by dividing the standard dimensions into two types: dense dimensions and sparse dimensions. This division allows Essbase to cope with data that is not smoothly distributed. For more information about sparse and dense data storage, see the Oracle Essbase Database Administrator's Guide.
When you create a new dimension and save an outline, Essbase automatically sets the new dimension as sparse. Standard dimensions that you plan to associate with attribute dimensions must be set as sparse. By definition, attribute dimensions are set as sparse; the sparse setting of attribute dimensions cannot be changed.
Note: | Dense/sparse storage does not apply to aggregate storage databases. |
To change the storage configuration of a dimension:
Open the outline in edit mode.
The Outline tab is displayed.
Select the Properties tab.
In the Dimension storage types option group, select Dense or Sparse for each dimension whose storage type you want to change.
Note: | You can change the dimension storage type only if the Auto configure option for the outline is set to false. |