@ISMBRUDA

The @ISMBRUDA calculation function for Essbase tests whether a member has a certain UDA.

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

Syntax

@ ISMBRUDA(mbrName, UDAStr)

Parameters

mbrName

Any valid single member name, or a function that returns a single member.

UDAStr

User-defined attribute (UDA) name string.

Notes

If you specify a nonexistent member name, the calculation script verification fails.

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.