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
Special Examples (errors, null, ...)
XMLA Properties
Find here the value of the XMLA properties when not specified otherwise.