CacheHierarchy class

2.4.52 cacheHierarchy

Target namespace: http://schemas.microsoft.com/office/spreadsheetml/2010/11/main

A CT_CacheHierarchy element that specifies the extended properties of an OLAP measure.<29>

The following W3C XML Schema ([XMLSCHEMA1] section 2.1) fragment specifies the contents of this element.

<xsd:element name="cacheHierarchy" type="CT_CacheHierarchy"/>

See section 5.3 for the full W3C XML Schema ([XMLSCHEMA1] section 2.1).

2.6.102 CT_CacheHierarchy

Target namespace: http://schemas.microsoft.com/office/spreadsheetml/2010/11/main

Referenced by: cacheHierarchy

CT_CacheHierarchy is a complex type which specifies additional properties for an OLAP measure.<78>

Attributes:

aggregatedColumn: An int attribute that specifies the zero-based index of PivotTable cache hierarchy which corresponds to this OLAP measure. The referenced CT_CacheHierarchy ([ISO/IEC-29500-4] section A.2) element specifies the PivotTable cache hierarchy that this OLAP measure aggregates. MUST only be specified if the measure attribute of this cache hierarchy is "true". The value MUST match the index of an existing cache hierarchy in CT_CacheHierarchies ([ISO/IEC-29500-4]) collection or be equal -1 if this OLAP measure is not an implicit measure which aggregates a cache hierarchy.

The following W3C XML Schema ([XMLSCHEMA1] section 2.1) fragment specifies the contents of this complex type.

<xsd:complexType name="CT_CacheHierarchy">

<xsd:attribute name="aggregatedColumn" use="required" type="xsd:int"/>

</xsd:complexType>

See section 5.3 for the full W3C XML Schema ([XMLSCHEMA1] section 2.1).

Reference