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