[Table of Contents] [docx version]
SpreadsheetML Reference Material - Table of Contents
cacheHierarchies (PivotCache Hierarchies)
Represents the collection of OLAP hierarchies in the PivotCache.
[Example:
<cacheHierarchies count="2">
<cacheHierarchy uniqueName="[Account].[Account]" caption="Account"
attribute="1" keyAttribute="1"
defaultMemberUniqueName="[Account].[Account].[All Accounts]"
allUniqueName="[Account].[Account].[All Accounts]"
dimensionUniqueName="[Account]" count="0"/>
<cacheHierarchy uniqueName="[Account].[Account Number]" caption="Account
Number" attribute="1" defaultMemberUniqueName="[Account].[Account
Number].[All Accounts]" allUniqueName="[Account].[Account Number].[All
Accounts]" dimensionUniqueName="[Account]" count="0"/>
</cacheHierarchies>
Parent Elements |
pivotCacheDefinition (§3.10.1.67) |
Child Elements |
Subclause |
cacheHierarchy (PivotCache Hierarchy) |
§3.10.1.6 |
Attributes |
Description |
count (Hierarchy Count) |
Specifies the number of OLAP hierarchies in the cache.
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_CacheHierarchies">
<sequence>
<element name="cacheHierarchy" minOccurs="0" maxOccurs="unbounded" type="CT_CacheHierarchy"/>
</sequence>
<attribute name="count" type="xsd:unsignedInt"/>
</complexType>