2.1.802 Part 4 Section 3.10.1.57, mp (OLAP Member Property)

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

Excel does not allow these values on this attribute.

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

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

Excel does not allow these values on this attribute.

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

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

Excel does not allow these values on this attribute.

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

d.   The standard does not state the relation between the name attribute and the nameLen attribute.

In Office, if the name attribute is specified, the nameLen attribute shall also be specified and gives the length of an OLAP hierarchy name.

e.   The standard does not state the relation between the name attribute and the pLen attribute.

In Office, if the name attribute is specified then the pLen attribute must also be specified.

f.   The standard does not state the relation between the name attribute and the pPos attribute.

In Office, if the name attribute is specified then the pPos attribute must also be specified.

g.   The standard does not state any relationship between the mp element and pivotTableDefinition@createdVersion.

Office assumes that if pivotTableDefinition@createdVersion is less than 3, then the name attribute shall be present.

h.   The standard says that mp represents an OLAP Member property.

Office assumes that if field is not 4294967295, then it specifies a valid index to a pivotField, in this PivotTable, which specifies the information for the member property that is not specified in this element.

i.   The standard limits the possible values for @level to unsignedInt.

Office requires that when specified, the value of @level be equal to the value of the associated cacheField element @level with the same name attribute as this element, or that the special value of 32767 be used to apply to all levels.

j.   The standard does not place restrictions on when the showAsCaption attribute is used.

Office ignores the showAsCaption attribute unless the name attribute is present and the uniqueMemberProperty attribute on the PivotField this element applies to is present.

k.   The standard does not place any restrictions on the value of @field.

In Office, the value of @field must refer to a valid pivotField or be equal to 4294967295.

l.   The standard does not state any relationship between the element and pivotTableDefinition@createdVersion.

In Office, if the pivotTableDefinition@createdVersion is greater than or equal to 3, then the field attribute shall not equal 4294967295 and the other attributes of this element shall not be present.

m.   The standard says that mp represents an OLAP Member property.

Office specifies that if field is not 4294967295, then the cacheField at index field in the associated PivotCache shall have memberPropertyField attribute equal to 1 or true.

n.   The standard does not state the relation between the name attrbute and the associated cacheField.

In Office, if name is specified and if field is not equal to 4294967295, then the associated cacheField shall have with a name attribute that matches this one and shall begin with the unique name of the OLAP hierarchy which this element is attached.

o.   The standard does not state a default value for the pPos attribute.

Excel uses a default value of 0 for this attribute.

p.   The standard does not state a default value for the pLen attribute.

Excel uses a default value of 0 for this attribute.

q.   The standard does not state a default value for the nameLen attribute.

Excel uses a default value of 0 for this attribute.

Show: