Design Flow for Aggregate Storage Applications

As part of the design phase for an Essbase aggregate storage (ASO) application and cube, you specify the cache size, load data and dimensions, perform aggregations, view statistics, write back to level 0 members, and analyze data.

This topic provides a high-level process for creating an aggregate storage application.

1. Create an aggregate storage application, cube (database), and outline.

   Aggregate Storage Applications, Cubes, and Outlines.

2. Specify the maximum size of the aggregate storage cache.

   Aggregate Storage Cache.

3. Load data into the aggregate storage cube. A data load can be combined with a dimension build.

   • Build Dimensions in Aggregate Storage Cubes
   • Load Data into Aggregate Storage Cubes

4. Precalculate chosen aggregations to optimize retrieval time.

   Aggregation of Data in an ASO Cube

5. View cube statistics.

6. Write back to an aggregate storage cube must be to level 0 members.

7. View data using Oracle tools (for example, Smart View) or third-party tools.