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
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
|
<html dir="ltr"><head>
<META http-equiv="Content-Type" content="text/html; charset=UTF-8">
<META HTTP-EQUIV="assetid" CONTENT="HV01104504"><META NAME="lcid" CONTENT="1033"><title>CubeField 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>CubeField element</h1><p>Contains information about a cube field (a hierarchy in an OLAP-based PivotTable view).</p><h2>Usage</h2><pre>
<code>
<CubeField />
</code>
</pre><h2>Element Information</h2><table>
<tr>
<td>
<b class="bterm">Element type</b>
</td>
<td><a href="xtcoCubeFieldType_HV01105097.htm" id="HV01105097" lcid="">CubeFieldType</a></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="xeleUniqueName_CubeFieldType_HV01105037.htm" id="HV01105037" lcid="">UniqueName</a></td>
<td>Contains the unique name of a field.</td>
</tr>
<tr>
<td><a href="xeleCaption_CubeFieldType_HV01104456.htm" id="HV01104456" lcid="">Caption</a></td>
<td>Contains the displayed name of a PivotTable field, the title of a chart, or the caption of a data label, series, Spreadsheet component, or trendline. For a PivotList component, contains the axis label, displayed name of a total, or the current filter value or page name.</td>
</tr>
<tr>
<td><a href="xeleDefaultItem_HV01104523.htm" id="HV01104523" lcid="">DefaultItem</a></td>
<td>Contains the name of the default page field item in a hierarchy.</td>
</tr>
<tr>
<td><a href="xeleAllItemName_HV01104394.htm" id="HV01104394" lcid="">AllItemName</a></td>
<td>Contains the unique name displayed for the page field when the user chooses to display all levels of a hierarchy.</td>
</tr>
<tr>
<td><a href="xeleDimension_HV01104539.htm" id="HV01104539" lcid="">Dimension</a></td>
<td>Contains the unique name of the dimension of a field.</td>
</tr>
<tr>
<td><a href="xeleDontShowInFieldList_HV01104572.htm" id="HV01104572" lcid="">DontShowInFieldList</a></td>
<td>Contains a Boolean value indicating whether a cube field should be shown in the field list for a PivotTable view or report.</td>
</tr>
<tr>
<td><a href="xeleMeasure_HV01104733.htm" id="HV01104733" lcid="">Measure</a></td>
<td>Specifies whether a field is a measure or hierarchy.</td>
</tr>
<tr>
<td><a href="xeleSet_CubeFieldType_HV01104962.htm" id="HV01104962" lcid="">Set</a></td>
<td>Contains a Boolean value indicating whether a cube field is a user-defined set.</td>
</tr>
<tr>
<td><a href="xeleNoDragToData_CubeFieldType_HV01104784.htm" id="HV01104784" lcid="">NoDragToData</a></td>
<td>Specifies whether a PivotTable field can be dragged to a data position.</td>
</tr>
<tr>
<td><a href="xeleNoDragToHide_CubeFieldType_HV01104786.htm" id="HV01104786" lcid="">NoDragToHide</a></td>
<td>Contains a Boolean value indicating that a cube field cannot be removed from a PivotTable view or report.</td>
</tr>
<tr>
<td><a href="xeleNoDragToRow_CubeFieldType_HV01104791.htm" id="HV01104791" lcid="">NoDragToRow</a></td>
<td>Specifies whether a PivotTable field can be dragged to a row position.</td>
</tr>
<tr>
<td><a href="xeleNoDragToColumn_CubeFieldType_HV01104782.htm" id="HV01104782" lcid="">NoDragToColumn</a></td>
<td>Specifies whether a PivotTable field can be dragged to a column position.</td>
</tr>
<tr>
<td><a href="xeleNoDragToPage_CubeFieldType_HV01104788.htm" id="HV01104788" lcid="">NoDragToPage</a></td>
<td>Specifies whether a PivotTable field can be dragged to a page position.</td>
</tr>
<tr>
<td><a href="xeleEnableMultiplePageItems_HV01104578.htm" id="HV01104578" lcid="">EnableMultiplePageItems</a></td>
<td>Contains a Boolean value indicating that the user is allowed to select two or more OLAP cube members when a given cube field is in the page area of the PivotTable view.</td>
</tr>
<tr>
<td><a href="xeleLayoutForm_CubeFieldType_HV01104705.htm" id="HV01104705" lcid="">LayoutForm</a></td>
<td>Specifies how items appear in a PivotTable report.</td>
</tr>
<tr>
<td><a href="xeleLayoutSubtotalLocation_CubeFieldType_HV01104708.htm" id="HV01104708" lcid="">LayoutSubtotalLocation</a></td>
<td>Specifies where subtotals are displayed in a PivotTable report.</td>
</tr>
<tr>
<td><a href="xeleOrientation_CubeFieldType_HV01104824.htm" id="HV01104824" lcid="">Orientation</a></td>
<td>Specifies whether the PivotTable properties in a PTLineItems element apply to a row or column, or specifies the orientation of a PivotTable field or a cube field axis.</td>
</tr>
<tr>
<td><a href="xeleMemberProperty_CubeFieldType_HV01104740.htm" id="HV01104740" lcid="">MemberProperty</a></td>
<td>Contains information about an OLAP member property field.</td>
</tr>
<tr>
<td><a href="xeleMemberPropertiesOrder_CubeFieldType_HV01104738.htm" id="HV01104738" lcid="">MemberPropertiesOrder</a></td>
<td>Specifies the order of a member property if a cube field is associated with multiple OLAP member properties.</td>
</tr>
<tr>
<td><a href="xeleHideDropDowns_CubeFieldType_HV01104666.htm" id="HV01104666" lcid="">HideDropDowns</a></td>
<td>Contains a Boolean value indicating whether the drop-down list for a field in the PivotTable view should be shown.</td>
</tr>
<tr>
<td><a href="xeleGroupLevel_HV01104652.htm" id="HV01104652" lcid="">GroupLevel</a></td>
<td>Describes the grouping properties for a hierarchy level in an OLAP-based PivotTable view or report.</td>
</tr>
<tr>
<td><a href="xeleIsGroupLevel_HV01104693.htm" id="HV01104693" lcid="">IsGroupLevel</a></td>
<td>Contains a Boolean value indicating that an OLAP hierarchy level is a custom group level rather than a level from the original OLAP cube.</td>
</tr>
<tr>
<td><a href="xeleUniqueName_GroupLevel_HV01105040.htm" id="HV01105040" lcid="">UniqueName</a></td>
<td>Specifies a unique name for an OLAP hierarchy group level.</td>
</tr>
<tr>
<td><a href="xeleName_GroupLevel_HV01104756.htm" id="HV01104756" lcid="">Name</a></td>
<td>Specifies a caption (display name) for an OLAP hierarchy group level.</td>
</tr>
<tr>
<td><a href="xeleGroupDefinition_HV01104647.htm" id="HV01104647" lcid="">GroupDefinition</a></td>
<td>Describes a particular grouping of OLAP members in a hierarchy level in an OLAP-based PivotTable view or report.</td>
</tr>
</table><h3>Attributes</h3><p>None.</p><h2>Definition</h2><pre>
<code>
<xsd:element name="CubeField" type="CubeFieldType" minOccurs="0" maxOccurs="unbounded" >
</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>
|
