Oracle International Corporation

Balaji Pattabhiraman

Deepankar Narayanan

Virad Gupta

Rahul Mahashabde

Raghu Edalur

Sai Jai Ganesh Gurubaran

Kalpana Madhalam

Venkata Gujjula

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.

Generation of dynamic contextual pivot grid analytics

A system and method facilitating data search, analysis, and/or related actions or data modifications in an enterprise computing environment. An example method includes providing a first user option to specify a transaction search; providing a second user option to specify an analytic; and employing an integrated analytics and search framework to present one or more search results via the analytic in response to user selection of the first user option. In a more specific embodiment, the first user option further enables user specification of one or more dimensions of a data component used for a search, by manipulation of an analytics setting. A third user option enables user modification of search data returned as search results and/or may enable users to perform related actions, e.g., approval of expense reports. Additional controls may enable selective user access to functionality depending upon content of the search results.

Embedding analytics within transaction search

A system and method facilitating transforming or updating displayed data using data hierarchy information. An example method includes storing hierarchy information characterizing a dataset via one or more tree tables; selectively accessing a database to update data characterized by metadata of the one or more tree tables; employing one or more pivot grids to replicate one or more hierarchical properties of the one or more tree tables; and displaying information based on the one or more pivot grids. The displaying step may further include using the pivot grid(s) to generate and display analytic(s), wherein data for the pivot grid(s) and analytics(s) is obtained from flattened tree tables. Dynamically executed Structured Query Language (SQL) construct(s) may retrieve un-cached fresh multi-dimensional data used for the pivot grid(s) or analytic(s) in a manner consistent with hierarchy information retrieved (via SQL) from the tree tables as tree metadata.

Hierarchical dimension analysis in multi-dimensional pivot grids

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.

Growing community of inventors

Karnataka, India

Balaji Pattabhiraman