Comparative analysis of business intelligence data

• US 7,747,564 B2
• Filed: 06/22/2006
• Issued: 06/29/2010
• Est. Priority Date: 06/22/2006
• Status: Active Grant

• Current Assignee: X Corp. (f/k/a Twitter, Inc.) (X Holdings Corp.)
• Original Assignee: International Business Machines Corporation
• Inventors: Liekucs, Andrew, Westman, Randy, Winter, Stewart, Reid, Murray, MacCulloch, Todd
• Primary Examiner(s): Alam; Shahid A
• Assistant Examiner(s): NGUYEN, PHONG H
• Application Number:
  US11/473,388
• Publication Number:
  US 20070299860A1
• Time in Patent Office: 1,468 Days
• Field of Search: 707/3, 707/7, 707/102, 707/999.003, 707/999.007, 707/999.102, 705/36.R, 715/209, 715/249, 715/853
• US Class Current: 707/603
• CPC Class Codes: G06Q 30/00 Commerce
• CPC Class Codes: G06Q 40/06 Asset management; Financial planning or analysis

Abstract

A definition manager independently defines a plurality of dimensional members of a data source. An operation manager receives user input selecting a set of dimensional members of interest and at least one operator to manipulate the selected set of members based on the selected at least one operator. The set of dimensional members of interest comprise a first dimensional member of interest having a given dimension and a given level in a hierarchy of the given dimension and a second dimensional member of interest having a different dimension from the given dimension or a different level in the hierarchy from the given level in the hierarchy. A display manager places the manipulated set of dimensional members in a report so that the manipulated set of dimensional members are displayed adjacently based on the operator to facilitate comparative analysis.

Claims

1. A method of providing comparative analysis of business intelligence data represented by a multi-dimensional model, the method comprising:

independently defining, by a definition manager in a comparative analysis system, a plurality of dimensional members of a data source;

receiving, by an operation manager in the comparative analysis system, user input selecting a set of dimensional members of interest and at least one operator to manipulate the selected set of members based on the selected at least one operator, wherein the set of dimensional members of interest comprise a first dimensional member of interest having a given dimension and a given level in a hierarchy of the given dimension and a second dimensional member of interest having a different dimension from the given dimension or a different level in the hierarchy from the given level in the hierarchy;

applying, by the operation manager, the at least one operator to the selected set of dimensional members of interest to form a manipulated set of dimensional members of interest; and

placing, by a display manager in the comparative analysis system, the manipulated set of dimensional members in a report so that the manipulated set of dimensional members are displayed adjacently based on the operator to facilitate comparative analysis,

wherein defining a plurality of dimensional members of a data source comprises translating a multi-dimensional model defining a report layout as a binary operator tree into a layout oriented object model that defines the report layout in a positional operator tree.

2. The method of claim 1,

wherein the at least one operator comprises a union operator, a cross-product operator, or a dot-product operator;

wherein applying the at least one operator to the selected set of dimensional members of interest comprises combining, by the operation manager, the selected set of dimensional members using the union operator, cross-product operator, or dot-product operator to form the manipulated set of dimensional members.

3. The method of claim 1,

wherein the selected set of dimensional members of interest comprise at least one measure.

4. The method of claim 1, wherein placing the manipulated set of dimensional members in a report comprises placing the manipulated set of dimensional members in a cross-tab in an asymmetrical axis configuration based on the selected set of dimensional members and the selected at least one operator.

5. The method of claim 1, wherein translating a multi-dimensional model comprises:

providing layout features common to different report types to build a result layout based on the selected at least one operator; and

providing layout features specific to at least one specific report type.

6. The method of claim 5, wherein providing layout features common to different report types comprises:

analyzing nodes of the multi-dimensional model;

creating as insertion points a list of candidate nodes under which a nest operation is performed; and

nesting nodes in the insertion points.

7. The method of claim 1, wherein translating the multi-dimensional model further comprises:

