DashboardOlapDataSource.Filter Property

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

Namespace: DevExpress.DashboardCommon

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

Declaration

[DefaultValue(null)]
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.

Remarks

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

Note

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

See Also