CalculatedMember Class
Calculated Member.When the object is serialized out as xml, its qualified name is x:calculatedMember.
Inheritance Hierarchy
System.Object
DocumentFormat.OpenXml.OpenXmlElement
DocumentFormat.OpenXml.OpenXmlCompositeElement
DocumentFormat.OpenXml.Spreadsheet.CalculatedMember
Namespace: DocumentFormat.OpenXml.Spreadsheet
Assembly: DocumentFormat.OpenXml (in DocumentFormat.OpenXml.dll)
Syntax
'Declaration
<ChildElementInfoAttribute(GetType(CalculatedMemberExtensionList))> _
Public Class CalculatedMember _
Inherits OpenXmlCompositeElement
'Usage
Dim instance As CalculatedMember
[ChildElementInfoAttribute(typeof(CalculatedMemberExtensionList))]
public class CalculatedMember : OpenXmlCompositeElement
Remarks
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: https://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.
Thread Safety
Any public static (Shared in Visual Basic) members of this type are thread safe. Any instance members are not guaranteed to be thread safe.