Table of Contents

Essbase - Dense and Sparse Dimension

About

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.

Thumb of rules

Set as sparse any Essbase - Standard dimensions with which you plan to associate Essbase - Attribute dimensions.

Article