Essbase - Aggregate Storage

Essbase Overview


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. Any non-aggregation calculations are performed dynamically when requested in reports.

Incremental loading and fast aggregation can provide near real-time analysis of transactional data.

Aggregate storage databases enable dramatic improvements in both :

  • database aggregation time
  • and dimensional scalability.

The aggregate storage kernel is an alternative to the block storage kernel. Aggregate storage databases typically address read-only, “rack and stack” applications that have large dimensionality, such as the following Bi Application :

  • Customer analysis. Data is analyzed from any dimension, and there are potentially millions of customers.
  • Procurement analysis. Many products are tracked across many vendors.
  • Logistics analysis. Near real-time updates of product shipments are provided.

Aggregate storage and block storage differ in concept and design. Some block storage outline features do not apply to aggregate storage. For example, the concept of dense and sparse dimensions does not apply.


The differences are visible in this domain :

  • Inherent
  • Outline
  • Calculation
  • Partitioning
  • Data Load
  • Query
  • Feature
Business Application Properties Storage
Customer Analysis Many dimensions, million of customer Aggregate
Sales Forecasting Top-down planning and allocations Block
Procurement Analysis Many products across many customers Aggregate
Profitability Analysis Cost Allocations across products and customers Block
Logistics Analysis Near real-time information on product shipments Aggregate
Financial consolidations Currency conversion, inter-company eliminations Block

See Comparison of Aggregate and Block Storage

Documentation / Reference

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 Folders Structure
Essbase - Application (Directory Structure)

An Essbase application is a management structure that contains : one or more database (cube) and related files called artifacts Essbase applications and databases reside on an essbase servers....
Essbase Overview
Essbase - Calculations

Essbase includes powerful calculation features for demanding analytic requirements. A rich library of functions makes it easy to define advanced and sophisticated business logic and relationships. Essbase...
Essbase Overview
Essbase - Database Restructuration

For information the types of changes and types of restructuring, see the following topics: For block storage outlines, see Optimizing...
Essbase Overview
Essbase - Dealing with Missing Fields in a Data Source during data load

Each record in the data source must have the same number of data value fields to perform a data load. If data values are missing, the data load processes incorrectly. For example, the following file is...
Essbase Overview
Essbase - Getting Started - Tutorial

Oracle by Example Documentation Oracle...
Essbase Overview
Essbase - MDX

in Essbase. When creating formulas for an aggregate storage database, you use MDX. When the aggregate storage option was added to Essbase, MDX was chosen over the Calc Scripting Language in order to...
Essbase Overview
Essbase - Substitution variables

Substitution variables are global placeholders for regularly changing information. Because changes to a variable value are reflected everywhere the variable is used, manual changes are reduced. For...

Share this page:
Follow us:
Task Runner