INTERACTIVE CHART AUTHORING THROUGH CHART MERGING

• US 20160188185A1
• Filed: 12/30/2014
• Published: 06/30/2016
• Est. Priority Date: 12/30/2014
• Status: Active Grant

• Current Assignee: SAP SE
• Original Assignee: Geraldine Bous
• Inventors: Bous, Geraldine
• Granted Patent: US 9,576,383 B2
• Time in Patent Office: Days
• US Class Current: 1/1
• CPC Class Codes: G06F 40/18 of spreadsheets form-filling G06F40/174
• CPC Class Codes: G06Q 10/10 Office automation; Time management
• CPC Class Codes: G06T 11/206 Drawing of charts or graphs

Abstract

A first chart and a second chart are parsed to determine one or more measures, dimensions, and filters visualized in the first chart and the second chart. The number of measures, dimensions, and filters visualized in the first chart and the second chart are calculated. It is determined how many of the number of measures, dimensions, and filters visualized in the first chart and the second chart are the same. One or more merge rules corresponding to the number of measures, dimensions, and filters visualized in the first chart and to the number of measures, dimensions, and filters visualized in the second chart that aren'"'"'t the same as measures, dimensions, and filters visualized in the first chart are obtained, and one or more merge permutations are derived based on the obtained merge rules. The first chart and the second chart are merged in accordance with one of the merge permutations.

Claims

1. A method comprising:

receiving a selection of a first chart and a second chart;

parsing the first chart to determine any measures, dimensions, or filters visualized in the first chart;

calculating a number of measures, a number of dimensions, and a number of filters visualized in the first chart;

parsing the second chart to determine any measures, dimensions, or filters visualized in the second chart;

calculating a number of measures, a number of dimensions, and a number of filters visualized in the second chart;

determining how many of the measures, dimensions or filters visualized in the second chart are the same as measures, dimensions or filters visualized in the first chart;

obtaining one or more merge rules corresponding to the number of measures, the number of dimensions, and the number filters visualized in the first chart and to the number of measures, the number of dimensions, and the number filters visualized in the second chart that aren'"'"'t the same as measures, dimensions or filters visualized in the first chart;

deriving one or more merge permutations based on the obtained one or more merge rules; and

merging the first chart and the second chart in accordance with one of the one or more merge permutations.

2. The method of claim 1, further comprising:

presenting the one or more merge permutations to a user for selection;

receiving a selection of one of the one or more merge permutations from the user; and

the merging comprises merging the first chart and the second chart in accordance with the selected permutation.

3. The method of claim 1, wherein the receiving a selection includes receiving a drag-and-drop navigation command where the first chart is dragged and dropped onto the second chart in a graphical user interface.

4. The method of claim 1, further comprising:

determining if any of the dimensions visualized in the first chart are hierarchical dimensions by virtue of being part of a hierarchy with any hierarchical dimensions visualized in the second chart; and

in response to a determination that at least one dimension visualized in the first chart is part of a hierarchy with at least one of the dimensions visualized in the second chart, executing one of the obtained one or more merge rules to merge the one or more hierarchical dimensions visualized in the first chart with the one or more hierarchical dimensions visualized in the second chart using a split-by operation.

5. The method of claim 2, further comprising:

ranking the one or more merge permutations based on relevance to the user; and

wherein the presenting includes presenting the one or more merge permutations based upon the ranking to the user for selection.

6. The method of claim 5, wherein the ranking uses a machine learning algorithm to determine relevance to the user.

7. The method of claim 6, wherein the machine learning algorithm uses past user activity as an input.

8. A system comprising:

a chart engine comprising one or more processors and configured to obtain data from one or more databases and create one or more charts based on the data;

a user interface component comprising one or more processors and configured to receive input from a user as to a selection of a first chart and a second chart to merge; and

a merge engine comprising;

a chart merging rules database including one or more merge rules;

an input chart parser comprising one or more processors and configured to parse the first chart to determine one or more measures, dimensions, and filters visualized in the first chart and parse the second chart to determine one or more measures, dimensions, and filters visualized in the second chart;

