[Table of Contents] [docx version]

SpreadsheetML Reference Material - Table of Contents

calculatedMembers (Calculated Members)

Represents the collection of calculated members in an OLAP PivotTable.

[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>

end example]

Parent Elements

pivotCacheDefinition3.10.1.67)

 

Child Elements

Subclause

calculatedMember (Calculated Member)

§3.10.1.10

 

Attributes

Description

count (Calculated Members Count)

Specifies the number of calculated members.

 

The possible values for this attribute are defined by the XML Schema unsignedInt datatype.

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

<complexType name="CT_CalculatedMembers">

   <sequence>

   <element name="calculatedMember" maxOccurs="unbounded" type="CT_CalculatedMember"/>

   </sequence>

   <attribute name="count" type="xsd:unsignedInt"/>

</complexType>