Returns, for the current member being calculated, the associated attribute value from the specified numeric or date attribute dimension.
@ATTRIBUTEVAL (attDimName)
attDimName | Single dimension specification for a numeric or date attribute dimension. |
#MISSING
.
Example 1
The following example is based on the Sample Basic database:
"Profit Per Ounce" = Profit/@ATTRIBUTEVAL(@NAME(Ounces));
In this formula, for the current member being calculated, @ATTRIBUTEVAL returns the associated attribute from the Ounces numeric attribute dimension. For example, if the member being calculated is Cola and if the Ounces attribute value associated with Cola is 12, @ATTRIBUTEVAL returns 12. The value returned is then divided into Profit to yield Profit Per Ounce.
Note: The @NAME function is required to process the string “Ounces” before passing it to the @ATTRIBUTEVAL function.
This example produces the following report:
Actual Year West Profit Profit Per Ounce ======== ================ Cola 4593 382.75
Example 2
The following MaxL execute calculation
statement applies a formula to members that are 16 Oz products:
execute calculation 'Misc ( IF (@ATTRIBUTEVAL(Ounces) == 16) Misc = .5; ENDIF; );' on sample.basic;
@ATTRIBUTEBVAL
@ATTRIBUTESVAL
@NAME
@TODATE
©2004 Hyperion Solutions Corporation. All Rights Reserved. http://www.hyperion.com |