SlicerCache Members
Include Protected Members
Include Inherited Members
Represents the current filter state for a slicer and information about which PivotCache or WorkbookConnection the slicer is connected to.
The SlicerCache type exposes the following members.
Properties
| Name | Description | |
|---|---|---|
.gif "Public property") |
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. |
|
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. |
|
Index | Gets the index of the specified SlicerCache object in the SlicerCaches collection. |
|
Name | Gets or sets the name of the slicer cache. |
|
OLAP | Gets whether the slicer associated with the specified slicer cache is based on an OLAP data source. |
|
Parent | Gets the parent SlicerCaches object for the specified SlicerCache object. |
|
PivotTables | Gets a SlicerPivotTables collection that contains information about the PivotTables the slicer cache is currently filtering. |
|
ShowAllItems | Gets or sets whether slicers connected to the specified slicer cache display items that have been deleted from in the corresponding PivotCache. |
|
SlicerCacheLevels | Gets the collection of SlicerCacheLevel objects that represent the levels of an OLAP hierarchy on which the specified slicer cache is based. |
|
SlicerItems | Gets a SlicerItems collection that contains the collection of all items in the slicer cache. |
|
Slicers | Gets a Slicers collection that contains the collection of Slicer objects associated with the specified SlicerCache. |
|
SortItems | Gets or sets whether the items in the slicer are sorted. |
|
SortUsingCustomLists | Gets or sets whether items in the specified slicer cache will be sorted by the custom lists. |
|
SourceName | Gets the name of the data source the slicer is connected to. |
|
SourceType | Gets the kind of data source the slicer is connected to. |
|
VisibleSlicerItems | Gets a SlicerItems collection that contains the collection of all the visible items in the specified slicer cache. |
|
VisibleSlicerItemsList | Gets or sets the list of MDX unique names for members at all levels of the hierarchy where manual filtering is applied. |
|
WorkbookConnection | Gets a WorkbookConnection object that represents the data connection used by the specified slicer. |
Top
Methods
| Name | Description | |
|---|---|---|
.gif "Public method") |
ClearManualFilter | Clears the filtering of all slicers associated with the specified slicer cache. |
|
Delete | Deletes the specified slicer cache and the slicers associated with it. |
Top