Skip to main content

DashboardOlapDataSource.Filter Property

Gets or sets the logical expression to be applied to the data for filtering.

Namespace: DevExpress.DashboardCommon

Assembly: DevExpress.Dashboard.v22.2.Core.dll

NuGet Packages: DevExpress.Dashboard.Core, DevExpress.Win.Dashboard.Design


public string Filter { get; set; }

Property Value

Type Default Description
String null

A String value specifying the logical expression to be applied to the data for filtering.


Use dimension attribute unique names to refer to OLAP fields.

The code below shows how to set a filter criteria for the Calendar Year, Category, and Subcategory fields:

olapDataSource.Filter = CriteriaOperator.And(
    new BinaryOperator("[Date].[Calendar Year].[Calendar Year]", "[Date].[Calendar Year].&[2001]"),
    new BinaryOperator("[Product].[Product Categories].[Category]", "[Product].[Product Categories].[Category].&[4]"),
    new BinaryOperator("[Product].[Product Categories].[Subcategory]", "[Product].[Product Categories].[Subcategory].&[31]")).ToString();

Refer to the following help topic for more information about building filter criteria: Expression Constants, Operators, and Functions


You cannot build complex criteria to filter data in OLAP mode.

See Also