OlapSlicerCacheLevelData Class
Defines the OlapSlicerCacheLevelData Class.This class is only available in Office2010.When the object is serialized out as xml, its qualified name is x14:level.
Inheritance Hierarchy
System.Object
DocumentFormat.OpenXml.OpenXmlElement
DocumentFormat.OpenXml.OpenXmlCompositeElement
DocumentFormat.OpenXml.Office2010.Excel.OlapSlicerCacheLevelData
Namespace: DocumentFormat.OpenXml.Office2010.Excel
Assembly: DocumentFormat.OpenXml (in DocumentFormat.OpenXml.dll)
Syntax
'Declaration
<OfficeAvailabilityAttribute(FileFormatVersions.Office2010)> _
<ChildElementInfoAttribute(GetType(OlapSlicerCacheRanges), FileFormatVersions.Office2010)> _
Public Class OlapSlicerCacheLevelData _
Inherits OpenXmlCompositeElement
'Usage
Dim instance As OlapSlicerCacheLevelData
[OfficeAvailabilityAttribute(FileFormatVersions.Office2010)]
[ChildElementInfoAttribute(typeof(OlapSlicerCacheRanges), FileFormatVersions.Office2010)]
public class OlapSlicerCacheLevelData : OpenXmlCompositeElement
Remarks
The following table lists the possible child types:
- OlapSlicerCacheRanges <x14:ranges>
2.6.72 CT_OlapSlicerCacheLevelData
Target namespace: https://schemas.microsoft.com/office/spreadsheetml/2010/main
Referenced by: CT_OlapSlicerCacheLevelsData
A complex type that specifies properties of an OLAP level in the OLAP hierarchy specified by this slicer cache and specifies OLAP members that are cached for this OLAP level within the OLAP hierarchy specified by this slicer cache.
Child Elements:
ranges : A CT_OlapSlicerCacheRanges element that specifies cached OLAP slicer items for the OLAP level specified by this element.
Attributes:
uniqueName : An ST_Xstring ([ISO/IEC-29500-1] section 22.9.2.19) attribute that specifies the MDX unique name of the OLAP level specified by this element within the OLAP hierarchy associated with this slicer cache. The length of this string MUST be at least 1 character and MUST NOT exceed 32767 characters.
count : An unsignedInt ([XMLSCHEMA2] section 3.3.22) attribute that specifies the total number of OLAP members in the OLAP data source in this OLAP level within the OLAP hierarchy specified by this slicer cache. The default value is 0.
sortOrder : An ST_OlapSlicerCacheSortOrder attribute that specifies how the OLAP slicer items for the OLAP level specified by this element are sorted in the slicer view.
crossFilter : An ST_SlicerCacheCrossFilter attribute that specifies how the OLAP slicer items that are used in slicer cross filtering are displayed.
The following W3C XML Schema ([XMLSCHEMA1] section 2.1) fragment specifies the contents of this complex type.
<xsd:complexType name="CT_OlapSlicerCacheLevelData">
<xsd:sequence>
<xsd:element name="ranges" type="CT_OlapSlicerCacheRanges" minOccurs="0" maxOccurs="1"/>
</xsd:sequence>
<xsd:attribute name="uniqueName" type="x:ST_Xstring" use="required"/>
<xsd:attribute name="count" type="xsd:unsignedInt" use="optional"/>
<xsd:attribute name="sortOrder" type="ST_OlapSlicerCacheSortOrder" use="optional" default="natural"/>
<xsd:attribute name="crossFilter" type="ST_SlicerCacheCrossFilter" use="optional" default="showItemsWithDataAtTop"/>
</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.