QUERY GENERATOR

• US 20150199399A1
• Filed: 01/10/2014
• Published: 07/16/2015
• Est. Priority Date: 01/10/2014
• Status: Abandoned Application

• Current Assignee: SAP SE
• Original Assignee: Sebastian Schroetel
• Inventors: Schroetel, Sebastian, Albrecht, Zoltan, Kampsen, Felix, Shan, Wenja
• Application Number:
  US14/152,122
• Publication Number:
  US 20150199399A1
• Time in Patent Office: Days
• US Class Current: 1/1
• CPC Class Codes: G06F 16/2423 Interactive query statement specification based on a database schema
• CPC Class Codes: G06F 16/2425 Iterative querying; Query formulation based on the results of a preceding query

Abstract

The disclosure generally describes computer-implemented methods, computer-readable media, and computer systems for querying information. An identifier is received that is associated with a first query for obtaining summary information associated with one or more business objects. An indicator is received that requests parameters for generating a second query associated with the first query and operable for obtaining detailed information associated with the one or more business objects. The first query associated with the received identifier is executed to identify the summary information. The parameters are generated using metadata associated with the one or more business objects. The summary information and the parameters are provided in response to the received identifier and indicator

Claims

1. A computer-implemented method comprising:

receiving an identifier associated with a first query for obtaining summary information associated with one or more business objects;

receiving an indicator requesting parameters for creating a second query associated with the first query and operable for obtaining detailed information associated with the one or more business objects;

executing, using one or more processors, the first query associated with the received identifier to identify the summary information;

creating, using metadata associated with the one or more business objects, the parameters; and

providing the summary information and the parameters in response to the received identifier and indicator.

2. The computer-implemented method of claim 1, wherein the identifier is a technical name associated with an information provider and identified by the identifier.

3. The computer-implemented method of claim 2, wherein the summary information is based on predefined dimensions and key figures associated with the information provider.

4. The computer-implemented method of claim 1, wherein the second query is associated with a view describing a layout of the detailed information.

5. The computer-implemented method of claim 1, wherein the parameters include an executable instance of the second query.

6. The computer-implemented method of claim 1, wherein the parameters include building blocks usable to formulate the second query.

7. The method of claim 1, wherein executing the first query includes, depending on at least a source of the first query, one of:

providing a first result set that includes the summary information when an API is used for executing the first query; and

providing a second result set that includes the summary information and the detailed information when the first query is executed in a native environment.

8. The method of claim 1, wherein the parameters are represented in a multi-dimensional expression language.

9. The computer-implemented method of claim 1, further comprising:

receiving the second query;

executing the second query; and

providing the detailed information in response to the received second query.

10. The computer-implemented method of claim 1, further comprising:

providing parameters for creating a third query associated with the second query and operable for obtaining additional detailed information associated with the one or more business objects;

receiving the third query;

executing the third query; and

providing the additional detailed information in response to the received third query.

11. A computer-readable media, the computer-readable media comprising computer-readable instructions embodied on tangible, non-transitory media, the instructions operable when executed by at least one computer to:

receive an identifier associated with a first query for obtaining summary information associated with one or more business objects;

receive an indicator requesting parameters for creating a second query associated with the first query and operable for obtaining detailed information associated with the one or more business objects;

execute, using one or more processors, the first query associated with the received identifier to identify the summary information;

create, using metadata associated with the one or more business objects, the parameters; and

provide the summary information and the parameters in response to the received identifier and indicator.

12. The computer-readable media of claim 11, wherein the identifier is a technical name associated with an information provider and identified by the identifier.

13. The computer-readable media of claim 12, wherein the summary information is based on predefined dimensions and key figures associated with the information provider.

14. The computer-readable media of claim 11, wherein the second query is associated with a view describing a layout of the detailed information.

15. The computer-readable media of claim 11, wherein the parameters include an executable instance of the second query.

16. A computer system, comprising:

memory operable to store content, including static and dynamic content; and

at least one hardware processor interoperably coupled to the memory and operable to perform instructions to;

receive an identifier associated with a first query for obtaining summary information associated with one or more business objects;

receive an indicator requesting parameters for creating a second query associated with the first query and operable for obtaining detailed information associated with the one or more business objects;

execute, using one or more processors, the first query associated with the received identifier to identify the summary information;

create, using metadata associated with the one or more business objects, the parameters; and

provide the summary information and the parameters in response to the received identifier and indicator.

17. The computer system of claim 16, wherein the identifier is a technical name associated with an information provider and identified by the identifier.

18. The computer system of claim 17, wherein the summary information is based on predefined dimensions and key figures associated with the information provider.

19. The computer system of claim 16, wherein the second query is associated with a view describing a layout of the detailed information.

20. The computer system of claim 16, wherein the parameters include an executable instance of the second query.