VariableSlicerMode (Property)

Applies To:

OLAPSlicer collection

Description:

Sets the variable slicer value to a members list or a tree control on the Slicer dialog box. The members list view is useful when you want to see all members at the same level as the previously selected member. The tree control enables you to see all available parent-child slicer value relationships.

Action:

Read-write, BqSlicerDisplayOptions constant group

Constants:

The VariableSlicerMode property uses the BqSlicerDispayOptions constant group, which consists of bqListView and bqTreeView.

Example:

This example shows how to set the variable slicer mode to tree view.

ActiveDocument.Sections["OLAPQuery"].Slicers.VariableSlicerMode = bqTreeView