fbpx

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.