2.2.5.3.4 Pivot Hierarchies

A pivot hierarchy corresponds to a cache hierarchy (section 2.2.5.2.7).

A pivot hierarchy is specified by the sequence of records that conform to the SXTH rule (defined in section 2.1.7.40). A pivot hierarchy is contained in a PivotTable view (section 2.2.5.3).

Pivot hierarchies MUST NOT exist in a non-OLAP PivotTable view.

A PivotTable view has a collection of pivot hierarchies as specified by the sequence of records that conform to the SXTHS rule (defined in section 2.1.7.40).

A pivot hierarchy can be referenced by a pivot hierarchy index which is a zero-based index of an SXTH rule in the collection specified by the SXTHS rule.

Each pivot hierarchy is associated with a cache hierarchy with a cache hierarchy index, as specified in section 2.2.5.2.7, equal to the pivot hierarchy index of the pivot hierarchy.

A pivot hierarchy can have pivot field (section 2.2.5.3.2) associated with it. The pivot fields associated with a pivot hierarchy do not need to exist if they have not been used by the application.

The association between a pivot hierarchy and pivot fields can be determined by the following: A pivot hierarchy has an associated cache hierarchy. This associated cache hierarchy in turn has cache field (section 2.2.5.2.2) associated with it. These specific cache fields have pivot fields associated with them. See section 2.2.5.3.2 for more details.

A pivot hierarchy can be on a PivotTable axis (section 2.2.5.3.7) . When a pivot field (section 2.2.5.3.2) associated with a pivot hierarchy is referenced by a data item (section 2.2.5.3.7.5.1) the pivot hierarchy is on the data axis (section 2.2.5.3.7.5). All pivot fields associated with a pivot hierarchy that is used on a PivotTable axis MUST be placed on the same PivotTable axis as the pivot hierarchy or not on any PivotTable axis.