Patent ID: 8204901

Claim:
A computer-implemented method for generating a relational query from a multidimensional query against a cube, the cube having a plurality of dimensions, at least one dimension including a hierarchy of members, the method comprising: based on a predetermined condition, determining a plurality of members from the hierarchy which predicates are to be included in the relational query, wherein the plurality of members are not specified in the multidimensional query, wherein the predicate for at least one determined member is to be included in lieu of predicates for one or more child members of the at least one determined member that are specified in the multidimensional query, wherein the condition comprises reaching a threshold ratio of the specified one or more child members to all child members of the at least one determined member; by operation of one or more computer processors, generating the relational query based on the multidimensional query and the determined plurality of members and without generating any other multidimensional query, wherein the relational query includes the predicate for the at least one determined member in lieu of the predicates for one or more child members of the at least one determined member that are specified in the multidimensional query; executing the relational query to obtain a set of query results; pruning, from the set of query results, one or more records included because of the at least one determined member, that are not responsive to the multidimensional query; and returning the pruned set of query results, responsive to the multidimensional query.