Share via

2.2.5.4.7.2 OLAP Manual Filters

  • Article

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.