Creating reports using dimension trees

• US 10,102,262 B2
• Filed: 08/29/2008
• Issued: 10/16/2018
• 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.
• Primary Examiner(s): Wilson, Kimberly
• Application Number:
  US12/202,087
• Publication Number:
  US 20100057756A1
• Time in Patent Office: 3,700 Days
• Field of Search: 707607, 7079991
• CPC Class Codes: G06F 16/26 Visual data mining; Browsing structured data

Abstract

A method and apparatus for creating reports using dimension trees. The method may include presenting trees of dimensions associated with one or more source databases, receiving a user selection of one of the dimension trees, and presenting a view of the selected dimension tree. The method may further include allowing a user to choose components of a report from the view of the selected dimension tree, and populating the report with data from the source databases.

Claims

1. A method comprising:

providing a pyramid model comprising a plurality of levels corresponding to a plurality of sets of dimension trees;

receiving a selection of a level of the plurality of levels;

providing, by a processing device, a plurality of dimension trees from the set of dimension trees corresponding to the selected level and that are associated with one or more databases;

receiving a selection of one of the plurality of dimension trees;

providing a plurality of views of the selected dimension tree, the plurality of views specifying different organizations of data associated with the selected dimension tree;

receiving a selection of one of the plurality of views of the selected dimension tree;

providing the selected view of the selected dimension tree;

allowing components of a report to be individually chosen from the selected view of the selected dimension tree by a placement of dimensions of the selected dimension tree on areas of the report;

generating a query in view of the components of the report that are individually chosen by the placement of the dimensions of the selected dimension tree on the areas of the report;

populating, by the processing device, the report with data returned from the one or more databases in view of the query, using the individually chosen components, wherein the report identifies the selected dimension tree;

receiving a selection of the selected dimension tree identified in the report; and

in response to the selection of the selected dimension tree identified in the report, providing additional dimension trees associated with the selected dimension tree to populate the report with additional data from a corresponding additional dimension tree.

2. The method of claim 1, further comprising:

providing one or more independent dimensions pertaining to the selected level, the independent dimensions not being a part of the selected dimension tree; and

allowing a providing of any of the independent dimensions for the components of the report.

3. The method of claim 1 wherein providing the selected view of the selected dimension tree comprises:

providing a plurality of predefined views of the selected dimension tree; and

allowing a specification of a desired view of the selected dimension tree.

4. The method of claim 1 wherein the selected dimension tree comprises one or more subtrees of dimensions and one or more individual dimensions.

5. The method of claim 4 wherein providing the selected view of the selected dimension tree comprises:

providing subtrees and individual dimensions located at the top of the dimension tree; and

allowing a view of dimensions of the subtrees and hierarchies within individual dimensions.

6. The method of claim 5 wherein allowing to choose components of a report from the selected view of the selected dimension tree comprises:

allowing a selection, for the components of the report, one or more subtrees, dimensions of the subtrees, individual dimensions, and elements within the individual dimensions.

7. The method of claim 1 wherein the placing of the dimensions of the selected dimension tree on the areas of the report corresponds to a drag-and-drop operation.

8. The method of claim 1 wherein the components of the report comprise a title, at least one parameter, at least one column name, and at least one row name.

9. A system comprising:

a memory to store a plurality of dimension trees associated with one or more databases;

a processing device, operatively coupled with the memory, to;

provide a pyramid model comprising a plurality of levels corresponding to a plurality of sets of dimension trees;

receive a selection of a level of the plurality of levels;

provide the plurality of dimension trees from the set of dimension trees corresponding to the selected level and that are associated with the one or more databases;

receive a selection of one of the plurality of dimension trees;

provide a plurality of views of the selected dimension tree, the plurality of views specifying different organizations of data associated with the selected dimension tree;

receive a selection of one of the plurality of views of the selected dimension tree;

provide the selected view of the selected dimension tree;

allow components of a report to be individually chosen from the selected view of the selected dimension tree by a placement of dimensions of the selected dimension tree on areas of the report;

generate a query in view of the components of the report that are individually chosen by the placement of the dimensions of the selected dimension tree on the areas of the report;

populate the report with data returned from the one or more databases in view of the query, using the individually chosen components, wherein the report identifies the selected dimension tree;

receive a selection of the selected dimension tree identified in the report; and

in response to the selection of the selected dimension tree identified in the report, provide additional dimension trees associated with the selected dimension tree to populate the report with additional data from a corresponding additional dimension tree.

10. The system of claim 9 wherein to provide the selected view of the selected dimension tree, the processing device is to:

provide a plurality of predefined views of the selected dimension tree; and

allow a specification of a desired view of the selected dimension tree.

11. The system of claim 9 wherein the selected dimension tree comprises one or more subtrees of dimensions and one or more individual dimensions.

12. The system of claim 11 wherein to provide the selected view of the selected dimension tree, the processing device is to:

provide subtrees and individual dimensions located at the top of the dimension tree; and

allow a view of dimensions of the subtrees and hierarchies within individual dimensions.

13. The system of claim 12 wherein to allow the choosing of components of the report from the selected view of the selected dimension tree, the processing device is to:

allow a selection, for the components of the report, one or more subtrees, dimensions of the subtrees, individual dimensions, and elements within the individual dimensions.

14. The system of claim 9 wherein the components of the report comprise a title, at least one parameter, at least one column name, and at least one row name.

15. A non-transitory computer readable storage medium comprising instructions that, when executed by a processing device, cause the processing device to:

provide a pyramid model comprising a plurality of levels corresponding to a plurality of sets of dimension trees;

receive a selection of a level of the plurality of levels;

provide a plurality of dimension trees from the set of dimension trees corresponding to the selected level and that are associated with one or more databases;

receive a selection of one of the plurality of dimension trees;

provide a plurality of views of the selected dimension tree, the plurality of views specifying different organizations of data associated with the selected dimension tree;

receive a selection of one of the plurality of views of the selected dimension tree;

provide the selected view of the selected dimension tree;

allow, by the processing device, components of a report to be individually chosen from the selected view of the selected dimension tree by a placement of dimensions of the selected dimension tree on areas of the report;

generate a query in view of the components of the report that are individually chosen by the placement of the dimensions of the selected dimension tree on the areas of the report;

populate the report with data returned from the one or more databases in view of the query, using the individually chosen components, wherein the report identifies the selected dimension tree;

receive a selection of the selected dimension tree identified in the report; and

in response to the selection of the selected dimension tree identified in the report, provide additional dimension trees associated with the selected dimension tree to populate the report with additional data from a corresponding additional dimension tree.

16. The non-transitory computer readable storage medium of claim 15 wherein to provide the selected view of the selected dimension tree, the processing device is to:

provide subtrees and individual dimensions located at the top of the dimension tree; and

allow a view of the dimensions of subtrees and hierarchies within individual dimensions.

17. The non-transitory computer readable storage medium of claim 16 wherein to allow the choosing of components of the report from the selected view of the selected dimension tree, the processing device is to:

allow a selection, for the components of the report, one or more subtrees, dimensions of the subtrees, individual dimensions, and elements within the individual dimensions.

18. The non-transitory computer readable storage medium of claim 15 wherein the components of the report comprise a title, at least one parameter, at least one column name, and at least one row name.