<calculatedMember> (Calculated Member)

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: 
<calculatedMembers count="1">
  <calculatedMember name="[Product].[Product Categories].[All 
    Products].[Calculated Member]" mdx="'[Product].[Product Categories].[All 
    Products].[Accessories]'" memberName="Calculated Member" 
    hierarchy="[Product].[Product Categories]" parent="[Product].[Product 
    Categories].[All Products]"/>
</calculatedMembers>

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:

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:

<complexType name="CT_CalculatedMember">
	<sequence minOccurs="0">
	<element name="extLst" minOccurs="0" type="CT_ExtensionList"/>
	</sequence>
	<attribute name="name" use="required" type="ST_Xstring"/>
	<attribute name="mdx" use="required" type="ST_Xstring"/>
	<attribute name="memberName" type="ST_Xstring"/>
	<attribute name="hierarchy" type="ST_Xstring"/>
	<attribute name="parent" type="ST_Xstring"/>
	<attribute name="solveOrder" type="xsd:int" default="0"/>
	<attribute name="set" type="xsd:boolean" default="false"/>
</complexType>