EMBEDDING ANALYTICS WITHIN TRANSACTION SEARCH

• US 20160012111A1
• Filed: 05/12/2015
• Published: 01/14/2016
• Est. Priority Date: 07/10/2014
• Status: Active Grant

• Current Assignee: Oracle International Corporation (Oracle Corporation)
• Original Assignee: Oracle International Corporation (Oracle Corporation)
• Inventors: Pattabhiraman, Balaji, Mahashabde, Rahul, Gupta, Virad, Narayanan, Deepankar, Madhalam, Kalpana, Gujjula, Venkata
• Granted Patent: US 10,606,855 B2
• Time in Patent Office: Days
• US Class Current: 1/1
• CPC Class Codes: G06F 16/248 Presentation of query results
• CPC Class Codes: G06F 16/284 Relational databases

Abstract

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.

Claims

1. A method for facilitating concurrent search and analysis in an enterprise computing environment, the enterprise computing environment including one or more client devices in communication with a server system, wherein the server system executes webpage software, wherein the webpage software provides webpage information accessible to the one or more client devices, the method comprising the following performed by one of the client devices:

employing a first user interface display screen to display one or more search options to enable user initiation of a data search;

showing, on the display screen, a collection of one or more search results of the data search in response to a user activation of one of the search options, wherein the search results are shown via a first data visualization concurrently with the one or more search options;

receiving a user selection of at least one of the search results; and

in response to the user selection, providing a first user option to implement functional manipulation of data associated with the search results.

2. The method of claim 1, wherein the data search includes a transaction search, and wherein the search results include indications of one or more transactions.

3. The method of claim 1, wherein the data associated with the search results includes data of a computing object associated with a particular search result selected by a user.

4. The method of claim 3, further including providing a second user option to trigger the functional manipulation from user manipulation of the first data visualization.

5. The method of claim 3, wherein the functional manipulation includes one or more software actions.

6. The method of claim 5, wherein the one or more software actions include approval of an expense report associated with the computing object.

7. The method of claim 3, further including providing a third user option to initiate a drill-down action via a menu or control incorporated in the first data visualization, wherein the drill-down action is based on a portion of an analytic identified by user selection of the third user option via the portion.

8. The method of claim 3, wherein the one or more search options includes a fourth user option to drag and drop a dimension onto a pivot grid associated with the first data visualization, resulting in an updated second data visualization in response thereto.

9. The method of claim 7, further including automatically selecting a data dimension, facet, filter, or search term in response to the drill-down action, and displaying data associated with the selection.

10. The method of claim 1, further including detecting a user initiated adjustment to the data visualization, and automatically adjusting displayed search results and a pivot grid in response to the user initiated adjustment.

11. The method of claim 1, wherein the data search includes a filtering operation performed upon a first set of data.

12. The method of claim 11, further including maintaining said first set of data in a relational database.

13. The method of claim 12, further including employing one or more Structured Query Language (SQL) constructs to selectively access data in the relational database in response to a user initiated query implemented via user selection of the one or more user options.

14. The method of claim 13, wherein the one or more SQL constructs include an SQL construct adapted to perform an approximately real time SQL query against the database during implementation of a data search or refresh of data displayed via the user interface display screen.

15. The method of claim 1, further including:

selectively displaying one or more user options to implement the functional manipulation via one or more software actions corresponding to one or more user interface controls; and

selectively altering display of the one or more user interface controls in accordance with the search results.

16. The method of claim 1, further including

providing a second user option to specify a transaction search;

providing a third user option to specify an analytic; and

using 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.

17. The method of claim 16, further including providing a fourth user option to modify data that has been displayed as a part of the search results.

18. The method of claim 16, wherein the second user option further includes one or mechanisms enabling user specification of one or more dimensions of a data component used for a search, by manipulation of an analytics setting, and wherein the method further includes adjusting a display of the search results to include one or more user interface controls for enabling user access to functionality, the functionality dependent upon content of the search results.

19. An apparatus comprising:

a digital processor coupled to a display and to a processor-readable storage device, wherein the processor-readable storage device includes one or more instructions executable by the digital processor to perform the following acts;

employing a first user interface display screen to display one or more search options to enable user initiation of a data search;

showing, on the display screen, a collection of one or more search results of the data search in response to a user activation of one of the search options, wherein the search results are shown via a first data visualization concurrently with the one or more search options;

receiving a user selection of at least one of the search results; and

in response to the user selection, providing a first user option to implement functional manipulation of data associated with the search results.

20. A processor-readable storage device including instructions executable by a digital processor, the processor-readable storage device including one or more instructions for:

employing a first user interface display screen to display one or more search options to enable user initiation of a data search;

showing, on the display screen, a collection of one or more search results of the data search in response to a user activation of one of the search options, wherein the search results are shown via a first data visualization concurrently with the one or more search options;

receiving a user selection of at least one of the search results; and

in response to the user selection, providing a first user option to implement functional manipulation of data associated with the search results.