Patent ID: 8635229

Claim:
A computer-readable storage memory encoded with instructions that, when executed, cause one or more processors of a computing device to: configure the computing device to construct a query in response to a report specification, wherein the query comprises a set of query operations that include at least one multidimensional and at least one relational operation to be applied to a multidimensional data cube having a plurality of dimensions, each dimension including a hierarchy of members; sequence the application of the query operations with the computing device by requiring that: (i) multidimensional slicing operations to be applied to the data cube and first level relational pre-aggregation filtering operations to be applied to the members of the data cube are applied within a first timeframe without allowing other ones of the query operations to be applied to the data cube within the first timeframe, (ii) multidimensional rollup operations are applied to the multidimensional data cube within a second timeframe subsequent to the first timeframe, and (iii) second level relational post auto aggregation filtering operations are applied to the relational representation of the data within a third timeframe subsequent to the second timeframe; and output a report based on a resultant data set produced by the application of the query operations in accordance with the sequencing.