Compartir a través de


SlicerCacheDefinition Class

Defines the SlicerCacheDefinition Class. It is the root element of SlicerCachePart.When the object is serialized out as xml, its qualified name is x14:slicerCacheDefinition.

Inheritance Hierarchy

System.Object
  DocumentFormat.OpenXml.OpenXmlElement
    DocumentFormat.OpenXml.OpenXmlCompositeElement
      DocumentFormat.OpenXml.OpenXmlPartRootElement
        DocumentFormat.OpenXml.Office2010.Excel.SlicerCacheDefinition

Namespace:  DocumentFormat.OpenXml.Office2010.Excel
Assembly:  DocumentFormat.OpenXml (in DocumentFormat.OpenXml.dll)

Syntax

'Declaration
<ChildElementInfoAttribute(GetType(SlicerCachePivotTables), FileFormatVersions.Office2010)> _
<OfficeAvailabilityAttribute(FileFormatVersions.Office2010)> _
<ChildElementInfoAttribute(GetType(SlicerCacheData), FileFormatVersions.Office2010)> _
<ChildElementInfoAttribute(GetType(ExtensionList), FileFormatVersions.Office2010)> _
Public Class SlicerCacheDefinition _
    Inherits OpenXmlPartRootElement
'Usage
Dim instance As SlicerCacheDefinition
[ChildElementInfoAttribute(typeof(SlicerCachePivotTables), FileFormatVersions.Office2010)]
[OfficeAvailabilityAttribute(FileFormatVersions.Office2010)]
[ChildElementInfoAttribute(typeof(SlicerCacheData), FileFormatVersions.Office2010)]
[ChildElementInfoAttribute(typeof(ExtensionList), FileFormatVersions.Office2010)]
public class SlicerCacheDefinition : OpenXmlPartRootElement

Remarks

The following table lists the possible child types:

  • SlicerCachePivotTables <x14:pivotTables>

  • SlicerCacheData <x14:data>

  • ExtensionList <x14:extLst>

2.4.33 slicerCacheDefinition

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

A CT_SlicerCacheDefinition element that specifies a slicer cache. 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.3 for the full W3C XML Schema ([XMLSCHEMA1] section 2.1).

2.6.64 CT_SlicerCacheDefinition

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

Referenced by: slicerCacheDefinition

A complex type that specifies a slicer cache.

Child Elements:

pivotTables : A CT_SlicerCachePivotTables element that specifies a group CT_SlicerCachePivotTable elements which specify the PivotTable ([ISO/IEC-29500-1] section 18.10) views that are filtered by the slicer cache.

data : A CT_SlicerCacheData element that specifies a data source for the slicer cache.

extLst : A CT_ExtensionList ([ISO/IEC-29500-4] section A.2) element 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 Formulas*. MUST be a unique case insensitive name within the scope of defined names.*

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

If the slicer source data is a non-OLAP data source, then 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 Slicer Cache Relationship to PivotCache*, and specifies a PivotTable (*[ISO/IEC-29500-1] section 18.10) cache field. The specified CT_CacheField ([ISO/IEC-29500-4] section A.2) MUST have a serverField attribute equal to FALSE.

If the slicer source data is an OLAP data source, then 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 Slicer Cache Relationship to PivotCache, and specifies a MDX unique name. The following attributes of the CT_CacheHierarchy ([ISO/IEC-29500-4] section A.2) 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 ([ISO/IEC-29500-4] section A.2) elements specified by CT_PivotHierarchies ([ISO/IEC-29500-4] section A.2) equal to the zero-based index of the CT_CacheHierarchy ([ISO/IEC-29500-4] section A.2) element in the list of CT_CacheHierarchy ([ISO/IEC-29500-4] section A.2) 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="1" 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 name="sourceName" type="x:ST_Xstring" use="required"/>

</xsd:complexType>

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

Thread Safety

Any public static (Shared in Visual Basic) members of this type are thread safe. Any instance members are not guaranteed to be thread safe.

See Also

Reference

SlicerCacheDefinition Members

DocumentFormat.OpenXml.Office2010.Excel Namespace