WithAttr

Returns all base members that are associated with an attribute member of the specified type.

Syntax

WithAttr ( member, STRING_LITERAL, [ signed_numeric_literal | character_string_literal ] )

member The top member of an attribute dimension.
STRING_LITERAL An operator. Must be enclosed in double quotation marks.

The following operators are supported:

> Greater than
>= Greater than or equal to
< Less than
<= Less than or equal to
= = Equal to
<> or != Not equal to
IN In
signed_numeric_literal An attribute described by numeric characters; for example, "16". Must be enclosed in double quotation marks.
character_string_literal An attribute described by alphabetic characters; for example, "Can". Must be enclosed in double quotation marks.

Example

The following query

SELECT
 Withattr([Pkg Type], "==", "Can")
on columns
FROM Sample.Basic

returns products that are packaged in a can:

Cola Diet Cola Diet Cream
22777 5708 11093

©2004 Hyperion Solutions Corporation. All Rights Reserved.
http://www.hyperion.com