@ATTRIBUTEBVAL

The @ATTRIBUTEBVAL calculation function for Essbase returns a member's Boolean attribute value.

This function returns, for the current member being calculated, the associated attribute value from the specified Boolean attribute dimension.

Syntax

@ATTRIBUTEBVAL (attDimName)

Parameters

attDimName: The name of a Boolean attribute dimension.

Notes

This function works only with Boolean attribute dimensions. To return values from numeric or date attribute dimensions, use @ATTRIBUTEVAL. To return values from text attribute dimensions, use @ATTRIBUTESVAL.
If no attribute is associated with the member being calculated or if the attribute associated with the member is a text, numeric, or date attribute, this function returns #MISSING.
Only level 0 members of attribute dimensions can be associated as attributes of members of a base dimension.

Example

This example is based on the Sample Basic database.

The Product dimension is associated with the Caffeinated Boolean attribute dimension, as shown in the following example:

Product {Caffeinated}
    100
       100-10 {Caffeinated:True}
       100-20 {Caffeinated:True}
       100-30 {Caffeinated:False}
    200
       200-10 {Caffeinated:True}
       200-20 {Caffeinated:True}
       200-30 {Caffeinated:False}
       200-40 {Caffeinated:False}
Caffeinated Attribute {Type: Boolean}
    True
    False

For the current member of the base dimension Product, the function @ATTRIBUTEBVAL(Caffeinated) returns the associated attribute value from the Boolean attribute dimension, Caffeinated. The following table shows the value that would be returned.

Table 3-15 Value Returned by @ATTRIBUTEBVAL(Caffeinated) Function

Current Member	Return Value
100-10	True
100-20	True
100-30	False
100	#MISSING
200-10	True
200-20	True
200-30	False
200-40	False
200	#MISSING
Product	#MISSING

For any member that does not have an associated attribute, #MISSING is returned. Only one value is returned at a time.