Show TOC

SAPListOfStaticFiltersLocate this document in the navigation structure

This function returns a list of all static filters of a data source. Static filters are defined in the underlying source and cannot be changed by the user.

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.

Example

Cell G15: =SAPListOfStaticFilters("DS_1";"TEXT")

If you enter the formula in cell G15, the static filters of data source DS_1 are displayed as text.