Show TOC

SAPListOfEffectiveFiltersLocate this document in the navigation structure

This function returns a list of all effective filters of a data source: Dynamic filters defined by the user, static filters defined in the underlying source, and filters by measure defined for the data source dimensions.

The formula consists of 2 parameters and is made up of the following arguments:
  • Data Source

    Enter the formula alias for the data source. You can set the alias when configuring the data source on the Components tab in the design panel.

  • Member Display

    You can enter TEXT, KEY or INPUT_STRING to define how the filtered members should be displayed in the workbook. This parameter is optional. The current display selected for members is the default setting. If two options exist, the first one is applied.

Example

Cell F20: =SAPListOfEffectiveFilters("DS_1";"TEXT")

You have added dimension Region from data source DS_1 to your analysis. You filter this dimension and the following members are part of the analysis: California, Arizona, Florida, Nevada. If you enter the formula in cell F20, the name of the dimension is displayed in cell F20, and the four filtered members are listed as text in cell G20.