Apparatus and method for navigating a multi-dimensional database

• US 8,122,337 B2
• Filed: 06/26/2008
• Issued: 02/21/2012
• Est. Priority Date: 06/26/2008
• Status: Active Grant

• Current Assignee: SAP France SA (SAP SE)
• Original Assignee: SAP France SA (SAP SE)
• Inventors: MacGregor, John Malcolm, McAlpine, Ian Thomas, MacCormick, Donald Alastair
• Primary Examiner(s): Hong, Stephen
• Assistant Examiner(s): Kells, Asher
• Application Number:
  US12/147,412
• Publication Number:
  US 20090327852A1
• Time in Patent Office: 1,335 Days
• Field of Search: None
• US Class Current: 715/214
• CPC Class Codes: G06F 16/248 Presentation of query results
• CPC Class Codes: G06F 16/26 Visual data mining; Browsing structured data
• CPC Class Codes: G06F 16/283 Multi-dimensional databases or data warehouses, e.g. MOLAP or ROLAP
• CPC Class Codes: G06F 40/177 of tables; using ruled lines

Abstract

A computer readable storage medium comprises executable instructions to provide a Graphical User Interface for displaying visualizations of a multi-dimensional database. An action is received within a visualization of a table of the multi-dimensional database, the action performed by a user when selecting a cell of the table. A slice in the visualization is populated in response to the action. The visualization is filtered to drill down on dimensions associated with the cell.

Claims

1. A non-transitory computer readable storage medium, comprising executable instructions to:

provide a graphical user interface for displaying visualizations of a multi-dimensional database, the visualizations comprising a crosstab displaying at least one member of a first dimension across the crosstab and at least one member of a second dimension down the crosstab in a table of cells;

receive an action within the table;

filter the crosstab to drill down on the member of the first dimension and the member of the second dimension associated with the cell; and

display members of a third dimension across the crosstab and members of a fourth dimension down the crosstab in response to the filtering, the members of the third dimension replacing the members of first dimension and the members of the fourth dimension replacing the members of the second dimension, at least one of the plurality of members of the third dimension and the plurality of members of the fourth dimension being arranged in a pre-determined order, the pre-determined order being based on monitored usage of the corresponding dimension members to determine an order of most frequently used dimension members.

2. The computer readable storage medium of claim 1, wherein the executable instructions to receive an action within a visualization of a table comprise executable instructions to highlight a cell of the crosstab comprising a value associated with the first dimension and the second dimension.

3. The computer readable storage medium of claim 2, wherein the value associated with the first dimension and the second dimension comprises a value associated with a member of the first dimension and a member of the second dimension.

4. The computer readable storage medium of claim 1, wherein the executable instructions to receive an action within a visualization of a table comprise executable instructions to display a menu of user choices in response to the user selecting a cell of the crosstab.

5. A non-transitory computer readable storage medium, comprising executable instructions to:

provide a visualization of a multi-dimensional database, the visualization displaying a crosstab having a first dimension across the crosstab and a second dimension down the crosstab;

populate a slice in the visualization with a member of the first dimension and a member of the second dimension in response to a user selection of a cell in the crosstab; and

filter the visualization based on the member of the first dimension and the member of the second dimension to result in a plurality of members of a third dimension being displayed across the crosstab and a plurality of members being displayed down the crosstab, at least one of the plurality of members of the third dimension and the plurality of members of the fourth dimension being arranged in a pre-determined order, the pre-determined order being based on monitored usage of the corresponding dimension members to determine an order of most frequently used dimension members.

6. The computer readable storage medium of claim 5, wherein the executable instructions to populate a slice in the visualization comprise executable instructions to highlight the cell of the crosstab selected by the user, the cell comprising a value associated with a member of the first dimension and a member of the second dimension.

7. The computer readable storage medium of claim 6, wherein the executable instructions to populate a slice in the visualization comprise executable instructions to display a menu of user choices in response to the user selection.

8. The computer readable storage medium of claim 6, wherein the executable instructions to populate a slice in the visualization comprise executable instructions to populate a slice in the visualization with the member of the first dimension and the member of the second dimension.

9. A method for navigating through a multi-dimensional database, comprising:

providing a visualization of a multi-dimensional database, the visualization displaying a crosstab having a first dimension across the crosstab and a second dimension down the crosstab;

receiving user-generated input via a graphical user interface selecting a member of the first dimension and a member of the second dimension, the member of the first dimension and the member of the second dimension represented in a cell of the crosstab selected by a user;

updating the crosstab to display drilled down dimensions associated with the member of the first dimension and the member of the second dimension, the updating comprising;

receiving a selection of a third dimension and a fourth dimension by the user, the third and fourth dimensions having values associated with the member of the first dimension and the member of the second dimension;

displaying a plurality of members of the third dimension across the crosstab; and

displaying a plurality of members of the fourth dimension down the crosstab;

wherein at least one of the plurality of members of the third dimension and the plurality of members of the fourth dimension being arranged in a pre-determined order, the pre-determined order being based on monitored usage of the corresponding dimension members to determine an order of most frequently used dimension members.

10. The method of claim 9, further comprising populating a slice in the visualization to display the member of the first dimension and the member of the second dimension.

11. The method of claim 9, further comprising highlighting the cell of the crosstab selected by the user and displaying a menu of user choices in response to the user selection.