18.104.22.168.4 Pivot Hierarchies
A pivot hierarchy corresponds to a cache hierarchy (section 22.214.171.124.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 126.96.36.199).
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 188.8.131.52.7, equal to the pivot hierarchy index of the pivot hierarchy.
A pivot hierarchy can have pivot field (section 184.108.40.206.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 220.127.116.11.2) associated with it. These specific cache fields have pivot fields associated with them. See section 18.104.22.168.2 for more details.
A pivot hierarchy can be on a PivotTable axis (section 22.214.171.124.7) . When a pivot field (section 126.96.36.199.2) associated with a pivot hierarchy is referenced by a data item (section 188.8.131.52.7.5.1) the pivot hierarchy is on the data axis (section 184.108.40.206.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.