2.1.772 Part 1 Section 18.10.1.51, map (OLAP Measure Group)

a.   The standard does not place any restrictions on the value of the measureGroup attribute.

In Office, the value of the measureGroup attribute must be less than the number of items in measureGroups collection.

b.   The standard does not restrict the value of @dimension.

In Office, @dimension must be less than the number of items in the dimensions collection.

c.   The standard does not specify the base of the dimension attribute index.

Office treats the dimension attribute as a zero-based index.

d.   The standard does not specify the base of the measureGroup attribute index.

Office treats the measureGroup attribute as a zero-based index.

e.   The standard states that the dimension attribute is optional.

Excel requires this attribute.

f.   The standard implies that the measureGroup attribute is optional.

Excel requires this attribute.