Essbase provides an aggregate storage kernel as a persistence mechanism for multidimensional databases.
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 :
- Data Load
|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|
Documentation / Reference
- A sample application (ASOsamp), a data file, and a rules file are provided to demonstrate aggregate storage functionality.