2.4.311 SXVDTEx
The SXVDTEx record specifies OLAP extensions to a pivot field. This record MUST NOT exist if this PivotTable view is a non-OLAP PivotTable view.
The pivot field associated with this record is the pivot field with an index that equals the index of this SXVDTEx record in the collection of SXVDTEx records of this PivotTable view.
The count of SXVDTEx records MUST equal the count of pivot fields in the OLAP PivotTable view.
|
|
|
|
|
|
|
|
|
|
1 |
|
|
|
|
|
|
|
|
|
2 |
|
|
|
|
|
|
|
|
|
3 |
|
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
frtHeaderOld |
|||||||||||||||||||||||||||||||
|
A |
B |
C |
D |
E |
F |
reserved |
isxth |
||||||||||||||||||||||||
|
isxtl |
|||||||||||||||||||||||||||||||
|
csxvi |
|||||||||||||||||||||||||||||||
|
rgsxvi (variable) |
|||||||||||||||||||||||||||||||
|
... |
|||||||||||||||||||||||||||||||
frtHeaderOld (4 bytes): An FrtHeaderOld structure. The frtHeaderOld.rt field MUST be 0x080F.
A - fTensorSort (1 bit): A bit that specifies whether the sort order is determined by the OLAP source data. See Pivot Field Sorting for more information.
B - fDrilledLevel (1 bit): A bit that specifies whether all pivot items in this pivot field are expanded. See Collapsing for more information.
C - fItemsDrilledByDefault (1 bit): A bit that specifies whether this attribute hierarchy is expanded by default. See Collapsing for more information.
D - fMemPropDisplayInReport (1 bit): A bit that specifies whether this member property pivot field is displayed in the PivotTable report. See row axis or column axis for more information. MUST be 0 if the PivotCache functionality level of the associated PivotCache is less than 3. MUST be ignored if this pivot field is not a member property pivot field.
E - fMemPropDisplayInTip (1 bit): A bit that specifies whether this member property pivot field is displayed in a ToolTip. MUST be 0 if the PivotCache functionality level of the associated PivotCache is less than 3. MUST be ignored if this pivot field is not a member property pivot field.
F - fMemPropDisplayInCaption (1 bit): A bit that specifies whether to display member property captions from this pivot field, for a pivot field of the associated OLAP levels and associated pivot hierarchy as this pivot field, instead of the pivot item captions. The pivot field for which to display captions has an SXAddl_SXCField12_SXDMemberCaption record. MUST be 0 if the PivotCache functionality level of the associated PivotCache is less than 3. MUST be ignored if this pivot field is not a member property pivot field.
reserved (10 bits): MUST be zero, and MUST be ignored.
isxth (2 bytes): A signed integer that specifies the pivot hierarchy that this pivot field is associated with. See Association of Pivot Hierarchies and Pivot Fields and Cache Fields for more information. MUST be a value from the following table:
-
Value
Meaning
-1
This pivot field is not part of a pivot hierarchy.
Greater than or equal to zero
This specifies a pivot hierarchy index, as specified in Pivot Hierarchies, that specifies a pivot hierarchy.
MUST be greater than or equal to -1 and less than the csxth field of the SXViewEx record of the PivotTable view.
isxtl (4 bytes): A signed integer that specifies the zero-based index of the OLAP level associated with the pivot hierarchy. If isxth specifies a pivot hierarchy that is not an OLAP Hierarchy, this value MUST be ignored.
csxvi (4 bytes): A signed integer that specifies the number of items in the array specified by rgsxvi. MUST equal the count of pivot items in this pivot field.
rgsxvi (variable): An array of SXVIFlags that specifies additional properties for the pivot items in this pivot field. Each SXVIFlags in the rgsxvi array specifies additional properties of the pivot item with a pivot item index equal to the index of the SXVIFlags element in the rgsxvi array.
-
The number of elements in this array MUST equal csxvi.