PivotGridFieldOptions.OLAPFilterUsingWhereClause Property

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

Namespace: DevExpress.XtraPivotGrid

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

Declaration

C#

[DefaultValue(PivotOLAPFilterUsingWhereClause.SingleValuesOnly)]
[XtraSerializableProperty]
public PivotOLAPFilterUsingWhereClause OLAPFilterUsingWhereClause { get; set; }

VB.NET

<DefaultValue(PivotOLAPFilterUsingWhereClause.SingleValuesOnly)>
<XtraSerializableProperty>
Public Property OLAPFilterUsingWhereClause As PivotOLAPFilterUsingWhereClause

Property Value

Type	Default	Description
PivotOLAPFilterUsingWhereClause	**SingleValuesOnly**	A PivotOLAPFilterUsingWhereClause enumeration member that specifies whether to use the WHERE or subselect clause in an MDX query, when filtering against filter fields in OLAP mode.

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 OLAPFilterUsingWhereClause
Cross-Platform Class Library	PivotGridFieldBase	.Options.OLAPFilterUsingWhereClause
WinForms Controls	PivotGridField	.Options.OLAPFilterUsingWhereClause
Reporting	XRPivotGridField	.Options.OLAPFilterUsingWhereClause
ASP.NET Web Forms Controls	PivotGridField	.Options.OLAPFilterUsingWhereClause
	MVCxPivotGridField	.Options.OLAPFilterUsingWhereClause

Remarks

If the field filter condition is set to show a single field value, set the OLAPFilterUsingWhereClause property to SingleValuesOnly.

Subselect clauses cannot be used in MDX queries containing calculated members, with the CurrentMember function used in the expression. In such instances, set the OLAPFilterUsingWhereClause property to Always.

To learn more, see OLAP Filtering Specifics.