Member Relationship Functions

Essbase member relationship functions allow you to use the member combination that Essbase is currently calculating to look up specific values.

Table 18-5 List of Member Relationship Functions

Function	Look-up Value
@ANCESTVAL	Ancestor values of the specified member combination
@ATTRIBUTEVAL	Numeric value of the attribute from the specified numeric or date attribute dimension associated with the current member
@ATTRIBUTESVAL	Text value of the attribute from the specified text attribute dimension associated with the current member
@ATTRIBUTEBVAL	Value (TRUE or FALSE) of the attribute from the specified Boolean attribute dimension associated with the current member
@CURGEN	Generation number of the current member combination for the specified dimension
@CURLEV	Level number of the current member combination for the specified dimension
@GEN	Generation number of the specified member
@LEV	Level number of the specified member
@MDANCESTVAL	Ancestor values of the specified member combination across multiple dimensions
@SANCESTVAL	Shared ancestor values of the specified member combination
@PARENTVAL	Parent values of the specified member combination
@MDPARENTVAL	Parent values of the specified member combination across multiple dimensions
@SPARENTVAL	Shared parent values of the specified member combination
@XREF	Data value from another database to be used for calculation of a value from the current database
@XWRITE	Used to write values to another Essbase database, or to the same database