Represents a calculated OLAP hierarchy. A calculated member is a member of an OLAP-based PivotTable whose value is calculated on the OLAP server. For PivotTables that are created from OLAP cubes the summarized values are precalculated on the OLAP server before the SpreadsheetML application displays the results. These fields appear in the PivotTable field list but cannot be changed from within the PivotTable. You cannot change the summary function used to calculate data fields or subtotals, or add calculated items.

Calculated members are defined by the Multidimensional Expressions (MDX) expression in the mdx attribute.

[Example:

end example]

Parent Elements

calculatedMembers (§3.10.1.11)

Child Elements	Subclause
extLst (Future Feature Data Storage Area)	§3.2.10

Attributes	Description
hierarchy (Hierarchy Name)	Specifies the name of the hierarchy to which the calculated member belongs. The possible values for this attribute are defined by the ST_Xstring simple type (§3.18.96).
mdx (Calculated Member MDX Formula)	Specifies the MDX formula for the calculated member. [Note: Data connectivity can use a number of different technologies. One example of potential values stored in this attribute can be found at: http://msdn2.microsoft.com/en-us/library/ms145595.aspx end note] The possible values for this attribute are defined by the ST_Xstring simple type (§3.18.96).
memberName (OLAP Calculated Member Name)	Specifies the OLAP member name for the calculated member. The possible values for this attribute are defined by the ST_Xstring simple type (§3.18.96).
name (Calculated Member Name)	Specifies the name of the calculated member. The possible values for this attribute are defined by the ST_Xstring simple type (§3.18.96).
parent (Parent Name)	Specifies the name of the parent of the calculated member. The possible values for this attribute are defined by the ST_Xstring simple type (§3.18.96).
set (Set)	Specifies a boolean value that indicates whether this calculated member describes a calculated set rather than a calculated member. A value of on, 1, or true indicates this is a calculated set. A value of off, 0, or false indicates this is a calculated member. The possible values for this attribute are defined by the XML Schema boolean datatype.
solveOrder (Calculated Members Solve Order)	Specifies the order in which this calculated member is calculated in relation to other calculated members. The possible values for this attribute are defined by the XML Schema int datatype.

The following XML Schema fragment defines the contents of this element:

</sequence>

</complexType>