Export (0) Print
Expand All
Expand Minimize

2.4.275 SXDB

Office

The SXDB record specifies PivotCache properties.


0

1

2

3

4

5

6

7

8

9
1
0

1

2

3

4

5

6

7

8

9
2
0

1

2

3

4

5

6

7

8

9
3
0

1

crdbdb

idstm

A

B

C

D

E

F

unused1

unused2

cfdbdb

cfdbTot

crdbUsed

vsType

cchWho

rgb (variable)

...

crdbdb (4 bytes): A signed integer that specifies the number of cache records for this PivotCache. MUST be greater than or equal to 0. MUST be 0 for OLAP PivotCaches. MUST be ignored if fSaveData is 0.

idstm (2 bytes): An unsigned integer that specifies the stream (1) that contains the data for this PivotCache. MUST be equal to the value of the idstm field of the SXStreamID record that specifies the PivotCache stream (1) that contains this record.

A - fSaveData (1 bit): A bit that specifies whether cache records exist. MUST be 0 for OLAP PivotCaches.

B - fInvalid (1 bit): A bit that specifies whether the cache records are in the not-valid state. MUST be equal to 1 if the PivotCache functionality level is greater than or equal to 3. MUST be equal to 1 for OLAP PivotCaches. See cache records for more information.

C - fRefreshOnLoad (1 bit): A bit that specifies whether the PivotCache is refreshed on load.

D - fOptimizeCache (1 bit): A bit that specifies whether optimization is applied to the PivotCache to reduce memory usage. MUST be 0 and MUST be ignored for a non-ODBC PivotCache.

E - fBackgroundQuery (1 bit): A bit that specifies whether the query used to refresh the PivotCache is executed asynchronously. MUST be ignored if vsType not equals 0x0002.

F - fEnableRefresh (1 bit): A bit that specifies whether refresh of the PivotCache is enabled. MUST be equal to 0 if the PivotCache functionality level is greater than or equal to 3. MUST be equal to 0 for OLAP PivotCaches.

unused1 (10 bits): Undefined and MUST be ignored.

unused2 (2 bytes): Undefined and MUST be ignored.

cfdbdb (2 bytes): A signed integer that specifies the number of cache fields that corresponds to the source data. MUST be greater than or equal to 0.

cfdbTot (2 bytes): A signed integer that specifies the number of cache fields in the PivotCache. MUST be greater than or equal to 0.

crdbUsed (2 bytes): An unsigned integer that specifies the number of records used to calculate the PivotTable report. Records excluded by PivotTable view filtering are not included in this value. MUST be 0 for OLAP PivotCaches.

vsType (2 bytes): An unsigned integer that specifies the type of source data. MUST be equal to the value of the sxvs field of the SXVS record that follows the SXStreamID record that specifies the PivotCache stream (1) that contains this record.

cchWho (2 bytes): An unsigned integer that specifies the number of characters in rgb. MUST be equal to 0xFFFF, or MUST be greater than or equal to 1 and less than or equal to 0x00FF.

rgb (variable): An optional XLUnicodeStringNoCch structure that specifies the name of the user who last refreshed the PivotCache. MUST exist if and only if the value of cchWho is not equal to 0xFFFF.  If this field exists, the length MUST equal cchWho. The length of this value MUST be less than 256 characters. The name is an application-specific setting that is not necessarily related to the User Names StreamABNF.

Show:
© 2014 Microsoft