BUILDING CUSTOM DIMENSION TREES

• US 20100057764A1
• Filed: 08/29/2008
• Published: 03/04/2010
• Est. Priority Date: 08/29/2008
• Status: Active Grant

• Current Assignee: Red Hat, Inc. (International Business Machines Corporation)
• Original Assignee: Red Hat, Inc. (International Business Machines Corporation)
• Inventors: Williamson, Eric J.
• Granted Patent: US 8,150,879 B2
• Time in Patent Office: Days
• US Class Current: N/A
• CPC Class Codes: G06F 16/242 Query formulation
• CPC Class Codes: G06F 16/283 Multi-dimensional databases or data warehouses, e.g. MOLAP or ROLAP

Abstract

A method and apparatus for creating custom dimension trees. The method may include receiving a user request to create a custom dimension tree, displaying a list of available dimensions, and receiving user selection of available dimensions from the list. The method may further include allowing the user to create virtual dimensions, mapping elements of the available dimensions to the virtual dimensions, and creating the custom dimension tree using the mapping. The custom dimension tree represents relationships between the virtual dimensions.

Claims

1. A computer-implemented method comprising:

receiving a request of a first user to create a custom dimension tree;

displaying a list of available dimensions;

receiving user selection of available dimensions from the list;

allowing the first user to create virtual dimensions;

mapping elements of the available dimensions to the virtual dimensions; and

creating the custom dimension tree using the mapping, the custom dimension tree representing relationships between the virtual dimensions.

2. The method of claim 1 wherein:

the user request identifies a level of a reporting pyramid; and

the displayed list of available dimensions includes dimensions inside dimension trees associated with the identified level of the reporting pyramid, and individual dimensions associated with the identified level of the reporting pyramid.

3. The method of claim 1 wherein:

the user request identifies an existing dimension tree; and

the displayed list of available dimensions includes dimensions inside the existing dimension tree.

4. The method of claim 1 wherein allowing the first user to create virtual dimensions comprises:

receiving user input specifying names of virtual dimensions; and

storing names of the virtual dimensions in a virtual dimension table.

5. The method of claim 4 wherein mapping elements of the available dimensions to the virtual dimensions comprises:

receiving user input specifying one or more element criteria for each of the virtual dimensions; and

for each of the virtual dimensions, finding elements of the available dimensions that satisfy a corresponding element criteria, and mapping the found elements to a relevant virtual dimension in the virtual dimension table.

6. The method of claim 4 wherein mapping elements of the available dimensions to the virtual dimensions comprises:

for each virtual dimension, receiving user input specifying which elements of the available dimensions are to be associated with a relevant virtual dimension; and

storing associations between the elements and the virtual dimensions based on the user input.

7. The method of claim 4 wherein creating the custom dimension tree comprises:

storing a name of the custom dimension tree with the names of the virtual dimensions in the virtual dimension table.

8. The method of claim 1 wherein the custom dimension tree is available only to the first user.

9. The method of claim 1 wherein the custom dimension tree is available to the first user and to one or more other users authorized by the first user.

10. The method of claim 1 further comprising:

building a report based on the custom dimension tree.

11. A system comprising:

a custom tree builder to receive a request of a first user to create a custom dimension tree, to display a list of available dimensions, to receive user selection of available dimensions from the list, to allow the first user to create virtual dimensions, and to map elements of the available dimensions to the virtual dimensions; and

a custom tree database, coupled to the custom tree builder, to store the custom dimension tree with mappings between the elements and the virtual dimensions, the custom dimension tree representing relationships between the virtual dimensions.

12. The system of claim 11 wherein:

the user request identifies a level of a reporting pyramid, and

the displayed list of available dimensions includes dimensions inside dimension trees associated with the identified level of the reporting pyramid, and individual dimensions associated with the identified level of the reporting pyramid.

13. The system of claim 11 wherein:

the user request identifies an existing dimension tree; and

the displayed list of available dimensions includes dimensions inside the existing dimension tree.

14. The system of claim 11 wherein the custom tree builder is to map elements of the available dimensions to the virtual dimensions by:

receiving user input specifying one or more element criteria for each of the virtual dimensions; and

for each of the virtual dimensions, finding elements of the available dimensions that satisfy a corresponding element criteria, and mapping the found elements to a relevant virtual dimension in the virtual dimension table.

15. The system of claim 11 wherein the custom tree builder is to map elements of the available dimensions to the virtual dimensions by:

for each virtual dimension, receiving user input specifying which elements of the available dimensions are to be associated with a relevant virtual dimension; and

storing associations between the elements and the virtual dimensions based on the user input.

16. The system of claim 11 further comprising a shared custom tree coordinator, coupled to the custom tree database, to make the custom dimension tree available to the first user and to one or more other users authorized by the first user.

17. The system of claim 11 further comprising a report builder, coupled to the custom tree database, to build a report based on the custom dimension tree.

18. A computer readable storage medium including instructions that, when executed by a processing system, cause the processing system to perform a method comprising:

receiving a request of a first user to create a custom dimension tree;

displaying a list of available dimensions;

receiving user selection of available dimensions from the list;

allowing the first user to create virtual dimensions;

mapping elements of the available dimensions to the virtual dimensions; and

creating the custom dimension tree using the mapping, the custom dimension tree representing relationships between the virtual dimensions.

19. The computer readable storage medium of claim 18 wherein:

the user request identifies a level of a reporting pyramid; and

the displayed list of available dimensions includes dimensions inside dimension trees associated with the identified level of the reporting pyramid, and individual dimensions associated with the identified level of the reporting pyramid.

20. The computer readable storage medium of claim 18 wherein mapping elements of the available dimensions to the virtual dimensions comprises:

receiving user input specifying one or more element criteria for each of the virtual dimensions; and

for each of the virtual dimensions, finding elements of the available dimensions that satisfy a corresponding element criteria, and mapping the found elements to a relevant virtual dimension in the virtual dimension table.