System and method for bottom up multidimensional data analysis in complex formulas types

Abstract

Described herein are systems and methods for use with a multidimensional database environment, for providing bottom-up multidimensional data analysis in complex formula types. Complex formulas expressions with conditional branches executed over very sparse regions can result in large computational overheads when the iteration is performed in a top-down mode without a knowledge of the target multidimensional cells that have real base data for evaluation. In accordance with an embodiment, the system employs a bottom-up approach that allows identification of those target cells having real data, and executes only those intersections for complex multidimensional expression evaluation. The bottom-up query path functionality can be activated in autonomous mode. The described approach minimizes the amount of redundant executions that have no base data, in some instances to zero level.