ATTRIBUTEVA

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])

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))