Data analysis expressions
First Claim
Patent Images
1. A computer-readable hardware storage medium storing instructions, that when executed by a processor, cause the processor to:
- receive input comprising a column definition of a particular column of a first table, wherein the input includes a data analysis expression based on at least one column of the first table other than the particular column and based on at least one column of a second table;
determine a relationship between the first table and the second table based on the data analysis expression; and
populate the particular column by executing the data analysis expression, wherein executing the data analysis expression for a particular row of the first table comprises;
receiving a new value for a cell in the first table;
generating a command to calculate a value of the data analysis expression based on the new value;
calculating the value of the data analysis expression based on first data in the particular row of the first table and second data retrieved from the second table based on a filter context associated with the particular row; and
outputting the calculated value at a cell, wherein the cell is a member of the particular column and the particular row.
2 Assignments
0 Petitions
Accused Products
Abstract
Methods and systems are disclosed for receiving and processing data analysis expressions. A particular method includes receiving a data analysis expression at a pivot table of a spreadsheet. The data analysis expression is executed for a particular cell of the pivot table by determining a context associated with the particular cell, calculating a value of the data analysis expression based on the context, and outputting the calculated value at the particular cell.
-
Citations
20 Claims
-
1. A computer-readable hardware storage medium storing instructions, that when executed by a processor, cause the processor to:
-
receive input comprising a column definition of a particular column of a first table, wherein the input includes a data analysis expression based on at least one column of the first table other than the particular column and based on at least one column of a second table; determine a relationship between the first table and the second table based on the data analysis expression; and populate the particular column by executing the data analysis expression, wherein executing the data analysis expression for a particular row of the first table comprises; receiving a new value for a cell in the first table; generating a command to calculate a value of the data analysis expression based on the new value; calculating the value of the data analysis expression based on first data in the particular row of the first table and second data retrieved from the second table based on a filter context associated with the particular row; and outputting the calculated value at a cell, wherein the cell is a member of the particular column and the particular row. - View Dependent Claims (2, 3, 4, 5, 6)
-
-
7. A computer system comprising:
-
one or more computing devices; memory storing one or more components, the one or more components comprising; a data interface component configured to receive data and to store the received data at a data table in a multi-dimensional cube data structure at the memory; a pivot table component configured to generate a pivot table based on the data table; an analysis component configured to; receive a data analysis expression; receive a user input associated with the multi-dimensional cube data structure; and execute the data analysis expression based on receiving the user input for a first cell and a second cell of the pivot table, wherein a first row context is associated with the first cell and a second row context is associated with the second cell, and wherein executing the data analysis expression for the first cell of the pivot table comprises; determining a first row context associated with the first cell; retrieving data associated with one or more rows of the pivot table corresponding to the first row context from the multi-dimensional cube data structure; calculating a value of the data analysis expression based on the retrieved data; and outputting the calculated value at the first cell. - View Dependent Claims (8, 9, 10, 11, 12, 13)
-
-
14. A method executing on one or more processors, the method causing the one or more processors to:
-
receive an input comprising a column definition of a particular column of a first table, wherein the input includes a data analysis expression based on at least one column of a second table from a first data structure and based on at least one column of a third table from a second data structure; determine a relationship between the second table and the third table; and populate the particular column of the first table by executing the data analysis expression, wherein executing the data analysis expression for a particular row of the first table comprises; receiving a user input; calculating a value of the data analysis expression based on the user input, wherein calculating the value based on the user input is based on first data retrieved from the second table and second data retrieved from the third table based on a filter context associated with the particular row; and outputting the calculated value at a cell, wherein the cell is a member of the particular column and the particular row of the first table. - View Dependent Claims (15, 16, 17, 18, 19, 20)
-
Specification