Skip to main content
Tag

DevExpress v24.2 Update — Your Feedback Matters

Our What's New in v24.2 webpage includes product-specific surveys. Your response to our survey questions will help us measure product satisfaction for features released in this major update and help us refine our plans for our next major release.

Take the survey Not interested

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.v24.2.dll

NuGet Package: DevExpress.Wpf.PivotGrid

#Declaration

public FieldOLAPFilterUsingWhereClause OlapFilterUsingWhereClause { get; set; }

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

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.

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

See Also