Oracle International Corporation

Virad Gupta

Deepankar Narayanan

Raghu Edalur

Rahul Mahashabde

Balaji Pattabhiraman

Mohini Mohana Sahoo

Ramasimha Rangaraju

Vivek Verma

Kalpana Madhalam

Sai Jai Ganesh Gurubaran

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.

Display of dynamic contextual pivot grid analytics

Embodiments of the invention provide systems and methods for scheduling and executing user-restricted processes within distributed computing systems. More specifically, certain embodiments of the present invention describe systems and methods by which runtime requests to execute user-restricted processes may be received, processed, and scheduled via a user application of an enterprise system or other distributed computing system. Requests may be received via transaction pages of user applications to schedule and execute user-restricted processes. The user application, a process scheduler, and/or other components within the distributed computing system may determine user contexts associated with the requests, and may determine whether or not the requested processes may be scheduled and executed. Such processes may include, for example, report generation processes, processes to initiate system functions, and/or processes to perform system maintenance within the distributed computing environment.

Process scheduling and execution in distributed computing environments

Various techniques are described herein for creating data partition process schedules and executing such partition schedules using multiple parallel process instances. Data processing tasks initiated by or for applications may be executed by creating and executing partition schedules, in which a number of different process instances are created and each assigned a subset of data to process. Partition schedules may be used to determine a number of process instances to be created, and each process instance may be assigned a unique set of run-time data values corresponding to a unique set of parameters within the data set to be processed by the application. The process instances may operate independently and in parallel to retrieve and process separate partitions of the data required for the overall data processing task initiated by/for the application.

Growing community of inventors

Fremont, CA, United States of America

Virad Gupta