WithAttr

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

Syntax

WithAttr ( member, character_string_literal, value_expression )

Parameter	Description
member	The top member of an attribute dimension.
character_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
value_expression	An attribute value described by a value expression. The expression must evaluate to a numeric value for numeric/date attributes and must evaluate to a string for text valued attributes. Can also be an exact character string (not case-sensitive) enclosed in double quotation marks.

Parameter

Description

member

The top member of an attribute dimension.

character_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

value_expression

An attribute value described by a value expression. The expression must evaluate to a numeric value for numeric/date attributes and must evaluate to a string for text valued attributes. Can also be an exact character string (not case-sensitive) 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