Export (0) Print
Expand All

2.2.5.4.4 Pivot Items

Office

Pivot items represent specific instances of the entities represented by pivot fields (section 2.2.5.4.3). Each pivot item specifies its display properties. For example, it can contain the user defined caption for the pivot item or information about whether this pivot item is hidden or not.

A pivot item specifies view properties of a cache item (section 2.2.5.3.6) or of an aggregation value associated with a pivot fields (section 2.2.5.4.3).

A pivot item is specified by an SXVI record (section 2.4.312) in a sequence of records that conforms to the PIVOTVD rule (section 2.1.7.20.5), and optionally an SXVIFlags structure (section 2.5.263) specified by an element in the array specified by the rgsxvi field of the SXVDTEx record (section 2.4.311). The SXVIFlags structure (section 2.5.263) specifies additional properties for OLAP PivotTable views (section 2.2.5.4.2).

If the itmType field of SXVI (section 2.4.312) is 0x0000, then this pivot item is associated with the cache item (section 2.2.5.3.6) specified by the iCache field of the SXVI record (section 2.4.312). Each pivot item that is associated with a cache item (section 2.2.5.3.6) MUST be associated with a different cache item (section 2.2.5.3.6) than the other pivot items in the collection. If the itmType field of this SXVI record (section 2.4.312) is not 0x0000, then this pivot item MUST NOT have an associated cache item (section 2.2.5.3.6).

The number of pivot items where the itmType field of the SXVI record (section 2.4.312) of the pivot item is 0x0000 MUST equal zero or the number of cache items (section 2.2.5.3.6) in the cache field (section 2.2.5.3.5) of the pivot fields (section 2.2.5.4.3).

A pivot item can be referenced by a pivot item index. A pivot item index is a zero-based index of SXVI records (section 2.4.312) in a PIVOTVD rule (section 2.1.7.20.5). Note that unlike pivot field index and cache field index, pivot item index and cache item index are not necessarily equal.

Show:
© 2016 Microsoft