ATTRIBUTEVA
The Essbase Report Writer ATTRIBUTEVA command 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.
Syntax
<ATTRIBUTEVA (attMbrName, options, startTuple[, endTuple])
Parameters
- 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))