Method and apparatus for processing a query to a multi-dimensional data structure
OwnerTheodore H. Pitts, Rolfe R. Schmidt +1inventors
InventorsTheodore H. Pitts, Rolfe R. Schmidt, Derek A. Lewsey
Life of this patent
Estimating the term…
Abstract
Consistent with the invention, a method includes receiving dimension solve order rules associated with a set of calculated members, and using the received dimension solve orders rules to translate a client query into a different query with corresponding solve orders.
Claims29
A method for forming a simplified query having absolute solve orders, the method comprising:
- receiving a set of strictly increasing dimension solve order rules associated with a set of calculated measures;
- assigning a set of labels to each of the set of calculated measures, the labels being assigned in order;
- generating a matrix having rows and columns corresponding to the assigned labels;
- receiving a complex query involving aggregation, the complex query corresponding to a multi-dimensional data structure;
- parsing the complex query according to a predetermined complex syntax;
- determining solve order rules, based on the generated matrix;
- and
- combining information from the parsed complex query with the determined solve order rules, whereby the simplified query is produced.
A computer-implemented method comprising:
- receiving a set of dimension solve order rules associated with a set of calculated members;
- assigning a set of labels to each of the set of calculated members;
- generating a matrix corresponding to the assigned labels;
- and
- determining absolute solve orders for a client query based on the generated matrix, wherein the client query involves aggregation of calculated members.
A metrics engine comprising:
- means for receiving dimension solve order rules associated with a set of calculated members;
- and
- means for determining absolute solve orders for a client query based on the received dimension solve order rules.
A computer-implemented method comprising:
- receiving dimension solve order rules associated with a set of calculated members;
- and
- using the received dimension solve orders rules to translate a client query into a different query with corresponding solve orders.
A metrics engine comprising:
- means for receiving dimension solve order rules associated with a set of calculated members;
- and
- means for facilitating the application of the dimension solve order rules to a relationship between a calculated member and a dimension.
A computer-implemented method comprising:
- receiving a client query having at least one associated function;
- and
- supporting a function across calculated members that is not supported by an underlying data source.
A computer-implemented method for forming a simplified query having absolute solve orders, the computer-implemented method comprising:
- receiving a complex query involving aggregation of calculated members, the complex query corresponding to a multi-dimensional data structure;
- determining absolute solve orders;
- and
- combining information from the complex query with the absolute solve orders, whereby the simplified query is produced.
A computer-implemented method for transforming a client query, the computer-implemented method comprising:
- generating at least one member with associated query language for
- the client query;
- and
- determining absolute solve orders for generated members.
A computing system comprising:
- a display to provide an interface to facilitate processing of dimension solve order;
- and
- a processing module for receiving the dimension solve order associated with a calculated member from the interface, the dimension solve order indicating where the member should be computed in relation to a dimension.
A computer readable medium containing instructions for controlling a computer system to perform a method, the method comprising:
- receiving a set of dimension solve order rules associated with a set of calculated members;
- assigning a set of labels to each of the set of calculated members;
- generating a matrix corresponding to the assigned labels;
- and
- determining absolute solve orders for a client query based on the generated matrix, wherein the client query involves aggregation across calculated members.
A computer readable medium containing instructions for controlling a computer system to perform a method, the method comprising:
- receiving dimension solve order rules associated with a set of calculated members;
- and
- using the received dimension solve orders rules to translate a client query into a different query with corresponding solve orders.
A computer readable medium containing instructions for controlling a computer system to perform a method, the method comprising:
- receiving a complex query involving aggregation of calculated members, the complex query corresponding to a multi-dimensional data structure;
- determining absolute solve orders;
- and
- combining information from the complex query with the absolute solve orders to produce a different query.
A computer readable medium containing instructions for controlling a computer system to perform a method, the method comprising:
- generating at least one calculated member with associated query language for the client query;
- and
- determining solve orders for generated calculated members.
A metrics engine to facilitate application of an aggregate function to calculated members.
Dependencies are inferred from the claim text.