The @ISMBR() function returns TRUE if the current member matches any one of the specified members.
@ISMBR(mbrName | rangeList | mbrList)
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 from the same dimension. |
mbrList | A comma-delimited list of members. |
If any term returns TRUE, the @ISMBR function returns TRUE.
In the Sample Basic database:
@ISMBR("New York":"New Hampshire") TRUE for Florida @ISMBR(@CHILDREN(Qtr1)) FALSE for Qtr2, Year
Copyright (c)1991-2000 Hyperion Solutions Corporation. All rights reserved.