Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
Export (0) Print
Expand All
Expand Minimize

Filter Members Dialog Box (Analysis Services - Multidimensional Data)

Topic Status: Some information in this topic is preview and subject to change in future releases. Preview information describes new features or changes to existing features in Microsoft SQL Server 2016 Community Technology Preview 2 (CTP2).

Use the Filter Members dialog box in SQL Server Data Tools (SSDT) 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.



Filter expression

Displays a grid of properties, operators, and values used to construct a filter expression.

Note 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:




Select the property of the member to use for the filter expression.


Select the operator to use for the filter expression.


Type 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.


Click to test the criteria specified in Filter expression.

Community Additions

© 2015 Microsoft