Essbase - Index

Essbase Overview

Definition

Essbase creates an index entry for each Essbase - Data block. The index represents the combinations of sparse standard dimension members. It contains an entry for each unique combination of sparse standard dimension members for which at least one data value exists.

Article Related





Discover More
Essbase Overview
Essbase - ASO/BSO Storage

Essbase support two storage type : block storage (BSO) and aggregate storage (ASO) as a persistence mechanism for multidimensional databases. How the data are internally stored is determined by...
Essbase Overview
Essbase - BSO Access Path

Essbase BSO uses two types of internal structures to store and access data: data block and index Accessing a cell in the data block does not involve sequential or index searches. The search...
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...



Share this page:
Follow us:
Task Runner