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.
Outline optimization changes the storage property of a member to Label Only or Dynamic Calc when it determines the value can be determined easily through calculation at query time. The following stored members are changed to Dynamic Calc:
In sparse dimensions, generation 1 members that have eight or fewer children
All parent members in dense dimensions
Members tagged as Two-Pass
Parents, grandparents, and so on, of Two-Pass members in dense dimensions are tagged as Two-Pass.
The following parent members are changed to Label Only:
Parent members with the first child consolidating up to them
Parent members with all children tagged for no consolidation
When you run the Outline Optimize menu option, outline dimensions are arranged in hourglass order; that is, the dense dimensions tagged as accounts or as time are positioned at the top of the outline. The remaining dense dimensions are positioned next, from the largest dense dimension down to the smallest dense dimension. Sparse dimensions are positioned next and arranged from the smallest sparse dimension to the largest one. Attribute dimensions are positioned at the end, in no particular order.
Note: | If you are using a rules file to build an outline, you can use the dimension build global setting for dimension rearrangement: Arrange dimensions by size and type to an hourglass shape. |
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