Methods and systems for recursively generating pivot tables

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.