Graphical user interface for relational database

• US 6,748,394 B2
• Filed: 04/27/2001
• Issued: 06/08/2004
• Est. Priority Date: 04/27/2000
• Status: Active Grant

• Current Assignee: Oracle International Corporation (Oracle Corporation)
• Original Assignee: Hyperion Solutions Corporation (Oracle Corporation)
• Inventors: Novy, Robert F., Shah, Arun, Ertl, Robert A.
• Primary Examiner(s): Mizrahi, Diane D.
• Application Number:
  US09/844,680
• Publication Number:
  US 20020035565A1
• Time in Patent Office: 1,138 Days
• Field of Search: 707/1, 707/2, 707/3, 707/100, 707/103.R, 707/103, 707/103.Y, 707/103.2, 707/104.1
• US Class Current: 707/718
• CPC Class Codes: G06F 16/2428 Query predicate definition using graphical user interfaces, including menus and forms G06F16/2423 takes precedence
• CPC Class Codes: G06F 16/283 Multi-dimensional databases or data warehouses, e.g. MOLAP or ROLAP
• CPC Class Codes: G06F 21/6218 to a system of files or objects, e.g. local or distributed file system or database
• CPC Class Codes: G06F 21/6227 where protection concerns the structure of data, e.g. records, types, queries
• CPC Class Codes: Y10S 707/956 Hierarchical
• CPC Class Codes: Y10S 707/99943 Generating database or data structure, e.g. via user interface
• CPC Class Codes: Y10S 707/99945 Object-oriented database structure processing

Abstract

Disclosed is a system, method, and apparatus for calculating metrics by using hierarchical level metadata to describe the various structures within the database. The hierarchical level metadata permit calculation of complex metrics by an analytical server which would otherwise be difficult or impossible. As a result of the way that the analytical server calculates the metrics, slicing and drilling are supported. Additionally, dimension and fact level security are also supported.

Claims

1. A graphical user interface for displaying metrics, said graphical user interface comprising:

a hierarchical listing of a plurality of dimensions for selection of one or more constraints for the plurality of dimensions; and

a metric selector for selection of a metric;

wherein after the selection of the one or more constraints and the metric, the graphical user interface submits a query requesting calculations of the metric based on the one or more selected constraints.

2. The graphical user interface of claim 1, further comprising a results page for graphically displaying calculations of the metric.

3. The graphical user interface of claim 2, wherein the results page further comprises a plurality of columns, wherein each of the plurality of columns is associated with a particular metric.

4. The graphical user interface of claim 3, wherein the results page further comprises a plurality of rows, wherein each of the plurality of rows is associated with values associated with one or more slices of one or more of the plurality of dimensions.

5. The graphical user interface of claim 4, wherein each of the plurality of columns comprises a graph displaying the calculated metric for the one or more constraint and a corresponding one of the values.

6. The graphical user interface of claim 5, wherein the results page further comprises one or more graphic bars corresponding to one or more metrics, a height of the one or more graphic bars corresponding to the calculated metrics.

7. The graphical user interface of claim 6, wherein the metrics are selected from the group consisting of profits, costs, sales made, and sales forecast.

8. The graphical user interface of claim 1 and further comprising a user-selectable button for transmitting the query.

9. The graphical user interface of claim 1 and further comprising at least a second metric selector for selection of at least a second metric.

10. A computer system for providing metrics, said computer system comprising:

an application programming interface for generating a graphical user interface for displaying metrics, said graphical user interface comprising;

a hierarchical listing of a plurality of dimensions for selection of one or more constraints for the plurality of dimensions; and

a metric selector for selection of a metric;

wherein after the selection of the one or more constraints and the metric, the graphical user interface submits a query requesting calculations of the metric based on the one or more selected constraints.

11. The computer system of claim 10, further comprising a client computer for displaying the graphical user interface.

12. The computer system of claim 10, further comprising an analytical server for calculating the metric.

13. The computer system of claim 10, and further comprising a user-selectable button for transmitting the query.

14. The computer system of claim 10, and further comprising at least a second metric selector for selection of at least a second metric.

15. The computer system of claims wherein the graphical user interface further comprises a results page for graphically displaying calculations of the metric.

16. The computer system of claim 15, wherein the results page further comprises a plurality of rows, wherein each of the plurality of rows is associated with values associated with one or more slices of one or more of the plurality of dimensions.

17. The computer system of claim 16, wherein the graphical user interface further comprises a plurality of columns associated with one or more metrics, each of the plurality of columns comprising a graph displaying the calculated metric for the one or more constraints and a corresponding one of the values.

18. The computer system of claim 17, wherein the results page further comprises one or more graphic bars corresponding to one or more metrics, a height of the one or more graphic bars corresponding to the calculated metrics.

19. The computer system of claim 18, wherein the metrics are selected from the group consisting of profits, costs, sales made, and sales forecast.