Share via

2.2.5.2.11 Tuple Cache

  • Article

An OLAP PivotCache (section 2.2.5.2) can contain cached data called a tuple cache which is used by cube functions for recalculation without accessing the data provider specified by the associated OLAP connection (section 2.2.8.3.1).

A tuple cache is specified by a sequence of records that conforms to the PCDSDTUPLECACHE rule (defined in section 2.1.7.38).

If the OLAP PivotCache contains a tuple cache, the fSheetData field in the BrtBeginPivotCacheDef (section 2.4.168) record MUST be equal to 1.

A tuple cache can contain a cache of cube values specified by a sequence of records that conforms to the PCDSDTCENTRIES rule (defined in section 2.1.7.38), a cache of cube members(specified by a sequence of records that conforms to the PCDSDTCQUERIES rule (defined in section 2.1.7.38), a cache of cube sets specified by a sequence of records that conforms to the PCDSDTCSETS rule (defined in section 2.1.7.38), and a cache of cube value server formats (specified by a sequence of records that conforms to the PCDSFCIENTRIES rule).

The sequence of records that conform to the PCDSDTCEMEMBER rule (defined in section 2.1.7.38) specifies a tuple cache entry. A tuple cache entry specifies an OLAP member or a reference to a tuple cache set. See section 2.4.156 for details.

A cache of cube values is a collection of values specified by the BrtPCDIMissing (section 2.4.731), BrtPCDINumber (section 2.4.732), BrtPCDIError (section 2.4.729), or BrtPCDIString (section 2.4.733) records. Each of these values is optionally followed by a collection of tuple cache entries specified by a sequence of records that conforms to the PCDSDTCEMEMBERS rule (defined in section 2.1.7.38), which specify the OLAP members or tuple cache sets corresponding to the value.

A cache of cube members is specified by a sequence of records that conforms to the PCDSDTCQUERIES rule. Each of the cube members has an MDX expression, specified by the BrtBeginPCDSDTCQuery (section 2.4.161) record. Each of the BrtBeginPCDSDTCQuery records is optionally followed by a collection of tuple cache entries specified by a sequence of records that conforms to the PCDSDTCEMEMBERS rule (defined in section 2.1.7.38) corresponding to the MDX expression.

A cache of cube sets is a collection of tuple cache sets specified by a sequence of records that conforms to the PCDSDTCSETS rule (defined in section 2.1.7.38). Each tuple cache set optionally has a collection of tuple cache entries specified by a sequence of records that conform to the PCDSDTCEMEMBERS rule (defined in section 2.1.7.38) corresponding to the MDX expression specified in the BrtBeginPCDSDTCSet (section 2.4.162) record.

A cache of cube value server formats is a collection of number formats specified by the BrtPCDSFCIEntry (section 2.4.734) record.