Visualization recommendations based on measure metadata

• US 8,301,585 B2
• Filed: 12/07/2009
• Issued: 10/30/2012
• Est. Priority Date: 12/07/2009
• Status: Active Grant

• Current Assignee: Business Objects Incorporated (SAP SE)
• Original Assignee: Business Objects Incorporated (SAP SE)
• Inventors: Mourey, Nicolas, Theraud, Aurélien
• Primary Examiner(s): Hicks, Michael
• Application Number:
  US12/632,353
• Publication Number:
  US 20110137850A1
• Time in Patent Office: 1,058 Days
• Field of Search: None
• US Class Current: 707/603
• CPC Class Codes: G06Q 10/00 Administration; Management
• CPC Class Codes: G09B 29/00 Maps; Plans; Charts; Diagrams, e.g. route diagram star maps G09B27/04; devices for holding or supporting maps A47B97/02; for computing purposes G06G1/14, G09B1/16; display boards G09F

Abstract

A system includes reception of metadata associated with one or more measures, determination of a compatibility of the two or more measures based on the metadata, and determination of a first score associated with a first visualization based on the compatibility. Some aspects include determination of a second score associated with a second visualization based on the compatibility, comparison of the first score and the second score, and recommendation of one of the first visualization or the second visualization based on the comparison.

Claims

1. A method comprising:

receiving, by a computer, metadata associated with two or more measures;

determining, by the computer, a plurality of feedings based on the two or more measures, each of the plurality of feedings including a respective subset of the two or more measures;

for each one of the plurality of feedings, determining, by the computer;

(i) a compatibility of the subset of the two or more measures included in the one of the plurality of feedings, (ii) a first score associated with a first type of visualization based on the compatibility of the subset of the two or more measures included in the one of the plurality of feedings and (iii) a second score associated with a second type of visualization based on the compatibility of the subset of the two or more measures included in the one of the plurality of feedings; and

determining, by the computer, a recommendation that is based on the first score for each of the plurality of feedings and the second score for each of the plurality of feedings;

wherein the determining the first score associated with the first type of visualization based on the compatibility of the subset of the two or more measures included in the one of the plurality of feedings comprises;

identifying a first value that is associated with the first type of visualization, the determined compatibility of the subset of the two or more measures included in the one of the plurality of feedings and a total number of measures in the subset of the two or more measures included in the one of the plurality of feedings; and

determining the first score associated with the first type of visualization based on the first value; and

wherein the determining the second score associated with the second type of visualization based on the compatibility of the subset of the two or more measures included in the one of the plurality of feedings comprises;

identifying a second value that is associated with the second type of visualization, the determined compatibility of the subset of the two or more measures included in the one of the plurality of feedings and a total number of measures in the subset of the two or more measures included in the one of the plurality of feedings; and

determining the second score associated with the second type of visualization based on the second value.

2. A method according to claim 1, wherein the recommendation comprises:

one of the plurality of feedings; and

one of the first type of visualization or the type of second visualization.

3. A method according to claim 2, wherein the determining the compatibility of the subset of the two or more measures included in the one of the plurality of feedings comprises determining the compatibility of the subset of the two or more measures included in the one of the plurality of feedings based on the metadata and based on data respectively associated with each measure included in the subset of the two or more measures.

4. A method according to claim 3, wherein the determining the compatibility of the subset of the two or more measures included in the one of the plurality of feedings comprises determining the compatibility of the subset of the two or more measures included in the one of the plurality of feedings based on an aggregation type associated with each measure included in the subset of the two or more measures and based on a range of the data respectively associated with each measure included in the subset of the two or more measures.

5. A method according to claim 1, wherein the determining the compatibility of the subset of the two or more measures included in the one of the plurality of feedings comprises determining the compatibility of the subset of the two or more measures included in the one of the plurality of feedings based on the metadata and based on data respectively associated with each measure included in the subset of the two or more measures.

6. A method according to claim 5, wherein the determining the first score associated with the first type of visualization based on the first value comprises:

determining a first intermediate score associated with the first type of visualization based on the first value;

