Export (0) Print
Expand All
This topic has not yet been rated - Rate this topic

2.2.5.4.6 Member Properties

Office

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 propertycache field (section 2.2.5.3.5). The associated pivot field (section 2.2.5.4.3) of a member propertycache field (section 2.2.5.3.5) is specified to be a member propertypivot 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 propertypivot 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 propertypivot 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).

Did you find this helpful?
(1500 characters remaining)
Thank you for your feedback
Show:
© 2014 Microsoft. All rights reserved.