Selects all members that have a specified user-defined attribute associated in the entire dimension or in a subtree rooted at the input member.
Uda ( dimension | member, character_string_literal )
dimension | The dimension in which to search for matching UDAs. |
member | A member to search (descendants included) for matching UDAs. |
character_string_literal |
An exact character string (not case-sensitive) representing the name of the UDA to select.
Must be enclosed in double quotation marks. For example, "Major Market" .
|
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.
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])
Sales | Profit | |
---|---|---|
East | 2248 | 1156 |
New York | 912 | 370 |
Massaachusetts | 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:
Sales | Profit | |
---|---|---|
East | 2248 | 1156 |
New York | 912 | 370 |
Massachusetts | 665 | 564 |
Florida | 286 | 104 |
©2004 Hyperion Solutions Corporation. All Rights Reserved. http://www.hyperion.com |