CalculatedMember Class
Defines the CalculatedMember Class.This class is only available in Office2010.When the object is serialized out as xml, its qualified name is x14:calculatedMember.
Inheritance Hierarchy
System.Object
DocumentFormat.OpenXml.OpenXmlElement
DocumentFormat.OpenXml.OpenXmlCompositeElement
DocumentFormat.OpenXml.Office2010.Excel.CalculatedMember
Namespace: DocumentFormat.OpenXml.Office2010.Excel
Assembly: DocumentFormat.OpenXml (in DocumentFormat.OpenXml.dll)
Syntax
'Declaration
<ChildElementInfoAttribute(GetType(TupleSet), FileFormatVersions.Office2010)> _
<OfficeAvailabilityAttribute(FileFormatVersions.Office2010)> _
Public Class CalculatedMember _
Inherits OpenXmlCompositeElement
'Usage
Dim instance As CalculatedMember
[ChildElementInfoAttribute(typeof(TupleSet), FileFormatVersions.Office2010)]
[OfficeAvailabilityAttribute(FileFormatVersions.Office2010)]
public class CalculatedMember : OpenXmlCompositeElement
Remarks
The following table lists the possible child types:
- TupleSet <x14:tupleSet>
2.4.13 calculatedMember
Target namespace: https://schemas.microsoft.com/office/spreadsheetml/2010/main
A CT_CalculatedMember element that specifies extended properties of a PivotTable ([ISO/IEC-29500-1] section 18.10) OLAP calculated member. See Pivot Table Cache Definition under Extensions by Part for how this element integrates with [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.3 for the full W3C XML Schema ([XMLSCHEMA1] section 2.1).
2.6.15 CT_CalculatedMember
Target namespace: https://schemas.microsoft.com/office/spreadsheetml/2010/main
Referenced by: calculatedMember
This complex type specifies extended properties of a PivotTable ([ISO/IEC-29500-1] section 18.10) OLAP calculated member.
Child Elements:
tupleSet : A CT_TupleSet element 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 65536 characters. MUST NOT exist if the set attribute in the ancestor CT_CalculatedMember ([ISO/IEC-29500-4] section A.2) element is 0.
flattenHierarchies : A boolean ([XMLSCHEMA2] section 3.2.2) attribute that specifies whether to display members from different OLAP levels of the same PivotTable ([ISO/IEC-29500-1] section 18.10) cache hierarchy of this PivotTable ([ISO/IEC-29500-1] section 18.10) named set in the same PivotTable ([ISO/IEC-29500-1] section 18.10) field. MUST NOT exist if the set attribute in the ancestor CT_CalculatedMember ([ISO/IEC-29500-4] section A.2) element is 0.
Value |
Meaning |
0 |
Each member from a different level of the same PivotTable ([ISO/IEC-29500-1] section 18.10) cache hierarchy of this PivotTable ([ISO/IEC-29500-1] section 18.10) named set is displayed in a separate PivotTable ([ISO/IEC-29500-1] section 18.10) field. |
1 |
All members from different levels of the same PivotTable ([ISO/IEC-29500-1] section 18.10) cache hierarchy of this PivotTable ([ISO/IEC-29500-1] section 18.10) named set are displayed in the same PivotTable ([ISO/IEC-29500-1] section 18.10) field. |
dynamicSet : A boolean ([XMLSCHEMA2] section 3.2.2) attribute that specifies whether this PivotTable ([ISO/IEC-29500-1] section 18.10) named set is a dynamic OLAP named set. MUST NOT exist if set attribute in the ancestor CT_CalculatedMember ([ISO/IEC-29500-4] section A.2) element is 0.
Value |
Meaning |
0 |
This PivotTable ([ISO/IEC-29500-1] section 18.10) named set is a static OLAP named set. |
1 |
This PivotTable ([ISO/IEC-29500-1] section 18.10) named set is a dynamic OLAP named set. |
hierarchizeDistinct : A boolean ([XMLSCHEMA2] section 3.2.2) attribute that specifies whether to automatically order and remove duplicates from this PivotTable ([ISO/IEC-29500-1] section 18.10) named set. MUST NOT exist if the set attribute in the ancestor CT_CalculatedMember ([ISO/IEC-29500-4] section A.2) element is 0.
Value |
Meaning |
0 |
Do not automatically order and remove duplicates from this PivotTable ([ISO/IEC-29500-1] section 18.10) named set. |
1 |
Automatically order and remove duplicates from this PivotTable ([ISO/IEC-29500-1] section 18.10) named set. |
mdxLong : An ST_Xstring ([ISO/IEC-29500-1] section 22.9.2.19) attribute that specifies multidimensional expression (MDX) of the PivotTable ([ISO/IEC-29500-1] section 18.10) OLAP calculated member. The length of this attribute MUST be zero or it MUST be greater than 32767 characters and less than 1073741823 characters. If this value is greater than 32767 characters, the length of the mdx attribute in the ancestor CT_CalculatedMember ([ISO/IEC-29500-4] section A.2) 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.3 for the full W3C XML Schema ([XMLSCHEMA1] section 2.1).
Thread Safety
Any public static (Shared in Visual Basic) members of this type are thread safe. Any instance members are not guaranteed to be thread safe.