GENERATION OF DYNAMIC CONTEXTUAL PIVOT GRID ANALYTICS

• US 20170116426A1
• Filed: 07/22/2016
• Published: 04/27/2017
• Est. Priority Date: 10/24/2015
• Status: Active Grant

• Current Assignee: Oracle International Corporation (Oracle Corporation)
• Original Assignee: Oracle International Corporation (Oracle Corporation)
• Inventors: Pattabhiraman, Balaji, Mahashabde, Rahul, Gupta, Virad, Narayanan, Deepankar, Edalur, Raghu, Gurubaran, Sai Jai Ganesh
• Granted Patent: US 10,642,990 B2
• Time in Patent Office: Days
• CPC Class Codes: G06F 16/25 Integrating or interfacing systems involving database management systems
• CPC Class Codes: G06F 16/252 between a Database Management System and a front-end application
• CPC Class Codes: G06F 16/26 Visual data mining; Browsing structured data
• CPC Class Codes: G06F 21/62 Protecting access to data via a platform, e.g. using keys or access control rules
• CPC Class Codes: G06F 21/6227 where protection concerns the structure of data, e.g. records, types, queries
• CPC Class Codes: G06F 40/186 Templates
• CPC Class Codes: G06Q 10/10 Office automation; Time management
• CPC Class Codes: H04L 63/102 Entity profiles

Abstract

A system and method for facilitating timely end user creation, customization, and/or configuration of analytic reports in a computing environment, such as an enterprise-computing environment. An example method includes receiving configuration information characterizing one or more User Interface (UI) features to be incorporated into an analytic report; employing the configuration information to generate one or more database queries to selectively retrieve data from the database; using the configuration information and the one or more database queries to construct an analytic template; and publishing the analytic template so that the analytic template is accessible to one or more end users of the computing environment. In a more specific embodiment, the computing environment includes an enterprise-computing environment, and the one or more users include enterprise personnel. The configuration information, which may include user job role information, includes instructions for collecting context information to control user accessibility to the analytic template and data associated therewith in accordance with the context information.

Claims

1. A method for facilitating creation of analytic reports in a computing environment, the method comprising:

receiving configuration information characterizing one or more user interface features to be incorporated into an analytic report;

employing the configuration information to generate one or more database queries to selectively retrieve data from a database;

using the configuration information and the one or more database queries to construct an analytic template; and

publishing the analytic template so that the analytic template is accessible to one or more end users of the computing environment.

2. The method of claim 1, wherein the computing environment includes an enterprise-computing environment, and wherein the one or more end users include enterprise personnel.

3. The method of claim 2, wherein the configuration information includes instructions for collecting context information to control user accessibility to the analytic template in accordance with the context information.

4. The method of claim 3, wherein the context information includes user role information.

5. The method of claim 4, wherein the configuration information further includes one or more security settings specifying which of the enterprise personnel using the computing environment may access the analytic template in accordance with the user role information pertaining to the enterprise personnel.

6. The method of claim 5, wherein the configuration information further includes a first security setting specifying which of the one or more database queries of the analytic template will retrieve data for use by the enterprise personnel in accordance with user role information pertaining to the enterprise personnel.

7. The method of claim 5, wherein the configuration information further includes instructions for obtaining additional context information pertaining to one or more user interface display screens and data associated therewith, the data pertaining to one or more enterprise transactions that are respectively associated with the one or more user interface display screens.

8. The method of claim 7, wherein the one or more user interface display screens represent one or more enterprise application pages of an enterprise application user interface component.

9. The method of claim 8, wherein the additional context information includes data available in one or more fields of the one or more user interface display screens.

10. The method of claim 9, wherein the additional context information further includes data retrieved from one or more user entries responsive to one or more user prompts, the one or more user prompts displayed during configuration of one or more of:

the analytic template, and an analytic report that is based on the analytic template.

11. A non-transitory processor-readable storage device including instructions executable by a digital processor, the non-transitory processor-readable storage device including one or more instructions for:

receiving configuration information characterizing one or more user interface features to be incorporated into an analytic report;

employing the configuration information to generate one or more database queries to selectively retrieve data from a database;

using the configuration information and the one or more database queries to construct an analytic template; and

publishing the analytic template so that the analytic template is accessible to one or more end users of a computing environment incorporating the non-transitory processor-readable storage device.

12. The non-transitory processor-readable storage device of claim 11, wherein the computing environment includes an enterprise-computing environment, and wherein the one or more end users include enterprise personnel.

13. The non-transitory processor-readable storage device of claim 12, wherein the configuration information includes instructions for collecting context information to control user accessibility to the analytic template in accordance with the context information.

14. The non-transitory processor-readable storage device of claim 13, wherein the context information includes the user role information.

15. The non-transitory processor-readable storage device of claim 14, wherein the configuration information further includes one or more security settings specifying which of the enterprise personnel using the computing environment may access the analytic template in accordance with the user role information pertaining to the enterprise personnel.

16. The non-transitory processor-readable storage device of claim 15, wherein the configuration information further includes a first security setting specifying which of the one or more database queries of the analytic template will retrieve data for use by the enterprise personnel in accordance with user role information pertaining to the enterprise personnel.

17. The non-transitory processor-readable storage device of claim 15, wherein the configuration information further includes instructions for obtaining additional context information pertaining to one or more user interface display screens and data associated therewith, the data pertaining to one or more enterprise transactions that are respectively associated with the one or more user interface display screens.

18. The non-transitory processor-readable storage device of claim 17, wherein the one or more user interface display screens represent one or more enterprise application pages of an enterprise application user interface component.

19. The non-transitory processor-readable storage device of claim 18, wherein the additional context information includes data available in one or more fields of the one or more user interface display screens.

20. The non-transitory processor-readable storage device of claim 19, wherein the additional context information further includes data retrieved from one or more user entries responsive to one or more user prompts, the one or more user prompts displayed during configuration of one or more of:

the analytic template, and an analytic report that is based on the analytic template.