MAPPING DATA IN ENTERPRISE APPLICATIONS FOR OPERATIONAL VISIBILITY

• US 20110205231A1
• Filed: 02/24/2010
• Published: 08/25/2011
• Est. Priority Date: 02/24/2010
• Status: Abandoned Application

• Current Assignee: Oracle International Corporation (Oracle Corporation)
• Original Assignee: Oracle International Corporation (Oracle Corporation)
• Inventors: Behzadi, Houman, Hartley, Jo Ann, Haba, Bao Tuan
• Application Number:
  US12/711,623
• Publication Number:
  US 20110205231A1
• Time in Patent Office: Days
• US Class Current: 345/440
• CPC Class Codes: G06Q 40/00 Finance; Insurance; Tax strategies; Processing of corporate or income taxes
• CPC Class Codes: G06T 11/206 Drawing of charts or graphs

Abstract

Novel tools and techniques for generating map displays to graphically illustrate financial performance. In one aspect, a map display might employ a coloration scheme that distinguishes among various ranked regions to illustrate, for example, revenue performance (which can be measured by any of a number of metrics), to allow a user to quickly understand the relative performance of a product line across a number of regions. In another aspect, a map display might correlate a first set of revenue information (or other financial information) with other data sets, such as sales force data, competitive sales data, and/or the like, to allow a user to quickly identify correlative patterns in the two data sets. Such map displays might feature two maps side-by-side, or might superimpose a map of one data set over a map of another data set, to assist in the user'"'"'s visual analysis.

Claims

1. A computer system, comprising:

one or more processors; and

memory in communication with the one or more processors, the memory having encoded thereon a set of instructions executable by the one or more processors to cause the computer system to at least;

access revenue data, created by an enterprise application and stored in a database, about a plurality of revenue transactions, the revenue data about each revenue transaction identifying an amount of revenue generated by a sale of one or more products by an enterprise;

provide a user interface for a user to interact with a data presentation system in communication with the database;

define a geographical hierarchy for the revenue data, the geographical hierarchy defining a plurality of regions organized hierarchically;

categorize the revenue data according to the geographical hierarchy;

define a ranking scheme for the revenue data, the ranking scheme comprising a plurality of thresholds for segmenting the plurality of regions into a plurality of ranks, according to a revenue characteristic for each region;

define a coloration scheme for the revenue data, the coloration scheme defining a coloration pattern corresponding to each of the plurality of ranks;

generate a map display in the user interface, the map display displaying at least a subset of the plurality of regions defined by the geographical hierarchy for the revenue data, each displayed region having a rank defined by the ranking scheme and a corresponding coloration pattern defined by the coloration scheme.

2. A method, comprising:

accessing revenue data, stored in a database, about a plurality of revenue transactions;

providing, at a computer system, a user interface for a user to interact with a data presentation system in communication with the database;

defining, at the computer system, a geographical hierarchy for the revenue data, the geographical hierarchy defining a plurality of regions organized hierarchically;

categorizing, at the computer system, the revenue data according to the geographical hierarchy;

defining, at the computer system, a ranking scheme for the revenue data, the ranking scheme comprising a plurality of thresholds for segmenting the plurality of regions into a plurality of ranks, according to a revenue characteristic for each region;

defining, at the computer system, a coloration scheme for the revenue data, the coloration scheme defining a coloration pattern corresponding to each of the plurality of ranks;

generating a map display in the user interface, the map display displaying at least a subset of the plurality of regions defined by the geographical hierarchy for the revenue data, each displayed region having a rank defined by the ranking scheme and a corresponding coloration pattern defined by the coloration scheme.

3. A computer-readable storage medium having encoded thereon a set of instructions executable by one or more computers to perform one or more operations, the set of instructions comprising:

instructions for accessing revenue data, stored in a database, about a plurality of revenue transactions;

instructions for providing a user interface for a user to interact with a data presentation system in communication with the database;

instructions for defining a geographical hierarchy for the revenue data, the geographical hierarchy defining a plurality of regions organized hierarchically;

instructions for categorizing the revenue data according to the geographical hierarchy;

instructions for defining a ranking scheme for the revenue data, the ranking scheme comprising a plurality of thresholds for segmenting the plurality of regions into a plurality of ranks, according to a revenue characteristic for each region;

instructions for defining a coloration scheme for the revenue data, the coloration scheme defining a coloration pattern corresponding to each of the plurality of ranks;

instructions for generating a map display in the user interface, the map display displaying at least a subset of the plurality of regions defined by the geographical hierarchy for the revenue data, each displayed region having a rank defined by the ranking scheme and a corresponding coloration pattern defined by the coloration scheme.

