Essbase - Dense and Sparse Dimension

Essbase Overview


Most data sets of multidimensional databases have two characteristics:

  • Data is not smoothly and uniformly distributed.
  • Data does not exist for the majority of member combinations. For example, all products may not be sold in all areas of the country.

Essbase maximizes performance by dividing the Essbase - Standard dimensions of an application into two types: :

  • dense dimensions
  • and sparse dimensions.

To know more about this two terms : Dimensional Data Modeling - What means Data is dense/sparse ?

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.


Discover More
Essbase Overview
Essbase - Aggregate Storage

Essbase provides an aggregate storage kernel as a persistence mechanism for multidimensional databases. Aggregate storage database are optimized for sparse data set that primarily require simple aggregation....
Sample.basic Database Outline Attribute
Essbase - Attribute dimensions

An attribute dimension is a special type of dimension that is associated with a standard dimensions. Use attribute dimensions to report and aggregate data based on characteristics of standard dimensions....
Essbase Overview
Essbase - Block storage

Block Storage databases are optimized for data set that are partially denses. Data is stored in dense data blocks which are indexed along sparse dimension for retrieval. This storage paradigm enables...
Essbase Overview
Essbase - Cell

A cell is a part of a data block and represent a combination of the dense dimension members. Essbase orders the cells in a data block according to the order of the members in the dense dimensions of the...
Essbase Data Block For D22 E3
Essbase - Data block

A data block is a multidimensional array structure that contains the data. each unique combinationsparse standard dimension membersdense dimension members A data block is created if at least one...
Essbase Database With All Sparse Standard Dimensions
Essbase - Dense and Sparse Selection Effect on the data storage (performance)

The choice between sparse and dense dimension have a great influence on the storage and therefore on the performance of Essbase. data blockeach unique combinationsparse standard dimension membersdense...
Outline For Optimized Query Times
Essbase - Designing an Outline to Optimize Query or Calculations Performance

The relative locations of dimensions in an outline can affect performance times : either or retrieval . Indeed, although they contain the same dimensions, the outline examples below : for Optimized...
Essbase Overview
Essbase - Index

Essbase creates an index entry for each . The index represents the combinations of sparse standard dimension members. It contains an entry for each unique combination of sparse standard dimension members...
Essbase Overview
Essbase - Outline Creation and Management using Outline Editor

This article provides an overview of creating outline using Outline Editor. For information Outline Editor, see the Oracle Essbase Administration Services Online Help. All examples in this chapter are...
Essbase Overview
Essbase - Selection of Dense and Sparse Dimensions

The setting of the dimension as sparse or dense have a lot of influence on the storage. See this article to understand how : . If you match patterns correctly, you can store the existing data in a reasonable...

Share this page:
Follow us:
Task Runner