Returns, for the current member being calculated, the associated attribute value from the specified Boolean attribute dimension.
Syntax
@ATTRIBUTEBVAL (attDimName)
Parameter | Description |
---|---|
attDimName | The name of a Boolean attribute dimension. |
Notes
The @ATTRIBUTEBVAL function works only with Boolean attribute dimensions. To return values from numeric or date attribute dimensions, use this @ATTRIBUTEVAL function. To return values from text attribute dimensions, use the @ATTRIBUTESVAL function. For more information on types of attributes, see the Oracle Essbase Database Administrator's Guide.
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, @ATTRIBUTEBVAL 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.
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 any member that does not have an associated attribute, #MISSING is returned. Only one value is returned at a time.
See Also