Show TOC

SAPListOfMeasureFiltersLocate this document in the navigation structure

This function returns a list of all measure filters including BEx conditions. The list contains two columns: the first column lists the filter type (BEX, DIMENSION, MEASURE) and the second with filter values.

The formula consist of three parameters and is made up of the following arguments:
  • Data Source

    Enter the formula alias of the data source or planning object. You can set the alias when configuring the data source or planning object on the Components tab in the design panel.

  • Display
    You can enter ALL, DIMENSION, MEASURE or BEX to define which measure filters should be displayed in the workbook:
    • ALL returns a list of all measure filters.
    • DIMENSION returns a list of filter by measure on all dimensions or a defined one.
    • MEASURE returns a list of filter by measure on data cells.

      The list also returns the filter type: All Dimensions Independently, Most Detailed Dimension in Rows or Most Detailed Dimension in Columns.

    • BEX returns a list of BEx conditions.

    This parameter is optional. ALL is the default value. You can also combine values of this parameter.

  • Name

    Enter the technical name of the dimension if you have selected DIMENSION in the display parameter. This parameter is optional. If you do not enter a dimension name, all dimensions are listed.

Example

Cell G20: =SAPListOfMeasureFilters("DS_1";"BEX")

Starting in cell G20, a list is displayed with all BEx conditions in data source DS_1.