Skip to main content

PivotGridControl.OlapDefaultMemberFields Property

Gets or sets for which filter fields the pivot grid processes only data related to their default members. This is a dependency property.

Namespace: DevExpress.Xpf.PivotGrid

Assembly: DevExpress.Xpf.PivotGrid.v24.1.dll

NuGet Package: DevExpress.Wpf.PivotGrid

Declaration

public PivotDefaultMemberFields OlapDefaultMemberFields { get; set; }

Property Value

Type Description
PivotDefaultMemberFields

A PivotDefaultMemberFields enumeration member that specifies for which filter fields the pivot grid processes only data related to their default members.

Available values:

Name Description
NonVisibleFilterFields

The Pivot Grid processes only data related to fields’ default members for filter fields that are not visible.

AllFilterFields

The Pivot Grid processes only data related to fields’ default members for all filter fields, except for those fields whose filter condition is not set to ‘Show All’.

Remarks

In OLAP mode, data is filtered against filter fields in a specific way. If a filter field is not visible, only data related to its default member (a member of the corresponding hierarchy that is set as the default on the server) is processed. Otherwise, data is filtered according to the current filter condition.

For visible filter fields whose filter condition is set to ‘Show All’, you can change this behavior via the OlapDefaultMemberFields property. To process only data related to these fields’ default members, set the OlapDefaultMemberFields property to PivotDefaultMemberFields.AllFilterFields.

To learn more, see OLAP Filtering Specifics.

See Also