To insert a filter

Context

You can insert a filter component to your analysis to simplify the filtering. This helps you to quickly change the view of the displayed data, for example to different periods of time.

Procedure

Select an empty cell where you want to place the filter component.
Choose Filter and select one of the listed dimensions to insert a filter component for this dimension.
The dimension name and a filter component formula are inserted in the worksheet. The functions used for the formulas are SAPGetDimensionInfo and SAPSetFilterComponent. The formulas are created automatically.
Optional Step: Specify the filter component formula.
The formula that is inserted automatically, allows the user to select multiple members for filtering. It looks like this: =SAPSetFilterComponent("DS_2"; "0CALYEAR";"ALL").
You can add one of the following parameters to the formula: SINGLE, MULTIPLE, LOWERBOUNDARY, UPPERBOUNDARY to specify the filtering options. If you add the parameter SINGLE, the user can only select one member for filtering. The formula looks like this: =SAPSetFilterComponent("DS_2"; "0CALYEAR";"ALL";"SINGLE").
You can also insert filter components to enable a range selection. Insert two filter components for the same dimension and add to one the parameter LOWERBOUNDARY and to the other the parameter UPPERBOUNDARY. You can now filter for the lower and upper bounds of a range.
Optional step: Format the filter component.
You can use the formatting options of Microsoft Excel to format cells of the filter component.
Select the filter icon to define a filter.
All tables on the current sheet that contain this dimension, will be filtered according to the selected filter. On the Components tab in the design panel, you can define which tables should be affected if not all tables should be filtered accordingly.

Results

The filter is added to the analysis according to your configuration.