Visualizing and manipulating multidimensional OLAP models graphically

• US 20050283494A1
• Filed: 06/22/2004
• Published: 12/22/2005
• Est. Priority Date: 06/22/2004
• Status: Abandoned Application

• Current Assignee: International Business Machines Corporation
• Original Assignee: International Business Machines Corporation
• Inventors: Zhou, Wei, Khatchatrian, Suzanna, Tomlyn, Craig Reginald, Colossi, Nathan Gevaerd, DeKimpe, Daniel Martin
• Application Number:
  US10/874,397
• Publication Number:
  US 20050283494A1
• Time in Patent Office: Days
• US Class Current: 1/1
• CPC Class Codes: G06F 16/283 Multi-dimensional databases or data warehouses, e.g. MOLAP or ROLAP

Abstract

Various embodiments of a method, apparatus and article of manufacture for graphically visualizing and manipulating a multidimensional OLAP model are provided. Data describing a multidimensional model is retrieved. The multidimensional model comprises a plurality of groups. Each group has one or more levels. The levels have a hierarchical order. Sets comprising one or more level indicators are displayed. Each set is side-by-side to at least one other set. Each set is associated with one group of the plurality of groups. The one or more level indicators of each set are associated with the one or more levels of the associated group, respectively. The one or more level indicators of each set are displayed in accordance with the hierarchical order of their associated levels. A visual indicator associated with a subset comprising one or more level indicators of each set is displayed.

Claims

1. A computer-based method of visualizing a multidimensional model comprising:

retrieving data describing a multidimensional model comprising a plurality of groups, each group having one or more levels, the levels having a hierarchical order;

displaying a plurality of sets comprising one or more level indicators, each set being side-by-side to at least one other set, each set being associated with one group of the plurality of groups, the one or more level indicators of each set being associated with the one or more levels of the associated group, respectively, the one or more level indicators of each set being displayed in accordance with the hierarchical order of their associated levels; and

displaying a visual indicator associated with a subset comprising one or more level indicators of each set.

2. The method of claim 1 further comprising:

displaying a line connecting the level indicators of each set, the line of each set being separate.

3. The method of claim 1 further comprising:

displaying visual indicia to indicate the sets.

4. The method of claim 1 wherein the visual indicator is a region indicator.

5. The method of claim 1 wherein the subset comprises one level indicator of each set, and the visual indicator comprises one or more lines connecting the level indicators of the subset.

6. The method of claim 1 wherein the level indicators of the subset are associated with levels which are associated with an aggregation of the multidimensional model.

7. The method of claim 1 further comprising:

displaying, for each group, a list box comprising a name associated with one of the levels of that group.

8. The method of claim 1 further comprising:

prior to said displaying said visual indicator, selecting the level indicators of the subset; and

generating aggregations in accordance with the levels associated with the level indicators of the subset.

9. The method of claim 1 further comprising:

prior to said displaying said visual indicator, selecting the level indicators of the subset; and

exporting aggregations associated with the levels associated with the level indicators of the subset.

10. The method of claim 1 further comprising:

prior to said displaying said visual indicator, selecting the level indicators of the subset; and

generating a query in accordance with the levels associated with the level indicators of the subset.

11. The method of claim 1 further comprising:

receiving a query; and

determining one or more levels that are requested by the query, and the associated level indicators to provide the subset.

12. The method of claim 1 further comprising:

receiving a query; and

determining one or more levels that will be accessed by that query, and also determining the associated level indicators of the one or more levels that will be accessed by the query to provide the subset.

13. The method of claim 1 further comprising:

receiving a plurality of queries;

for each query, determining one or more levels that are accessed by that query;

in response activating a record operation, storing the queries and the levels that are accessed by the queries; and

wherein said displaying said visual indicator is performed in response to activating a playback operation, such that the queries and the levels accessed by the queries are sequentially retrieved, the level indicators associated with the levels that are accessed by the query are determined to provide the subset, and said displaying said visual indicator is performed for each query.

14. The method of claim 1 further comprising;

receiving a plurality of queries;

for each query, determining one or more regions comprising one or more levels accessed by that query and associated level indicators to provide the subset for each query;

determining an access frequency for the one or more regions; and

for each region, when the access frequency exceeds a predetermined threshold, displaying another visual indicator which indicates that the region is frequently accessed.

15. The method of claim 1 further comprising:

displaying an any-level associated with each set.

16. The method of claim 1 further comprising:

when said visual indicator is activated, determining levels associated with the level indicators of the subset, and displaying additional information regarding the levels associated with the subset.

17. The method of claim 2 wherein each line corresponds to a lateral edge of a prism to form a three-dimensional representation.

18. The method of claim 1 wherein each displayed set corresponds to a lateral edge of a prism, the subset comprises one level indicator from each set, wherein said displaying said visual indicator displays one or more lines that connect each level indicator of the subset along one or more lateral faces of the prism, respectively.

