# US 2015/0178339 A1 · Interactive multi-dimensional nested table supporting scalable real-time querying of large data volumes

> Agents: this data is available as JSON from the patentgrep API and MCP server — see https://patentgrep.com/llms.txt

- Number: US 2015/0178339 A1
- Document ID: US20150178339A1
- Status: Published application
- Kind: A1
- Application number: 14/577,466
- Filed: 2014-12-19
- Published: 2015-06-25
- Earliest claimed: 2013-12-19
- Assignees: Exposit Labs, Inc.
- Applicants: Metamarkets Group Inc.
- Inventors: Vadim Ogievetsky; Michael Driscoll; Young Min Kin; Elizabeth Allen; Katherine Chu; Ofir Oss; Adam Smith; Luca Candela
- Web page: https://patentgrep.com/patent/US20150178339A1

## CPC

- G06F 16/283: {Multi-dimensional databases or data warehouses, e.g. MOLAP or ROLAP}
- G06F 16/26: Visual data mining; Browsing structured data
- G06F 40/18: of spreadsheets (form-filling G06F40/174)
- G06F: ELECTRIC DIGITAL DATA PROCESSING (computer systems based on specific computational models G06N)

## Abstract

Displaying a visual representation of table, including generating a visual representation of a table including a plurality of dimensions, displaying the visual representation of the table, where a first dimension value corresponding to one of the plurality of dimensions is collapsed when the table is initially generated, and a second dimension value corresponding to one of the plurality of dimensions is expanded such that sub-dimension values for the first dimension value are not visible, and sub-dimension values for the second dimension value are visible, detecting that a user has placed a first dimension value manipulator corresponding to said first dimension value into an expand mode, and in response to detecting the first dimension value manipulator is in an expand mode, expanding the first dimension value in the displayed visual representation of the table such that the sub-dimension values for the first dimension value are visible.

## Claims

### Claim 1

A computer readable storage medium or media having computer-executable instructions stored therein that when executed cause a machine to:
generate a visual representation of a table based on stored data, the table including a plurality of dimensions;
display the visual representation of the table, wherein a first dimension value corresponding to one of the plurality of dimensions is collapsed when the table is initially generated, and a second dimension value corresponding to one of the plurality of dimensions is expanded when the table is initially generated, such that sub-dimension values for the first dimension value are not visible, and sub-dimension values for the second dimension value are visible;
detect that a user has placed a first dimension value manipulator corresponding to the first dimension value into an expand mode; and
in response to detecting the first dimension value manipulator is in an expand mode, expand the first dimension value in the displayed visual representation of the table such that the sub-dimension values for the first dimension value are visible.

### Claim 2 (depends on 1)

The computer readable storage medium or media of claim 1, wherein when the table is initially generated, the sub-dimension values for the second dimension that are visible are a portion of all sub-dimension values for the second dimension, and wherein the sub-dimension values for the second dimension that are visible are determined to satisfy a predetermined relevancy threshold.

### Claim 3 (depends on 2)

The computer readable storage medium or media of claim 2, further comprising instructions that when executed further cause a machine to:
detect that a sub-manipulator, corresponding to the sub-dimension values for the second dimension value, is in an expand mode; and
in response to detecting that the sub-manipulator is in the expand mode, display all the sub-dimension values for the second dimension value in the visual representation of the table.

### Claim 4 (depends on 1)

The computer readable storage medium or media of claim 1, further comprising instructions that when executed further cause a machine to, prior to expanding the first dimension value:
generate a metric value calculated based on the sub-dimension values of the first dimension value; and
display the metric value corresponding to the first dimension value in the visual representation of the table.

### Claim 5 (depends on 1)

The computer readable storage medium or media of claim 1, further comprising instructions that when executed further cause a machine to:
receive a request from a user via the visual representation of the table to add a dimension to the visual representation of the table; and
in response to the request to add a dimension, add an additional dimension and at least one additional manipulator that allows a user to manipulate the visual representation of the data based on the additional dimension.

### Claim 6 (depends on 1)

The computer readable storage medium or media of claim 1, further comprising instructions that when executed further cause a machine to:
receive user input rearranging a hierarchy of the plurality of dimensions of the table; and
modify the visible sub-dimensional values based on the rearranged hierarchy of the plurality of dimensions of the table.

### Claim 7 (depends on 1)

The computer readable storage medium or media of claim 1, further comprising instructions that when executed further cause a machine to:
receive user input indicating a selection of at least two rows;
dynamically perform a calculation based on data in the at least two selected rows; and
display a result of the calculation in the visual representation of the table.

### Claim 8

