How does a pivoting tray relate to a summary table with OLAP cubes?
When the pivoting tray first appears, the grouping variables are layers are listed in the summary table with selection buttons to select any category of any grouping variable. The row(s) at the bottom of the summary table contain the summary variable(s) selected, and the columns of these rows contain the summary statistics such as mean and percent of total N selected. Note: if students experiment with the pivoting tray, they will learn that the grouping variables, summary variables, and statistics can be moved into virtually any configuration of layers, rows, and columns. 6. Describe how the OLAP cube summary table can be used to mine data. Use the selection button to select various combinations of the categories of the grouping variables (for example older couples without children), and look at the variables of interest (such as the mean). By doing this for several combinations, the largest or smallest value will be identified. Note: OLAP cubes have a great deal more power than is imp
Related Questions
- I would like to calculate energy depositions in a calorimeter; something like the summary table that FLUKA prints out at the end. How can I do it?
- Does dbSNP use the summary of genotypes table to produce the submitted frequency table, or vice versa?
- Is the tax gross-up payment reportable in the Summary Compensation Table in year 1?
