QUERYBOTTOMUP

Use the QUERYBOTTOMUP configuration setting to activate bottom-up query processing for Essbase 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.

Syntax

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.

Description

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.

Example

QUERYBOTTOMUP TRUE