OlapSlicerCache Class

Defines the OlapSlicerCache Class.This class is only available in Office2010.When the object is serialized out as xml, its qualified name is x14:olap.

Inheritance Hierarchy

System.Object
  DocumentFormat.OpenXml.OpenXmlElement
    DocumentFormat.OpenXml.OpenXmlCompositeElement
      DocumentFormat.OpenXml.Office2010.Excel.OlapSlicerCache

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

Syntax

'Declaration
<ChildElementInfoAttribute(GetType(OlapSlicerCacheLevelsData), FileFormatVersions.Office2010)> _
<OfficeAvailabilityAttribute(FileFormatVersions.Office2010)> _
<ChildElementInfoAttribute(GetType(OlapSlicerCacheSelections), FileFormatVersions.Office2010)> _
<ChildElementInfoAttribute(GetType(ExtensionList), FileFormatVersions.Office2010)> _
Public Class OlapSlicerCache _
    Inherits OpenXmlCompositeElement
'Usage
Dim instance As OlapSlicerCache
[ChildElementInfoAttribute(typeof(OlapSlicerCacheLevelsData), FileFormatVersions.Office2010)]
[OfficeAvailabilityAttribute(FileFormatVersions.Office2010)]
[ChildElementInfoAttribute(typeof(OlapSlicerCacheSelections), FileFormatVersions.Office2010)]
[ChildElementInfoAttribute(typeof(ExtensionList), FileFormatVersions.Office2010)]
public class OlapSlicerCache : OpenXmlCompositeElement

Remarks

The following table lists the possible child types:

  • OlapSlicerCacheLevelsData <x14:levels>

  • OlapSlicerCacheSelections <x14:selections>

  • ExtensionList <x14:extLst>

2.6.74 CT_OlapSlicerCache

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

Referenced by: CT_SlicerCacheData

A complex type that specifies the associated OLAP PivotTable ([ISO/IEC-29500-1] section 18.10) PivotCache, and specifies OLAP Slicer Items. See Slicer Cache Relationship to PivotCache for more details.

Child Elements:

levels : A CT_OlapSlicerCacheLevelsData element that specifies a list of OLAP levels of the OLAP hierarchy specified by this slicer cache.

selections : A CT_OlapSlicerCacheSelections element that specifies a list of OLAP Slicer Items that are selected.

extLst : A CT_ExtensionList ([ISO/IEC-29500-4] section A.2) element that specifies future extensibility for this element.

Attributes:

pivotCacheId : An unsignedInt ([XMLSCHEMA2] section 3.3.22) attribute that specifies the associated OLAP PivotTable ([ISO/IEC-29500-1] section 18.10) PivotCache. MUST be equal to the pivotCacheId attribute of an existing CT_PivotCacheDefinition element.

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

<xsd:complexType name="CT_OlapSlicerCache">

<xsd:sequence>

<xsd:element name="levels" type="CT_OlapSlicerCacheLevelsData" minOccurs="1" maxOccurs="1"/>

<xsd:element name="selections" type="CT_OlapSlicerCacheSelections" minOccurs="1" maxOccurs="1"/>

<xsd:element name="extLst" type="x:CT_ExtensionList" minOccurs="0" maxOccurs="1"/>

</xsd:sequence>

<xsd:attribute name="pivotCacheId" type="xsd:unsignedInt" 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

OlapSlicerCache Members

DocumentFormat.OpenXml.Office2010.Excel Namespace