Share via

2.2.5.4.9.1.2 OLAP Page Filtering

  • Article

In an OLAP PivotTable views (section 2.2.5.4.2) the filtering on the page axis (section 2.2.5.4.9.1) is specified using the pivot hierarchy (section 2.2.5.4.5) that the pivot field (section 2.2.5.4.3) is associated with, as specified in the Association of Pivot Hierarchies and Pivot Fields and Cache Fields section.

If the value of the fEnableMultiplePageItems field of the SXTH record (section 2.4.308) of the pivot hierarchy (section 2.2.5.4.5) is 0, the stUnique field of the SXPIEx record (section 2.4.299) specifies an OLAP member to filter by.

If the value of the fEnableMultiplePageItems field of the SXTH record (section 2.4.308) of the pivot hierarchy (section 2.2.5.4.5) is 1, then the specification 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), as specified in the following table:

PivotCache Functionality Level

Filtering Behavior

Less than 3

Specifies that the SXAddl_SXCHierarchy_SXDFilterMember records (section 2.4.273.44) of the pivot hierarchy (section 2.2.5.4.5) specify the OLAP members to filter by.

Greater than or equal to 3

Specifies that the filtering is applied as specified by Manual Filters (section 2.2.5.4.7) and OLAP Manual Filters (section 2.2.5.4.7.2) for this pivot hierarchy (section 2.2.5.4.5).