Returns all base-dimension members associated with a specified attribute.
Syntax
<ATTRIBUTE attMbrName| Parameter | Description |
|---|---|
attrMbrName | The name of a member of an attribute dimension. |
Notes
When attrMbrName is a non level-0 member of an attribute dimension, Essbase returns all base-dimension members associated with its children. For example, in the Sample Basic database, <ATTRIBUTE Large returns all base-dimension members associated with any children of the attribute parent Large.
With Boolean attributes, if you specify a Boolean dimension name (for example, Caffeinated), Essbase returns all base-dimension members associated with either Caffeinated member (for example, True or False). To return only one or the other, specify that member name (for example, <ATTRIBUTE Caffeinated_True).
Your outline may contain duplicate Boolean, date, and numeric attribute-dimension member names; for example, 12 can be the attribute value for the size (in ounces) of a product as well as the value for the number of packing units for a product. To distinguish duplicate member names with the <ATTRIBUTE command, specify the full name of the attribute (for example, <ATTRIBUTE 12_Ounces).
Example
<ATTRIBUTE Red
returns all base-dimension members associated with the member Red of the specified attribute dimension.
<PAGE (Market, Measures, Scenario)
South Sales Actual
<COLUMN (Year)
<ICHILDREN Year
{OUTALTNAMES}
<ATTRIBUTE Ounces_12
!returns on rows only the names of the drinks that are associated with the member Ounces_12 on the corresponding attribute dimension:
South Sales Actual
Qtr1 Qtr2 Qtr3 Qtr4 Year
======== ======== ======== ======== ========
Cola 2,296 2,509 2,975 2,824 10,604
Diet Cola 1,436 1,569 1,482 1,189 5,676
Old Fashioned 1,686 1,625 1,773 1,840 6,924
Sasparilla 1,862 1,938 1,830 1,921 7,551
Diet Cream 1,241 1,255 1,378 1,593 5,467 See Also