Share via

2.2.5.3.6.1.2 Date Filters

  • Article

A date filter specifies a criterion that is applied to pivot items (section 2.2.5.3.3) of date type of a pivot field (section 2.2.5.3.2). A date filter determines which pivot items are included in the calculation of the PivotTable view (section 2.2.5.3) and displayed in the PivotTable (section 2.2.5) report.

Date filters are specified by BrtBeginSXFILTER (section 2.4.247) records with the sxft field in the range 0x0000001A through 0x00000041.

For non-OLAP PivotTable views, a date filter can be applied if and only if the BrtBeginPCDFAtbl (section 2.4.131) record associated with the corresponding cache field (section 2.2.5.2.2) has the fDateInField field equal to 1, the fMixedTypesIgnoringBlanks field equal to 0, and the fNonDates field is equal to 0. For OLAP PivotTable views, a date filter can be applied if and only if the wAttributeMemberValueType field of the BrtBeginPCDHierarchy (section 2.4.146) record specifies that the cache hierarchy (section 2.2.5.2.7) has a data type of date and the fTimeHierarchy field of the BrtBeginPCDHierarchy record is equal to 1, or the fAttributeMemberValueTypeKnown field of the BrtBeginPCDHierarchy record is equal to 0 and the fTimeHierarchy field of the BrtBeginPCDHierarchy record is equal to 1.

Date filters are applied before value filters (section 2.2.5.3.6.1.3) and in no specific order.