2.2.5.1 Data Functionality Level
A data functionality level is a number that represents a set of features and runtime behaviors in areas related to data manipulation and display, which includes PivotTable view (section 2.2.5.3), query tables and External Connections (section 2.2.8).
The data functionality level that a PivotCache (section 2.2.5.2) is created with is specified by the bVerCacheCreated field of the BrtBeginPivotCacheDef (section 2.4.168) record. The data functionality level that a PivotTable view is created with is specified by the bVerSxMacro field of the BrtBeginSXView (section 2.4.275) record.
The following table specifies various restrictions based on the value of the bVerCacheCreated field of the BrtBeginPivotCacheDef record.
|
Restriction |
Restriction for data functionality level <3 |
Restriction for data functionality level >=3 |
|---|---|---|
|
Maximum number of cache fields (section 2.2.5.2.2) |
1024 |
16384 |
|
Maximum number of cache items (section 2.2.5.2.3) of a cache field |
32500 |
1048576 |
|
Maximum string length of a cache item name |
256 |
32767 |
|
Maximum number of pivot items (section 2.2.5.3.3) to show in an AutoFilter |
255 |
2147483647 |
|
Maximum string length of the MDX formula specified by the pcdCalcMemCommon.stMdx field in the BrtBeginPCDCalcMem (section 2.4.126) record |
2048 |
32767 |
The bVerSxMacro field of the BrtBeginSXView (section 2.4.275) record MUST be greater than or equal to 3 if and only if the bVerCacheCreated field of the BrtBeginPivotCacheDef (section 2.4.168) record is greater than or equal to 3.