managing a pointer to a result layout object for a query in the layout oriented object model depending on a report type of the query; and

encoding the selected at least one operator in the layout oriented object model.

8. The method of claim 1, further comprising:

responsive to a hierarchize property for a selection set containing one or more of the selected set of dimensional members of interest being enabled, balancing, by a hierarchy manager in the comparative analysis system, displayed members in the report.

9. The method of claim 8, further comprising automatically adding a hierarchical display layout for visually representing levels of the displayed members.

10. The method of claim 8, further comprising automatically adding one or more ancestor members of the selected set of dimensional members of interest to the report.

11. The method of claim 10, wherein adding one or more ancestor members comprises adding a first common ancestor of the selected set of dimensional members of interest.

12. The method of claim 8, further comprising receiving user input to enable or disable the hierarchize property for one or more of the selected set of dimensional members of interest.

13. A computer program product comprising a computer recordable medium having a computer readable program recorded thereon, wherein the computer readable program, when executed on a computing device, causes the computing device to:

independently define, by a definition manager in a comparative analysis system, a plurality of dimensional members of a data source;

receive, by an operation manager in the comparative analysis system, user input selecting a set of dimensional members of interest and at least one operator to manipulate the selected set of members based on the selected at least one operator, wherein the set of dimensional members of interest comprise a first dimensional member of interest having a given dimension and a given level in a hierarchy of the given dimension and a second dimensional member of interest having a different dimension from the given dimension or a different level in the hierarchy from the given level in the hierarchy;

apply, by the operation manager, the at least one operator to the selected set of dimensional members of interest to form a manipulated set of dimensional members of interest; and

place, by a display manager in the comparative analysis system, the manipulated set of dimensional members in a report so that the manipulated set of dimensional members are displayed adjacently based on the operator to facilitate comparative analysis,

wherein defining a plurality of dimensional members of a data source comprises translating a multi-dimensional model defining a report layout as a binary operator tree into a layout oriented object model that defines the report layout in a positional operator tree.

14. The computer program product of claim 13, wherein the computer readable program further causes the computing device to:

responsive to a hierarchize property for a selection set containing one or more of the selected set of dimensional members of interest being enabled, balance, by a hierarchy manager in the comparative analysis system, displayed members in the report.

15. The computer program product of claim 14, wherein the computer readable program further causes the computing device to:

automatically add one or more ancestor members of the selected set of dimensional members of interest to the report.

16. A comparative analysis system, comprising:

a processor; and

a memory coupled to the processor, wherein the memory comprises instructions which, when executed by the processor, cause the processor to;

independently define, by a definition manager, a plurality of dimensional members of a data source;

receive, by an operation manager, user input selecting a set of dimensional members of interest and at least one operator to manipulate the selected set of members based on the selected at least one operator, wherein the set of dimensional members of interest comprise a first dimensional member of interest having a given dimension and a given level in a hierarchy of the given dimension and a second dimensional member of interest having a different dimension from the given dimension or a different level in the hierarchy from the given level in the hierarchy;

apply, by the operation manager, the at least one operator to the selected set of dimensional members of interest to form a manipulated set of dimensional members of interest; and

place, by a display manager, the manipulated set of dimensional members in a report so that the manipulated set of dimensional members are displayed adjacently based on the operator to facilitate comparative analysis,

wherein defining a plurality of dimensional members of a data source comprises translating a multi-dimensional model defining a report layout as a binary operator tree into a layout oriented object model that defines the report layout in a positional operator tree.

17. The comparative analysis system of claim 16, wherein the instructions further cause the processor to:

responsive to a hierarchize property for a selection set containing one or more of the selected set of dimensional members of interest being enabled, balance, by a hierarchy manager, displayed members in the report.

18. The comparative analysis system of claim 17, wherein the instructions further cause the processor to:

automatically add one or more ancestor members of the selected set of dimensional members of interest to the report.