2.1.769 Part 1 Section 18.10.1.47, kpi (OLAP KPI)

a.   The standard implies that the caption attribute is optional.

Excel requires this attribute.

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

c.   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 most 32767 characters.

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

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

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

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

g.   The standard does not limit the length of the value of the value 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 goal 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.

i.   The standard does not limit the length of the value of the status 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.

j.   The standard does not limit the length of the value of the trend 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.

k.   The standard does not limit the length of the value of the weight 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.

l.   The standard does not limit the length of the value of the time 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.

m.   The standard states that the time attribute can be present.

Office reports files as corrupt that contain this attribute.

n.   The standard states the values of the weight attribute are defined by the Xstring simple type.

Office will not successfully open files when this attribute is non-empty and contains a value that does not match the uniqueName attribute value of a cacheHierarchy with a measure value of 1.

o.   The standard places no restrictions on the relationship between the parent attribute and the uniqueName attribute on the parent kpi element.

Excel requires the value of the parent attribute, when not null, to be equal to the value of the uniqueName attribute on the parent kpi element.

p.   The standard places no restrictions on the relationship between the value attribute and the uniqueName attribute on the cacheHierarchy element.

Excel requires the value of the value attribute to be equal to the value of the uniqueName attribute on a cacheHierarchy element whose measure attribute has a value of 1.

q.   The standard places no restrictions on the relationship between the goal attribute and the uniqueName attribute on the cacheHierarchy element.

Excel requires the value of the goal attribute to be equal to the value of the uniqueName attribute on a cacheHierarchy element whose measure attribute has a value of 1.

r.   The standard places no restrictions on the relationship between the status attribute and the uniqueName attribute on the cacheHierarchy element.

Excel requires the value of the status attribute to be equal to the value of the uniqueName attribute on a cacheHierarchy element whose measure attribute has a value of 1.

s.   The standard places no restrictions on the relationship between the trend attribute and the uniqueName attribute on the cacheHierarchy element.

Excel requires the value of the trend attribute to be equal to the value of the uniqueName attribute on a cacheHierarchy element whose measure attribute has a value of 1.