22.214.171.124.4 Pivot Hierarchies
A pivot hierarchy corresponds to a cache hierarchy (section 126.96.36.199.7).
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 188.8.131.52).
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 184.108.40.206.7, equal to the pivot hierarchy index of the pivot hierarchy.
A pivot hierarchy can have pivot field (section 220.127.116.11.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 18.104.22.168.2) associated with it. These specific cache fields have pivot fields associated with them. See section 22.214.171.124.2 for more details.
A pivot hierarchy can be on a PivotTable axis (section 126.96.36.199.7) . When a pivot field (section 188.8.131.52.2) associated with a pivot hierarchy is referenced by a data item (section 184.108.40.206.7.5.1) the pivot hierarchy is on the data axis (section 220.127.116.11.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.