PivotGridFieldOptions.OLAPUseNonEmpty Property

Gets or sets whether the NonEmpty function should be used in MDX queries for the current measure.

Namespace: DevExpress.XtraPivotGrid

Assembly: DevExpress.PivotGrid.v20.1.Core.dll

Declaration

[DefaultValue(true)]
[PropertyCategory(PropertyCategory.OLAPSource)]
public bool OLAPUseNonEmpty { get; set; }
<PropertyCategory(PropertyCategory.OLAPSource)>
<DefaultValue(True)>
Public Property OLAPUseNonEmpty As Boolean

Property Value

Type Default Description
Boolean

true

true to use the NonEmpty function in MDX queries; otherwise, false.

Property Paths

You can access this nested property as listed below:

Library Object Type Path to OLAPUseNonEmpty
Cross-Platform Class Library PivotGridFieldBase
.Options.OLAPUseNonEmpty
WinForms Controls PivotGridField
.Options.OLAPUseNonEmpty
PivotGridField
.Options.OLAPUseNonEmpty
ASP.NET Controls and MVC Extensions PivotGridField
.Options.OLAPUseNonEmpty
PivotGridField
.Options.OLAPUseNonEmpty
MVCxPivotGridField
.Options.OLAPUseNonEmpty
MVCxPivotGridField
.Options.OLAPUseNonEmpty
Reporting XRPivotGridField
.Options.OLAPUseNonEmpty
XRPivotGridField
.Options.OLAPUseNonEmpty

Remarks

PivotGridControl prevents an OLAP server from processing empty tuples (tuples for which there is no data in a particular measure) by default. This allows the pivot grid to deliver better performance.

To exclude empty tuples from the complete set, PivotGridControl uses the NonEmpty MDX function.

In some instances, the NonEmpty function causes valuable data to be filtered out. This may happen when NonEmpty is used with a calculated measure.

If you find any values missing from the pivot grid while using calculated measures, try setting the OLAPUseNonEmpty property to false for these measures. Note that this may slow the performance.

NOTE

The OLAPUseNonEmpty property is in effect only for fields that define measures.

See Also