PivotGridOptionsOLAP.PrefilterUsingWhereClause Property

Gets or sets whether to use the WHERE clause in an MDX query, when filtering against filter fields in OLAP mode.

Namespace: DevExpress.XtraPivotGrid

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

Declaration

[Browsable(false)]
[DefaultValue(PivotOLAPFilterUsingWhereClause.SingleValuesOnly)]
public PivotOLAPFilterUsingWhereClause PrefilterUsingWhereClause { get; set; }

Property Value

Type Default Description
PivotOLAPFilterUsingWhereClause

SingleValuesOnly

A PivotOLAPFilterUsingWhereClause enumeration.

Available values:

Name Description
SingleValuesOnly

The WHERE clause is used when the filter condition contains a single field value, either excluded or included into the pivot grid (in OLAP mode). Otherwise, a subselect clause is used.

Always

The WHERE clause is always used when filtering against filter fields in OLAP mode.

Never

The WHERE clause is never used when filtering against filter fields in OLAP mode. A subselect clause is used instead.

Auto

The pivot grid automatically selects when to use the WHERE clause in an MDX query.

Property Paths

You can access this nested property as listed below:

Library Object Type Path to PrefilterUsingWhereClause
WinForms Controls PivotGridControl
.OptionsOLAP.PrefilterUsingWhereClause
Reporting XRPivotGrid
.OptionsOLAP.PrefilterUsingWhereClause
ASP.NET MVC Extensions MVCxPivotGrid
.OptionsOLAP.PrefilterUsingWhereClause
PivotGridSettings
.OptionsOLAP.PrefilterUsingWhereClause
ASP.NET Web Forms Controls ASPxPivotGrid
.OptionsOLAP.PrefilterUsingWhereClause
See Also