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