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 |
---|---|
The top member of an attribute dimension. | |
character_string_literal | An operator. Must be enclosed in double quotation marks. The following operators are supported:
|
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 |
See Also