determining a positivity of each measure included in the subset of the two or more measures based on the data respectively associated with each measure included in the subset of the two or more measures;

determining a second intermediate score associated with the first type of visualization based on the positivity of each measure included in the subset of the two or more measures; and

determining the first score based on the first intermediate score and on the second intermediate score.

7. A method according to claim 5, wherein the determining the compatibility of the subset of the two or more measures included in the one of the plurality of feedings comprises determining the compatibility of the subset of the two or more measures included in the one of the plurality of feedings based on an aggregation type associated with each measure included in the subset of the two or more measures and based on a range of the data respectively associated with each measure included in the subset of the two or more measures.

8. A method according to claim 1, wherein the determining the first score associated with the first type of visualization based on the first value comprises:

determining a first intermediate score associated with the first type of visualization based on the first value;

determining a positivity of each measure included in the subset of the two or more measures based on the data respectively associated with each measure included in the subset of the two or more measures;

determining a second intermediate score associated with the first type of visualization based on the positivity of each measure included in the subset of the two or more measures; and

determining the first score based on the first intermediate score and on the second intermediate score.

9. A method according to claim 8, wherein the determining the second score associated with the second type of visualization based on the second value comprises:

determining a third intermediate score associated with the second type of visualization based on the second value;

determining a positivity of each measure included in the subset of the two or more measures based on the data respectively associated with each measure included in the subset of the two or more measures;

determining a fourth intermediate score associated with the second type of visualization based on the positivity of each measure included in the subset of the two or more measures; and

determining, a second score associated with the second visualization based on the third intermediate score and on the fourth intermediate score.

10. A method according to claim 9,

wherein the determining the compatibility of the subset of the two or more measures included in the one of the plurality of feedings comprises determining the compatibility of the subset of the two or more measures included in the one of the plurality of feedings based on an aggregation type associated with each measure included in the subset of the two or more measures and based on a range of the data respectively associated with each measure included in the subset of the two or more measures.

11. A system comprising:

a client application to transmit metadata associated with two or more measures; and

a visualization engine that includes a computer, the visualization engine to;

receive the metadata;

determine a plurality of feedings based on the two or more measures, each of the plurality of feedings including a respective subset of the two or more measures;

for each one of the plurality of feedings, determine;

(i) a compatibility of the subset of the two or more measures included in the one of the plurality of feedings, (ii) a first score associated with a first type of visualization based on the compatibility of the subset of the two or more measures included in the one of the plurality of feedings and (iii) a second score associated with a second type of visualization based on the compatibility of the subset of the two or more measures included in the one of the plurality of feedings; and

determine a recommendation that is based on the first score for each of the plurality of feedings and the second score for each of the plurality of feedings;

wherein the determine the first score associated with the first type of visualization based on the compatibility of the subset of the two or more measures included in the one of the plurality of feedings comprises;

identify a first value that is associated with the first type of visualization, the determined compatibility of the subset of the two or more measures included in the one of the plurality of feedings and a total number of measures in the subset of the two or more measures included in the one of the plurality of feedings; and

determine the first score associated with the first type of visualization based on the first value; and

wherein the determine the second score associated with the second type of visualization based on the compatibility of the subset of the two or more measures included in the one of the plurality of feedings comprises;

identify a second value that is associated with the second type of visualization, the determined compatibility of the subset of the two or more measures included in the one of the plurality of feedings and a total number of measures in the subset of the two or more measures included in the one of the plurality of feedings; and

determine the second score associated with the second type of visualization based on the second value.

12. A system according to claim 11, wherein the recommendation comprises:

one of the plurality of feedings; and

one of the first type of visualization or the type of second visualization.

13. A system according to claim 12, wherein the determine the compatibility of the subset of the two or more measures included in the one of the plurality of feedings comprises determine the compatibility of the subset of the two or more measures included in the one of the plurality of feedings based on the metadata and based on data respectively associated with each measure included in the subset of the two or more measures.

14. A system according to claim 13, wherein the determine the compatibility of the subset of the two or more measures included in the one of the plurality of feedings comprises determine the compatibility of the subset of the two or more measures included in the one of the plurality of feedings based on an aggregation type associated with each measure included in the subset of the two or more measures and based on a range of the data respectively associated with each measure included in the subset of the two or more measures.

