Selects all members to which a specified user-defined attribute is associated in the entire dimension or in a subtree rooted at the input member.
Syntax
Uda ( dimension | member, string_value_expression )
Parameter | Description |
---|---|
The dimension in which matching UDAs are searched. | |
A member to search (descendants included) for matching UDAs. | |
string_value_expression | The name of the UDA to be selected. Can be an expression that evaluates to the UDA string, or an exact character string (not case-sensitive) enclosed in double quotation marks. |
Notes
A user-defined attribute is a term associated with members of an outline to describe a characteristic. This function selects all members that have the specified UDA.
Example
Dimension Example
In the following query, the Uda function searches a dimension (top member included) for descendant members having a UDA of Major Market:
SELECT {[Measures].[Sales], [Measures].[Profit]} ON COLUMNS, {UDA([Market], "Major Market")} ON ROWS FROM Sample.Basic WHERE ([Year].[Jul], [Product].[Cola])
(axis) | Sales | Profit |
---|---|---|
East | 2248 | 1156 |
New York | 912 | 370 |
Massachusetts | 665 | 564 |
Florida | 286 | 104 |
California | 912 | 370 |
Texas | 567 | 206 |
Central | 1392 | 369 |
Illinois | 567 | 208 |
Ohio | 85 | 18 |
Colorado | 199 | 70 |
returning the grid:
Member Example
In the following query, the Uda function searches a member (itself included) for descendant members having a UDA of Major Market:
SELECT {[Measures].[Sales], [Measures].[Profit]} ON COLUMNS, {UDA([East], "Major Market")} ON ROWS FROM Sample.Basic WHERE ([Year].[Jul], [Product].[Cola])
returning the grid:
(axis) | Sales | Profit |
---|---|---|
East | 2248 | 1156 |
New York | 912 | 370 |
Massachusetts | 665 | 564 |
Florida | 286 | 104 |