IsUda

The MDX IsUda function for Essbase returns TRUE if the member has the associated UDA tag (user-defined attribute).

Syntax

IsUda ( member , string_value_expression )

Parameters

member: A member specification.
string_value_expression: A user-defined attribute (UDA) name string, defined in the outline.

Example

The following expression:

IsUda([Market].CurrentMember, "Major Market")

returns TRUE if the current member of the Market has the user-defined attribute "Major Market."

Therefore, the following query:

SELECT
 Filter([Market].Members, IsUda([Market].CurrentMember, "Major Market"))
ON COLUMNS
FROM Sample.Basic

returns the following output:

Table 4-98 Output Grid from MDX Example

East	New York	Massachusetts	Florida	California	Texas	Central	Illinois	Ohio	Colorado
24161	8202	6712	5029	12964	6425	38262	12577	4384	7227