15. A system according to claim 11, wherein the determine the compatibility of the subset of the two or more measures included in the one of the plurality of feedings comprises determine the compatibility of the subset of the two or more measures included in the one of the plurality of feedings based on the metadata and based on data respectively associated with each measure included in the subset of the two or more measures.

16. A system according to claim 15, wherein the determination of the first score associated with the first type of visualization based on the first value comprises:

determination of a first intermediate score associated with the first type of visualization based on the first value;

determination of a positivity of each measure included in the subset of the two or more measures based on the data respectively associated with each measure included in the subset of the two or more measures;

determination of a second intermediate score associated with the first type of visualization based on the positivity of each measure included in the subset of the two or more measures; and

determination of the first score based on the first intermediate score and on the second intermediate score.

17. A system according to claim 15, wherein the determination of the compatibility of the subset of the two or more measures included in the one of the plurality of feedings comprises determination of the compatibility of the subset of the two or more measures included in the one of the plurality of feedings based on an aggregation type associated with each measure included in the subset of the two or more measures and based on a range of the data respectively associated with each measure included in the subset of the two or more measures.

18. A system according to claim 11, wherein the determination of the first score associated with the first type of visualization based on the first value comprises:

determination of a first intermediate score associated with the first type of visualization based on the first value;

determination of a positivity of each measure included in the subset of the two or more measures based on the data respectively associated with each measure included in the subset of the two or more measures;

determination of a second intermediate score associated with the first type of visualization based on the positivity of each measure included in the subset of the two or more measures; and

determination of the first score based on the first intermediate score and on the second intermediate score.

19. A system according to claim 18, wherein the determination of the second score associated with the second type of visualization based on the second value comprises:

determination of a third intermediate score associated with the second type of visualization based on the second value;

determination of a positivity of each measure included in the subset of the two or more measures based on the data respectively associated with each measure included in the subset of the two or more measures;

determination of a fourth intermediate score associated with the second type of visualization based on the positivity of each measure included in the subset of the two or more measures; and

determination of a second score associated with the second visualization based on the third intermediate score and on the fourth intermediate score.

20. A system according to claim 19,

wherein the determination of the compatibility of the subset of the two or more measures included in the one of the plurality of feedings comprises determination of the compatibility of the subset of the two or more measures included in the one of the plurality of feedings based on an aggregation type associated with each measure included in the subset of the two or more measures and based on a range of the data respectively associated with each measure included in the subset of the two or more measures.

21. A non-transitory computer-readable medium having stored thereon program code, the program code executable by a computer to result in a method comprising:

receiving metadata associated with two or more measures;

determining a plurality of feedings based on the two or more measures, each of the plurality of feedings including a respective subset of the two or more measures;

for each one of the plurality of feedings, determining;

(i) a compatibility of the subset of the two or more measures included in the one of the plurality of feedings, (ii) a first score associated with a first type of visualization based on the compatibility of the subset of the two or more measures included in the one of the plurality of feedings and (iii) a second score associated with a second type of visualization based on the compatibility of the subset of the two or more measures included in the one of the plurality of feedings; and

determining a recommendation that is based on the first score for each of the plurality of feedings and the second score for each of the plurality of feedings;

wherein the determining the first score associated with the first type of visualization based on the compatibility of the subset of the two or more measures included in the one of the plurality of feedings comprises;

identifying a first value that is associated with the first type of visualization, the determined compatibility of the subset of the two or more measures included in the one of the plurality of feedings and a total number of measures in the subset of the two or more measures included in the one of the plurality of feedings; and

determining the first score associated with the first type of visualization based on the first value; and

wherein the determining the second score associated with the second type of visualization based on the compatibility of the subset of the two or more measures included in the one of the plurality of feedings comprises;

identifying a second value that is associated with the second type of visualization, the determined compatibility of the subset of the two or more measures included in the one of the plurality of feedings and a total number of measures in the subset of the two or more measures included in the one of the plurality of feedings; and

determining the second score associated with the second type of visualization based on the second value.