Methods and systems for recursively generating pivot tables

• US 9,430,469 B2
• Filed: 04/09/2014
• Issued: 08/30/2016
• Est. Priority Date: 04/09/2014
• Status: Expired due to Fees

• Current Assignee: Google LLC (Alphabet Inc.)
• Original Assignee: Google Inc. (Alphabet Inc.)
• Inventors: Lam, Allister, Hinds, Jeremy Adam, Renwick, James, Cronin, Garrett, Calvo, Rafael Darder, Cervera, Fernando Gabriel
• Primary Examiner(s): RIES, LAURIE ANNE
• Application Number:
  US14/248,718
• Publication Number:
  US 20150370433A1
• Time in Patent Office: 874 Days
• US Class Current: 1/1
• CPC Class Codes: G06F 16/00 Information retrieval; Database structures therefor; File system structures therefor
• CPC Class Codes: G06F 16/24553 of query operations
• CPC Class Codes: G06F 16/283 Multi-dimensional databases or data warehouses, e.g. MOLAP or ROLAP
• CPC Class Codes: G06F 40/18 of spreadsheets form-filling G06F40/174

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.

Claims

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

16. The computer-readable storage medium of claim 15, wherein the instructions include instructions 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.

17. The computer-readable storage medium of claim 16, wherein the instructions include instructions to provide, for display, the modified generated database query.

18. The computer-readable storage medium of claim 15, wherein the instructions include instructions to provide, for display on the user interface, the dimension value of the first dimension as an actionable object.

19. The computer-readable storage medium of claim 15, wherein the instructions include instructions to 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.

20. The computer-readable storage medium of claim 15, wherein the instructions include instructions 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.