a chart merging engine comprising one or more processors and configured to;

calculate a number of measures, a number of dimensions, and a number of filters visualized in the first chart;

calculate a number of measures, a number of dimensions, and a number of filters visualized in the second chart;

determine how many of the measures, dimensions or filters visualized in the second chart are the same as measures, dimensions or filters visualized in the first chart;

obtain one or more merge rules corresponding to the number of measures, the number of dimensions, and the number filters visualized in the first chart and to the number of measures, the number of dimensions, and the number filters visualized in the second chart that aren'"'"'t the same as measures, dimensions or filters visualized in the first chart;

derive one or more merge permutations based on the obtained one or more merge rules; and

merge the first chart and the second chart in accordance with one of the one or more merge permutations.

9. The system of claim 8, wherein the chart merging engine further comprises a chart permutation ranking component comprising one or more processors and configured to rank the one or more merge permutations based on relevance to the user.

10. The system of claim 9, wherein the user interface component is further configured to:

present the one or more merge permutations based upon the ranking to the user for selection; and

receive a selection of one of the one or more merge permutations from the user; and

wherein the merging comprises merging the first chart and the second chart in accordance with the selected permutation.

11. The system of claim 10, wherein the receiving a selection includes receiving a drag-and-drop navigation command where the first chart is dragged and dropped onto the second chart in a graphical user interface.

12. The system of claim 9, wherein the ranking uses a machine learning algorithm to determine relevance to the user.

13. The system of claim 8, further comprising a merged chart database and wherein the chart merging engine is further configured to save the merged chart in the merged chart database for later selection by the user to be merged with another chart.

14. A non-transitory computer-readable medium storing executable instructions thereon, which, when executed by a processor, causes the processor to perform operations comprising:

receiving a selection of a first chart and a second chart;

parsing the first chart to determine any measures, dimensions, or filters visualized in the first chart;

calculating a number of measures, a number of dimensions, and a number of filters visualized in the first chart;

parsing the second chart to determine any measures, dimensions, or filters visualized in the second chart;

calculating a number of measures, a number of dimensions, and a number of filters visualized in the second chart;

determining how many of the measures, dimensions or filters visualized in the second chart are the same as measures, dimensions or filters visualized in the first chart;

obtaining one or more merge rules corresponding to the number of measures, the number of dimensions, and the number filters visualized in the first chart and to the number of measures, the number of dimensions, and the number filters visualized in the second chart that aren'"'"'t the same as measures, dimensions or filters visualized in the first chart;

deriving one or more merge permutations based on the obtained one or more merge rules; and

merging the first chart and the second chart in accordance with one of the one or more merge permutations.

15. The non-transitory computer-readable medium of claim 14, wherein the operations further comprise:

presenting the one or more merge permutations to a user for selection;

receiving a selection of one of the one or more merge permutations from the user; and

the merging comprises merging the first chart and the second chart in accordance with the selected permutation.

16. The non-transitory computer-readable medium of claim 14, wherein the receiving a selection includes receiving a drag-and-drop navigation command where the first chart is dragged and dropped onto the second chart in a graphical user interface.

17. The non-transitory computer-readable medium of claim 14, wherein the operations further comprise:

determining if any of the dimensions visualized in the first chart are hierarchical dimensions by virtue of being part of a hierarchy with any hierarchical dimensions visualized in the second chart; and

in response to a determination that at least one dimension visualized in the first chart is part of a hierarchy with at least one of the dimensions visualized in the second chart, executing one of the obtained one or more merge rules to merge the one or more hierarchical dimensions visualized in the first chart with the one or more hierarchical dimensions visualized in the second chart using a split-by operation.

18. The non-transitory computer-readable medium of claim 15, wherein the operations further comprise:

ranking the one or more merge permutations based on relevance to the user; and

wherein the presenting includes presenting the one or more merge permutations based upon the ranking to the user for selection.

19. The non-transitory computer-readable medium of claim 18, wherein the ranking uses a machine learning algorithm to determine relevance to the user.

20. The non-transitory computer-readable medium of claim 19, wherein the machine learning algorithm uses past user activity as an input.