PivotOLAPFilterUsingWhereClause Enum

Lists values that specify whether to use the WHERE clause in an MDX query, when filtering against filter fields in OLAP mode.

Namespace: DevExpress.XtraPivotGrid

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

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

Declaration

C#

[ResourceFinder(typeof(ResFinder), "PropertyNamesRes")]
public enum PivotOLAPFilterUsingWhereClause

VB.NET

<ResourceFinder(GetType(ResFinder), "PropertyNamesRes")>
Public Enum PivotOLAPFilterUsingWhereClause

Members

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.

Related API Members

The following properties accept/return PivotOLAPFilterUsingWhereClause values:

• PivotGridFieldOptions.OLAPFilterUsingWhereClause
• PivotGridOptionsOLAP.PrefilterUsingWhereClause

Remarks

Values listed by this enumeration are used to set the PivotGridFieldOptions.OLAPFilterUsingWhereClause property.