Back to Devexpress

FieldOLAPFilterUsingWhereClause Enum

wpf-devexpress-dot-xpf-dot-pivotgrid-cd2f534d.md

latest2.0 KB
Original Source

FieldOLAPFilterUsingWhereClause 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.Xpf.PivotGrid

Assembly : DevExpress.Xpf.PivotGrid.v25.2.dll

NuGet Package : DevExpress.Wpf.PivotGrid

Declaration

csharp
public enum FieldOLAPFilterUsingWhereClause
vb
Public Enum FieldOLAPFilterUsingWhereClause

Members

NameDescription
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.

|

The following properties accept/return FieldOLAPFilterUsingWhereClause values:

Remarks

Values listed by this enumeration are used to set the PivotGridField.OlapFilterUsingWhereClause property.

See Also

DevExpress.Xpf.PivotGrid Namespace