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
• Getting Help from Oracle

Applies to

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