Display of Dynamic Context Pivot Grid Analysis

Abstract

Systems and methods for facilitating end-user creation and use of analytical reports derived from or based on analytical report templates. The example method includes: displaying a user interface (UI) display screen incorporating page data derived from a database; providing one or more user options in the UI display screen to select an analysis report associated with the UI display screen; in part Generate an analysis report corresponding to the selection by taking a portion of the page data to automatically generate one or more queries configured to selectively retrieve data from the database based on the configuration information according to the configuration information specified in the analysis report. and using the one or more queries to populate one or more characteristics of the analysis report with report data derived from the database, thereby generating a populated analysis report responsive thereto, and then displaying the populated analysis Report.

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