Add and combine reports

• US 8,839,144 B2
• Filed: 12/29/2010
• Issued: 09/16/2014
• Est. Priority Date: 12/29/2010
• Status: Active Grant

• Current Assignee: SAP SE
• Original Assignee: SAP AG (SAP SE)
• Inventors: Kraus, Stefan, El Idrissi-Lamghari, Tahar, Tillert, Peter, Baeck, Christian, Kazmaier, Gerrit Simon
• Primary Examiner(s): SAX, STEVEN PAUL
• Application Number:
  US12/980,585
• Publication Number:
  US 20120174013A1
• Time in Patent Office: 1,357 Days
• Field of Search: 715771-773, 715/765, 715/769, 715/802, 715/804, 715/805, 715/834, 715821-823, 705/4
• US Class Current: 715/804
• CPC Class Codes: G06F 3/0481 based on specific properties of the displayed interaction object or a metaphor-based environment, e.g. interaction with desktop elements like windows or icons, or assisted by a cursor's changing behaviour or appearance
• CPC Class Codes: G06Q 10/063 Operations research, analysis or management
• CPC Class Codes: G06Q 10/0631 Resource planning, allocation, distributing or scheduling for enterprises or organisations

Abstract

A system may include reception of a selection of a first report, the first report based on a first data source defining a first plurality of fields and defining a first at least one key figure, the first report including at least one of the first at least one key figures and at least one of the first plurality of fields, presentation of a first graphical representation of the first data source, the first graphical representation comprising a first graphical icon representing the first at least one key figure, and at least one second graphical icon, each of the at least one second graphical icons representing a respective one of the at least one of the first plurality of fields of the first report, reception of a selection of a second report, the second report based on a second data source defining a second plurality of fields and defining a second at least one key figure, the second report including at least one of the second at least one key figures and at least one of the second plurality of fields, presentation of a second graphical representation of the second data source, the second graphical representation graphically linked to the first graphical representation and comprising a third graphical icon representing the second at least one key figure and a plurality of fourth graphical icons, each of the plurality of fourth graphical icons representing a respective one of the second plurality of fields, reception of a selection of one of the plurality of fourth graphical icons representing one of the second plurality of fields, and generation of a third report comprising the at least one of the first plurality of fields and the one of the second plurality of fields.

Claims

1. A method implemented by a computing system in response to execution of program code by a processor of the computing system, comprising:

receiving a selection of a first graphical report, the first graphical report depicting data of a first data structure defined by first metadata, the first metadata defining a first plurality of fields and defining a first key figure, and the first graphical report including the first key figure and a plurality of the first plurality of fields, wherein the first graphical report is one of a spreadsheet or a graphical chart;

presenting a first graphical representation of the first data structure, the first graphical representation comprising a first graphical icon representing the first key figure, and a plurality of second graphical icons, each of the plurality of second graphical icons representing a respective one of the plurality of the first plurality of fields of the first graphical report, and each of the plurality of second graphical icons graphically linked to the first graphical icon;

receiving a selection of one of the second graphical icons representing a field of the first graphical report;

receiving a selection of a second graphical report, the second graphical report depicting data of a second data structure defined by second metadata, the second metadata defining a second plurality of fields and defining a second key figure, the second graphical report including the second key figure and a plurality of the second plurality of fields, wherein the second graphical report is one of a spreadsheet or a graphical chart;

receiving an indication of a mapping between the field of the first graphical report and one of the second plurality of fields;

presenting a second graphical representation of the second data structure, the second graphical representation comprising a third graphical icon representing the second key figure and a plurality of fourth graphical icons, each of the plurality of fourth graphical icons representing a respective one of the second plurality of fields, each of the plurality of fourth graphical icons graphically linked to the third graphical icon, and the third graphical icon graphically linked to the first graphical icon;

receiving a selection of one of the plurality of fourth graphical icons representing one of the second plurality of fields; and

generating, based on the mapping, a third graphical report comprising the first key figure, the second key figure, the plurality of the first plurality of fields and the one of the second plurality of fields, wherein the third graphical report is one of a spreadsheet or a graphical chart.

2. A method according to claim 1, wherein generating the third graphical report comprises mapping a field of the first data structure to a field of the second data structure.

3. A method according to claim 1, further comprising:

in response to receiving the selection of the one of the plurality of fourth graphical icons, changing the one of the plurality of fourth graphical icons to a fifth graphical icon.

4. A method according to claim 3,

wherein the fifth graphical icon is substantially identical to the second graphical icons.

5. A method according to claim 1, further comprising:

receiving a selection of a fourth graphical report, the fourth graphical report depicting data of a third data structure defined by third metadata, the third metadata defining a third plurality of fields and defining a third key figure, the fourth graphical report including the third key figure and a plurality of the third plurality of fields, wherein the fourth graphical report is one of a spreadsheet or a graphical chart;

