An MDX Question?
OLAP Server User Guide
Configuring icCube
Running icCube
Migrating icCube
Security
Creating Schemas/Cubes
Working with icCube
Reporting Tools Integration
Embedding icCube
Plugins/Extensions
HOWTO
Web Reporting
Web App Integration
Installation
Local Settings
Displaying a Report
Visualization Library
Tutorials
Demos
MDX Documentation
MDX Tutorial (Gentle Introduction)
MDX Functions Reference
MDX Language Reference
MDX OO Extensions
JAVA Integration
R Integration
Reference
icCube Client Library
XMLA Client Library
Filter (standard 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.

icCube OLAP version: 3.0.3 03-Mar-2013 14:06:07 GMT