Essbase Relationship Functions

Relationship functions look up specific values within the database based
on current cell location and a series of parameters. You can use these functions
to refer to another value in a data series. Relationship functions have an
implicit current member argument; that is, these functions are dependent on
the current member’s position.

In the following quick-reference table, words in italics loosely represent
information you supply to the function. For details, see the individual function
topics.

Function Return Value
@ANCESTVAL Ancestor values of a specified one-dimensional
member combination
.
@ATTRIBUTEBVAL Associated attribute value from a Boolean attribute
dimension
.
@ATTRIBUTESVAL Associated attribute value from a text attribute
dimension
.
@ATTRIBUTEVAL Associated attribute value from a numeric or
date attribute dimension
.
@CURGEN Generation number of the current member in dimension.
@CURLEV Level number of the current member in dimension.
@GEN Generation number of member.
@LEV Level number of member.
@MDANCESTVAL Ancestor values for any number of multidimensional
member combinations
.
@MDPARENTVAL Parent values for any number of multidimensional
member combinations
.
@PARENTVAL Parent values for member in dimension.
@SANCESTVAL Ancestor values for shared members at a certain depth under root member.
@SPARENTVAL Parent values for shared members under root
member
.
@XREF Values from a different database than
the one being calculated.