2.4.263 BrtBeginSXTH

The BrtBeginSXTH record specifies properties of a pivot hierarchy (section 2.2.5.3.4) and specifies a collection of records as defined by the PivotTable (section 2.1.7.40) part ABNF. The collection of records specifies a pivot hierarchy.

A - fOutlineMode (1 bit):  A bit that specifies whether the pivot fields (section 2.2.5) representing the levels of this pivot hierarchy have the fOutline field of the BrtBeginSXVD record (section 2.4.272) set to 1 when the pivot fields are first created. See section 2.2.5.3.7.4.2 for more information.

B - fEnableMultiplePageItems (1 bit):  A bit that specifies whether multiple OLAP members can be selected when the pivot hierarchy is on the page axis (section 2.2.5.3.7.1) of the PivotTable view (section 2.2.5.3).

C - fSubtotalAtTop (1 bit):  A bit that specifies whether the pivot fields representing the levels of this pivot hierarchy have the fSubtotalAtTop field of the BrtBeginSxvd record set to 1 when the pivot fields are first created. See Subtotaling (section 2.2.5.3.7.4.2) for more information.

D - fDontShowFList (1 bit):  A bit that specifies whether this pivot hierarchy is hidden in the pivot field list, a mechanism for adding and removing pivot fields and pivot hierarchies from the PivotTable view.

E - fDragToRow (1 bit):  A bit that specifies whether this pivot hierarchy can be placed on the row axis of the PivotTable view. Possible values for this field and their meanings are listed in the following table.

Value	Meaning
0	Specifies that this pivot hierarchy cannot be placed on the row axis of the PivotTable view.
1	Specifies that this pivot hierarchy can be placed on the row axis of the PivotTable view. If this field is equal to 1, the fMeasure field on the BrtBeginPCDHierarchy (section 2.4.146) record of the associated cache hierarchy (section 2.2.5.2.7) MUST be 0.

F - fDragToColumn (1 bit):  A bit that specifies whether this pivot hierarchy can be placed on the column (1) axis of the PivotTable view. Possible values for this field and their meanings are listed in the following table.

Value	Meaning
0	Specifies that this pivot hierarchy cannot be placed on the column (1) axis of the PivotTable view.
1	Specifies that this pivot hierarchy can be placed on the column (1) axis of the PivotTable view. If this field is equal to 1, the fMeasure field of the BrtBeginPCDHierarchy record of the associated cache hierarchy MUST be 0.

G - fDragToPage (1 bit):  A bit that specifies whether this pivot hierarchy can be placed on the page axis (section 2.2.5.3.7.1) of the PivotTable view. Possible values for this field and their meanings are listed in the following table.

Value	Meaning
0	Specifies that this pivot hierarchy cannot be placed on the page axis of the PivotTable view.
1	Specifies that this pivot hierarchy can be placed on the page axis of the PivotTable view. If this field is equal to 1, the fMeasure field in the BrtBeginPCDHierarchy record of the associated cache hierarchy MUST be 0.

H - fDragToHide (1 bit):  A bit that specifies whether this pivot hierarchy can be removed from the PivotTable view.

I - fDragToData (1 bit):  A bit that specifies whether this pivot hierarchy can be placed on the data axis (section 2.2.5.3.7.5) of the PivotTable view. Possible values for this field and their meanings are listed in the following table.

Value	Meaning
0	Specifies that this pivot hierarchy cannot be placed on the data axis of the PivotTable view.
1	Specifies that this pivot hierarchy can be placed on the data axis of the PivotTable view. If this field is equal to 1, the fMeasure field on the BrtBeginPCDHierarchy record of the associated cache hierarchy MUST be 1.

J - fFilterInclusive (1 bit):  A bit that specifies whether manual filters (section 2.2.5.3.5) applied to this pivot hierarchy are inclusive or exclusive. This value MUST be a value from the following table.

Value	Meaning
0	OLAP members specified in the manual filter are excluded from the PivotTable view along with their descendants.
1	OLAP members specified in the manual filter are included from the PivotTable view along with their ascendants and descendants.

For more information, see section 2.2.5.3.5.2.

reserved1 (22 bits): This value MUST be 0, and MUST be ignored.

K - fLoadCap (1 bit):  A bit that specifies whether an irstCaption is included in this record.

reserved2 (15 bits): This value MUST be 0, and MUST be ignored.

irstCaption (variable):  An XLWideString (section 2.5.169) that specifies the user-defined caption of this pivot hierarchy. This value MUST exist if fLoadCap is 1. This value MUST NOT exist if fLoadCap is 0. This value MUST be less than or equal to 32,767 characters in length.