Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
SlicerCacheLevel Members (Excel)
Collapse the table of content
Expand the table of content

SlicerCacheLevel Members (Excel)

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

Name

Description

Application

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.

Count

Returns the number of SlicerItem objects in the specified SlicerCacheLevel object. Read-only.

Creator

Returns a 32-bit integer that indicates the application in which this object was created. Read-only Long.

CrossFilterType

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

Name

Returns the MDX unique name of OLAP hierarchy level represented by the object.

Ordinal

Returns the one-based ordinal value of the hierarchy level represented by the specified SlicerCacheLevel object. Read-only

Parent

Returns the SlicerCache object for the specified SlicerCacheLevel object. Read-only.

SlicerItems

Returns a SlicerItems collection that contains the collection of all slicer items for the specified level. Read-only

SortItems

Returns or sets whether the items in the slicer are sorted. Read/write

VisibleSlicerItemsList

Returns the list of slicer items that are currently included in the slicer filter. Read-only

Show:
© 2015 Microsoft