Sequenced query processing in data processing system

A computer-readable storage medium encoded with instructions that, when executed, cause one or more processors of a computing device to:

• configure a 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 any multidimensional slicing operation to be applied to the data cube and any first level relational pre-aggregation filtering operation 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;
• and
• output a report based on a resultant data set produced by application of the query operation in accordance with the sequencing.

A computing device, comprising:

• one or more processors;
• a report engine, executable by the one or more processors to perform query operations associated with a report specification, wherein the query operations include at least one multidimensional operation and at least one relational operation to be applied to a data cube having a plurality of dimensions, each dimension including a hierarchy of members;
• and
• a sequencing module, executable by the one or more processors to sequence the application of the query operations with the report engine by requiring that any multidimensional slicing operation and any first level relational pre-aggregation filtering operation to be applied 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,
• wherein the report engine is further executable by the one or more processors to output a report based on the report data set.