Returns all base-dimension members associated with a specified varying attribute member. This command allows querying of the base member list given the attribute member-dimension and the perspective setting.
Note: | For use only in applications enabled with varying attributes. |
Syntax
<ATTRIBUTEVA (attMbrName, options, startTuple[, endTuple])
Parameter | Description |
---|---|
attrMbrName | The name of a member of a varying attribute dimension. |
options | ANY |
startTuple[, endTuple] | (m1, m2, ..., mN) Level-0 members from one or more independent dimensions for attrMbrName may be part of the input tuple. Members from all independent dimensions should be listed. If a member is not listed, the member of the same dimension from the current query or calculation context is used. |
Notes
When attrMbrName is a non level-0 member of an attribute dimension, Essbase returns all base-dimension members associated with its children.
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, <ATTRIBUTEVA 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 <ATTRIBUTEVA command, specify the full name of the attribute (for example, <ATTRIBUTE 12_Ounces).
Example
<AttributeVa([Ounces_12], ANY, (Jan), (Feb)) <AttributeVa([Ounces], ANY, (Jan))
See Also