Was this page helpful?
Additional feedback?
1500 characters remaining
Export (0) Print
Expand All
Collapse the table of content
Expand the table of content
Expand Minimize

2.1.733 Part 1 Section 18.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 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.

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

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

l.   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.

m.   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.

n.   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.

o.   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.

p.   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:
© 2016 Microsoft