Returns TRUE if the member has the associated UDA tag (user-defined attribute).
IsUda ( member , character_string_literal )
member | A member specification. |
character_string_literal | A user-defined attribute (UDA) name string, defined in the database outline. |
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 |
©2004 Hyperion Solutions Corporation. All Rights Reserved. http://www.hyperion.com |