2.2.5.3.5.2 OLAP Manual Filters

For OLAP PivotTable views (section 2.2.5.3), manual filtering operates on pivot hierarchies (section 2.2.5.3.4). OLAP manual filtering uses filtering lists to determine what filtering to apply.

The SXTHItem list is specified to be the list of the OLAP members specified by BrtBeginSXTHItem (section 2.4.264) records of the pivot hierarchy (section 2.2.5.3.4)

The selected pivot items (section 2.2.5.3.3) list is specified to be the list of pivot items, with the fOlapFilterSelected field of the BrtBeginSXVI (section 2.4.274) record equal to 0x1, in the pivot fields (section 2.2.5.3.2) associated with the pivot hierarchy.

If both the SXTHItem list and the selected pivot items list are empty then, no manual filtering is specified for the pivot hierarchy. Otherwise, the value of the fFilterInclusive field of the BrtBeginSXTH (section 2.4.263) record of the pivot hierarchy determines how the lists will be used.

If the fFilterInclusive field of the BrtBeginSXTH record of the pivot hierarchy is equal to 0x1, the OLAP members in the SXTHItem list and their ascendants and descendants are included in the manual filter, and the pivot items (section 2.2.5.3.3) in the selected pivot items list and their ascendants and descendants are included in the manual filter. New OLAP members in the source data (section 2.2.5.2.1) will be excluded by default when the PivotTable view (section 2.2.5.3) is refreshed.

If the fFilterInclusive field of the BrtBeginSXTH (section 2.4.263) record of the pivot hierarchy (section 2.2.5.3.4) is equal to 0x0, the OLAP members in the SXTHItem list and their descendants, are excluded in the manual filter, and the pivot items (section 2.2.5.3.3) in the selected pivot items list and their descendants, are excluded in the manual filter. New OLAP members in the source data will be included by default when the PivotTable view is refreshed.

The filtering lists do not include OLAP members which are ascendants or descendants of other OLAP members in the lists.