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

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

Declaration

C#

[XtraSerializablePropertyId(2)]
[XtraSerializableProperty]
public FieldOLAPFilterUsingWhereClause OlapFilterUsingWhereClause { get; set; }

VB.NET

<XtraSerializablePropertyId(2)>
<XtraSerializableProperty>
Public Property OlapFilterUsingWhereClause As FieldOLAPFilterUsingWhereClause

Property Value

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

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 the OLAP Filtering Specifics section in the Filtering Basics topic.