2.2.5.4.8.2 Simple Filters

  • Article

A simple filter is a top N filter which is also known as AutoShow. The fAutoShow field of the SXVDEx record (section 2.4.310) specifies whether a simple filter is applied for a pivot field (section 2.2.5.4.3). The fTopAutoShow field of the SXVDEx record (section 2.4.310) specifies whether a simple filter applies to the top or bottom n items. The citmAutoShow field of the SXVDEx record (section 2.4.310) specifies the number of pivot items (section 2.2.5.4.4) displayed.

Simple filters MUST only be applied to pivot fields (section 2.2.5.4.3) of a PivotTable view (section 2.2.5.4) with data functionality level (section 2.2.5.2) less than or equal to 2, or to pivot fields (section 2.2.5.4.3) of an OLAP PivotTable views (section 2.2.5.4.2) with the fSrvSupportSubquery field of the SXAddl_SXCCache_SXDInfo12 record (section 2.4.273.7) of the corresponding PivotCache (section 2.2.5.3) equal to zero.