Export (0) Print
Expand All
Expand Minimize

2.1.767 Part 4 Section 3.10.1.6, cacheHierarchy (PivotCache Hierarchy)

a. The standard does not limit the length of the value of the uniqueName attribute.

Excel restricts the value of this attribute to be at least 1 and at most 255 characters when the createdVersion attribute on the pivotCacheDefinition element is less than 3 and 32767 characters otherwise.

b. The standard does not limit the length of the value of the caption attribute.

Excel restricts the value of this attribute to be at least 1 and at most 255 characters when the createdVersion attribute on the pivotCacheDefinition element is less than 3 and 32767 characters otherwise.

c. The standard states that the caption attribute is optional.

Excel requires this attribute.

d. The standard does not limit the length of the value of the defaultMemberUniqueName attribute.

Excel restricts the value of this attribute to be at most 255 characters when the createdVersion attribute on the pivotCacheDefinition element is less than 3 and 32767 characters otherwise.

e. The standard does not limit the length of the value of the allUniqueName attribute.

Excel restricts the value of this attribute to be at most 255 characters when the createdVersion attribute on the pivotCacheDefinition element is less than 3 and 32767 characters otherwise.

f. The standard does not limit the length of the value of the allCaption attribute.

Excel restricts the value of this attribute to be at most 255 characters when the createdVersion attribute on the pivotCacheDefinition element is less than 3 and 32767 characters otherwise.

g. The standard does not limit the length of the value of the dimensionUniqueName attribute.

Excel restricts the value of this attribute to be at least 1 and at most 255 characters when the createdVersion attribute on the pivotCacheDefinition element is less than 3 and 32767 characters otherwise.

h. The standard does not limit the length of the value of the displayFolder attribute.

Excel restricts the value of this attribute to be at most 65535 characters.

i. The standard does not limit the length of the value of the measureGroup attribute.

Excel restricts the value of this attribute to be at most 65535 characters.

j. The standard states that on and off are valid values of the attribute attribute.

Excel does not allow these values on this attribute.

This note applies to the following products: 2007, 2007 SP1, 2007 SP2.

k. The standard states that on and off are valid values of the hidden attribute.

Excel does not allow these values on this attribute.

This note applies to the following products: 2007, 2007 SP1, 2007 SP2.

l. The standard states that on and off are valid values of the keyAttribute attribute.

Excel does not allow these values on this attribute.

This note applies to the following products: 2007, 2007 SP1, 2007 SP2.

m. The standard states that on and off are valid values of the measure attribute.

Excel does not allow these values on this attribute.

This note applies to the following products: 2007, 2007 SP1, 2007 SP2.

n. The standard states that on and off are valid values of the measures attribute.

Excel does not allow these values on this attribute.

This note applies to the following products: 2007, 2007 SP1, 2007 SP2.

o. The standard states that on and off are valid values of the oneField attribute.

Excel does not allow these values on this attribute.

This note applies to the following products: 2007, 2007 SP1, 2007 SP2.

p. The standard states that on and off are valid values of the set attribute.

Excel does not allow these values on this attribute.

This note applies to the following products: 2007, 2007 SP1, 2007 SP2.

q. The standard states that on and off are valid values of the time attribute.

Excel does not allow these values on this attribute.

This note applies to the following products: 2007, 2007 SP1, 2007 SP2.

r. The standard states that on and off are valid values of the unbalanced attribute.

Excel does not allow these values on this attribute.

This note applies to the following products: 2007, 2007 SP1, 2007 SP2.

s. The standard states that on and off are valid values of the unbalancedGroup attribute.

Excel does not allow these values on this attribute.

This note applies to the following products: 2007, 2007 SP1, 2007 SP2.

t. The standard does not place any restrictions on the value for the parentSet attribute.

In Excel, the value must be less than the number of cacheHierarchy elements in cacheHierarchies collection.

u. The standard does not state value restrictions for the iconSet attribute.

Excel requires that the iconSet attribute be between 0 and 11.

v. The standard does not place any restrictions on the value for the set attribute.

In Excel, the values for the measure attribute and the set attribute cannot both be 1.

w. The standard does not place any restrictions on the value for the measure attribute.

In Excel, the values for the measure attribute and the set attribute cannot both be 1.

x. The standard does not specify the relationship between the dimensionUniqueName attribute and dimension item in the dimensions collection.

Excel requires that the dimensionUniqueName attribute match the uniqueName attribute of an item in the dimensions collection and must be present if the set attribute equals 0, measure=0, and hidden=0.

y. The standard states that the oneField attribute, when true, indicates this hierarchy is associated with only one field.

Excel requires that the oneField attribute be written out when the fieldsUsage collection contains one item.

z. The standard does not specify any dependencies between the measure attribute value and dimensions collection.

In Excel, if the measure attribute equals 0, the matching dimension shall not have measure=1; if the measure attribute equals 1, there shall be at least one dimension with measure=1 if dimensions collection present.

Show:
© 2014 Microsoft