2.4.317 SXVS
The SXVS record specifies the type of source data used for a PivotCache. This record is followed by a sequence of records that specify additional information about the source data.
|
|
|
|
|
|
|
|
|
|
1 |
|
|
|
|
|
|
|
|
|
2 |
|
|
|
|
|
|
|
|
|
3 |
|
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
sxvs |
|||||||||||||||||||||||||||||||
sxvs (2 bytes): An unsigned integer that specifies the type of source data used for the PivotCache. The types of records that follow this record are dictated by the value of this field. MUST be a value from the following table:
-
-
Name
-
Value
-
Meaning
SHEET
0x0001
Specifies that the source data is a range. This record MUST be followed by a DConRef record that specifies a simple range, or a DConName record that specifies a named range, or a DConBin record that specifies a built-in named range.
EXTERNAL
0x0002
Specifies that external source data is used. This record MUST be followed by a sequence of records beginning with a DbQuery record that specifies connection and query information that is used to retrieve external data.
CONSOLIDATION
0x0004
Specifies that multiple consolidation ranges are used as the source data. This record MUST be followed by a sequence of records beginning with an SXTbl record that specifies information about the multiple consolidation ranges.
SCENARIO
0x0010
The source data is populated from a temporary internal structure. In this case there is no additional source data information because the raw data does not exist as a permanent structure and the logic to produce it is application-dependent.
-