Defining Slicers

Slicers (also called Where Clauses) define the characteristics to use in the Query. Use the Slicer tab in the Query Clause section of the Fields page to define a slicer.

To add a characteristic to a slicer:

Drag the lowest child member for a characteristic from Characteristics and Key Figures to Slicer.
Click the lowest child member for a characteristic under Characteristics and Key Figures and click .
Double-click the lowest child member for a characteristic.

Table 37. Slicer Options

Option	Description
Characteristics	Selected characteristic
Value	Selected child member in the characteristic
Input	Whether the value is an input parameter to be defined during runtime.
Runtime	Allows users to define slicer values at runtime. (See Defining Runtime Parameters.) Note: Runtime is enabled only when Input is checked.

Note:

When creating slicers, you can restrict the data retrieved by selecting a dimension or hierarchy, clicking Range, and selecting the lowest level member to add to the slicer. (See Restricting the Members Retrieved.)