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 query associated with a user input;
generating a command to calculate a value of the data analysis expression based on the query;
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. The computer-readable hardware storage medium of claim 1, further storing instructions, that when executed by the processor, cause the processor to:
receive a selection of a subset of rows of the first table; and
automatically re-execute the data analysis expression for the selected subset of rows.
3. The computer-readable hardware storage medium of claim 1, wherein the data analysis expression includes a user-defined formula.
4. The computer-readable hardware storage medium of claim 1, wherein the data analysis expression includes a formula to be aggregated over rows of at least one data table.
5. The computer-readable hardware storage medium of claim 4, wherein the data analysis expression includes at least one aggregation selected from the group consisting of: a sum pivot table aggregation, an average pivot table aggregation, a minimum pivot table aggregation, a maximum pivot table aggregation, and a count pivot table aggregation, wherein the at least one aggregation may be performed for a plurality of expressions other than the data analysis expression.
6. The computer-readable hardware storage medium of claim 1, wherein the relationship includes a related column that is an index column of the first table, an index column of the second table, or any combination thereof.
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 query associated with the multi-dimensional cube data structure; and
execute the data analysis expression based on receiving the query 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.
8. The computer system of claim 7, wherein the memory is a random access memory (RAM).
9. The computer system of claim 7, wherein the multi-dimensional cube data structure is an online analytical processing (\u201cOLAP\u201d) cube data structure.
10. The computer system of claim 7, wherein the data analysis expression includes a user-defined formula.
11. The computer system of claim 7, further comprising automatically re-executing the data analysis expression in response to a pivot operation of the pivot table.
12. The computer system of claim 7, wherein the data analysis expression includes a reference to a column of at least one data table, wherein the reference to the column resolves to the column when the reference is used in a column calculation, and wherein the reference to the column resolves to a value stored at a particular row of the column when the reference is used in a scalar calculation.
13. The computer system of claim 7, wherein determining the context associated with the first cell includes filtering based on the first cell.
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 query associated with a user input;
calculating a value of the data analysis expression based on the query, wherein calculating the value based on the query 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.
15. The method of claim 14 wherein the first data structure is an online analytical processing (\u201cOLAP\u201d) cube.
16. The method of claim 14, wherein the method further causes the one or more processors to:
receive a selection of a subset of the particular row of the first table; and
automatically re-execute the data analysis expression for the subset of the particular row of the first table.
17. The method of claim 14, wherein the data analysis expression includes a formula.
18. The method of claim 17, wherein the data analysis expression includes a formula associated with at least one aggregation, wherein the at least one aggregation is selected from the group consisting of: a sum pivot table aggregation, an average pivot table aggregation, a minimum pivot table aggregation, a maximum pivot table aggregation, and a count pivot table aggregation.
19. The method of claim 14, wherein the data analysis expression includes at least one time-based function.
20. The method of claim 14, wherein the data analysis expression includes a related table function, a relatedtable table function, a filter table function, a distinct table function, a values table function, an all table function, an allexcept table function, an allnoblankrow table function, or any combination thereof.
21. A system comprising:
one or more processors;
one or more memory components storing computer-executable instructions embodied thereon that, when executed by one or more processors, enable:
receiving a first input comprising a column definition of a particular column of a first table, wherein the first 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;
identifying a relationship between the second table and the third table; and
populating 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 query associated with a second input, wherein the second input is a user input;
calculating a value of the data analysis expression 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, in response to the query; 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.
22. The system of claim 21 wherein the first data structure is an online analytical processing (\u201cOLAP\u201d) cube.
23. The system of claim 21, wherein the system further comprises one or more memory components storing computer-executable instructions embodied thereon that, when executed by one or more processors, enable:
receiving a selection of a subset of the particular row of the first table; and
automatically re-executing the data analysis expression for the subset of the particular row of the first table.
24. The system of claim 21, wherein the data analysis expression includes a formula.
25. The system of claim 21, wherein the data analysis expression includes a formula associated with at least one aggregation, wherein the at least one aggregation is selected from the group consisting of: a sum pivot table aggregation, an average pivot table aggregation, a minimum pivot table aggregation, a maximum pivot table aggregation, and a count pivot table aggregation.
26. The system of claim 21, wherein the data analysis expression includes at least one time-based function.
27. The system of claim 21, wherein the data analysis expression includes a related table function, a relatedtable table function, a filter table function, a distinct table function, a values table function, an all table function, an allexcept table function, an allnoblankrow table function, or any combination thereof.
28. A computer-readable hardware storage medium comprising instructions that, when executed by one or more processors, cause the one or more processors to:
receive a first input comprising a column definition of a particular column of a first table, wherein the first 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 query associated with a second input, wherein the second input is a user input;
based on the query, calculating a value of the data analysis expression that 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.
29. The computer-readable hardware storage medium of claim 28 wherein the first data structure is an online analytical processing (\u201cOLAP\u201d) cube.
30. The computer-readable hardware storage medium of claim 28, further comprising instructions, that when executed by one or more processors, cause the one or more processors to:
receive a selection of a subset of the particular row of the first table; and
automatically re-execute the data analysis expression for the subset of the particular row of the first table.
31. The computer-readable hardware storage medium of claim 28, wherein the data analysis expression includes a formula.
32. The computer-readable hardware storage medium of claim 28, wherein the data analysis expression includes a formula associated with at least one aggregation, wherein the at least one aggregation is selected from the group consisting of: a sum pivot table aggregation, an average pivot table aggregation, a minimum pivot table aggregation, a maximum pivot table aggregation, and a count pivot table aggregation.
33. The computer-readable hardware storage medium of claim 28, wherein the data analysis expression includes at least one time-based function.
34. The computer-readable hardware storage medium of claim 28, wherein the data analysis expression includes a related table function, a relatedtable table function, a filter table function, a distinct table function, a values table function, an all table function, an allexcept table function, an allnoblankrow table function, or any combination thereof.
The claims below are in addition to those above.
All refrences to claim(s) which appear below refer to the numbering after this setence.
1. A multi-plate extrusion die for producing a multi-component extrusion having an upstream and a downstream direction, comprising:
a primary aperture extending in the downstream direction for a primary extrudate fed from a primary extruder, the primary extrudate being formed by the primary aperture into substantially a final shape of the multi-component extrusion, the primary extrudate having a prong mounting face and having a non-prong surface,
a base capstocking conduit for a capstocking extrudate
fed from a capstocking extruder where the base capstocking conduit joins with the primary aperture and applies a base capstocking layer on the prong mounting face of the primary extrudate,
a prong capstocking conduit for the capstocking extrudate fed from the capstocking extruder, where the prong capstocking conduit forms a prong and where the prong capstocking conduit joins with the primary aperture downstream of the base capstocking conduit and attaches a base end of the prong to the base capstocking layer on the prong mounting face of the primary extrudate.
2. The multi-plate extrusion die of claim 1, wherein
the base capstocking conduit joins with the primary aperture and applies the capstocking layer on the non-prong portion of the primary extrudate.
3. The multi-plate extrusion die of claim 1, further comprising,
a surface capstocking conduit joins with the primary aperture and applies the capstocking extrudate to the non-prong surface of the primary extrudate.
4. The multi-plate extrusion die of claim 1, wherein the primary extrudate is a thermoplastic resin formed into a hollow, thin walled extrusion.
5. The multi-plate extrusion die of claim 4, wherein the thermoplastic resin is PVC resin.
6. The multi-plate extrusion die of claim 1, wherein the primary extrudate is a foamed thermoplastic resin.
7. The multi-plate extrusion die of claim 6, wherein the thermoplastic resin is a foamed PVC resin.
8. The multi-plate extrusion die of claim 6, wherein the thermoplastic resin is a foamed SAN resin.
9. The multi-plate extrusion die of claim 1, wherein the capstocking extrudate is a PVC resin.
10. A method for producing a multi-component extrusion, comprising:
forming a primary extrudate within a multi-plate extrusion die fed from a primary extruder into a substantially final shape of the multi-component extrusion, such primary extrudate having a prong mounting face and having a non-prong surface,
applying a base capstocking layer of a capstocking extrudate on the prong mounting face of the primary extrudate within the multi-plate extrusion die with a capstocking extruder,
forming a prong within the multi-plate extrusion die of capstocking extrudate from a capstocking extruder,
attaching the prong to the base capstocking layer within the multi-plate extrusion die.
11. The method of claim 10, wherein the primary extrudate is a thermoplastic resin and is formed into a hollow, thin walled extrusion.
12. The method of claim 10, wherein the thermoplastic resin is a PVC resin.
13. The method of claim 10, wherein the primary extrudate is a foamed thermoplastic resin and is formed into a solid extrusion.
14. The method of claim 13, wherein the foamed thermoplastic resin is foamed SAN resin.
15. The method of claim 14, wherein the foamed thermoplastic resin is foamed PVC resin.
16. The method of claim 10, wherein the capstocking extrudate is a PVC resin.
17. The method of claim 10, further comprising applying a capstocking layer of the capstocking extrudate to the non-prong surface of the primary extrudate within the multi-plate extrusion die with the capstocking extruder.
18. A multi-component extrusion having a snap-in connector prong, comprising:
a primary extrudate of a predetermined shape having a prong mounting face and a non-prong surface,
a base capstocking layer formed of a capstocking extrudate on the prong mounting face of the primary extrudate,
a prong for use as a snap-in connector where the prong is formed of the capstocking extrudate and is attached to the base capstocking layer.
19. The multi-component extrusion of claim 18, wherein the primary extrudate is a hollow, thin walled extrusion formed of thermoplastic resin.
20. The multi-component extrusion of claim 19, wherein the thermoplastic resin is a PVC resin.
21. The multi-component extrusion of claim 18, wherein the primary extrudate is a solid foamed extrusion formed from a foamed thermoplastic resin.
22. The multi-component extrusion of claim 21, wherein the foamed thermoplastic resin is foamed SAN resin.
23. The multi-component extrusion of claim 22, wherein the foamed thermoplastic resin is foamed PVC resin.
24. The multi-component extrusion of claim 18, wherein the capstocking extrudate is a PVC resin.
25. The multi-component extrusion of claim 18, further comprising a second prong for use as the snap-in connector where the second prong is formed of the capstocking extrudate and is attached to the base capstocking layer.