Uda

Selects all members that have a specified user-defined attribute associated in the entire dimension or in a subtree rooted at the input member.

Syntax

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

Description

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