1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
|
<html dir="ltr"><head>
<META http-equiv="Content-Type" content="text/html; charset=UTF-8">
<META HTTP-EQUIV="assetid" CONTENT="HV01104452"><META NAME="lcid" CONTENT="1033"><title>CalculatedMember element</title><link rel="stylesheet" type="text/css" href="office10.css"><script type="text/javascript" language="Javascript" src="ExpCollapse.js"></script><script type="text/javascript" language="JavaScript" src="inline.js"></script></head><body><h1>CalculatedMember element</h1><p>Contains information about a calculated member in an OLAP-based PivotTable view or report.</p><h2>Usage</h2><pre>
<code>
<CalculatedMember />
</code>
</pre><h2>Element Information</h2><table>
<tr>
<td>
<b class="bterm">Element type</b>
</td>
<td>Anonymous</td>
</tr>
<tr>
<td>
<b class="bterm">Namespace</b>
</td>
<td>urn:schemas-microsoft-com:office:excel</td>
</tr>
<tr>
<td>
<b class="bterm">Schema name</b>
</td>
<td>XML Spreadsheet 2000</td>
</tr>
</table><h2>Elements and Attributes</h2><h3>Parent Elements</h3><table>
<tr>
<th>Element</th>
<th>Description</th>
</tr>
<tr>
<td><a href="xelePivotTable_HV01104867.htm" id="HV01104867" lcid="">PivotTable</a></td>
<td>Contains information about a PivotTable view.</td>
</tr>
</table><h3>Child Elements</h3><table>
<tr>
<th>Element</th>
<th>Description</th>
</tr>
<tr>
<td><a href="xeleName_CalculatedMember_HV01104750.htm" id="HV01104750" lcid="">Name</a></td>
<td>Specifies the name of the OLAP calculated member.</td>
</tr>
<tr>
<td><a href="xeleMemberName_HV01104737.htm" id="HV01104737" lcid="">MemberName</a></td>
<td>Specifies a caption (display name) for the custom OLAP calculated member (not used for sets).</td>
</tr>
<tr>
<td><a href="xeleParentUniqueName_CalculatedMember_HV01104850.htm" id="HV01104850" lcid="">ParentUniqueName</a></td>
<td>Specifies a unique name for the parent member of the OLAP calculated member (not used for sets).</td>
</tr>
<tr>
<td><a href="xeleSourceHierarchy_CalculatedMember_HV01104986.htm" id="HV01104986" lcid="">SourceHierarchy</a></td>
<td>Specifies a unique name for the hierarchy with which the OLAP calculated member is associated (not used for sets).</td>
</tr>
<tr>
<td><a href="xeleSourceHierarchyLevel_CalculatedMember_HV01104988.htm" id="HV01104988" lcid="">SourceHierarchyLevel</a></td>
<td>Contains an index of the hierarchy level to which a particular OLAP member property applies. A value of 32767 indicates that the OLAP member property applies to all the levels in a hierarchy.</td>
</tr>
<tr>
<td><a href="xeleFormula_CalculatedMember_HV01104623.htm" id="HV01104623" lcid="">Formula</a></td>
<td>Contains the MDX representation of the formula for the OLAP calculated member.</td>
</tr>
<tr>
<td><a href="xeleSolveOrder_HV01104972.htm" id="HV01104972" lcid="">SolveOrder</a></td>
<td>Specifies where in a sequence of calculations a calculated member will be computed and applied.</td>
</tr>
<tr>
<td><a href="xeleInvalid_HV01104690.htm" id="HV01104690" lcid="">Invalid</a></td>
<td>Contains a Boolean value indicating that the OLAP cube changed in such a way as to invalidate the OLAP calculated member.</td>
</tr>
<tr>
<td><a href="xeleSet_CalculatedMember_HV01104961.htm" id="HV01104961" lcid="">Set</a></td>
<td>Contains a Boolean value indicating that a calculation creates a custom OLAP set.</td>
</tr>
</table><h3>Attributes</h3><p>None.</p><h2>Definition</h2><pre>
<code>
<xsd:element name="CalculatedMember" minOccurs="0" >
<xsd:complexType>
<xsd:sequence>
<xsd:element name="Name" type="xsd:string" minOccurs="0">
</xsd:element>
<xsd:element name="MemberName" type="xsd:string" minOccurs="0">
</xsd:element>
<xsd:element name="ParentUniqueName" type="xsd:string" minOccurs="0">
</xsd:element>
<xsd:element name="SourceHierarchy" type="xsd:string" minOccurs="0">
</xsd:element>
<xsd:element name="SourceHierarchyLevel" type="xsd:integer" minOccurs="0">
</xsd:element>
<xsd:element name="Formula" type="xsd:string" minOccurs="0">
</xsd:element>
<xsd:element name="SolveOrder" type="xsd:integer" minOccurs="0">
</xsd:element>
<xsd:element name="Invalid" minOccurs="0">
</xsd:element>
<xsd:element name="Set" minOccurs="0">
</xsd:element>
</xsd:sequence>
</xsd:complexType>
</xsd:element>
</code>
</pre><center><a href="XMLSchemaCopyright_HV01147162.htm">©2003-2004 Microsoft Corporation. All rights reserved.</a>
Permission to copy, display and distribute this document is available at: <a
href="http://r.office.microsoft.com/r/rlidAWSContentRedir?AssetID=XT010988631033&CTT=11&Origin=HV011232471033"
target="_new">http://msdn.microsoft.com/library/en-us/odcXMLRef/html/odcXMLRefLegalNotice.asp</a></center></body></html>
|
