The requested page is not available for the requested platform. You are viewing the content for Default platform.

DashboardOlapDataSource.Filter Property

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

Namespace: DevExpress.DashboardCommon

Assembly: DevExpress.Dashboard.v19.1.Core.dll

Declaration

[DefaultValue(null)]
public string Filter { get; set; }
<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();

To learn more about building filter criteria, see Expression Constants, Operators, and Functions.

See Also