2.4.274 BrtBeginSXVI
This record specifies a pivot item (section 2.2.5.3.3) 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 |
|
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
itmtype |
A |
B |
C |
D |
E |
F |
G |
H |
I |
reserved |
iCache |
||||||||||||||||||||
|
... |
displayName (variable) |
||||||||||||||||||||||||||||||
|
... |
|||||||||||||||||||||||||||||||
itmtype (1 byte): A PivotItemType (section 2.5.105) that specifies the type of this pivot item. This value MUST NOT equal PITGRAND or PITBLANK (section 2.5.105). All BrtBeginSXVI (section 2.4.274) records that have a value of PITDATA (defined in section 2.5.105) for the itmtype field MUST precede all other BrtBeginSXVI records in the PivotTable part ABNF.
A - fHidden (1 bit): A bit that specifies whether this pivot item is hidden by a manual filter (section 2.2.5.3.5). If this record applies to an OLAP PivotTable view (section 2.2.5.3) or the value of itmtype is not PITDATA, this value MUST be 0.
B - fHideDetail (1 bit): A bit that specifies whether this pivot item is collapsed. This value MUST be 0 for OLAP PivotTable views. For more details, section 2.2.5.3.7.4.1.
C - fFormula (1 bit): A bit that specifies whether the cache item (section 2.2.5.2.3) associated with this pivot item is a calculated item (section 2.2.5.2.6). If this record applies to an OLAP PivotTable view or the value of the itmtype field is not PITDATA, this value MUST be 0.
D - fMissing (1 bit): A bit that specifies whether this pivot item is missing from the source data (section 2.2.5.2.1). If this record applies to an OLAP PivotTable view or the value of itmtype is not PITDATA, this value MUST be 0.
E - fDisplayName (1 bit): A bit that specifies whether this pivot item has a user-defined caption.
F - fDrilledMember (1 bit): A bit that specifies whether this pivot item is expanded. This value MUST be 0 for non-OLAP PivotTable views, or if the fAttributeHierarchy field in the BrtBeginPCDHierarchy (section 2.4.146) record in the associated cache hierarchy (section 2.2.5.2.7), as specified by section 2.2.5.3.4, has a value of 1. If the value of itmtype is not PITDATA, this value MUST be 0. For more details, section 2.2.5.3.7.4.1.
G - fHasChildrenEst (1 bit): A bit that specifies whether the pivot item can have child objects. If this record applies to a non-OLAP PivotTable view, this value MUST be 0.
H - fCollapsedMember (1 bit): A bit that specifies whether this pivot item is collapsed when the preceding PivotTable view field is on the row axis or column (1) axis. The value MUST be 0 for non-OLAP PivotTable views. This value MUST be 0 unless the fAttributeHierarchy field in the BrtBeginPCDHierarchy record in the associated cache hierarchy, as specified by section 2.2.5.3.4, has a value of 1. This field MUST be ignored, unless there is a following pivot field (section 2.2.5.3.2) for which the fAttributeHierarchy field in the BrtBeginPCDHierarchy record in the associated cache hierarchy, as specified by cache hierarchies (section 2.2.5.2.7), also has a value of 1. For more details, section 2.2.5.3.7.4.1.
I - fOlapFilterSelected (1 bit): A bit that specifies whether this pivot item is included in the manual filter applied to the corresponding pivot field specified by the preceding BrtBeginSXVD record (section 2.4.272). This value MUST be 0 for non-OLAP PivotTable views. For more details, see section 2.2.5.3.5.2. The meaning of this value is specified in the following table.
-
Value of fFilterInclusive field of BrtBeginSXVD record
Value of fOlapFilterSelected
Meaning
1
1
This pivot item is included in the manual filter applied to the corresponding pivot field specified by the preceding BrtBeginSXVD record, and will be displayed in the corresponding PivotTable view specified by the preceding BrtBeginSXView (section 2.4.275) record.
1
0
This pivot item is not included in the manual filter applied to the corresponding pivot field specified by the preceding BrtBeginSXVD record, and will not be displayed in the corresponding PivotTable view specified by the preceding BrtBeginSXView record.
0
1
This pivot item is excluded from the manual filter applied to the corresponding pivot field specified by the preceding BrtBeginSXVD record, and will not be displayed in the corresponding PivotTable view specified by the preceding BrtBeginSXView record.
0
0
This pivot item is not excluded from the manual filter applied to the corresponding pivot field specified by the preceding BrtBeginSXVD record, and will be displayed in the corresponding PivotTable view specified by the preceding BrtBeginSXView record.
-
reserved (7 bits): This value MUST be 0, and MUST be ignored.
iCache (4 bytes): A signed integer that specifies a reference to a cache item. If itmtype is not PITDATA, a reference to a cache item is not specified and this value MUST be -1. Otherwise, this value MUST be a cache item index, as specified by Cache Items, in the cache field (section 2.2.5.2.2) that is associated with this pivot field.
displayName (variable): An XLWideString (section 2.5.169) that specifies the user-defined caption of this pivot item. This field exists only if the value of the fDisplayName field is 1. If the bVerSxMacro field of the BrtBeginSXView record for this PivotTable view is less than or equal to 2, the length MUST be less than 256 characters. Otherwise, the length MUST be less than 32,768 characters.