SlicerCacheDefinition class

2.4.38 slicerCacheDefinition

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

A slicerCacheDefinition element is a CT_SlicerCacheDefinition type element, as specified in section 2.6.70, that specifies a slicer cache, as specified in section 2.3.2.1. This element is the root element of the slicer cache part.

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

<xsd:element name="slicerCacheDefinition" type="CT_SlicerCacheDefinition"/>

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

2.6.70 CT_SlicerCacheDefinition

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/IEC-29500-1] 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 (1) for the slicer cache.

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

Attributes:

name: An ST_Xstring ([ISO/IEC-29500-1] 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.

sourceName: An ST_Xstring attribute that specifies the MDX unique name or PivotTable ([ISO/IEC-29500-1] section 18.10) cache field (1) 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 (1), the value of this attribute MUST be equal to the name attribute of a CT_CacheField ([ISO/IEC-29500-4] 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/IEC-29500-4] section A.2) elements of all included CT_CacheField elements MUST be equal.

If the slicer source data is an OLAP data source (1), the value MUST be equal to the value of the uniqueName attribute in one of the CT_CacheHierarchy ([ISO/IEC-29500-4] 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/IEC-29500-4] section A.2) element with a zero-based index in the list of CT_PivotHierarchy elements specified by the CT_PivotHierarchies ([ISO/IEC-29500-4] 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/IEC-29500-4] section A.2) MUST have an includeNewItemsInFilter attribute equal to "false".

The following W3C XML Schema ([XMLSCHEMA1] 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" minOccurs="0" maxOccurs="1"/>

</xsd:sequence>

<xsd:attribute name="name" type="x:ST_Xstring" use="required"/>

<xsd:attribute name="sourceName" type="x:ST_Xstring" use="required"/>

</xsd:complexType>

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

Reference