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

, Planning, Planning Modules, FreeForm, Financial Consolidation and Close, Tax Reporting, Profitability and Cost Management, Sales Planning, and Strategic Workforce Planning.