2.1.745 Part 1 Section 18.10.1.10, calculatedMember (Calculated Member)
a. The standard discusses calculatedMember in the context of calculated OLAP hierarchies only.
-
In Office, the calculatedMember element can also be used to represent a named set.
b. The standard does not have a length restriction for the name attribute.
-
Office limits the name attribute to being non-empty and less than 64000 characters.
c. The standard does not specify a length restriction for the mdx attribute.
-
Office limits the mdx attribute to being non-empty; if the createdVersion attribute of the pivotCacheDefinition is less than 3, the mdx attribute max length is less than 2049, otherwise it is 32767.
d. The standard states that calculated items cannot be added.
-
Office does allow the addition of calculated items.
e. The standard does not limit the length of the value of the memberName attribute.
-
Excel restricts the value of this attribute to be at least 1 and at most 65535 characters.
f. The standard does not limit the length of the value of the hierarchy attribute.
-
Excel restricts the value of this attribute to be at least 1 and at most 65535 characters.
g. The standard does not limit the length of the value of the parent attribute.
-
Excel restricts the value of this attribute to be at least 1 and at most 65535 characters.
h. The standard does not specify a dependency of the memberName attribute on the set attribute.
-
Office requires that the memberName attribute shall be specified if the set attribute equals 0; it shall not be specified if the set attribute equals 1.
i. The standard does not specify a dependency of the hierarchy attribute on the set attribute.
-
Office requires that the hierarchy attribute shall be specified if the set attribute equals 0; it shall not be specified if the set attribute equals 1.
j. The standard does not specify a dependency between the parent attribute and the set attribute.
-
Office requires that the parent attribute shall not be specified if the set attribute equals 1.