SlicerCacheLevel Interface

Definition

Namespace:

Microsoft.Office.Interop.Excel

Assembly:

Microsoft.Office.Interop.Excel.dll

Represents a level of a hierarchy in an OLAP data source being filtered by a slicer.

public interface class SlicerCacheLevel

[System.Runtime.InteropServices.Guid("000244C6-0000-0000-C000-000000000046")]
[System.Runtime.InteropServices.InterfaceType(2)]
public interface SlicerCacheLevel

Public Interface SlicerCacheLevel

Attributes

GuidAttribute InterfaceTypeAttribute

Remarks

When a slicer is used to filter an OLAP data source, the slicer cache it is associated with can contain multiple hierarchy levels from the data source. Use the SlicerCacheLevels collection of the parent SlicerCache object to access the SlicerCacheLevel objects that represent these hierarchy levels.

Properties

Application	When used without an object qualifier, this property gets an Application object that represents the Microsoft Excel application. When used with an object qualifier, this property gets an Application object that represents the creator of the specified object.
Count	Gets the number of SlicerItem objects in the specified SlicerCacheLevel object.
Creator	Gets a 32-bit integer that indicates the application in which this object was created.
CrossFilterType	Gets or sets whether a slicer is participating in cross filtering with other slicers that share the same slicer cache, and how cross filtering is displayed.
Name	Gets the MDX unique name of OLAP hierarchy level represented by the object.
Ordinal	Gets the one-based ordinal value of the hierarchy level represented by the specified SlicerCacheLevel object.
Parent	Gets the SlicerCache object for the specified SlicerCacheLevel object.
SlicerItems	Gets a SlicerItems collection that contains the collection of all slicer items for the specified level.
SortItems	Gets or sets whether the items in the slicer are sorted.
VisibleSlicerItemsList	Gets the list of slicer items that are currently included in the slicer filter.