Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
Export (0) Print
Expand All

2.2.5.4.9.1.2 OLAP Page Filtering

Office

In an OLAPPivotTable 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).

Show:
© 2015 Microsoft