OLAP query generation engine

• US 6,651,055 B1
• Filed: 03/01/2001
• Issued: 11/18/2003
• Est. Priority Date: 03/01/2001
• Status: Active Grant

• Current Assignee: Infor Incorporated
• Original Assignee: Lawson Software Incorporated (Infor Incorporated)
• Inventors: Kilmer, Lee Eric, Jaquier, Gary Lynn, Pavelka, Thomas Joseph, Bendickson, Richard Scott
• Primary Examiner(s): Rones, Charles
• Assistant Examiner(s): Wu, Y
• Application Number:
  US09/797,303
• Time in Patent Office: 992 Days
• Field of Search: 707/1, 707/2, 707/3, 707/4, 707/5, 707/8, 707/9, 707/10, 707/100, 707/101, 707/102, 707/104.1
• US Class Current: 1/1
• CPC Class Codes: G06F 16/2452 Query translation
• CPC Class Codes: G06F 16/283 Multi-dimensional databases or data warehouses, e.g. MOLAP or ROLAP
• CPC Class Codes: Y10S 707/99931 Database or file accessing
• CPC Class Codes: Y10S 707/99932 Access augmentation or optimizing
• CPC Class Codes: Y10S 707/99933 Query processing, i.e. searching
• CPC Class Codes: Y10S 707/99934 Query formulation, input preparation, or translation

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.

Claims

1. 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.

2. The method of claim 1, wherein the query statement is generated using the Multi-Dimensional Expression (MDX) query format when the property of the query object indicates Microsoft Analysis Services OLAP server.

3. The method of claim 2, wherein processing the query object includes generating a select clause and a from clause from the query object, and combining the select clause and the from clause to generate the query statement.

4. The method of claim 2, wherein processing the query object includes generating a select clause, a from clause, and a with clause from the query object, and combining the with, select and from clauses to generate the query statement.

5. The method of claim 2, wherein processing the query object includes generating a select clause, a from clause, and a where clause from the query object, and combining the select, from and where clauses to generate the query statement.

6. The method of claim 2, wherein processing the query object includes generating a select clause, a from clause, and an order by clause front the query object, and combining the select, from and order by clauses to generate the query statement.

7. The method of claim 1, wherein the query statement is generated using the Report Scripts (RS) query format when the property of the query object indicates Hyperion Essbase™

OLAP server.

8. The method of claim 7, wherein processing the query object includes generating a header specification, an axis specification and an execute specification from the query object, and combining the header, axis and execute specifications.

9. The method of claim 7, wherein processing the query object includes generating a header specification, an axis specification, a member specification, and an execute specification from the query object, and combining the header, axis, member and execute specifications to generate the query statement.

10. The method of claim 7, wherein processing the query object includes generating a header specification, an axis specification, an expression specification, and an execute specification from the query object, and combining the header, axis, expression and execute specifications to generate the query statement.

11. The method of claim 1, wherein the query object property supports at least three OLAP servers, each of the OLAP servers using a different structured query format.

12. 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.

13. The method of claim 12, wherein the query object supports the Microsoft Analysis Services OLAP server and Hyperion Essbase™

OLAP server, and wherein processing includes generating an MDX query statement when the property indicates that the OLAP server is a Microsoft Analysis Services OLAP server and includes generating an RS query statement when the property indicates that the OLAP server is a an Hyperion Essbase™

OLAP server, respectively.

14. The method of claim 12, wherein the query object supports at least three OLAP servers, wherein each uses a different structured query format, and the wherein processing includes generating the query statement using one of the at least three formats.

15. 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.

16. The apparatus of claim 15, wherein the query object is capable of supporting the Microsoft Analysis Services OLAP server and Hyperion Essbase™

OLAP server, and wherein the means for processing generates an MDX query statement and an RS query statement when the property of the query object indicates that the OLAP server is a Microsoft Analysis Services OLAP server and an Hyperion Essbase™

OLAP server, respectively.

17. The apparatus of claim 15, wherein the query object is capable of supporting at least three OLAP servers, wherein each uses a different structured query format, and the means for processing generates the query statement using one of the at least three formats.