Essbase @ATTRIBUTESVAL

Returns, for the current member being calculated, the associated attribute
value from the specified text attribute dimension.

Syntax

@ATTRIBUTESVAL (attDimName)
Parameter Description
attDimName The name of a text attribute dimension.

Notes

  • The @ATTRIBUTESVAL function works only with text attribute
    dimensions. To return values from numeric or date attribute dimensions, use
    the @ATTRIBUTEVAL function.
    To return values from Boolean attribute dimensions, use the @ATTRIBUTEBVAL 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 numeric, Boolean, or date
    attribute, @ATTRIBUTESVAL returns an empty string.
  • 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 Pkg Type text attribute
dimension, as shown in the following example:

Product {Pkg Type}
    100
       100-10 {Pkg Type:Can}
       100-20 {Pkg Type:Can}
       100-30 {Pkg Type:Bottle}
    200
       200-10 {Pkg Type:Bottle}
       200-20 {Pkg Type:Bottle}
       200-30 {Pkg Type:Bottle}
       200-40 {Pkg Type:Bottle}
Pkg Type Attribute {Type: Text}
    Bottle
    Can

For the current member of the base dimension, Product, the function

@ATTRIBUTESVAL(“Pkg Type”)

returns the associated attribute value from the text attribute dimension,
Pkg Type. The following table shows the value that would be returned:

Current Member Return Value
100-10 Can
100-20 Can
100-30 Bottle
100 (empty string)
200-10 Bottle
200-20 Bottle
200-30 Bottle
200-40 Bottle
200 (empty string)
Product (empty string)

For any member that does not have an associated attribute, an empty
string is returned.

See Also

  • @ATTRIBUTEVAL
  • @ATTRIBUTEBVAL