Displaying visualizations linked to one or more data source queries

• US 8,645,853 B2
• Filed: 11/03/2006
• Issued: 02/04/2014
• Est. Priority Date: 11/03/2006
• Status: Active Grant

• Current Assignee: Business Objects Incorporated (SAP SE)
• Original Assignee: Business Objects Incorporated (SAP SE)
• Inventors: Prinsen, Edward, Gosper, Julian Lars, Lo, Philip Coldrey, Yau, Chuen Chi
• Primary Examiner(s): TRAN, TUYETLIEN T
• Application Number:
  US11/556,637
• Publication Number:
  US 20080109740A1
• Time in Patent Office: 2,650 Days
• Field of Search: 715/228, 715/764, 715/769, 707/4
• US Class Current: 715/769
• CPC Class Codes: G06F 16/248 Presentation of query results
• CPC Class Codes: G06F 16/283 Multi-dimensional databases or data warehouses, e.g. MOLAP or ROLAP
• CPC Class Codes: G06F 16/9038 Presentation of query results
• CPC Class Codes: G06F 3/0486 Drag-and-drop

Abstract

A computer readable storage medium includes executable instructions to provide a Graphical User Interface with a plurality of visualization types and a semi-structured workspace. A drag-and-drop of a visualization type into a drop zone in the semi-structured workspace is received. The drop zone corresponds to a location in the semi-structured workspace where an associated visualization is displayed. A link is created between the associated visualization and a query to a data source.

Claims

1. A non-transitory computer readable storage medium, comprising executable instructions to cause at least one data processor of at least one computing system to:

provide a Graphical User Interface (GUI) with a plurality of visualization types and a semi-structured workspace, wherein the semi-structured work space is a distinct section of the GUI that allows a user to select one or more visualizations and arrange them in a limited number of configurations and the visualization type selected comprises at least one of;

a record set, a table, a crosstab, a chart, a graphic or a metadata panel;

receive a drag-and-drop of a new visualization into a drop zone in the semi-structured workspace wherein;

the drop zone corresponds to a location in the semi-structured workspace where an associated visualization is displayed; and

the new visualization divides a workspace in two with the new visualization positioned in the drop zone and the associated visualization in the remaining area, wherein the new visualization is automatically linked to the data source query that was linked to the associated visualization and a change of a link to point to a different data source query causes the associated visualization to be updated;

receive input activating an alternative drop mode;

move through a list of available drop zones for a new visualization upon receiving an input such that each available drop zone is highlighted as the available drop zone is moved through; and

drop the new visualization in a selected available drop zone from the list of available drop zones.

2. The computer readable storage medium of claim 1, wherein if there are two previously placed visualizations in the semi-structured workspace then the instructions to receive the drag-and-drop of the new visualization divide the semi-structured workspace into a major portion for one of the previously placed visualizations and a minor portion for each of:

the associated visualization and the other of the two previously placed visualizations.

3. The computer readable storage medium of claim 1, wherein if there are three previously placed visualizations in the semi-structured workspace then the instructions to receive the drag-and-drop of the new visualization divide the semi-structured workspace between each of the three previously placed visualizations and the associated visualization.

4. The computer readable storage medium of claim 1, wherein if the drop zone corresponds to the location of a previously placed visualization in the semi-structured workspace then the instructions to receive the drag-and-drop of the new visualization replaces the previously placed visualization with the associated visualization.

5. The computer readable storage medium of claim 1 further comprising executable instructions to:

receive a drag-and-drop of a first previously placed visualization in a first location into a drop zone corresponding to a second location containing a second previously placed visualization;

display the first previously placed visualization in the second location; and

display the second previously placed visualization in the first location.

6. The computer readable storage medium of claim 1, wherein the drop zone is indicated by highlighting the location that corresponds to the drop zone.

7. The computer readable storage medium of claim 1, wherein the data source is OLAP.

8. The computer readable storage medium of claim 1, wherein the data source is one of a group of one or more data sources.

9. The computer readable storage medium of claim 1 further comprising executable instructions to:

change a link to point to a different query in a group of one or more queries; and

update the associated visualization.

10. The computer readable storage medium of claim 1, wherein the semi-structured workspace supports a maximum number of visualizations selected from one of 2, 4, 6, 8, 10, 12, 14 and 16.

11. A method for implementation by one or more data processors of at least one computing system comprising:

providing a Graphical User Interface (GUI) with a plurality of visualization types and a semi-structured workspace, wherein the semi-structured work space is a distinct section of the GUI that allows a user to select one or more visualizations and arrange them in a limited number of configurations and the visualization type selected comprises at least one of;

a record set, a table, a crosstab, a chart, a graphic or a metadata panel;

receiving a drag-and-drop of a new visualization into a drop zone in the semi-structured workspace wherein;

the drop zone corresponds to a location in the semi-structured workspace where an associated visualization is displayed; and

the new visualization divides a workspace in two with the new visualization positioned in the drop zone and the associated visualization in the remaining area, wherein the new visualization is automatically linked to the data source query that was linked to the associated visualization and a change of a link to point to a different data source query causes the associated visualization to be updated;

receiving input activating an alternative drop mode;

moving through a list of available drop zones for a new visualization upon receiving an input such that each available drop zone is highlighted as the available drop zone is moved through; and

dropping the new visualization in a selected available drop zone from the list of available drop zones.

12. A system comprising:

at least one data processor; and

memory storing instructions, which when executed by the at least one data processor, result in operations comprising;

providing a Graphical User Interface (GUI) with a plurality of visualization types and a semi-structured workspace, wherein the semi-structured work space is a distinct section of the GUI that allows a user to select one or more visualizations and arrange them in a limited number of configurations and the visualization type comprises at least one of;

a record set, a table, a crosstab, a chart, a graphic or a metadata panel;

receiving a drag-and-drop of a new visualization into a drop zone in the semi-structured workspace wherein;

the drop zone corresponds to a location in the semi-structured workspace where an associated visualization is displayed; and

the new visualization divides a workspace in two with the new visualization positioned in the drop zone and the associated visualization in the remaining area, wherein the new visualization is automatically linked to the data source query that was linked to the associated visualization and a change of a link to point to a different data source query causes the associated visualization to be updated;

receiving input activating an alternative drop mode;

move through a list of available drop zones for a new visualization upon receiving an input such that each available drop zone is highlighted as the available drop zone is moved through; and

dropping the new visualization in a selected available drop zone from the list of available drop zones.