Essbase @ATTRIBUTEBVAL

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

  • @ATTRIBUTEVAL
  • @ATTRIBUTESVAL