SlicerCacheLevel Members (Excel)
Contribute to this content Use GitHub to suggest and submit changes. See our guidelines for contributing to VBA documentation. |
Represents a level of a hierarchy in an OLAP data source being filtered by a slicer.
Properties
Name |
Description |
---|---|
When used without an object qualifier, this property returns an Application object that represents the Microsoft Excel application. When used with an object qualifier, this property returns an Application object that represents the creator of the specified object. Read-only. |
|
Returns the number of SlicerItem objects in the specified SlicerCacheLevel object. Read-only. |
|
Returns a 32-bit integer that indicates the application in which this object was created. Read-only Long. |
|
Returns 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. Read/write |
|
Returns the MDX unique name of OLAP hierarchy level represented by the object. |
|
Returns the one-based ordinal value of the hierarchy level represented by the specified SlicerCacheLevel object. Read-only |
|
Returns the SlicerCache object for the specified SlicerCacheLevel object. Read-only. |
|
Returns a SlicerItems collection that contains the collection of all slicer items for the specified level. Read-only |
|
Returns or sets the sort order of the items in the slicer. Read/write. |
|
Returns the list of slicer items that are currently included in the slicer filter. Read-only |