CalculatedMember Class

Office 2010

Calculated Member.When the object is serialized out as xml, its qualified name is x:calculatedMember.

Namespace:  DocumentFormat.OpenXml.Spreadsheet
Assembly:  DocumentFormat.OpenXml (in DocumentFormat.OpenXml.dll)

[ChildElementInfoAttribute(typeof(CalculatedMemberExtensionList))]
public class CalculatedMember : OpenXmlCompositeElement

The following table lists the possible child types:

  • CalculatedMemberExtensionList <x:extLst>


[ISO/IEC 29500-1 1st Edition]

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


end example]

Parent Elements

calculatedMembers (§18.10.1.11)

Child Elements

Subclause

extLst (Future Feature Data Storage Area)

§18.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 (§22.9.2.19).

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 (§22.9.2.19).

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 (§22.9.2.19).

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 (§22.9.2.19).

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 (§22.9.2.19).

set (Set)

Specifies a boolean value that indicates whether this calculated member describes a calculated set rather than a calculated member.

A value of 1 or true indicates this is a calculated set.

A value of 0 or false indicates this is a calculated member.

The possible values for this attribute are defined by the W3C 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 W3C XML Schema int datatype.

[Note: The W3C XML Schema definition of this element’s content model (CT_CalculatedMember) is located in §A.2. end note]

© ISO/IEC29500: 2008.

Any public static (Shared in Visual Basic) members of this type are thread safe. Any instance members are not guaranteed to be thread safe.

Community Additions

ADD
Show:
© 2014 Microsoft