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/IEC29500-1:2016] 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/IEC29500-1:2016] section 22.9.2.19) attribute that specifies the display folder of this PivotTable ([ISO/IEC29500-1:2016] 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/IEC29500-4:2016] section A.2) element is zero ("0").
flattenHierarchies: A Boolean ([XMLSCHEMA2/2] 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. This attribute MUST NOT exist if the set attribute in the ancestor CT_CalculatedMember element is zero ("0").
|
Value |
Meaning |
|---|---|
|
"0" |
Each member from a different level of the same PivotTable cache hierarchy of this PivotTable named set is displayed in a separate PivotTable field. |
|
"1" |
All members from different levels of the same PivotTable cache hierarchy of this PivotTable named set are displayed in the same PivotTable field. |
dynamicSet: A Boolean ([XMLSCHEMA2/2] 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").
|
Value |
Meaning |
|---|---|
|
"0" |
This PivotTable named set is a static OLAP named set. |
|
"1" |
This PivotTable named set is a dynamic OLAP named set. |
hierarchizeDistinct: A Boolean ([XMLSCHEMA2/2] 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").
|
Value |
Meaning |
|---|---|
|
"0" |
Do not automatically order and remove duplicates from this PivotTable named set. |
|
"1" |
Automatically order and remove duplicates from this PivotTable named set. |
mdxLong: An ST_Xstring attribute that specifies Multidimensional Expressions (MDX) of the PivotTable OLAP calculated member. The length of this attribute MUST be 0 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/2] 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/2] section 2.1).