[Table of Contents] [docx version]
SpreadsheetML Reference Material - Table of Contents
pivotHierarchies (PivotTable OLAP Hierarchies)
Represents the collection of OLAP hierarchies associated with the PivotTable.
[Example:
<sh:pivotHierarchies count="3">
<sh:pivotHierarchy dragToRow="0" dragToCol="0" dragToPage="0" dragToData="1"/>
<sh:pivotHierarchy dragToRow="0" dragToCol="0" dragToPage="0" dragToData="1"/>
<sh:pivotHierarchy dragToRow="0" dragToCol="0" dragToPage="0" dragToData="1"/>
<sh:pivotHierarchy dragToRow="0" dragToCol="0" dragToPage="0" dragToData="1"/>
</sh:pivotHierarchies>
end example]
|
Parent Elements |
|
pivotTableDefinition (§3.10.1.73) |
|
Child Elements |
Subclause |
|
pivotHierarchy (OLAP Hierarchy) |
§3.10.1.72 |
|
Attributes |
Description |
|
count (OLAP Hierarchy Count) |
Specifies the number of OLAP hierarchies in the collection.
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_PivotHierarchies">
<sequence>
<element name="pivotHierarchy" maxOccurs="unbounded" type="CT_PivotHierarchy"/>
</sequence>
<attribute name="count" type="xsd:unsignedInt"/>
</complexType>