Compacting ASO Outline Using Calculation Manager

Compact the ASO outline from Oracle Hyperion Calculation Manager to run the process right away. When the process is complete, you can review details of the process to optimize the outline. This process is recommended for streamlining outlines in development environments.

To compact outlines using Calculation Manager:

1. Sign in to Oracle Enterprise Performance Management Cloud.
2. Click Navigator and then Rules under Create and Manage.
   Calculation Manager is displayed.
3. In Calculation Manager, Click Actions and then Database Properties.
4. From Enterprise View, expand the database node.
5. Right-click the cube and select Compact Outline.
6. Click OK to start the process.
   When the process finishes, Compact Outline Action Status is displayed.
7. Click Show Details to view process status. Review warnings to identify changes that can be made to optimize the outline. Some sample warnings:

   Invalid formula for member [<Member1>](reason: depends on a member[<Member2>] with invalid formula) will be ignored during execution

   The formula for member [<Member1>] is Complex. If possible add a non-empty directive to optimize for sparse data

   Invalid Formula for member [<Member1>](reason: depends on a member[<Member2>] with higher solveorder) will be ignored during execution

   Evaluate the warnings and make changes to the indicated member using the Dimension Editor.