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