A method for displaying a visual representation of a table, comprising:
generating a visual representation of a table based on stored data, the table including a plurality of dimensions;
displaying the visual representation of the table, wherein a first dimension value corresponding to one of the plurality of dimensions is collapsed when the table is initially generated, and a second dimension value corresponding to one of the plurality of dimensions is expanded when the table is initially generated, such that sub-dimension values for the first dimension value are not visible, and sub-dimension values for the second dimension value are visible;
detecting that a user has placed a first dimension value manipulator corresponding to the first dimension value into an expand mode; and
in response to detecting the first dimension value manipulator is in an expand mode, expanding the first dimension value in the displayed visual representation of the table such that the sub-dimension values for the first dimension value are visible.

### Claim 9 (depends on 8)

The method of claim 8, wherein when the table is initially generated, the sub-dimension values for the second dimension that are visible are a portion of all sub-dimension values for the second dimension, and wherein the sub-dimension values for the second dimension that are visible are determined to satisfy a predetermined relevancy threshold.

### Claim 10 (depends on 9)

The method of claim 9, further comprising:
detecting that a sub-manipulator, corresponding to the sub-dimension values for the second dimension value, is in an expand mode; and
in response to detecting that the sub-manipulator is in the expand mode, displaying all the sub-dimension values for the second dimension value in the visual representation of the table.

### Claim 11 (depends on 8)

The method of claim 8, further comprising:
generating a metric value calculated based on the sub-dimension values of the first dimension value; and
displaying the metric value corresponding to the first dimension value in the visual representation of the table.

### Claim 12 (depends on 8)

The method of claim 8, further comprising:
receiving a request from a user, via the visual representation of the table, to add a dimension to the visual representation of the table; and
in response to the request to add a dimension, adding an additional dimension and at least one additional manipulator that allows a user to manipulate the visual representation of the data based on the additional dimension.

### Claim 13 (depends on 8)

The method of claim 8, further comprising:
receiving user input rearranging a hierarchy of the plurality of dimensions of the table; and
modifying the visible sub-dimensional values based on the rearranged hierarchy of the plurality of dimensions of the table.

### Claim 14 (depends on 8)

The method of claim 8, further comprising:
receiving user input indicating a selection of at least two rows;
dynamically performing a calculation based on data in the at least two selected rows; and
displaying a result of the calculation in the visual representation of the table.

### Claim 15

A computer system for displaying a visual representation of a table, comprising:
one or more processors;
a memory, coupled to the one or more processors, on which are stored which, when executed by the one or more processors, cause the one or more processors to:
generate a visual representation of a table based on stored data, the table including a plurality of dimensions;
display the visual representation of the table, wherein a first dimension value corresponding to one of the plurality of dimensions is collapsed when the table is initially generated, and a second dimension value corresponding to one of the plurality of dimensions is expanded when the table is initially generated, such that sub-dimension values for the first dimension value are not visible, and sub-dimension values for the second dimension value are visible;
detect that a user has placed a first dimension value manipulator corresponding to the first dimension value into an expand mode; and
in response to detecting the first dimension value manipulator is in an expand mode, expand the first dimension value in the displayed visual representation of the table such that the sub-dimension values for the first dimension value are visible.

### Claim 16 (depends on 15)

The system of claim 15, wherein when the table is initially generated, the sub-dimension values for the second dimension that are visible are a portion of all sub-dimension values for the second dimension, and wherein the sub-dimension values for the second dimension that are visible are determined to satisfy a predetermined relevancy threshold.

### Claim 17 (depends on 16)

The system of claim 16, further comprising instructions that when executed further cause a machine to:
detect that a sub-manipulator, corresponding to the sub-dimension values for the second dimension value, is in an expand mode; and
in response to detecting that the sub-manipulator is in the expand mode, display all the sub-dimension values for the second dimension value in the visual representation of the table.

### Claim 18 (depends on 15)

The system of claim 15, further comprising instructions that when executed further cause a machine to, prior to expanding the first dimension value:
generate a metric value calculated based on the sub-dimension values of the first dimension value; and
display the metric value corresponding to the first dimension value in the visual representation of the table.

### Claim 19 (depends on 15)

The system of claim 15, further comprising instructions that when executed further cause a machine to:
receive a request from a user, via the visual representation of the table, to add a dimension to the visual representation of the table; and
in response to the request to add a dimension, add an additional dimension and at least one additional manipulator that allows a user to manipulate the visual representation of the data based on the additional dimension.

### Claim 20 (depends on 15)

The system of claim 15, further comprising instructions that when executed further cause a machine to:
receive user input rearranging a hierarchy of the plurality of dimensions of the table; and
modify the visible sub-dimensional values based on the rearranged hierarchy of the plurality of dimensions of the table.