4. The computer-readable storage medium of claim 3, wherein the revenue data represents an amount of revenue earned over a specified period.

5. The computer-readable storage medium of claim 3, wherein the revenue data represents revenue growth over a specified period.

6. The computer-readable storage medium of claim 3, wherein the geographical hierarchy is a first geographical hierarchy, and wherein the revenue data stored in the database comprises a first plurality of data elements each comprising a geographical dimension corresponding to a second geographical hierarchy, and wherein the instructions for categorizing the revenue data comprise instructions for translating the geographical dimension of each of the first plurality of data elements from the second geographical hierarchy to the first geographical hierarchy.

7. The computer-readable storage medium of claim 6, wherein the revenue data stored in the database comprises a second plurality of data elements each comprising a geographical dimension corresponding to a third geographical hierarchy, and wherein the instructions for categorizing the revenue data further comprise instructions for translating the geographical dimension of each of the second plurality of elements from the third geographical hierarchy to the first geographical hierarchy.

8. The computer-readable storage medium of claim 3, wherein the revenue data stored in the database comprises a plurality of data elements each comprising a non-geographical dimension, and wherein the instructions for categorizing the revenue data comprise instructions for translating the non-geographical dimension of each of the plurality of data elements to the geographical hierarchy.

9. The computer-readable storage medium of claim 3, wherein the instructions for defining a geographical hierarchy comprise instructions for defining a geographical hierarchy based on user input indicating a desired geographical hierarchy.

10. The computer-readable storage medium of claim 3, wherein the instructions for defining a ranking scheme comprise instructions for defining ranking scheme based on user input specifying one or more of the plurality of thresholds.

11. The computer-readable storage medium of claim 3, wherein the instructions for defining a coloration scheme comprise instructions for defining a coloration scheme based on user input indicating one or more desired colors to be used on the map display.

12. The computer-readable storage medium of claim 3, wherein the set of instructions further comprises:

instructions for receiving user input selecting one of the displayed regions on the map display; and

instructions for displaying, in response to the user input, a subset of the revenue data, the subset of the revenue data pertaining to the selected region.

13. The computer-readable storage medium of claim 12, wherein the instructions for displaying a subset of the revenue data comprise instructions for generating a second map display in the user interface, the second map display displaying a plurality of sub-regions of the selected region.

14. The computer-readable storage medium of claim 13, wherein each displayed sub-region has a ranking defined by the ranking scheme and a color defined by the coloration scheme.

15. The computer-readable storage medium of claim 12, wherein the instructions for displaying a subset of the revenue data comprise instructions for generating a textual display of the subset of the revenue data.

16. The computer-readable storage medium of claim 3, wherein the revenue data comprises a first set of data about a plurality of revenue transactions associated with a first product, and wherein the set of instructions further causes the comprises:

instructions for accessing, in the database, a second set of data;

instructions for categorizing the second set of data according to the geographical hierarchy; and

instructions for correlating revenue data for at least one region with a subset of the second set of data, the subset of the second set of data pertaining to the at least one region.

17. The computer-readable storage medium of claim 16, wherein the second set of data comprises revenue data about a plurality of revenue transactions associated with a second product.

18. The computer-readable storage medium of claim 16, wherein the second set of data comprises sales force data about a sales force responsible for the plurality of revenue transactions associated with the first product.

19. The computer-readable storage medium of claim 16, wherein the instructions for generating a map display comprise instructions for displaying, in the user interface, information about the correlated subset of the second set of data.

20. The computer-readable storage medium of claim 19, wherein the ranking scheme is a first ranking scheme, wherein the coloration scheme comprises a first coloration scheme, and wherein the set of instructions further comprises:

instructions for defining a second ranking scheme for the second set of data, the second ranking scheme comprising a second plurality of thresholds for segmenting the plurality of regions into a second plurality of ranks according to a characteristic in the second set of data for each of the plurality of regions; and

instructions for defining a second coloration scheme for the second set of data, the second coloration scheme defining a second coloration pattern corresponding to each of the second set of rants;

wherein the instructions for displaying information about the correlated subset of the second set of data comprise instructions for generating a second map display in the user interface, the second map display displaying the at least one region, each of the at least one region having a rank defined by the second ranking scheme and a corresponding coloration pattern defined by the second coloration scheme.

21. The computer-readable storage medium of claim 20, wherein the instructions for generating a second map display comprise instructions for superimposing the second map display over the first map display.