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.