OLAP query generation engine
AssigneeLawson Software, Inc.
InventorsLee Eric Kilmer, Richard Scott Bendickson, Thomas Joseph Pavelka, Gary Lynn Jaquier
Life of this patent
Estimating the term…
Abstract
A system and method for generating an On-Line Analytical Processing (OLAP) query. A query object is provided that supports a plurality of OLAP servers which use different structured query formats. An OLAP server is determined from among the OLAP servers for which the query will be executed based on a property of the query object. The query object is processed to generate a query statement using the structured query format that corresponds to the determined OLAP server.
Claims17
A method of generating an On-Line Analytical Processing (OLAP) query, comprising:
- providing a query object capable of supporting a plurality of OLAP servers, each of the OLAP servers using a different structured query format, wherein the plurality of OLAP servers include an OLAP server from a group of OLAP servers including Microsoft Analysis Services OLAP server and Hyperion Essbase™ OLAP server;
- determining an OLAP server from among the plurality of OLAP servers for which the query will be executed based upon a property of the query object;
- and
- processing the query object to generate a query statement using the structured query format corresponding to the OLAP server determined.
A method of generating an OLAP query using a query object capable of supporting a plurality of OLAP servers, each of the OLAP servers using a different structured query format, wherein the plurality of OLAP servers include an OLAP server from a group of OLAP servers including Microsoft Analysis Services OLAP server and Hyperion Essbase™ OLAP server, the method comprising:
- determining, based upon a property of the query object, an OLAP server from among the plurality of OLAP servers, wherein determining includes identifying an OLAP server from a group of OLAP servers including Microsoft Analysis Services OLAP server and Hyperion Essbase™ OLAP server;
- and
- processing the query object to generate a query statement using the structured query format corresponding to the OLAP server determined.
An apparatus for generating an OLAP query using a query object capable of supporting a plurality of OLAP servers, each of the OLAP servers using a different structured query format, wherein the plurality of OLAP servers include an OLAP server from a group of OLAP servers including Microsoft Analysis Services OLAP! server and Hyperion Essbase™ OLAP server, the apparatus comprising:
- means for determining, based upon a property of the query object, an OLAP server from among the plurality of OLAP servers, wherein the means for determining includes means for identifying an OLAP server from a group of OLAP servers including Microsoft Analysis Services OLAP server and Hyperion Essbase™ OLAP server;
- and
- means for processing the query object to generate a query statement using the structured query format corresponding to the OLAP server determined.
Dependencies are inferred from the claim text.