Filter (MDX)

Filters the specified set elements according to the filtering condition.

Parameters

Name	Type	Cardinality	Default value
	set-expression
	boolean-expression
limit	value-expression	zero-one

Return

set

Description

Returns a subset of the specified set based on the filtering condition.

Only elements that satisfy the filter condition are included in the result set.

The third parameter, if defined, limits the number of returned tuples or members.

Examples

Filter(member-set,condition)

Filter(member-set,condition,limit)

Special Examples (errors, null, ...)

Filter({},condition), Filter(NULL,condition)

Filter(member-set, string)

XMLA Properties

Find here the value of the XMLA properties when not specified otherwise.