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