CalculatedMember class

2.4.15 calculatedMember

Target namespace: http://schemas.microsoft.com/office/spreadsheetml/2009/9/main

A calculatedMember element is a CT_CalculatedMember type element, as specified in section 2.6.15, that specifies extended properties of a PivotTable, as specified in [ISO/IEC-29500-1] section 18.10, OLAP calculated member. See section 2.2.4.5 for how this element integrates with the Office Open XML file formats specified in [ISO/IEC-29500-1].

The following W3C XML Schema ([XMLSCHEMA1] section 2.1) fragment specifies the contents of this element.

<xsd:element name="calculatedMember" type="CT_CalculatedMember"/>

See section 5.4 for the full W3C XML Schema ([XMLSCHEMA1] section 2.1).

2.6.15 CT_CalculatedMember

Target namespace: http://schemas.microsoft.com/office/spreadsheetml/2009/9/main

Referenced by: calculatedMember

A complex type that specifies extended properties of a PivotTable ([ISO/IEC-29500-1] section 18.10) OLAP calculated member.

Child Elements:

tupleSet: A CT_TupleSet element (section 2.6.16) that specifies OLAP tuples within this OLAP named set.

Attributes:

displayFolder: An ST_Xstring ([ISO/IEC-29500-1] section 22.9.2.19) attribute that specifies the display folder of this PivotTable ([ISO/IEC-29500-1] section 18.10) named set. The length of this value MUST be less than 65,536 characters. This attribute MUST NOT exist if the set attribute in the ancestor CT_CalculatedMember ([ISO/IEC-29500-4] section A.2) element is zero ("0").

flattenHierarchies: A Boolean ([XMLSCHEMA2] section 3.2.2) attribute that specifies whether to display members from different OLAP levels of the same PivotTable cache hierarchy of this PivotTable named set in the same PivotTable field (1). This attribute MUST NOT exist if the set attribute in the ancestor CT_CalculatedMember element is zero ("0").

dynamicSet: A Boolean ([XMLSCHEMA2] section 3.2.2) attribute that specifies whether this PivotTable named set is a dynamic OLAP named set. This attribute MUST NOT exist if the set attribute in the ancestor CT_CalculatedMember element is zero ("0").

hierarchizeDistinct: A Boolean ([XMLSCHEMA2] section 3.2.2) attribute that specifies whether to automatically order and remove duplicates from this PivotTable named set. This attribute MUST NOT exist if the set attribute in the ancestor CT_CalculatedMember element is zero ("0").

mdxLong: An ST_Xstring attribute that specifies multidimensional expression (MDX) of the PivotTable OLAP calculated member. The length of this attribute MUST be zero or it MUST be greater than 32,767 characters and less than 1,073,741,823 characters. If this value is greater than 32,767 characters, the length of the mdx attribute in the ancestor CT_CalculatedMember element MUST be "1" and the first character of the mdx attribute MUST be equal to " ", the space character (0x0020).

The following W3C XML Schema ([XMLSCHEMA1] section 2.1) fragment specifies the contents of this complex type.

<xsd:complexType name="CT_CalculatedMember">

<xsd:sequence>

<xsd:element name="tupleSet" minOccurs="0" maxOccurs="1" type="CT_TupleSet"/>

</xsd:sequence>

<xsd:attribute name="displayFolder" type="x:ST_Xstring" use="optional"/>

<xsd:attribute name="flattenHierarchies" type="xsd:boolean" use="optional" default="true"/>

<xsd:attribute name="dynamicSet" type="xsd:boolean" use="optional" default="false"/>

<xsd:attribute name="hierarchizeDistinct" type="xsd:boolean" use="optional" default="true"/>

<xsd:attribute name="mdxLong" type="x:ST_Xstring" use="optional"/>

</xsd:complexType>

See section 5.4 for the full W3C XML Schema ([XMLSCHEMA1] section 2.1).

Reference