METHOD AND SYSTEM FOR IMPLEMENTING USER REPORTING

• US 20130197953A1
• Filed: 01/30/2013
• Published: 08/01/2013
• Est. Priority Date: 01/31/2012
• Status: Active Application

• Current Assignee: Oracle International Corporation (Oracle Corporation)
• Original Assignee: Oracle International Corporation (Oracle Corporation)
• Inventors: SHOLES, Keith, ERICKSON, Jeff, ZHONG, Qiu, LI, Na
• Application Number:
  US13/754,871
• Publication Number:
  US 20130197953A1
• Time in Patent Office: Days
• US Class Current: 705/7.12
• CPC Class Codes: G06Q 10/0631 Resource planning, allocation, distributing or scheduling for enterprises or organisations

Abstract

Disclosed are methods and apparatuses that efficiently provides for end user reporting from interactive applications. One embodiment provides an approach for implementing dynamic field selection for a user to select report parameters for an end user report using the user interface of an ERP application. User inputs are used to automatically generate queries to form a report data model usable by a reporting tool.

Claims

1. A method for generating a report definition for an resource management system, comprising the steps of:

receiving a plurality of user inputs at an resource management application, comprising selections for a plurality of report parameters;

creating a report data model based at least in part on the user inputs;

loading the report data model into a reporting tool; and

designing a report definition using the reporting tool, wherein the report definition is based at least in part upon the report parameters from the report data model.

2. The method of claim 1, wherein the resource management system is an ERP system.

3. The method of claim 1, wherein the report definition defines visualization aspects of the report.

4. The method of claim 1, wherein the report parameters comprise data fields to be included in the report.

5. The method of claim 4, wherein the report parameters further comprise which rows in a data field are to be included in the report.

6. The method of claim 1, wherein the reporting tool is invoked through the resource management application.

7. The method of claim 1, wherein the report data model and the report definition are saved to a computer storage device.

8. The method of claim 1, further comprising the steps of:

receiving a user input at the resource management application selecting one or more queries;

receiving a user input selecting a report definition;

querying the database using the selected queries; and

generating report based at least in part on the data returned by the database in response to the queries, and on the report definition of the selected report.

9. The method of claim 8, wherein the one or more queries are generated automatically by the resource management application based at least in part on a plurality of user inputs at the resource management application.

10. A system for generating a report for an resource management system, comprising:

a database containing data for which a report is to be generated;

a resource management application, wherein the resource management application is configured to receive inputs from a user selecting a plurality of report parameters and to create a report data model based at least in part upon the selected report parameters; and

a reporting tool, wherein the reporting tool is configured to load a report data model and to receive inputs from a user to create a report definition.

11. The system of claim 10, wherein the resource management system is an ERP system.

12. The system of claim 10, wherein the report definition defines visualization aspects of the report.

13. The system of claim 10, wherein the report parameters comprise data fields to be included in the report.

14. The system of claim 13, wherein the report parameters further comprise which rows in a data field are to be included in the report.

15. The system of claim 10, wherein the reporting tool is invoked through the resource management application.

16. The system of claim 10, wherein the report data model and the report definition are saved to a computer storage device.

17. The system of claim 10, wherein the resource management application is further configured to allow a user to execute a report definition, comprising the steps of:

receiving a user input at the resource management application selecting one or more queries;

receiving a user input selecting a report definition;

querying the database using the selected queries; and

generating report based at least in part on the data returned by the database in response to the queries, and on the report definition of the selected report.

18. The system of claim 17, wherein the one or more queries are generated automatically by the resource management application based at least in part on a plurality of user inputs at the resource management application

19. A computer program product including a non-transitory computer readable medium having instructions which, when executed by a processor, causes the processor to perform a process for generating a report definition for an resource management system, the process comprising:

receiving a plurality of user inputs at an resource management application, comprising selections for a plurality of report parameters;

creating a report data model based at least in part on the user inputs;

loading the report data model into a reporting tool; and

designing a report definition using the reporting tool, wherein the report definition is based at least in part upon the report parameters from the report data model.

20. The computer program product of claim 19, wherein the resource management system is an ERP system.

21. The computer program product of claim 19, wherein the report definition defines visualization aspects of the report.

22. The computer program product of claim 19, wherein the report parameters comprise data fields to be included in the report.

23. The computer program product of claim 22, wherein the report parameters further comprise which rows in a data field are to be included in the report.

24. The computer program product of claim 19, wherein the reporting tool is invoked through the resource management application.

25. The computer program product of claim 19, wherein the report data model and the report definition are saved to a computer storage device.

26. The computer program product of claim 19, further comprising the steps of:

receiving a user input at the resource management application selecting one or more queries;

receiving a user input selecting a report definition;

querying the database using the selected queries; and

generating report based at least in part on the data returned by the database in response to the queries, and on the report definition of the selected report.

27. The computer program product of claim 26, wherein the one or more queries are generated automatically by the resource management application based at least in part on a plurality of user inputs at the resource management application.