2.4.261 BrtBeginSXTDMP
The BrtBeginSXTDMP record specifies properties of a member property and specifies the beginning of an empty collection of records as defined by the PivotTable (section 2.1.7.40) part ABNF.
|
|
|
|
|
|
|
|
|
|
1 |
|
|
|
|
|
|
|
|
|
2 |
|
|
|
|
|
|
|
|
|
3 |
|
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
cchLevelUnq |
ichPropName |
||||||||||||||||||||||||||||||
|
cchPropName |
isxtl |
||||||||||||||||||||||||||||||
|
... |
isxvd |
||||||||||||||||||||||||||||||
|
... |
A |
B |
C |
reserved3 |
|||||||||||||||||||||||||||
|
irstProperty (variable) |
|||||||||||||||||||||||||||||||
|
... |
|||||||||||||||||||||||||||||||
cchLevelUnq (2 bytes): An unsigned integer that specifies the length of the MDX unique name of the associated OLAP level represented by the cache hierarchy (section 2.2.5.2.7) that is associated with this pivot hierarchy (section 2.2.5.3.4). This MDX unique name comes before the member property name in irstProperty.
-
For example, if the value of irstProperty equals "[Store].[Store Name].[Store Manager]", cchLevelUnq equals 20. This refers to "[Store].[Store Name]".
ichPropName (2 bytes): An unsigned integer that specifies the zero-based position of the character where the member property name portion begins in irstProperty. This value MUST be equal to the value as specified by the following formula.
-
ichPropName = cchLevelUnq + 2
-
For example, if the value of irstProperty equals "[Store].[Store Name].[Store Manager]", ichPropName equals 22. This refers to the starting character of "Store Manager".
-
cchPropName (2 bytes): An unsigned integer that specifies the length of the member property name portion of irstProperty. This value MUST be equal to the value as specified by the following formula, where 'n' is the length of irstProperty.
-
cchPropName = n – ichPropName – 1
-
For example, if the value of irstProperty equals "[Store].[Store Name].[Store Manager]", cchPropName equals 13. This refers to the length of "Store Manager".
isxtl (4 bytes): An unsigned integer that specifies the zero-based ordinal of the associated OLAP level represented by the cache hierarchy that is associated with this pivot hierarchy. If this value is equal to 32,767, this specifies that this member property will apply to all levels. If this value is not equal to 32,767 and isxvd is not equal to -1, then this value MUST be equal to the isxtl field of the BrtBeginPCDField (section 2.4.136) record of the cache field (section 2.2.5.2.2) associated with the pivot field specified by isxvd.
isxvd (4 bytes): An ISXVD (section 2.5.84) that specifies the pivot field that this member property is associated with. This value MUST NOT be equal to -2.
-
If this value is not equal to -1, the fOlapMemPropField of the BrtBeginPCDField record of the cache field associated with the pivot field specified by this field MUST be 1. If this value is not equal to -1, irstProperty MUST be equal to the stFldName field of the BrtBeginPCDField record of the cache field associated with the pivot field specified by this field.
-
If this value is equal to -1, irstProperty MUST NOT equal the stFldName of any BrtBeginPCDField records on the PivotCache (section 2.2.5.2) associated with this PivotTable view.
A - fDisplayInReport (1 bit): A bit that specifies whether to show this member property value in a PivotTable cell.
B - reserved1 (1 bit): This value MUST be 0, and MUST be ignored.
C - reserved2 (1 bit): This value MUST be 0, and MUST be ignored.
reserved3 (13 bits): This value MUST be 0, and MUST be ignored.
irstProperty (variable): An XLWideString (section 2.5.169) that specifies the MDX unique name of this member property.