1. Database Administrator's Guide for Oracle Essbase
  2. Block Storage Calculation Optimization
  3. Member Set Functions and Performance

Member Set Functions and Performance

Complex member formulas with dynamic dependencies may impact performance of your Essbase block storage calculations, unless you enable hybrid mode processing for calculations.

Queries and calculations that reference a member that has been tagged as Dynamic Calc may be slower than queries and calculations involving the same members, if the member has formulas involving any of these functions:

  • @CURRMBR

  • @PARENT

  • @SPARENTVAL

  • @ANCEST

  • @SANCESTVAL

If you have any of the above formulas referencing Dynamic Calc members, Oracle recommends using hybrid mode for query and calculations. Refer to Hybrid Mode for Fast Analytic Processing for more details.