Oracle International Corporation

Kalpana Madhalam

Deepankar Narayanan

Virad Gupta

Balaji Pattabhiraman

Rahul Mahashabde

Venkata Gujjula

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.

Growing community of inventors

Parramatta, Australia

Kalpana Madhalam