receiving an indication of a mapping between the field of the first report and one of the third plurality of fields;

presenting a third graphical representation of the third data structure, the third graphical representation comprising a fifth graphical icon representing the third key figure and a plurality of sixth graphical icons, each of the plurality of sixth graphical icons representing a respective one of the third plurality of fields, each of the plurality of sixth graphical icons graphically linked to the fifth graphical icon, and the fifth graphical icon graphically linked to the first graphical icon; and

receiving a selection of one of the plurality of sixth graphical icons representing one of the third plurality of fields,

wherein generating the third graphical report comprises generating the third graphical report to include the plurality of the first plurality of fields, the one of the second plurality of fields, and the one of the third plurality of fields.

6. A method according to claim 1,

wherein the first metadata defines a plurality of dimensions, each of the dimensions associated with a respective one of the first plurality of fields, and

wherein the first graphical representation comprises a plurality of fifth graphical icons, each of the fifth graphical icons representing a respective one of the plurality of dimensions,

wherein the first graphical icon is graphically connected to each of the fifth graphical icons, and

wherein each of the fifth graphical icons is graphically connected to each respective one of the first plurality of fields with which the fifth graphical icon is associated.

7. A method according to claim 1, further comprising:

receiving a selection of the second key figure; and

wherein generating the third graphical report comprises generating the third graphical report to include the plurality of the first plurality of fields, the one of the second plurality of fields, and the second key figure.

8. A non-transitory medium storing processor-executable program code, the program code executable by a device to:

receive a selection of a first graphical report, the first graphical report depicting data of a first data structure defined by first metadata, the first metadata defining a first plurality of fields and defining a first key figure, and the first graphical report including the first key figure and a plurality of the first plurality of fields, wherein the first graphical report is one of a spreadsheet or a graphical chart;

present a first graphical representation of the first data structure, the first graphical representation comprising a first graphical icon representing the first key figure, and a plurality of second graphical icons, each of the plurality of second graphical icons representing a respective one of the plurality of the first plurality of fields of the first graphical report, and each of the plurality of second graphical icons graphically linked to the first graphical icon;

receive a selection of one of the second graphical icons representing a field of the first report;

receive a selection of a second graphical report, the second report depicting data of a second data structure defined by second metadata, the second metadata defining a second plurality of fields and defining a second at least one key figure, the second graphical report including the second key figure and a plurality of the second plurality of fields, wherein the second graphical report is one of a spreadsheet or a graphical chart;

receive an indication of a mapping between the field of the first graphical report and one of the second plurality of fields;

present a second graphical representation of the second data structure, the second graphical representation comprising a third graphical icon representing the second key figure and a plurality of fourth graphical icons, each of the plurality of fourth graphical icons representing a respective one of the second plurality of fields, each of the plurality of fourth graphical icons graphically linked to the third graphical icon, and the third graphical icon graphically linked to the first graphical icon;

receive a selection of one of the plurality of fourth graphical icons representing one of the second plurality of fields; and

generate, based on the mapping, a third graphical report comprising the first key figure, the second key figure, the plurality of the first plurality of fields and the one of the second plurality of fields, wherein the third graphical report is one of a spreadsheet or a graphical chart.

9. A medium according to claim 8, wherein generation of the third graphical report comprises mapping of a field of the first data structure to a field of the second data structure.

10. A medium according to claim 8, the program code further executable by a device to:

change, in response to receiving the selection of the one of the plurality of fourth graphical icons, the one of the plurality of fourth graphical icons to a fifth graphical icon.

11. A medium according to claim 10,

wherein the fifth graphical icon is substantially identical to the second graphical icons.

12. A medium according to claim 8, the program code further executable by a device to:

receive a selection of a fourth graphical report, the fourth graphical report depicting data of a third data structure defined by third metadata, the third metadata defining a third plurality of fields and defining a third one key figure, the fourth graphical report including the third key figure and a plurality of the third plurality of fields, wherein the fourth graphical report is one of a spreadsheet or a graphical chart;

receive an indication of a mapping between the field of the first report and one of the third plurality of fields;

present a third graphical representation of the third data structure, the third graphical representation comprising a fifth graphical icon representing the third key figure and a plurality of sixth graphical icons, each of the plurality of sixth graphical icons representing a respective one of the third plurality of fields, each of the plurality of sixth graphical icons graphically linked to the fifth graphical icon, and the fifth graphical icon graphically linked to the first graphical icon; and

receive a selection of one of the plurality of sixth graphical icons representing one of the third plurality of fields,

wherein generation of the third graphical report comprises generating the third graphical report to include the plurality of the first plurality of fields, the one of the second plurality of fields, and the one of the third plurality of fields.

13. A medium according to claim 8,

