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.v20.2.Core.dll

Declaration

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

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

Corresponds to a Boolean value of true.

False

Corresponds to a Boolean value of false.

Default

The value is determined by the current object's parent object setting (e.g., a control setting).

Property Paths

You can access this nested property as listed below:

Library Object Type Path to OLAPFilterByUniqueName
Cross-Platform Class Library PivotGridFieldBase
.Options.OLAPFilterByUniqueName
WinForms Controls PivotGridField
.Options.OLAPFilterByUniqueName
Reporting XRPivotGridField
.Options.OLAPFilterByUniqueName
ASP.NET MVC Extensions MVCxPivotGridField
.Options.OLAPFilterByUniqueName
ASP.NET Web Forms Controls PivotGridField
.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.

See Also