Filter Members Dialog Box (SSAS)
Use the Filter Members dialog box in Business Intelligence Development Studio to filter dimension members by member caption, member name, member unique name, key column value, or value column value for the current level while browsing a dimension in the Browser tab of Dimension Designer.
Options
Term
Definition
Filter expression
Displays a grid of properties, operators, and values used to construct a filter expression.
.gif "ms183723.note(en-US,SQL.90).gif")
Note:
After a row is added, it cannot be removed. You must close and reopen the dialog box to specify a new filter expression.
The grid contains the following columns:
Term
Definition
PropertySelect the property of the member to use for the filter expression.
OperatorSelect the operator to use for the filter expression.
ValueType the value of the property selected in Property to evaluate using the operator specified in Operator.
Test pane
When Test is clicked, this pane displays the members returned by the filter expression. If no members are returned using the criteria specified in Filter expression, a warning is displayed.
Test
Click to test the criteria specified in Filter expression.
See Also
Reference
Analysis Services Designers and Dialog Boxes (SSAS)
Concepts
Browser (Dimension Designer) (SSAS)