2.2.5.3.1 PivotCache Functionality Level

  • Article

The PivotCache functionality level is the data functionality level (section 2.2.5.2) associated with a PivotCache (section 2.2.5.3). The PivotCache functionality level is used in specification of restrictions for the PivotCache and associated PivotTable views (section 2.2.5.3.3). It is specified as follows:

  • If an SXAddl_SXCCache_SXDVerSXMacro record (section 2.4.273.10) exists, then the value of the dwVer field of the SXAddl_SXCCache_SXDVerSXMacro specifies the PivotCache functionality level.

  • If an SXAddl_SXCCache_SXDVerSXMacro record does not exist and an SXAddl_SXCView_SXDVer10Info record (section 2.4.273.108) exists for an associated PivotTable views, then the value of the bVerSxMacro field of the SXAddl_SXCView_SXDVer10Info record specifies the PivotCache functionality level, except if that value is greater than or equal to 3, in which case the PivotCache functionality level is specified to be 1.

  • If an SXAddl_SXCCache_SXDVerSXMacro record does not exist and an SXAddl_SXCView_SXDVer10Info record does not exist for an associated PivotTable views, then the PivotCache functionality level is specified to be 0.