corelibraries-devexpress-dot-xtrapivotgrid-dot-pivotgridoptionsolap.md
Gets or sets whether PivotGridControl should take into account OLAP member values or unique names when filtering data in the OLAP mode.
Namespace : DevExpress.XtraPivotGrid
Assembly : DevExpress.PivotGrid.v25.2.Core.dll
NuGet Packages : DevExpress.PivotGrid.Core, DevExpress.Win.Navigation
[DefaultValue(false)]
public bool FilterByUniqueName { get; set; }
<DefaultValue(False)>
Public Property FilterByUniqueName As Boolean
| Type | Default | Description |
|---|---|---|
| Boolean | false |
true to take into account unique names when filtering data in the OLAP mode; false to take into account values instead.
|
You can access this nested property as listed below:
| Library | Object Type | Path to FilterByUniqueName |
|---|---|---|
| WinForms Controls | PivotGridControl |
.OptionsOLAP .FilterByUniqueName
| | ASP.NET MVC Extensions | PivotGridSettings |
.OptionsOLAP .FilterByUniqueName
| | ASP.NET Web Forms Controls | ASPxPivotGrid |
.OptionsOLAP .FilterByUniqueName
|
By default, PivotGridControl takes into account OLAP member values when filtering data in the 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 FilterByUniqueName property to true to enable the PivotGridControl to use unique names instead of values.
The FilterByUniqueName property is in effect for those fields whose PivotGridFieldOptions.OLAPFilterByUniqueName property is set to DefaultBoolean.Default.
See Also