2.6.70 CT_SlicerCacheDefinition

  • Article

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

Referenced by: slicerCacheDefinition

A complex type that specifies a slicer cache.

Child Elements:

pivotTables: A CT_SlicerCachePivotTables element (section 2.6.72) that specifies a group of CT_SlicerCachePivotTable elements (section 2.6.73) that specify the PivotTable ([ISO/IEC29500-1:2016] section 18.10) views that are filtered by the slicer cache (section 2.1.4).

data: A CT_SlicerCacheData element (section 2.6.71) that specifies a data source for the slicer cache.

extLst: A CT_ExtensionList element, as specified in [ISO/IEC29500-4:2016] section A.2, that specifies future extensibility for this element.

Attributes:

name: An ST_Xstring ([ISO/IEC29500-1:2016] section 22.9.2.19) attribute that specifies the name of the slicer cache. MUST adhere to the name production rule provided in section 2.2.2. MUST be a unique case-insensitive name within the scope of defined names.

xr10:uid: An ST_Guid ([ISO/IEC29500-1:2016] section 22.9.2.4) attribute that specifies the unique id of the slicer cache.  If any instance of this type specifies this attribute, then all instances MUST specify it, and the values MUST be distinct.

sourceName: An ST_Xstring attribute that specifies the MDX unique name or PivotTable ([ISO/IEC29500-1:2016] section 18.10) cache field of the associated PivotTable PivotCache used by the slicer cache.

  • If the slicer source data (section 2.3.2.1.1)is a non-OLAP data source, the value of this attribute MUST be equal to the name attribute of a CT_CacheField ([ISO/IEC29500-4:2016] section A.2) element in the list of cache fields, as specified in section 2.3.2.1.2, and specify a PivotTable cache field. The specified CT_CacheField MUST have a serverField attribute equal to "false". The includeNewItemsInFilter attributes of the CT_PivotField ([ISO/IEC29500-4:2016] section A.2) elements of all included CT_CacheField elements MUST be equal.

  • If the slicer source data is an OLAP data source, the value MUST be equal to the value of the uniqueName attribute in one of the CT_CacheHierarchy ([ISO/IEC29500-4:2016] section A.2) elements within the associated OLAP pivot cache, as specified in section 2.3.2.1.4, and specify a MDX unique name. The following attributes of the CT_CacheHierarchy element MUST be "false": measure, set, and measures. The CT_PivotHierarchy ([ISO/IEC29500-4:2016] section A.2) element with a zero-based index in the list of CT_PivotHierarchy elements specified by the CT_PivotHierarchies ([ISO/IEC29500-4:2016] section A.2) equal to the zero-based index of the CT_CacheHierarchy element in the list of CT_CacheHierarchy elements specified by CT_CacheHierarchies ([ISO/IEC29500-4:2016] section A.2) MUST have an includeNewItemsInFilter attribute equal to "false".

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

 <xsd:complexType name="CT_SlicerCacheDefinition">
   <xsd:sequence>
     <xsd:element name="pivotTables" type="CT_SlicerCachePivotTables" minOccurs="0" maxOccurs="1"/>
     <xsd:element name="data" type="CT_SlicerCacheData" minOccurs="0" maxOccurs="1"/>
     <xsd:element name="extLst" type="x:CT_ExtensionList" minOccurs="0" maxOccurs="1"/>
   </xsd:sequence>
   <xsd:attribute name="name" type="x:ST_Xstring" use="required"/>
   <xsd:attribute ref="xr10:uid" use="optional"/>
   <xsd:attribute name="sourceName" type="x:ST_Xstring" use="required"/>
 </xsd:complexType>

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