Syntax

Uda ( dimension | member, string_value_expression )

Parameters

dimension

The dimension in which matching UDAs are searched.

member

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.

Examples

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 MDX 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])

The above query returns the following output:

Member Example

In the following MDX 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: