2.1.764 Part 4 Section 126.96.36.199, cacheField (PivotCache Field)
a. The standard does not restrict values of the hierarchy attribute.
In Office, the hierarchy attribute must be non-negative and less than the count of cacheHierarchie elements in the cacheHierarchies node. This attribute is only used by OLAP PivotCache.
b. The standard does not define all the possible values of the level attribute.
In Excel, the level attribute is only used by the OLAP PivotCache. If memberPropertyField is 0, this value shall be either 0x7fff (which means all levels) or it shall be less than the count of fieldUsage elements in fieldsUsage node.
c. The standard does not specify restrictions for the name attribute.
In Office, the name attribute must be unique. The name is case-insensitive and shall have length between 1 and 32767 inclusively. If the value of createdVersion is less than 3, @name shall not be longer than 255 characters.
d. The standard does not define maxLength restriction for the caption attribute.
In Office, the caption attribute shall not be longer than 32767; if createdVersion of pivotCacheDefinition is less than 3, then the caption attribute must not be defined.
e. The standard does not define length restriction for the propertyName attribute.
In Office, the propertyName attribute shall have length between 1 and 32767 inclusively.
f. In the standard the databaseField attribute is not restricted by data source type.
In Office, the databaseField attribute must be TRUE for OLAP data sources.
g. In the standard, the formula attribute is defined as a generic string.
Office requires that the formula attribute be a Pivot formula as defined in §188.8.131.52.8, Pivot Formulas.
h. In the standard the mappingCount attribute does not have restrictions.
In Office, the mappingCount attribute shall be less than or equal to number of cacheField items in the cacheFields collection.
i. The standard states that on and off are valid values of the databaseField, memberPropertyField, serverField, and uniqueList attributes.
Excel does not allow the on and off values on these attributes.
This note applies to the following products: 2007, 2007 SP1, 2007 SP2.
j. The standard does not specify restrictions for the memberPropertyField attribute.
In Office, the memberPropertyField attribute shall be 1 if the propertyName attribute is not empty and it shall be 0 or false for non-OLAP PivotCaches.
k. The standard does not restrict the formula attribute usage for different data sources.
In Office, the formula attribute shall not be specified for OLAP PivotCaches.
l. In the standard, there is no restriction on value of the databaseField attribute for the first cacheField in collection.
In Office, the first cacheField shall have a databaseField attribute equal to 1 or true.