2.2.5.4.5 Pivot Hierarchies

Office

A pivot hierarchy is specified to be contained by a PivotTable axis (section 2.2.5.4.9) when all pivot fields (section 2.2.5.4.3) associated with that pivot hierarchy are placed on that PivotTable axis (section 2.2.5.4.9). Pivot fields (section 2.2.5.4.3) MUST NOT be placed on a PivotTable axis (section 2.2.5.4.9) different from the pivot axis that any other pivot field (section 2.2.5.4.3) associated with the same pivot hierarchy is placed on. Additional restrictions can apply, as specified by the SXTH rule (section 2.1.7.20.5) and the PivotTable Axes section.

A pivot hierarchy corresponds to one of the following entities in the OLAP source data (section 2.2.5.3.2) associated with an OLAP PivotCache (section 2.2.5.3.4):

A pivot hierarchy is associated with an OLAP hierarchy in the source data (section 2.2.5.3.2). A pivot hierarchy is specified by the sequence of records that conform to the PIVOTTH rule (section 2.1.7.20.5) and, optionally, the SXADDLHIERARCHY rule (section 2.1.7.20.5).

Pivot hierarchies MUST NOT exist if the PivotTable view (section 2.2.5.4) is a non- OLAP PivotTable views (section 2.2.5.4.2). At least one pivot hierarchy MUST exist if the PivotTable view (section 2.2.5.4) is an OLAP PivotTable views (section 2.2.5.4.2).

A pivot hierarchy specifies OLAP hierarchy information and has one or more associated pivot fields (section 2.2.5.4.3) associated with OLAP levels of the OLAP hierarchy, an OLAP named set, an OLAP KPI, or an OLAP measure.

A pivot hierarchy can be referenced by pivot hierarchy index. A pivot hierarchy index is the zero-based index of a PIVOTTH rule (section 2.1.7.20.5) in the associated PIVOTVIEW rule (section 2.1.7.20.5).

A pivot hierarchy is associated with an OLAP object as specified in the following table:

fMeasure field of SXTH

fSet field of SXTH

fKPI field of SXTH

Meaning

0

0

0

OLAP hierarchy

0

1

0

OLAP named set

0

0

1

OLAP KPI

1

0

0

OLAP measure

Show: