Most data sets of multidimensional databases have two characteristics:
Essbase maximizes performance by dividing the Essbase - Standard dimensions of an application into two types: :
To know more about this two terms : Sitemap
This division allows Essbase to cope with data that is not smoothly distributed, without losing the advantages of matrix-style access to the data. Essbase speeds data retrieval while minimizing memory and disk requirements.
Essbase - Attribute dimensions dimensions are always sparse dimensions.
By default, a new dimension is set sparse.
Set as sparse any Essbase - Standard dimensions with which you plan to associate Essbase - Attribute dimensions.