PivotGridFieldOptions.OLAPFilterByUniqueName Property

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

Namespace: DevExpress.XtraPivotGrid

Assembly: DevExpress.PivotGrid.v21.2.Core.dll

NuGet Package: DevExpress.PivotGrid.Core

Declaration

C#

[DefaultValue(DefaultBoolean.Default)]
public DefaultBoolean OLAPFilterByUniqueName { get; set; }

VB.NET

<DefaultValue(DefaultBoolean.Default)>
Public Property OLAPFilterByUniqueName As DefaultBoolean

Property Value

Type	Default	Description
DefaultBoolean	Default	A DefaultBoolean enumeration member that specifies whether PivotGridControl should take into account OLAP member values or unique names when filtering data in an OLAP mode.

Available values:

Name	Description
True	true. DefaultBoolean.True has a constant value of 0, while the standard true value corresponds to a value of 1. In Visual Basic, do not use implicit conversion of Boolean values to DefaultBoolean, and vice versa, as the conversion may produce incorrect results.
False	false. DefaultBoolean.False has a constant value of 1, while the standard false value corresponds to a value of 0. In Visual Basic, do not use implicit conversion of Boolean values to DefaultBoolean, and vice versa, as the conversion may produce incorrect results.
Default	The default behavior determined by the control’s logic.

Property Paths

You can access this nested property as listed below:

Object Type	Path to OLAPFilterByUniqueName
PivotGridFieldBase	.Options .OLAPFilterByUniqueName

Remarks

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 DefaultBoolean.True to enable the PivotGridControl to use unique names instead of values.

If the OLAPFilterByUniqueName property is set to DefaultBoolean.Default, the control’s PivotGridOptionsOLAP.FilterByUniqueName property is in effect.