Returns all base members that are associated with an attribute member of the specified type.
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:
|
||||||||||||||
| 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. |
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 |