FLEXIBLE AND INTUITIVE TABLE BASED VISUALIZATIONS FOR BIG DATA

• US 20170147551A1
• Filed: 11/24/2015
• Published: 05/25/2017
• Est. Priority Date: 11/24/2015
• Status: Active Grant

• Current Assignee: SAP SE
• Original Assignee: SAP SE
• Inventors: Hille-Doering, Reiner, Kalisz, Karol
• Granted Patent: US 10,474,746 B2
• Time in Patent Office: Days
• 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 40/177 of tables; using ruled lines

Abstract

A method, system, and computer-readable medium to define a row scope for a table-based visualization of the multidimensional data set, the row scope specifying a number of dimensions of the multidimensional data set; selectively define at least one data selection of the multidimensional data set to connect to the defined row scope to be visualized in the table-based visualization; and generate an instance of the table-based visualization based on the defined row scope and the defined at least one data selection.

Claims

1. A method to visualize a multidimensional data set, the method comprising:

defining a row scope for a table-based visualization of the multidimensional data set, the row scope specifying a number of dimensions of the multidimensional data set;

selectively defining at least one data selection of the multidimensional data set to connect to the defined row scope to be visualized in the table-based visualization; and

generating an instance of the table-based visualization based on the defined row scope and the defined at least one data selection.

2. The method of claim 1, wherein the defining of the row scope comprises selecting a subset of a total number of dimensions of the multidimensional data set to define a row of the table-based visualization.

3. The method of claim 2, wherein the defining of the row scope comprises selecting at least two dimensions of the multidimensional data set and combining the selected at least two dimensions of the multidimensional data set to define a row of the table-based visualization.

4. The method of claim 1, further comprising specifying parameters to define a visualization for the at least one data selection of the multidimensional data set to be visualized as in a cell of a table-based visualization.

5. The method of claim 1, wherein the at least one data selection of the multidimensional data set comprises selecting data including at least one of a single value, multiple values, an array of values, a list of arrays, a function of data values of the multidimensional data set, and combinations thereof.

6. The method of claim 1, wherein the visualization includes a presentation of at least one of a single selection of content, a trend chart, a comparison chart, and a custom visualization.

7. The method of claim 6, wherein the textual content includes a representation of a single selection of a text, a value, and an image content;

the trend charts include at least one representation of a bar chart, a bullet chart, a delta bar chart, and a fraction bar chart to compare two single data selections; and

the trend charts include at least one representation of a line chart, a column chart, and a bubble chart to list a selection of multiple cells of data.

8. The method of claim 6, wherein the custom visualization presents content with at least one of the following features:

a size of a table-based visualization cell depends on the content therein, a visualization of the content depends on a display size of a device to render the visualization, a visualization of the content depends on a characteristic of a post-analysis result of selected content, a visualization of the content is presented on a geographical map, a visualization of the content is selectively determined by a user during a runtime, a type of visualization of the content is selectively determined in response to a user specified selection during a runtime, a visualization of the content is specified during a design time, and a type of visualization of the content is selectively determined in response to a user specified selection during a runtime.

9. The method of claim 1, wherein the visualization includes a presentation of interactive content, wherein the interactive content is at least one of:

an interactive control to invoke an internal action in reply to a user input, an interactive control to invoke an external action in reply to a user input, and at least one other interactive content.

10. A non-transitory computer-readable medium having processor-executable instructions stored thereon, the medium comprising:

instructions to define a row scope for a table-based visualization of the multidimensional data set, the row scope specifying a number of dimensions of the multidimensional data set;

instructions to selectively define at least one data selection of the multidimensional data set to connect to the defined row scope to be visualized in the table-based visualization; and

instructions to generate an instance of the table-based visualization based on the defined row scope and the defined at least one data selection.

11. The medium of claim 10, wherein the defining of the row scope comprises selecting a subset of a total number of dimensions of the multidimensional data set to define a row of the table-based visualization.

12. The medium of claim 11, wherein the defining of the row scope comprises selecting at least two dimensions of the multidimensional data set and combining the selected at least two dimensions of the multidimensional data set to define a row of the table-based visualization.

13. The medium of claim 10, further comprising instructions to specify parameters to define a visualization for the at least one data selection of the multidimensional data set to be visualized as in a cell of a table-based visualization.

14. The medium of claim 10, wherein the at least one data selection of the multidimensional data set comprises selecting data including at least one of a single value, multiple values, an array of values, a list of arrays, a function of data values of the multidimensional data set, and combinations thereof.

15. The medium of claim 10, wherein the visualization includes a presentation of at least one of a single selection of content, a trend chart, a comparison chart, and a custom visualization.

16. The medium of claim 15, wherein the textual content includes a representation of a single selection of a text, a value, and an image content;

the trend charts include at least one representation of a bar chart, a bullet chart, a delta bar chart, and a fraction bar chart to compare two single data selections; and

the trend charts include at least one representation of a line chart, a column chart, and a bubble chart to list a selection of multiple cells of data.

17. The medium of claim 15, wherein the custom visualization presents content with at least one of the following features:

a size of a table-based visualization cell depends on the content therein, a visualization of the content depends on a display size of a device to render the visualization, a visualization of the content depends on a characteristic of a post-analysis result of selected content, a visualization of the content is presented on a geographical map, a visualization of the content is selectively determined by a user during a runtime, a type of visualization of the content is selectively determined in response to a user specified selection during a runtime, a visualization of the content is specified during a design time, and a type of visualization of the content is selectively determined in response to a user specified selection during a runtime.

18. The medium of claim 10, wherein the visualization includes a presentation of interactive content, wherein the interactive content is at least one of:

an interactive control to invoke an internal action in reply to a user input, an interactive control to invoke an external action in reply to a user input, and at least one other interactive content.