Returns TRUE if the member has the associated UDA tag (user-defined attribute).
Syntax
IsUda ( member , string_value_expression )
Parameter | Description |
---|---|
A member specification. | |
string_value_expression | A user-defined attribute (UDA) name string, defined in the database outline. |
Example
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
East | New York | Massachusetts | Florida | California | Texas | Central | Illinois | Ohio | Colorado |
---|---|---|---|---|---|---|---|---|---|
24161 | 8202 | 6712 | 5029 | 12964 | 6425 | 38262 | 12577 | 4384 | 7227 |