Share via

2.6.76 CT_OlapSlicerCacheRange

  • Article

Target namespace: http://schemas.microsoft.com/office/spreadsheetml/2009/9/main

Referenced by: CT_OlapSlicerCacheRanges

A complex type that specifies a collection of cached OLAP slicer items in the OLAP level specified by the ancestor CT_OlapSlicerCacheLevelData element.

Child Elements:

i: A CT_OlapSlicerCacheItem element that specifies an OLAP slicer item in the OLAP level specified by the CT_OlapSlicerCacheLevelData element that is part of this range. The number of CT_OlapSlicerCacheItem child elements MUST be greater than 0 and equal to or less than 1,000.

Attributes:

startItem: An unsignedInt ([XMLSCHEMA2/2] section 3.3.22) attribute that specifies the zero-based index of the OLAP member on this OLAP level for the first item in this range. The order of the OLAP slicer item is determined by the current sort order and current slicer cross filtering setting applied to all OLAP slicer items on this OLAP level. The value of the starting position MUST be 0 or MUST be a multiple of 1,000. See Slicer Items for more information.

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

 <xsd:complexType name="CT_OlapSlicerCacheRange">
   <xsd:sequence>
     <xsd:element name="i" type="CT_OlapSlicerCacheItem" minOccurs="1" maxOccurs="unbounded"/>
   </xsd:sequence>
   <xsd:attribute name="startItem" type="xsd:unsignedInt" use="required"/>
 </xsd:complexType>

See section 5.4 for the full W3C XML Schema ([XMLSCHEMA1/2] section 2.1).