OlapSlicerCacheItem Class

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

Inheritance Hierarchy

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

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

Syntax

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

Remarks

The following table lists the possible child types:

  • OlapSlicerCacheItemParent <x14:p>

2.6.68 CT_OlapSlicerCacheItem

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

Referenced by: CT_OlapSlicerCacheRange

This element specifies an OLAP slicer item of the OLAP level in the OLAP hierarchy specified by the ancestor CT_OlapSlicerCacheLevelData element. This element contains a list of all ancestor OLAP members of this OLAP slicer item in the OLAP hierarchy.

Child Elements:

p : A CT_OlapSlicerCacheItemParent element that specifies the OLAP members that are ascendants of the OLAP slicer item specified by this element. The first element in this list specifies the OLAP member that is the parent of the OLAP slicer item specified by this element. Each subsequent element in this list specifies an ascendant OLAP member in the next level up the OLAP hierarchy.

Attributes:

n : An ST_Xstring ([ISO/IEC-29500-1] section 22.9.2.19) attribute that specifies the MDX unique name of the OLAP member associated with the OLAP slicer item specified by this element.

c : An ST_Xstring ([ISO/IEC-29500-1] section 22.9.2.19) attribute that specifies the caption of the OLAP slicer item specified by this element.

nd : A boolean ([XMLSCHEMA2] section 3.2.2) attribute that specifies whether the OLAP slicer item specified by this element has no data associated with it. This attribute MUST NOT exist if the crossFilter attribute of the ancestor element CT_OlapSlicerCacheLevelData is “none”. For more information, see Slicer Cross Filtering.

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

<xsd:complexType name="CT_OlapSlicerCacheItem">

<xsd:sequence>

<xsd:element name="p" type="CT_OlapSlicerCacheItemParent" minOccurs="0" maxOccurs="unbounded"/>

</xsd:sequence>

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

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

<xsd:attribute name="nd" type="xsd:boolean" use="optional" default="false"/>

</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

OlapSlicerCacheItem Members

DocumentFormat.OpenXml.Office2010.Excel Namespace