Share via

2.2.5.4.6 Member Properties

  • Article

A member property is the PivotTable (section 2.2.5) representation of an OLAP member property. Member properties can have properties that are associated with the PivotCache (section 2.2.5.3) and a PivotTable view (section 2.2.5.4).

A member property is specified by the SXAddl_SXCHierarchy_SXDProperty record (section 2.4.273.57) in the sequence of records that conform to the SXADDLHIERARCHY rule (section 2.1.7.20.5). A member property is contained in a pivot hierarchy (section 2.2.5.4.5).

A member property is associated with one OLAP member property of the OLAP hierarchy specified by the pivot hierarchy (section 2.2.5.4.5) of the member property.

A member property can be associated with a cache field (section 2.2.5.3.5) and a pivot field (section 2.2.5.4.3). If there is a cache field (section 2.2.5.3.5) with an stFieldName field of the SXFDB record equal to the stProperty field of the SXAddl_SXCHierarchy_SXDProperty record (section 2.4.273.57), then this specifies that the member property is associated with that cache field (section 2.2.5.3.5), and the cache field (section 2.2.5.3.5) is specified to be a member property cache field (section 2.2.5.3.5). The associated pivot field (section 2.2.5.4.3) of a member property cache field (section 2.2.5.3.5) is specified to be a member property pivot field (section 2.2.5.4.3).

It is not required that a member property is associated with any cache field (section 2.2.5.3.5) or pivot field (section 2.2.5.4.3). If there is no cache field (section 2.2.5.3.5) with a stFieldName field of the SXFDB record (section 2.4.283) equal to the stProperty field of the SXAddl_SXCHierarchy_SXDProperty record (section 2.4.273.57), then this specifies that the member property is not associated with any cache field (section 2.2.5.3.5) or pivot field (section 2.2.5.4.3). Such a member property does not participate in the row axis (section 2.2.5.4.9.2) or column axis (section 2.2.5.4.9.3).

A member property pivot field (section 2.2.5.4.3) can be shown only in the row area (section 2.2.5.4.10.1.1) or column area (section 2.2.5.4.10.1.2) of a PivotTable view (section 2.2.5.4). A member property pivot field (section 2.2.5.4.3) can only be shown after the last visible level of the corresponding pivot hierarchy (section 2.2.5.4.5). The order of member property fields shown in the PivotTable view (section 2.2.5.4) is the same as the order of SXAddl_SXCHierarchy_SXDProperty records (section 2.4.273.57) in the corresponding pivot hierarchy (section 2.2.5.4.5).