@ISMBRUDA

Returns TRUE if the specified user-defined attribute (UDA) exists for the specified member at calculation time.

Syntax

@ ISMBRUDA(mbrName, UDAStr)
Parameter Description
mbrName Valid member name or member combination, or a function that returns a member or member combination.
UDAStr User-defined attribute (UDA) name string.

Notes

If a nonexistent member name is specified, calculation script verification fails with an error code.

Example

The following examples use the Sample.Basic database.

@ISMBRUDA (“New York”, “Major Market”) and @ISMBRUDA([Market].[New York], “Major Market”) both return true.

@ISMBRUDA(“New York”, “Small Market”) AND @ISCHILD(“Market”)

Because “New York” is not a small market, the first condition returns false.

IF(@ISMBRUDA(“New York”)

Because UDAStr is omitted, the verification fails.