Methods and systems for recursively generating pivot tables

Patent metadata

Field	Value
Publication number	US-9430469-B2
Application number	US-201414248718-A
Country	US
Kind code	B2
Filing date	Apr 9, 2014
Priority date	Apr 9, 2014
Publication date	Aug 30, 2016
Grant date	Aug 30, 2016

Abstract

Systems and methods for recursively generating pivot tables are described. A processor provides, for display, a first table including a first set of results, each result including values corresponding to a first dimension. Each value of the first dimension is associated with a corresponding actionable object for further filtering a data set. In response to an action on an actionable object, the processor identifies a first set of entries of the plurality of entries that correspond to a value of the first dimension with which the actionable object is associated. The processor receives a second request to generate a second table from the first table identifying a second dimension. The processor generates the second table including a second set of results having values corresponding to the second dimension identified in the second request.

First claim

What is claimed is:

1. A method for recursively generating pivot tables, comprising
receiving, by a processor, a first request to generate a first pivot table from a data set including a plurality of entries corresponding to a plurality of dimensions and a plurality of metrics, the first request identifying a first dimension of the plurality of dimensions and at least one metric of the plurality of metrics;
generating the first pivot table including a first set of results, each result of the first set of results including a first plurality of values corresponding to the first dimension and the at least one metric identified in the first request;
providing, for display on a user interface, the generated first pivot table, each value of the first dimension associated with a corresponding actionable object for further filtering the data set;
receiving an action on at least one actionable object corresponding to a particular value of the first dimension;
identifying, from the first set of results, one or more results corresponding to the particular value of the first dimension;
receiving a second request to generate a second pivot table from the results corresponding to the particular value of the first dimension, the second request identifying a second dimension of the plurality of dimensions and at least one metric of the plurality of metrics;
generating, from the identified results corresponding to the particular value of the first dimension, the second pivot table including a second set of results, each result of the second set of results including a second plurality of dimension values corresponding to the second dimension and the at least one metric identified in the second request; and
providing, for display on the user interface, the second pivot table, each dimension value of the second dimension associated with a corresponding actionable object for further filtering the data set.

2. The method of claim 1 , further comprising:
generating a database query responsive to receiving the first request to generate the first pivot table; and
responsive to receiving the second request, modifying the generated database query to include a filter instruction corresponding to the dimension value of the first dimension.

3. The method of claim 2 , further comprising providing, for display, the modified generated database query.

4. The method of claim 1 , further comprising providing, for display on the user interface, the dimension value of the first dimension as an actionable object.

5. The method of claim 1 , further comprising responsive to an action on an actionable object corresponding to a value of the first dimension, generating a filter identifying a first set of entries of the plurality of entries that correspond to a value of the first dimension with which the actionable object is associated.

6. The method of claim 1 , further comprising providing, for display, the first pivot table including a first plurality of cells including values of the first dimension and a second plurality of cells including values of the at least one metric.

7. The method of claim 6 , wherein the first plurality of cells include the actionable objects.

8. A system for recursively generating pivot tables, comprising:
a data processing system having a pivot table generation module and a user interface module, the data processing system further comprising
a memory storing processor-executable instructions; and
a processor configured to execute the processor-executable instructions to:
receive a first request to generate a first pivot table from a data set including a plurality of entries corresponding to a plurality of dimensions and a plurality of metrics, the request identifying a first dimension of the plurality of dimensions and at least one metric of the plurality of metrics;
generate the first pivot table including a first set of results, each result of the first set of results including a first plurality of values corresponding to the first dimension and the at least one metric identified in the first request;
provide, for display on a user interface, the generated first pivot table, each value of the first dimension associated with a corresponding actionable object for further filtering the data set;
receive an action on at least one actionable object corresponding to a particular value of the first dimension;

identify, from the first set of results, one or more results corresponding to the particular value of the first dimension;
receive a second request to generate a second pivot table from the results corresponding to the particular value of the first dimension, the second request identifying a second dimension of the plurality of dimensions and at least one metric of the plurality of metrics;
generate, from the identified results corresponding to the particular value of the first dimension, the second pivot table including a second set of results, each result of the second set of results including a second plurality of dimension values corresponding to the second dimension and the at least one metric identified in the second request; and
provide, for display on the user interface, the second pivot table, each dimension value of the second dimension associated with a corresponding actionable object for further filtering the data set.

9. The system of claim 8 , wherein the processor is further configured to:
generate a database query responsive to receiving the first request to generate the first pivot table; and
responsive to receiving the second request, modify the generated database query to include a filter instruction corresponding to the dimension value of the first dimension.

10. The system of claim 9 , wherein the processor is further configured to provide, for display, the modified generated database query.

11. The system of claim 8 , wherein the processor is further configured to provide, for display on the user interface, the dimension value of the first dimension as an actionable object.

12. The system of claim 8 , further comprising responsive to an action on an actionable object corresponding to a value of the first dimension, generate a filter identifying a first set of entries of the plurality of entries that correspond to a value of the first dimension with which the actionable object is associated.

13. The system of claim 8 , wherein the processor is further configured to provide, for display, the first pivot table including a first plurality of cells including values of the first dimension and a second plurality of cells including values of the at least one metric.

14. The system of claim 13 , wherein the first plurality of cells include the actionable objects.

15. A computer-readable storage medium having instructions to provide information via a computer network, the instructions comprising instructions to:
receive a first request to generate a first pivot table from a data set including a plurality of entries corresponding to a plurality of dimensions and a plurality of metrics, the request identifying a first dimension of the plurality of dimensions and at least one metric of the plurality of metrics;
generate the first pivot table including a first set of results, each result of the first set of results including a first plurality of values corresponding to the first dimension and the at least one metric identified in the first request;
provide, for display on a user interface, the generated first pivot table, each value of the first dimension associated with a corresponding actionable object for further filtering the data set;
receive an action on at least one actionable object corr

Assignees

• Google Inc

Inventors

• Lam Allister
• Hinds Jeremy Adam
• Renwick James
• Cronin Garrett
• Calvo Rafael Darder
• Cervera Fernando Gabriel

Classifications

• G06F40/18

  of spreadsheets (form-filling G06F40/174) · CPC title

• G06F16/00 Primary

  Information retrieval; Database structures therefor; File system structures therefor · CPC title

• G06F16/24553

  of query operations · CPC title

• G06F16/283 Primary

  Multi-dimensional databases or data warehouses, e.g. MOLAP or ROLAP · CPC title

• G06F17/246

  Physics · mapped topic