The arrangement of dimensions in an outline and the storage properties of dimensions and members affect two areas of performance--how quickly batch calculations are run and how long it takes to retrieve data.
Note: | This functionality only applies to block storage outlines. |
As you design, develop, and tune a block storage database outline, you can use Optimize Outline to apply standard design principles to the outline for optimized performance of batch calculations. The standards applied using this feature may not optimize your outline because of factors unique to your deployment such as calculation scripts, end user workloads, and hardware environment.
For detailed information about outline design and performance issues, see “Optimizing Calculations” in the Oracle Essbase Database Administrator's Guide.
To optimize an outline for calculation performance:
If the outline is open in Outline Editor and there are unsaved edits, save the outline.
From Enterprise View or a custom view, select a database.
Select the Outline node, right-click, and select Optimize.
Caution! | This action cannot be undone. |
At the confirmation prompt, click Yes.
If the outline is open, close and reopen it to see the updated outline.
Essbase Administration Server displays in a message the number of members that were changed.
“Designing an Outline to Optimize Performance” in the Oracle Essbase Database Administrator's Guide