@MBRPARENT
The @MBRPARENT calculation function for Essbase returns the parent of the specified member.
This function can be used on unique and duplicate-name outlines.
Syntax
@MBRPARENT (mbrName)Example
The following examples are based on the following duplicate-name outline:
Product
100
100–10
100–10–10
100–20
100–30
200
200–10
200–20
200–30
300
300–10
300–20
Diet
100–10
100–10–11
200–10
300–10
Bottle
200–10
300–20@MBRPARENT ("100-10", "Product")Returns the member 100.
@MBRPARENT("100-10-11")Returns the member [Diet].[100-10].