Share via

2.2.5.2 PivotCache

  • Article

The PivotCache contains cached information about source data (section 2.2.5.2.1). The cached information is used by PivotTable Views (section 2.2.5.3) to generate PivotTable (section 2.2.5) reports, or it is used by cube functions to display OLAP data sets and values. The same PivotCache MUST NOT be used by both a PivotTable view and a cube function. The information contained in a PivotCache includes organization, data types and the values of the source data.

The PivotCache is divided into two parts. The first part consists of the optional cache record (section 2.2.5.2.10) structures, as specified by the PivotCache record (section 2.1.7.39) part. The cache record structures represent a snapshot of the source data (section 2.2.5.2.1) and enable a PivotTable view (section 2.2.5.3) that uses a PivotCache to be recalculated without retrieving the source data. The cache record structures do not exist for OLAP source data.

The second part of a PivotCache is the set of structures that describe metadata about the source data (section 2.2.5.2.1), such as where it comes from, the data entities it has, and the unique values of those entities, as specified by the PivotCache definition (section 2.1.7.38) part.

See section 2.2.5.2.1 for the specification of an OLAP PivotCache.