# 2.2.5.4.7.2 OLAP Manual Filters

**Office**

For **OLAP****PivotTable views** (section 2.2.5.4.2), **manual filtering** (section 2.2.5.4.7) operates on **pivot hierarchies** (section 2.2.5.4.5). **OLAP manual filtering** uses filtering lists to determine what filtering to apply. The **OLAP manual filtering** operation depends on the **PivotCache Functionality Level** (section 2.2.5.3.1) of the **associated PivotCache** (section 2.2.5.4.1) of the **PivotTable view** (section 2.2.5.4).

The list of excluded OLAP members is specified by the **rgHiddenMemberSets** field of the **SXTH record** (section 2.4.308). If the **fFilterInclusive** field of the **SXTH record** (section 2.4.308) of the **pivot hierarchy** (section 2.2.5.4.5) is equal to 0x1, the list of excluded OLAP members MUST be empty.

The list of included OLAP members is specified by a collection of **SXAddl_SXCHierarchy_SXDFilterMember12 records** (section 2.4.273.45) of the **pivot hierarchy** (section 2.2.5.4.5). If the **PivotCache Functionality Level** (section 2.2.5.3.1) of the **associated PivotCache** (section 2.2.5.4.1) of the **PivotTable view** (section 2.2.5.4) is less than 3, the selected **pivot items** (section 2.2.5.4.4) list MUST be empty. If the **fFilterInclusive** field of the **SXTH record** (section 2.4.308) of the **pivot hierarchy** (section 2.2.5.4.5) is equal to 0x0, the list of included OLAP members MUST be empty.

The selected **pivot items** (section 2.2.5.4.4) list is specified to be the list of **pivot items** (section 2.2.5.4.4), with the **fOlapFilterSelected** field of the **SXVIFlags structure** (section 2.5.263) that corresponds to each **pivot item** (section 2.2.5.4.4) equal to 0x1, in the **pivot fields** (section 2.2.5.4.3) associated with the **pivot hierarchy** (section 2.2.5.4.5). If the **PivotCache Functionality Level** (section 2.2.5.3.1) of the **associated PivotCache** (section 2.2.5.4.1) of the **PivotTable view** (section 2.2.5.4) is less than 3, the selected **pivot items** (section 2.2.5.4.4) list MUST be empty.

If all of the lists of excluded OLAP members, included OLAP members and the selected **pivot items** (section 2.2.5.4.4) are empty, then no **manual filtering** (section 2.2.5.4.7) is specified for the **pivot hierarchy** (section 2.2.5.4.5). Otherwise, the value of the **fFilterInclusive** field of the **SXTH record** (section 2.4.308) of the **pivot hierarchy** (section 2.2.5.4.5) determines how the lists are used.

If the **fFilterInclusive** field of the **SXTH record** (section 2.4.308) of the **pivot hierarchy** (section 2.2.5.4.5) is equal to 0x1, the members (3) of the included OLAP members list and their ascendants and descendants are included in the **manual filter** (section 2.2.5.4.7). The **pivot items** (section 2.2.5.4.4) in the selected **pivot items** (section 2.2.5.4.4) list, and their ascendants and descendants are also included in the **manual filter** (section 2.2.5.4.7). New OLAP members in the **source data** (section 2.2.5.3.2) will be excluded by default when the **PivotTable view** (section 2.2.5.4) is refreshed.

If the **fFilterInclusive** field of the **SXTH record** (section 2.4.308) of the **pivot hierarchy** (section 2.2.5.4.5) is equal to 0x0, the members (3) of the excluded OLAP members list and their descendants are excluded in the **manual filter** (section 2.2.5.4.7). The **pivot items** (section 2.2.5.4.4) in the selected **pivot items** (section 2.2.5.4.4) list and their descendants are also excluded in the **manual filter** (section 2.2.5.4.7). New OLAP members in the **source data** (section 2.2.5.3.2) will be included by default when the **PivotTable view** (section 2.2.5.4) is refreshed.

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