[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

pivotCacheDefinition3.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>