@ISMBR

The @ISMBR calculation function for Essbase tests whether a member is a match for any of the specified members. It returns TRUE if the current member being calculated matches any one of the specified members within a list or range.

Syntax

@ISMBR (mbrName | rangeList | mbrList)

Parameters

mbrName: Any valid single member name or member combination, or a function that returns a single member or member combination.
rangeList: A valid member name, a comma-delimited list of member names, member set functions, and range functions.
mbrList: A comma-delimited list of members.

Notes

If a cross-dimensional (->) member is included, that term evaluates as TRUE only if all the components of the cross-dimensional member match the current member list.

If any term returns TRUE, this function returns TRUE.

Example

In the Sample Basic database:

@ISMBR("New York":"New Hampshire")

Returns TRUE for Florida.

@ISMBR(@CHILDREN(Qtr1))

Returns FALSE for Qtr2, Year.