Attribute
The MDX Attribute function for Essbase returns all base members that are associated with a specified attribute member.
Syntax
Attribute ( member )Parameters
- member
-
Specification of a member from an attribute dimension.
Example
The following query
SELECT
{[Year].Children}
ON COLUMNS,
Attribute ([Ounces_12])
ON ROWS
FROM Sample.Basicreturns the grid:
Table 4-37 Output Grid from MDX Example
| (axis) | Qtr1 | Qtr2 | Qtr3 | Qtr4 |
|---|---|---|---|---|
| Cola | 5096 | 5892 | 6583 | 5206 |
| Diet Cola | 1359 | 1534 | 1528 | 1287 |
| Old Fashioned | 1697 | 1734 | 1883 | 1887 |
| Sarsaparilla | 1153 | 1231 | 1159 | 1093 |
| Diet Cream | 2695 | 2723 | 2855 | 2820 |
See Also