Flexible and intuitive table based visualizations for big data

• US 10,474,746 B2
• Filed: 11/24/2015
• Issued: 11/12/2019
• Est. Priority Date: 11/24/2015
• Status: Active Grant

• Current Assignee: SAP SE
• Original Assignee: SAP SE
• Inventors: Kalisz, Karol, Hille-Doering, Reiner
• Primary Examiner(s): Baderman, Scott T
• Assistant Examiner(s): Velez-Lopez, Mario M
• Application Number:
  US14/951,036
• Publication Number:
  US 20170147551A1
• Time in Patent Office: 1,449 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 to be generated 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 a subset of the multidimensional data set to connect to the defined row scope to be represented in the table-based visualization as a graphical visualization, the defined at least one data selection of the subset of the multidimensional data set specifying columns of the table-based visualization and results sets to be used in the graphical visualization of data content for the specified columns; and

generating an instance of the table-based visualization based on the defined row scope and the defined at least one data selection, a row in the table-based visualization having a scope of the dimensions defined by the defined row scope and dimensions excluded from the defined row scope being included in the graphical visualization in the table-based visualization, the generated instance of the table-based visualization being presented in a column of a table comprising a plurality of dimensions of the multidimensional data set.

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 represented 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 textual 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 to be generated 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 a subset of the multidimensional data set to connect to the defined row scope to be represented in the table-based visualization as a graphical visualization, the defined at least one data selection of the subset of the multidimensional data set specifying columns of the table-based visualization and results sets to be used in the graphical visualization of data content for the specified columns; 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, a row in the table-based visualization having a scope of the dimensions defined by the defined row scope and dimensions excluded from the defined row scope being included in the graphical visualization in the table-based visualization, the generated instance of the table-based visualization being presented in a column of a table comprising a plurality of dimensions of the multidimensional data set.

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 represented 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 textual 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.