Share via

2.2.5.3.5.1 Non-OLAP Manual Filters

  • Article

For non-OLAP PivotTable (section 2.2.5), the state of the manual filter on a pivot field (section 2.2.5.3.2) can be determined by the value of the fHidden field of the BrtBeginSXVI (section 2.4.274) records directly following the corresponding BrtBeginSXVD (section 2.4.272). This field specifies whether the corresponding pivot item (section 2.2.5.3.3) is hidden by the manual filter and therefore not displayed in the PivotTable report.

If the fFilterInclusive field of the BrtBeginSXVD record is equal to 0x1, pivot items (section 2.2.5.3.3) corresponding to new values in the source data (section 2.2.5.2.1) are not displayed by default in the PivotTable (section 2.2.5) report after the associated PivotCache (section 2.2.5.2) has been refreshed.