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 |