Share via

2.2.5.3.7.1.1 Non-OLAP Page Filtering

  • Article

A non-OLAP PivotTable view (section 2.2.5.3) can be filtered to not include some pivot items (section 2.2.5.3.3) from the pivot field (section 2.2.5.3.2) on the page axis (section 2.2.5.3.7.1). The PivotTable (section 2.2.5) report only includes values specified by cache items (section 2.2.5.2.3) that are associated with pivot items that are filtered in.

The following table specifies how the filtering of pivot items of a pivot field is specified.

In the following table, the first column is the value of the fEnableMultiplePageItems field of the BrtBeginSXVD (section 2.4.272) record of the corresponding pivot field (section 2.2.5.3.2), the second column is the value of the isxvi field of the BrtBeginSXPI (section 2.4.255) record, and the third column is the value of the fSubtotalHiddenPageItems field of the BrtBeginSXView (section 2.4.275) record.

fEnableMultiplePageItems

isxvi

fSubtotalHiddenPageItems

Filtering Behavior

0

Not 0x001000FE

Any

Specifies that the isxvi field of the BrtBeginSXPI record specifies a pivot item (section 2.2.5.3.3) index, as specified by section 2.2.5.3.3, of the one pivot item of a pivot field that is filtered in.

Any

0x001000FE

0

Specifies that pivot items are filtered in if and only if the fHidden field of the corresponding BrtBeginSXVI (section 2.4.274) records is equal to 0.

Any

0x001000FE

1

Specifies that all pivot items of a pivot field filtered in.

If the fEnableMultiplePageItems field of the corresponding pivot field (section 2.2.5.3.2) is equal to 1, the isxvi field of the BrtBeginSXPI (section 2.4.255) record MUST be equal to 0x001000FE and MUST be ignored.