wherein the first metadata defines a plurality of dimensions, each of the dimensions associated with a respective at least one of the first plurality of fields, and

wherein the first graphical representation comprises a plurality of fifth graphical icons, each of the fifth graphical icons representing a respective one of the plurality of dimensions,

wherein the first graphical icon is graphically connected to each of the fifth graphical icons, and

wherein each of the fifth graphical icons is graphically connected to each respective one of the first plurality of fields with which the fifth graphical icon is associated.

14. A medium according to claim 8, the program code further executable by a device to:

receive a selection of the second key figure; and

wherein generation of the third report comprises generation of the third report to include the plurality of the first plurality of fields, the one of the second plurality of fields, and the second key figure.

15. A system comprising:

a computing device comprising;

a memory system storing processor-executable program code; and

a processor to execute the processor-executable program code in order to cause the computing device to;

receive a selection of a first graphical report, the first graphical report depicting data of a first data structure defined by first metadata, the first metadata defining a first plurality of fields and defining a first key figure, and the first graphical report including the first key figure and a plurality of the first plurality of fields, wherein the first graphical report is one of a spreadsheet or a graphical chart;

present a first graphical representation of the first data structure, the first graphical representation comprising a first graphical icon representing the first key figure, and a plurality of second graphical icons, each of the plurality of second graphical icons representing a respective one of the plurality of the first plurality of fields of the first graphical report, and each of the plurality of second graphical icons graphically linked to the first graphical icon;

receive a selection of one of the second graphical icons representing a field of the first graphical report;

receive a selection of a second graphical report, the second graphical report depicting data of a second data structure defined by second metadata, the second metadata defining a second key figure, the second graphical report including the second key figure and a plurality of the second plurality of fields, wherein the second graphical report is one of a spreadsheet or a graphical chart;

receive an indication of a mapping between the field of the first report and one of the second plurality of fields;

present a second graphical representation of the second data structure, the second graphical representation comprising a third graphical icon representing the second key figure and a plurality of fourth graphical icons, each of the plurality of fourth graphical icons representing a respective one of the second plurality of fields, each of the plurality of fourth graphical icons graphically linked to the third graphical icon, and the third graphical icon graphically linked to the first graphical icon;

receive a selection of one of the plurality of fourth graphical icons representing one of the second plurality of fields; and

generate, based on the mapping, a third graphical report comprising the first key figure, the second key figure, the plurality of the first plurality of fields and the one of the second plurality of fields, wherein the third graphical report is one of a spreadsheet or a graphical chart.

16. A system according to claim 15, wherein generation of the third graphical report comprises mapping of a field of the first data structure to a field of the second data structure.

17. A system according to claim 15, the processor further to execute the processor-executable program code in order to cause the computing device to:

change, in response to receiving the selection of the one of the plurality of fourth graphical icons, the one of the plurality of fourth graphical icons to a fifth graphical icon.

18. A system according to claim 17,

wherein the fifth graphical icon is substantially identical to the second graphical icons.

19. A system according to claim 15, the processor further to execute the processor-executable program code in order to cause the computing device to:

receive a selection of a fourth graphical report, the fourth graphical report based on a third data source defined by third metadata, the third metadata defining a third plurality of fields and defining a third key figure, the fourth graphical report including the third key figure and a plurality of the third plurality of fields, wherein the fourth graphical report is one of a spreadsheet or a graphical chart;

receive an indication of a mapping between the field of the first report and one of the third plurality of fields;

present a third graphical representation of the third data structure, the third graphical representation comprising a fifth graphical icon representing the third key figure and a plurality of sixth graphical icons, each of the plurality of sixth graphical icons representing a respective one of the third plurality of fields, each of the plurality of sixth graphical icons graphically linked to the fifth graphical icon, and the fifth graphical icon graphically linked to the first graphical icon; and

receive a selection of one of the plurality of sixth graphical icons representing one of the third plurality of fields,

wherein generation of the third graphical report comprises generating the third graphical report to include the plurality of the first plurality of fields, the one of the second plurality of fields, and the one of the third plurality of fields.

20. A system according to claim 15,

wherein the first metadata defines a plurality of dimensions, each of the dimensions associated with a respective one of the first plurality of fields, and

wherein the first graphical representation comprises a plurality of fifth graphical icons, each of the fifth graphical icons representing a respective one of the plurality of dimensions,

wherein the first graphical icon is graphically connected to each of the fifth graphical icons, and

wherein each of the fifth graphical icons is graphically connected to each respective one of the first plurality of fields with which the fifth graphical icon is associated.

21. A system according to claim 15, the processor further to execute the processor-executable program code in order to cause the computing device to:

receive a selection of the second key figure; and

wherein generation of the third graphical report comprises generation of the third graphical report to include the plurality of the first plurality of fields, the one of the second plurality of fields, and the second key figure.