# 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 (2) 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 (2) 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.