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.v24.1.Core.dll
NuGet Packages: DevExpress.PivotGrid.Core, DevExpress.Win.Navigation
Declaration
[PivotAPIMemberCategory(APICategory.OLAPSource)]
[XtraSerializableProperty]
public DefaultBoolean OLAPFilterByUniqueName { get; set; }Property Value
| Type | Description |
|---|---|
| DefaultBoolean | 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 | Return Value |
|---|---|---|
| True | The value is true. |
|
| False | The value is false. |
|
| Default | The value is specified by a global option or a higher-level object. |
|
Property Paths
You can access this nested property as listed below:
| Object Type | Path to OLAPFilterByUniqueName |
|---|---|
| PivotGridFieldBase |
|
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.