@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)

Parameters

mbrName: Name of a member in the outline (or an expression returning a member name)

Example

For the following examples, assume the following outline hierarchy exists:

Market dimension member East expanded to reveal Massachusetts with child members Springfield, Salem, and Boston.

@MBRPARENT("Salem")

returns Massachusetts.


FIX(Actual, Jan, "100-10")
Sales (
IF (@ISLEV("Market", 0))
	@MBRPARENT(@CURRMBR("Market")) / @COUNT(SKIPNONE,@CHILDREN(@MBRPARENT(@CURRMBR("Market"))));
ENDIF
)
ENDFIX

The calculation script distributes the value of Massachusetts equally among Springfield, Salem, and Boston.