Skip to main content

PivotGridField.OlapFilterByUniqueName Property

Gets or sets whether PivotGridControl should take into account OLAP member values or unique names when filtering data in an OLAP mode. This is a dependency property.

Namespace: DevExpress.Xpf.PivotGrid

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

NuGet Package: DevExpress.Wpf.PivotGrid


public bool? OlapFilterByUniqueName { get; set; }

Property Value

Type Description

true to take into account unique names when filtering data in the OLAP mode; false to take into account values instead.


By default, PivotGridControl takes into account OLAP member values when filtering data in an OLAP mode. Specific cube dimensions may contain several OLAP members with the same value. As a result, the pivot grid cannot distinguish between such members and treats them as one, which may lead to incorrect filtering. In this instance, set the OlapFilterByUniqueName property to true to enable the PivotGridControl to use unique names instead of values.

If the OlapFilterByUniqueName property is set to null (Nothing in Visual Basic), the control’s PivotGridControl.OlapFilterByUniqueName property is in effect.

See Also