@ISMBR

Function

The @ISMBR() function returns TRUE if the current member matches any one of the specified members.

Syntax

@ISMBR(mbrName | rangeList | mbrList)

mbrNameAny valid single member name or member combination, or a function that returns a single member or member combination.
rangeListA valid member name, a comma-delimited list of member names, member set functions, and range functions from the same dimension.
mbrListA comma-delimited list of members.

If any term returns TRUE, the @ISMBR function returns TRUE.

Notes

Example

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.