Share via

2.2.5.3.6.2 Simple Filters

  • Article

A simple filter is a top N filter which is also known as an AutoShow. The fAutoShow field of the BrtBeginSXVD (section 2.4.272) record specifies whether a simple filter is applied for a pivot field (section 2.2.5.3.2). The fTopAutoShow field of the BrtBeginSXVD record specifies whether a simple filter applies to the top or bottom N items. The citmAutoShow field of the BrtBeginSXVD record specifies the number of pivot items (section 2.2.5.3.3) displayed.

Simple filters MUST only be applied to pivot fields of a PivotTable view (section 2.2.5.3) with the bVerSxMacro field of the corresponding BrtBeginSXView (section 2.4.275) record less than or equal to 2, or to pivot fields of an OLAP PivotTable view with the fSupportSubquery field of the BrtBeginPivotCacheDef (section 2.4.168) record of the corresponding PivotCache (section 2.2.5.2) equal to 0.