Generation of dynamic contextual pivot grid analytics
First 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.
1 Assignment
0 Petitions
Accused Products
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.
-
Citations
17 Claims
-
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. - View Dependent Claims (2, 3, 4, 5, 6, 14, 15, 16, 17)
-
-
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 configuration information contains instructions for generating the composite query used to obtain 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 context information pertaining to data associated with user interface display screens used to display the analytic report, obtain instructions for retrieving data from live multitenant 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 context information, and the composite query to construct an analytic template; publishing the analytic template to a repository so that the analytic template is accessible to one or more authorized end users of a computing environment incorporating the non-transitory processor-readable storage device 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 for one or more 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. - View Dependent Claims (8, 9, 10, 11, 12, 13)
-
Specification