ANALYZING DATA WITHIN A DATA REPORT

• US 20110153643A1
• Filed: 12/22/2009
• Published: 06/23/2011
• Est. Priority Date: 12/22/2009
• Status: Active Grant

• Current Assignee: SAP SE
• Original Assignee: SAP SE
• Inventors: HAGGIE, THOMAS
• Granted Patent: US 8,819,041 B2
• Time in Patent Office: Days
• US Class Current: 707/769
• CPC Class Codes: G06Q 10/06 Resources, workflows, human or project management; Enterprise or organisation planning; Enterprise or organisation modelling

Abstract

Described are methods and systems related to analyzing data within a data report. The data report, including a result set and metadata associated with the result set is retrieved. The result set is analyzed to identify one or more fields. Dimensions and measures within the result set are inferred. Based upon the inferred dimensions and measures, a user interface element is rendered on a user interface. The user interface element is utilized to define a query. Based upon the query defined in the user interface element, a measure included in the query is aggregated along a dimension included in the query, to create a collection of aggregations. A visual representation of the collection of the aggregations is rendered on the user interface.

Claims

1. An article of manufacture, comprising a computer-readable medium comprising computer readable instructions which when executed by a computer, cause the computer to perform a method for analyzing data within a data report, the method comprising:

retrieving a data report including a result set and associated metadata of the result set;

analyzing the result set to identify one or more fields present in the result set;

inferring a set of dimensions and measures within the result set;

based upon the set of dimensions and measures, rendering one or more user interface elements for defining a query, wherein each of the one or more user interface elements is associated with a member of the set of dimensions and measures inferred from the result set;

receiving a selection of one or more specific user interface elements for inclusion in the query;

aggregating a measure along a dimension included in the query, to create a collection of aggregations; and

rendering a visual representation of the collection of the aggregations.

2. The article of manufacture of claim 1, wherein inferring the set of dimensions and measures comprises inferring zero or more dimensions for each of the identified fields.

3. The article of manufacture of claim 1, wherein inferring the set of dimensions and measures comprises inferring one or more measures for each of the identified fields.

4. The article of manufacture of claim 1, wherein the user interface element is operable to accept a user selection of the query.

5. The article of manufacture of claim 1, wherein aggregating the measure along the dimension comprises performing an aggregation function along the dimension.

6. The article of manufacture of claim 1, wherein aggregating the measure along the dimension comprises performing an aggregation function along all the dimensions inferred from the result.

7. The article of manufacture of claim 1, wherein inferring the set of dimensions and measures within the result set, further comprises:

identifying a first field as numeric and non-discrete; and

adding the first field to the measures in the set of dimensions and measures.

8. The article of manufacture of claim 1, wherein inferring the set of dimensions and measures within the result set, further comprises:

identifying a second field within the result set as non-numeric;

adding the second field to the dimensions in the set of dimensions and measures; and

adding a count of the second field to the measures in the set of dimensions and measures.

9. The article of manufacture of claim 1, wherein inferring the set of dimensions and measures within the result set, further comprises:

identifying a third field within the result set as numeric and discrete;

adding the third field to the dimensions in the set of dimensions and measures; and

adding the third field to the measures and a count of the third field to the measures in the set of dimensions and measures.

10. The article of manufacture of claim 1, further comprising:

identifying a modification in the query; and

performing corresponding modification to the visual representation of the collection of the aggregation.

11. The article of manufacture of claim 10, further comprising re-aggregating to create an updated collection of the aggregation in accordance with the modification in the query.

12. The article of manufacture of claim 1, wherein inferring the set of dimensions and measures within the result set, further comprises:

identifying a fourth field within the result set as a dimension;

identifying the fourth field as containing unique values for the result set; and

excluding the fourth field from the set of measures and dimensions.

13. The article of manufacture of claim 1, further comprising:

providing a selection for determining a type of the visual representation of the collection of aggregations.

14. The article of manufacture of claim 1, further comprising:

providing a selection for determining a manner of rendering the collection of aggregations.

15. The article of manufacture of claim 14, further comprising:

performing one or more iterations of the result set in the data report, based upon the determined manner of rendering the collection of aggregations.

16. A computer implemented method for analyzing data within a data report, the method comprising:

retrieving a data report including a result set and associated metadata of the result set;

analyzing the result set to identify one or more fields present in the result set;

inferring a set of dimensions and measures within the result set;

based upon the set of dimensions and measures, rendering one or more user interface elements for defining a query, wherein each of the one or more user interface elements is associated with a member of the set of dimensions and measures inferred from the result set;

receiving a selection of one or more specific user interface elements for inclusion in the query;

aggregating a measure along a dimension included in the query, to create a collection of aggregations; and

rendering a visual representation of the collection of the aggregations.

17. The computer implemented method of claim 16, further comprising:

receiving a selection of one or more specific user interface elements for inclusion in the query.

18. A computing device operable for analyzing data within a data report comprising:

a processor operable for reading and executing instructions stored in one or more memory elements; and

the one or more memory elements storing instructions for;

a data report repository to store one or more data reports including a result set and associated metadata of the result set;

a report analyzer to analyze a result set of a selected data report to infer one or more dimensions and one or more measures for the result set;

the memory to store the inferred dimensions and measures;

the user interface module to render;

a first user interface element on the user interface, based upon a dimension from the inferred dimensions, the first user interface element operable for defining a query, and

a second user interface element on the user interface, based upon a measure from the inferred measures, the second user interface element operable for defining the query;

an aggregation engine to aggregate the measure along the dimension to create a collection of aggregations; and

a visualization engine to render a visual representation of the collection of aggregations on the user interface.

19. The computing device of claim 18 wherein the user interface module is configured to:

receive a user selection for the selected data report; and

receive a selection of first user interface element and the second user interface element for inclusion in the query.

20. The computing device of claim 18, further comprising an accumulator for accumulating one or more measures for values in a dimension having a similar value, wherein the dimension is associated with the query.