Returns, for the current member being calculated, the associated attribute value from the specified text attribute dimension.
@ATTRIBUTESVAL (attDimName)
attDimName | The name of a text attribute dimension. |
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.
©2004 Hyperion Solutions Corporation. All Rights Reserved. http://www.hyperion.com |