In the CubeQuery section, the measure dimension is handled like any other dimension (it can be placed in rows or columns), but a separate results set column is created for each Measure member, whether it is in a row, column, or filter.
Table 53. Measures in CubeQuery
| Qtr1 | Qtr2 | ||
|---|---|---|---|
| Sales | Cola | 14585 | 16048 |
| Diet Cola | 7276 | 7957 | |
| COGS | Cola | 5681 | 6136 |
| Diet Cola | 3496 | 3871 | |
| Caffeine Free Cola | 1493 | 1606 |
Table 54. Measures in Results Set
| Product SKU | Quarter | Sales | COGS |
|---|---|---|---|
| Cola | Qtr1 | 14585 | 5681 |
| Diet Cola | Qtr1 | 7276 | 3496 |
| Caffeine Free Cola | Qtr1 | 3187 | 1493 |
If no Measures are in the row, column or filter, all data values appear in a Value column.