2.2.5.4.5.1 Association of Pivot Hierarchies and Pivot Fields and Cache Fields

  • Article

A pivot field (section 2.2.5.4.3) is associated with the pivot hierarchy (section 2.2.5.4.5) specified by either the isxth field of the SXVDTEx record (section 2.4.311) of that pivot field (section 2.2.5.4.3), or the isxth field of the SXAddl_SXCField12_SXDISXTH record (section 2.4.273.31) of that pivot field (section 2.2.5.4.3).

If a pivot field (section 2.2.5.4.3) has an SXAddl_SXCField12_SXDISXTH record (section 2.4.273.31), the isxth field of the SXVDTEx record (section 2.4.311) MUST be -1 and the association is specified by isxth field of the SXAddl_SXCField12_SXDISXTH record (section 2.4.273.31).

A pivot hierarchy (section 2.2.5.4.5) associated with a pivot field (section 2.2.5.4.3) is associated with the cache field (section 2.2.5.3.5) the pivot field (section 2.2.5.4.3) is associated.

If a pivot hierarchy (section 2.2.5.4.5) is on the page axis (section 2.2.5.4.9.1) or data axis (section 2.2.5.4.9.5), the isxvd field of SXTH (section 2.4.308) is a reference to an associated pivot field (section 2.2.5.4.3).

If the pivot hierarchy (section 2.2.5.4.5) is not a measure (section 2.2.5.4.5.2), named set (section 2.2.5.4.5.4), KPI (section 2.2.5.4.5.3), there can be more than one pivot field (section 2.2.5.4.3) associated with it and each array elements in the rgisxvd field of SXTH (section 2.4.308) is a reference to the associated pivot field (section 2.2.5.4.3) for the pivot hierarchy (section 2.2.5.4.5) level.

If a pivot field (section 2.2.5.4.3) has an SXAddl_SXCField12_SXDISXTH record (section 2.4.273.31) sxaxis.sxaxisData, sxaxis.sxaxisRw, sxaxis.sxaxisCol and sxaxis.sxaxisPage fields of the Sxvd record (section 2.4.309) of the pivot field (section 2.2.5.4.3) MUST be 0.

If a pivot hierarchy (section 2.2.5.4.5) is a measure (section 2.2.5.4.5.2), named set (section 2.2.5.4.5.4), or KPI (section 2.2.5.4.5.3), there can be no more than one pivot field (section 2.2.5.4.3) associated with it.