Generation of dynamic contextual pivot grid analytics

Patent metadata

Field	Value
Publication number	US-10642990-B2
Application number	US-201615217836-A
Country	US
Kind code	B2
Filing date	Jul 22, 2016
Priority date	Oct 24, 2015
Publication date	May 5, 2020
Grant date	May 5, 2020

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.

First claim

We claim:

1. A method for facilitating creation of analytic reports in a computing environment, the method comprising:
receiving a query from a user to build an analytic report associated with an application page from an analytic template selected from a plurality of analytic templates;
in response to the query, analyzing the association of the application page and context information to determine a subset of analytic templates from the plurality of analytic templates to present to the user associated with a given user role, wherein the context information comprises subject matter characterizing the application page and role-level security that defines user permissions for accessing and displaying types of analytic reports based on user roles, wherein the given user role is subordinate to another user role and at least one or more of the analytic templates are unavailable to the other user role that is superior to the given user role;
determining where to present the subset of analytic templates to the user and presenting the subset of analytic templates to the user based on the determination;
receiving a selection of the analytic template from the subset of analytic templates from the user, wherein the analytic template includes a query definition containing a plurality of database queries of a composite query, wherein the plurality of database queries are filterable based on multilayered security policies, wherein the composite query further comprises access criteria specifying role-level security;
analyzing the query definition to determine configuration information characterizing one or more user interface features to be incorporated into the analytic report, wherein the configuration information includes instructions for collecting the context information to control user accessibility to the analytic template in accordance with the context information, wherein the configuration information contains instructions for generating the composite query used to retrieve selected data from a database in accordance with parameters and information defining the analytic template, obtain the one or more user interface features for incorporation into the analytic report, obtain security data pertaining to security settings configured to filter the plurality of database queries based on multilayered security policies, obtain additional information pertaining to data associated with user interface display screens used to display the analytic report, obtain instructions for retrieving data from live databases, and obtain specification data pertaining to joins of data used to produce joined analytic report data;
employing the configuration information to generate the composite query used to selectively retrieve data from the database, obtain application page data and obtain additional context information used to determine which analytic report data to include in the analytic report, 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 the analytic template and an analytic report that is based on the analytic template;
using the configuration information, the application page data, the additional information, and the composite query to construct the analytic template; and
publishing the analytic template to a repository so that the analytic template is accessible to one or more authorized end users of the computing environment with respect to the multilayered security policies,
rendering a user interface in a browser of end user clients, and displaying the application page that includes page data derived from the database via the user interface, wherein the application page includes one or more user interface controls that enable user selection of an analytic report associated with the application page, wherein the selected analytic report is generated in response to the user selection by employing a portion of the page data to configure another composite query in accordance with configuration information specified in the analytic report, wherein the user interface includes the application page that includes page fields that provide context used to create another analytic report; and
publishing the analytic report to the repository of authorized end users in response to user selection of the one or more user interface controls, wherein the repository is a live multi-tenant database and the analytic report is accessible by the one or more authorized end users via a tile repository.

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

4. The method of claim 1 , wherein the configuration information further includes instructions for obtaining the 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.

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

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

7. 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 a query from a user to build an analytic report associated with an application page from an analytic template selected from a plurality of analytic templates;
in response to the query, analyzing the association of the application page and context information to determine a subset of analytic templates from the plurality of analytic templates to present to the user associated with a given user role, wherein the context information comprises subject matter characterizing the application page and role-level security that defines user permissions for accessing and displaying types of analytic reports based on user roles, wherein the given user role is subordinate to another user role and at least one or more of the analytic templates are unavailable to the other use role that is superior to the given user role;
determining where to present the subset of analytic templates to the user and presenting the subset of analytic templates to the user based on the determination;
receiving a selection of the analytic template from the subset of analytic templates from the user, wherein the analytic template includes a query definition containing a plurality of database queries of a composite query, wherein the plurality of database queries are filterable based on multilayered security policies, wherein the composite query further comprises access criteria specifying role-level security;
analyzing the query definition to determine configuration information characterizing one or more user interface features to be incorporated into the analytic report, wherein the configuration information includes instructions for collecting the context information to control user accessibility to the analytic template in accordance with the context information, wherein the configurati

Assignees

• Oracle Int Corp

Inventors

• Pattabhiraman Balaji
• Mahashabde Rahul
• Gupta Virad
• Narayanan Deepankar
• Edalur Raghu
• Gurubaran Sai Jai Ganesh

Classifications

• G06F16/26

  Visual data mining; Browsing structured data · CPC title

• H04L63/102

  Entity profiles · CPC title

• G06F21/62 Primary

  Protecting access to data via a platform, e.g. using keys or access control rules · CPC title

• G06F16/25

  Integrating or interfacing systems involving database management systems · CPC title

• G06F40/186

  Templates · CPC title