@ISMBR

The @ISMBR calculation function for Essbase tests whether a member is a match for any of the specified members.

This function 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.