The storage method you select for your dimension is dependent upon whether it is dense or sparse.
To select a dimension storage method:
Access the dimension properties tabs of the Essbase Model Properties dialog box using the procedure in Accessing the Dimension Properties Tabs.
Select a Dimension Storage option:
Dense—Use dense storage for a dimension in which a high percentage of available data positions are filled. For example, time data often exists for almost all products in all markets, so Year is frequently a dense dimension.
Sparse—Use sparse storage for a dimension in which a low percentage of available data positions is filled. For example, if Product represents product units and Market represents geographical regions in which products are sold, then the Product and Market dimensions may be sparse dimensions because not every product is usually sold in every market.
Existing—Use the storage method currently set for the dimension.
Note:
To restore the settings on this tab to their previously saved values, click Restore. To restore the settings to their original system default values, click Default.