2.4.815 BrtSXDI14
The BrtSXDI14 record specifies additional information about a data item (section 2.2.5.3.7.5.1).
|
|
|
|
|
|
|
|
|
|
1 |
|
|
|
|
|
|
|
|
|
2 |
|
|
|
|
|
|
|
|
|
3 |
|
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
FRTHeader |
|||||||||||||||||||||||||||||||
|
df |
|||||||||||||||||||||||||||||||
|
isxvd |
|||||||||||||||||||||||||||||||
|
A |
reserved |
irstUniqueClient (variable) |
|||||||||||||||||||||||||||||
|
... |
|||||||||||||||||||||||||||||||
FRTHeader (4 bytes): An FRTBlank (section 2.5.55) that specifies the future record (section 2.1.6) information for this record.
df (4 bytes): A ShowDataAs (section 2.5.134) that specifies the data display format for this data item. If isxvd is equal to -1, then this field MUST be greater than or equal to 0x00000009. If this field is less than or equal to 0x00000008, then the df field of the immediately preceding BrtBeginSXDI (section 2.4.243) record MUST be equal to the value of this field and MUST be ignored. If this field is greater than or equal to 0x00000009, the df field of the immediately preceding BrtBeginSXDI record MUST be equal to 0 and MUST be ignored.
-
If this field is greater than 0x00000000 and less than 0x00000005, or if this field is greater than or equal to 0x0000000B, then the isxvd field of the immediately preceding BrtBeginSXDI record specifies the pivot field (section 2.2.5.3.2) that the calculations are based on, and the isxvd field of the immediately preceding BrtBeginSXDI record MUST NOT equal -1 or -2.
-
If this field is greater than 0x00000000 and less than 0x00000004, then the isxvi field of the immediately preceding BrtBeginSXDI record specifies the pivot item (section 2.2.5.3.3) that the calculations are based on.
isxvd (4 bytes): An ISXVD (section 2.5.84) that specifies the pivot field summarized by this data item. A value of -1 specifies that the isxvdData field of the immediately preceding BrtBeginSXDI record specifies the pivot field summarized by this data item. This field MUST NOT be equal to -2. This field MUST be equal to -1 for non-OLAP PivotTable views.
-
If this field is not equal to -1, the pivot field specified by the isxvdData field of the immediately preceding BrtBeginSXDI record MUST contain a BrtSXVD14 (section 2.4.830) record with an fIgnorable field equal to 1. The pivot hierarchy (section 2.2.5.3.4) associated with that pivot field (as specified in section 2.2.5.3.4)) MUST contain a BrtSXTH14 (section 2.4.820) record. The cache field (section 2.2.5.2.2) associated with that pivot field MUST contain a BrtPCDField14 (section 2.4.718) record. The cache hierarchy (section 2.2.5.2.7) associated with that cache field (as specified in section 2.2.5.2.7) MUST contain a BrtPCDH14 (section 2.4.719) record with an fIgnorable field equal to 1.
-
If this field is not equal to -1, the isxvdData field of the immediately preceding BrtBeginSXDI record SHOULD<48> be ignored.
-
For more details, see section 2.2.5.2.7.1 (Measures).
A - fUniqueClient (1 bit): A bit that specifies whether the irstUniqueClient field exists. This field MUST be equal to 1 if isxvd is not equal to -1.
reserved (7 bits): This value MUST be 0, and MUST be ignored.
irstUniqueClient (variable): An XLWideString (section 2.5.169) that specifies the unique name for duplicated OLAP measures. This field MUST exist if and only if the value of fUniqueClient is 1. This field MUST be unique within the PivotTable (section 2.1.7.40) part ABNF. If the string exists, the number of characters MUST be less than or equal to 65535.