Display of dynamic contextual pivot grid analytics

Abstract

A system and method for facilitating end-user creation and use of an analytic report that is derived from or based on an analytic report template. The example method includes displaying a User Interface (UI) display screen that incorporates page data derived from a database; providing, in the UI display screen, one or more user options to select an analytic report associated with the UI display screen; generating an analytic report corresponding to the selection, in part by employing a portion of the page data to automatically generate one or more queries in accordance with configuration information specified in the analytic report, the one or more queries configured to selectively retrieve the analytic report data from the database in accordance with the configuration information; and using the one or more queries to populate one or more features of the analytic report with the report data derived from the database, yielding a populated analytic report in response thereto, which is then displayed.

Description

[0001] Cross References to Related Applications [0002] This application claims U.S. Patent Application Serial No. 15 / 217,847, filed July 22, 2016, entitled "DISPLAY OF DYNAMIC CONTEXTUALPIVOT GRID ANALYTICS," and filed July 22, 2016, entitled "GENERATION OF CONTEXTUAL PIVOT GRID ANALYTICS,” U.S. Patent Application Serial No. 15 / 217,836 and U.S. Provisional Patent Application Serial No. 62 / 246,033, filed October 24, 2015, entitled “DYNAMIC CONTEXTUAL PIVOT GRIDANALYTICS,” all of which are incorporated by reference is incorporated herein for all purposes as if fully set forth in this application. [0003] This application is related to the following applications, each of which is hereby incorporated by reference for all purposes as if fully set forth in this application: [0004] 1. U.S. Patent Application Serial No. 14 / 710,448, entitled "SUPPORT HIERARCHICAL DIMENSION ANALYSISIN MULTI-DIMENSIONAL PIVOT GRIDS," filed May 12, 2015 (Attorney Docket No. ORACP0127-ORA141024-US-NP);...

AI Technical Summary

Problems solved by technology

However, this report creation process is slow and costly, and administrators may lack a comprehensive understanding of the reporting capabilities sought

As such, such systems generally lack effective features for enabling rapid or real-time generation and customization of reports that can address rapidly changing enterprise data analysis needs

[0011] Additionally, large enterprises (which can include thousands of employees) can accumulate many different analytics reports created by different contracted developers, which may not uniformly comply with corporate data security policies

Thus, use of such conventional report creation methods and systems generally does not provide consistent and unified multi-layered security features, thereby potentially reducing an enterprise's control over data security

[0012] Furthermore, the reports created by developers are often complex and lack a consistent framework or approach, such that end users must often relearn how the user interface used to display the report operates for each new report that is accessed and viewed

This can be time-consuming and costly, potentially reducing the ability of business personnel to make critical and informed business decisions quickly

Images