Separate columns for metadata labels are displayed for each Essbase generation in the hierarchy.
Table 49. CubeQuery Requested Items (Profit Member Applied In the Filter)
| Product | Qtr1 | Qtr2 | Qtr3 | Qtr4 |
|---|---|---|---|---|
Cola | 5096 | 5892 | 6583 | 5206 |
Diet Cola | 1359 | 1534 | 1528 | 1287 |
Caffeine Free Cola | 593 | 446 | 400 | 544 |
| Cola | 7048 | 7872 | 8511 | 7037 |
Old Fashioned | 1697 | 1734 | 1883 | 1887 |
Diet Root Beer | 2963 | 3079 | 3149 | 2834 |
Sarsaparilla | 1153 | 1231 | 1159 | 1093 |
Birch Beer | 908 | 986 | 814 | 1384 |
| Root Beer | 6721 | 7030 | 7005 | 7198 |
Table 50. Results Set
| Category | Product SKU | Year | Profit |
|---|---|---|---|
| Colas | Cola | Qtr1 | 5096 |
| Colas | Diet Cola | Qtr1 | 1359 |
| Colas | Caffeine Free Cola | Qtr1 | 593 |
| Root Beer | Old Fashioned | Qtr1 | 1697 |
| Root Beer | Diet Root Beer | Qtr1 | 2963 |
| Root Beer | Sarsaparilla | Qtr1 | 1153 |
| Root Beer | Birch Beer | Qtr1 | 908 |
If only one generation of the hierarchy is in the query, additional columns do not show the parent members in the Results section as shown below:
Table 51. CubeQuery Requested Items (Profit Member is in the Columns)
| Qtr1 | Qtr2 | Qtr3 | Qtr4 | |
|---|---|---|---|---|
| Profit | Profit | Profit | Profit | |
| Cola | 5096 | 5892 | 6583 | 5206 |
| Diet Cola | 1359 | 1534 | 1528 | 1287 |
| Caffeine Free Cola | 593 | 446 | 400 | 544 |
| Old Fashioned | 1697 | 1734 | 1883 | 1887 |
| Diet Root Beer | 2963 | 3079 | 3149 | 2834 |
| Sarsaparilla | 1153 | 1231 | 1159 | 1093 |
| Birch Beer | 908 | 986 | 814 | 1384 |
| Dark Cream | 2544 | 3231 | 3355 | 3065 |