Flexible Dashboard Enhancing Visualization of Database Information

• US 20130297588A1
• Filed: 05/07/2012
• Published: 11/07/2013
• Est. Priority Date: 05/07/2012
• Status: Abandoned Application

• Current Assignee: SAP AG (SAP SE)
• Original Assignee: SAP AG (SAP SE)
• Inventors: Tyagi, Harish
• Application Number:
  US13/465,350
• Publication Number:
  US 20130297588A1
• Time in Patent Office: Days
• US Class Current: 707/722
• CPC Class Codes: G06F 16/248 Presentation of query results
• CPC Class Codes: G06Q 10/06 Resources, workflows, human or project management; Enterprise or organisation planning; Enterprise or organisation modelling
• CPC Class Codes: G06Q 10/10 Office automation; Time management

Abstract

Embodiments provide systems and methods allowing optimization of dashboard analytics. In certain embodiments, results obtained from querying a database may be manipulated to arrange, replace, or supplement existing views. The end user is afforded control to drag and drop view(s) for positioning within a dashboard, as well as to provide additional and/or replacement views. The dashboard can serve as one point of contact allowing end users to render reports created in business warehouse systems, or business intelligence on-demand systems.

Claims

1. A computer-implemented method comprising:

causing a view engine to display to a user on a screen, a dashboard comprising a plurality of views of a database query result produced by a query engine, each of the plurality of views including an icon comprising a miniature depiction of a format type of the query result, together with a listing of available views from the database query result, wherein the listing of available views further includes the icon;

causing the view engine to receive an input from a user, wherein the user input comprises selecting a single available view from the listing, wherein the single available view comprises query result information from the database query result;

in response to the input, causing the view engine to create a modified dashboard comprising the single available view; and

causing the view engine to display to the user, the modified dashboard.

2. A method as in claim 1 wherein the user input comprises clicking on the single available view in the listing, and the modified dashboard comprises replacing one of the plurality of views with the single available view.

4. A method as in claim 1 wherein the single available view comprises a different format including query result information already present in at least one of the plurality of views.

5. A method as in claim 4 wherein the different format reflects a change between vertical or horizontal orientation.

6. A method as in claim 4 wherein the different format reflects a change between a chart of one format and a chart of a different format.

7. A method as in claim 4 wherein the different view format reflects a change between a chart and a plot.

22. A method as in claim 1 wherein the icon comprises a bar chart, a plot, a pie chart, or a table.

3. (canceled)

8. A non-transitory computer readable storage medium embodying a computer program for performing a method, said method comprising:

causing a view engine to display to a user on a screen, a dashboard comprising a plurality of views of a database query result produced by a query engine, each of the plurality of views including an icon comprising a miniature depiction of a format type of the query result, together with a listing of single available views from the database query result, wherein the listing of available views further includes the icon;

causing the view engine to receive an input from a user, wherein the user input comprises selecting an available view from the listing, wherein the single available view comprises query result information from the database query result;

in response to the input, causing the view engine to create a modified dashboard comprising the single available view; and

causing the view engine to display to the user, the modified dashboard.

9. A non-transitory computer readable storage medium as in claim 8 wherein the user input comprises clicking on the single available view in the listing, and the modified dashboard comprises replacing one of the plurality of views with the single available view.

11. A non-transitory computer readable storage medium as in claim 8 wherein the single available view comprises a different view format including query result information already present in at least one of the plurality of views.

12. A non-transitory computer readable storage medium as in claim 11 wherein the different format reflects a change between vertical or horizontal orientation.

13. A non-transitory computer readable storage medium as in claim 11 wherein the different format reflects a change between a chart of one typo format and a chart of a different format.

14. A non-transitory computer readable storage medium as in claim 11 wherein the different format reflects a change between a chart and a plot.

23. A non-transitory computer readable storage medium as in claim 8 wherein the icon comprises a bar chart, a plot, a pie chart, or a table.

10. (canceled)

15. A computer system comprising:

one or more processors;

a software program, executable on said computer system, the software program configured to;

cause a view engine to display to a user on a screen, a dashboard comprising a plurality of views of a database query result produced by a query engine, each of the plurality of views including an icon comprising a miniature depiction of a format type of the query result, together with a listing of available views from the database query result, wherein the listing of available views further includes the icon;

cause the view engine to receive an input from a user, wherein the user input comprises selecting a single available view from the listing, wherein the single available view comprises query result information from the database query result;

in response to the input, cause the view engine to create a modified dashboard comprising the single available view; and

cause the view engine to display to the user, the modified dashboard.

16. A computer system as in claim 15 wherein the user input comprises clicking on the single available view in the listing, and the modified dashboard comprises replacing one of the plurality of views with the single available view.

18. A computer system as in claim 15 wherein the single available view comprises a different view format including query result information already present in at least one of the plurality of views.

19. A computer system as in claim 18 wherein the different format reflects a change between vertical or horizontal orientation.

20. A computer system as in claim 18 wherein the different format reflects a change between one of,

a chart of one format and a chart of a different typo format;

and

a chart and a plot.

21. A computer system as in claim 18 wherein the icon comprises a bar chart, a plot, a pie chart, or a table.

17. (canceled)