DashboardOlapDataSource.Filter Property

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

Namespace: DevExpress.DashboardCommon

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

NuGet Packages: DevExpress.Dashboard.Core, DevExpress.WindowsDesktop.Dashboard.Core

Declaration

C#

[DefaultValue(null)]
public string Filter { get; set; }

VB.NET

<DefaultValue(Nothing)>
Public Property Filter As String

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.