2.4.243 BrtBeginSXDI
The BrtBeginSXDI record specifies a data item (section 2.2.5.3.7.5.1) that summarizes data in a PivotTable (section 2.1.7.40) and specifies the beginning of a collection of records as defined by the PivotTable (section 2.1.7.40) part ABNF. Data items (section 2.2.5.3.7.5.1) use summary functions to combine values from the underlying source data (section 2.2.5.2.1).
|
|
|
|
|
|
|
|
|
|
1 |
|
|
|
|
|
|
|
|
|
2 |
|
|
|
|
|
|
|
|
|
3 |
|
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
isxvdData |
|||||||||||||||||||||||||||||||
|
iiftab |
|||||||||||||||||||||||||||||||
|
df |
|||||||||||||||||||||||||||||||
|
isxvd |
|||||||||||||||||||||||||||||||
|
isxvi |
|||||||||||||||||||||||||||||||
|
ifmt |
|||||||||||||||||||||||||||||||
|
fLoadDisplayName |
stDisplayName (variable) |
||||||||||||||||||||||||||||||
|
... |
|||||||||||||||||||||||||||||||
isxvdData (4 bytes): An ISXVD (section 2.5.84) that specifies the pivot field (section 2.2.5.3.2) that this data item summarizes. This value MUST NOT equal -1 or -2.
-
If the PivotTable view (section 2.2.5.3) is a non-OLAP PivotTable view, the values in the source data associated with the associated cache field (section 2.2.5.2.2) of the referenced pivot field are aggregated as specified in this record.
-
If the PivotTable view is an OLAP PivotTable view, the associated pivot hierarchy (section 2.2.5.3.4) of the referenced pivot field specifies the OLAP measure for this data item and the iiftab field is ignored. The associated pivot hierarchy is determined as specified in section 2.2.5.3.4.
-
The sxaxisData field of the referenced BrtBeginSXVD record (section 2.4.272) MUST be equal to 1.
iiftab (4 bytes): A DataConsolidationFunction (section 2.5.28) that specifies the aggregation function that applies to this data item. The valid values of this field are specified by the DataConsolidationFunction enumeration.
df (4 bytes): A ShowDataAs (section 2.5.134) that specifies the data format for this data item. This value MUST be less than or equal to 0x00000008.
isxvd (4 bytes): An ISXVD (section 2.5.84) that specifies the pivot field the calculations specified by the df field are based on. When df is greater than 0x00000000 and less than 0x00000005, this value MUST NOT equal -1 or -2. When df is 0x00000000 or greater than or equal to 0x00000005, this field is ignored.
isxvi (4 bytes): An unsigned integer that specifies which pivot item (section 2.2.5.3.3) the calculations specified by the df field are based on. When df is greater than 0x00000000 and less than 0x00000004, this field MUST be a value from the following table.
-
Value
Meaning
0x00000000 to 0x00100000
Specifies the pivot item index in the pivot field specified by isxvd, as specified in section 2.2.5.3.3. The referenced BrtBeginSXVI (section 2.4.274) record specifies the pivot item this calculation is based on.
0x001000FC
The calculation is based on the previous pivot item.
0x001000FD
The calculation is based on the next pivot item.
-
When df is 0x00000000 or greater than or equal to 0x00000004 this field is ignored.
-
ifmt (4 bytes): A PivotNumFmt (section 2.5.106) that specifies the format applied to this data item.
fLoadDisplayName (1 byte): A Boolean (section 2.5.98.3) that specifies whether the stDisplayName field exists after the fixed size portion of the record. This value MUST be a value from the following table.
-
Value
Meaning
0x00
stDisplayName does not exist.
0x01
stDisplayName exists.
stDisplayName (variable): An optional XLWideString (section 2.5.169) that specifies the name of the data item. If the value of the bVerSxMacro field defined in the associated BrtBeginSXView (section 2.4.275) record is less than 3, the length of this value MUST be less than 256 characters; otherwise it MUST be less than 32,768 characters. This value MUST exist if and only if fLoadDisplayName is 0x01.