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 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.Basicreturns
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 |