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

Filter

SQL Server 2000

Filter

Returns the set resulting from filtering a specified set based on a search condition.

Syntax

Filter(«Set», «Search Condition»)

Remarks

The Filter function evaluates a Multidimensional Expressions (MDX) logical expression, specified in «Search Condition», against each member of the set specified in «Set», returning the set of members that met the search condition.

The Filter function works in a fashion similar to that of the IIf function. While the IIf function returns only one of two options based on the evaluation of an MDX logical expression, the Filter function returns a set of members that meet the specified search condition. In effect, the Filter function executes IIf(«Search Criteria», «Member», NULL) on each member in the set and returns the resulting set. If none of the members meet the search condition, an empty set is returned.

Example

The following example returns {Paris, Buffalo} if these cities declined in sales from the 1995 to the 1996 level:

Filter(SampleSet, (Sales,[1996]) < (Sales, [1995]))

See Also

IIf

Show:
© 2015 Microsoft