Optimizing Aggregate Storage Option Cubes
Performance of Aggregate Storage Option (ASO) reporting cubes is governed by many factors, including the number of slices in the cube, the outline of the cube, and the type of dimensions in the cube.
Optimizing ASO cubes involves the following steps:
- Merging Data Slices and Removing Zeros
- Compacting the Outline
- Reviewing Dimension Hierarchy Types
- Creating Required Aggregate Views
- Reviewing ASO Retrieval Formula Statistics in the Activity Report
- Getting Help from Oracle
Applies to
Oracle Hyperion Planning, Planning Modules, FreeForm, Financial Consolidation and Close, Tax Reporting, Enterprise Profitability and Cost Management, Oracle Hyperion Profitability and Cost Management, Sales Planning, and Strategic Workforce Planning.