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 |