2.1.776 Part 1 Section 18.10.1.57, mp (OLAP Member Property)

  • Article

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

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

c.   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 ust also be specified.

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

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

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

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

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

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

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

k.   The standard does not state the relation between the name attribute 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.

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

Excel uses a default value of 0 for this attribute.

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

Excel uses a default value of 0 for this attribute.

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

Excel uses a default value of 0 for this attribute.