This Essbase configuration setting activates bottom-up query processing for formula calculation. In hybrid mode, this optimizes query times by identifying the required intersections for calculation, making the query time proportional to input data size.
QUERYBOTTOMUP TRUE | FALSE
TRUE—Query execution occurs in bottom-up mode, to resolve dependency analysis quickly in cases where the formula cache has a relatively small input data set.
FALSE— Default option. Query execution is top-down.
To optimize cubes in the application for hybrid mode for faster formula execution, set QUERYBOTTOMUP to TRUE.
This usage is recommended for hybrid mode performance tuning if both of these are true:
- you experience query performance problems
- formulas are complex and contain many cross-dimensional operators or IF/ELSE statements
Complex formulas can cause the formula cache to grow large while also being sparse (having a relatively small input data set). Using QUERYBOTTOMUP TRUE forces query execution to occur in bottom-up mode, to resolve dependency analysis more efficiently in cases where the formula cache is sparse.
@QUERYBOTTOMUP calculation function