19. The method of claim 17 wherein the subset comprises a plurality of level indicators of at least one set.

20. The method of claim 17 further comprising:

rotating the three-dimensional representation.

21. An article of manufacture comprising a computer program usable medium embodying one or more instructions executable by a computer for performing a method of visualizing a multidimensional model, said method comprising:

retrieving data describing a multidimensional model comprising a plurality of groups, each group having one or more levels, the levels having a hierarchical order;

displaying a plurality of sets comprising one or more level indicators, each set being side-by-side to at least one other set, each set being associated with one group of the plurality of groups, the one or more level indicators of each set being associated with the one or more levels of the associated group, respectively, the one or more level indicators of each set being displayed in accordance with the hierarchical order of their associated levels; and

displaying a visual indicator associated with a subset comprising one or more level indicators of each set.

22. The article of manufacture of claim 21 wherein said method further comprises:

displaying a line connecting the level indicators of each set, the line of each set being separate.

23. The article of manufacture of claim 21 wherein said method further comprises:

displaying visual indicia to indicate the sets.

24. The article of manufacture of claim 21 wherein the visual indicator is a region indicator.

25. The article of manufacture of claim 21 wherein the subset comprises one level indicator of each set, and the visual indicator comprises one or more lines connecting the level indicators of the subset.

26. The article of manufacture of claim 21 wherein the level indicators of the subset are associated with levels which are associated with an aggregation of the multidimensional model.

27. The article of manufacture of claim 21 wherein said method further comprises:

displaying, for each group, a list box comprising a name associated with one of the levels of that group.

28. The article of manufacture of claim 21 wherein said method further comprises:

prior to said displaying said visual indicator, selecting the level indicators of the subset; and

generating aggregations in accordance with the levels associated with the level indicators of the subset.

29. The article of manufacture of claim 21 wherein said method further comprises:

prior to said displaying said visual indicator, selecting the level indicators of the subset; and

exporting aggregations associated with the levels associated with the level indicators of the subset.

30. The article of manufacture of claim 21 wherein said method further comprises:

prior to said displaying said visual indicator, selecting the level indicators of the subset; and

generating a query in accordance with the levels associated with the level indicators of the subset.

31. The article of manufacture of claim 21 wherein said method further comprises:

receiving a query; and

determining one or more levels that are requested by the query, and their associated level indicators to provide the level indicators of the subset.

32. The article of manufacture of claim 21 wherein said method further comprises:

receiving a query; and

determining one or more levels that will be accessed by that query, and also determining the level indicators associated with the one or more levels that will be accessed by the query to provide the level indicators of the subset,

wherein said displaying said visual indicator is performed for each query.

33. The article of manufacture of claim 21 wherein said method further comprises:

receiving a plurality of queries;

for each query, determining one or more levels accessed by that query;

in response to activating a record operation, storing the queries and the levels accessed by that query; and

wherein said displaying said visual indicator is performed in response to activating a playback operation such that the queries and the levels accessed by the queries are sequentially retrieved, the level indicators associated with the levels accessed by the query are determined to provide the level indicators of the subset for each query, and said displaying said visual indicator is performed for each query.

34. An apparatus for performing a method of visualizing a multidimensional model, comprising:

a processor; and

a memory storing one or more instructions that;

retrieve data describing a multidimensional model comprising a plurality of groups, each group having one or more levels, the levels having a hierarchical order;

display a plurality of sets comprising one or more level indicators, each set being side-by-side to at least one other set, each set being associated with one group of the plurality of groups, the one or more level indicators of each set being associated with the one or more levels of the associated group, respectively, the one or more level indicators of each set being displayed in accordance with the hierarchical order of their associated levels; and

display a visual indicator associated with a subset comprising one or more level indicators of each set.

35. The apparatus of claim 34 wherein said one or more instructions also:

display an any-level associated with each set.

36. The apparatus of claim 34 wherein said one or more instructions also:

when said visual indicator is activated, determine levels associated with the level indicators of the subset, and display additional information regarding the levels associated with the subset.

37. The apparatus of claim 34 wherein said one or more instructions also:

display a line connecting the level indicators of each set, the line of each set being separate, wherein each line corresponds to a lateral edge of a prism to provide a three-dimensional representation.

38. The apparatus of claim 34 wherein each displayed set corresponds to a lateral edge of a prism, the subset comprises one level indicator from each set, wherein said one or more instructions that display said visual indicator display one or more lines that connect each level indicator of the subset along one or more lateral faces of the prism.

39. The apparatus of claim 37 wherein the subset comprises a plurality of level indicators of at least one set.

40. The apparatus of claim 37 wherein said one or more instructions also:

rotate the three-dimensional representation.