Reviewing ASO Retrieval Formula Statistics in the Activity Report
For detailed information on accessing and using the Activity Report, see Using the Activity Report in Getting Started with Oracle Enterprise Performance Management Cloud for Administrators.
Review the ASO retrieval metrics available in the Top 10 Longest Performing Essbase Queries over 15 seconds section in of the Activity Report to evaluate whether the formula executions required to complete ASO data retrieval are optimal. Specifically, evaluate the values of these metrics:
- ullFormulaExec, which identifies the number of formula
executions required to complete the retrieval. If this number is high, review
ullFormulaMissing and
ullFormulaExecOOT.
Also, compact the outline and view the output to check whether any formula that is described as complex can benefit from the use of Nonemptymember or Nonemptytuple setting.
- ullFormulaMissing, which identifies the number of formula
executions required to complete the retrieve where the values are set to
#missing. If this number is high, review all the member
formulas to verify whether Nonemptymember or
Nonemptytuple statement can be used.
Also, compact the outline and view the output to check whether any formula that is described as complex can benefit from the use of Nonemptymember or Nonemptytuple statement.
- ullFormulaExecOOT, which identifies the number of formula executions that are considered out of turn. Generally, Out of turn formula executions indicate a solve order issue. Compact the outline and view the output to identify the solve order issues and resolve them. Also, review the solve order of members with formula that are called by other members with formula to ensure that formula execution occurs in the correct order.
For information on compacting ASO outlines, see: