This topic provides a high-level process for creating an aggregate storage application.
Create an aggregate storage application, database, and outline.
See Creating Aggregate Storage Applications, Databases, and Outlines.
Load data into the aggregate storage database. A data load can be combined with a dimension build.
See Preparing Aggregate Storage Databases. You can preview a subset of the data in Administration Services. See “Previewing Data” in the Oracle Essbase Administration Services Online Help.
Precalculate chosen aggregations to optimize retrieval time.
See “Viewing Aggregate Storage Statistics” in the Oracle Essbase Administration Services Online Help.
If required, enable write-back by using the Aggregate Storage Partition Wizard.
See Using a Transparent Partition to Enable Write-Back for Aggregate Storage Databases.
View data using Oracle tools (for example Spreadsheet Add-in) or third-party tools.