Setting Data Storage Properties

When you create dimensions and save an outline, Essbase automatically sets the new dimensions in the outline as sparse. You can change the dimension storage type according to the optimal configuration for the database.

Set as sparse any standard dimensions with which you plan to associate attribute dimensions. See Selection of Dense and Sparse Dimensions.

  To set data storage properties using Outline Editor, see “Setting Dimensions as Dense or Sparse” in the Oracle Essbase Administration Services Online Help.