Filter (MDX)

Filter

(MDX)

Filters the specified set elements according to the filtering condition.

Parameters

Name	Type	Cardinality	Default value
	set-expression
	logical-expression

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.

Examples

Filter(member-set,condition)

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.

Documentation