Show TOC

SAPGetDimensionEffectiveFilterLocate this document in the navigation structure

This function returns all effective filters of a dimension: dynamic filters defined by the user, static filters defined in the underlying source, and filters by measure defined for the selected dimension.

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

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

  • Dimension

    Enter the technical name of the dimension.

  • Member Display

    You can enter TEXT, KEY, or INPUT_STRING to define how the filtered members should be displayed in the workbook.

    You can use INPUT_STRING_AS_ARRAY if the formula is called from VBA to get the input string as a string array.

Example

Cell F20: =SAPGetDimensionEffectiveFilter("DS_1";"0DIVISION";"TEXT")

If you enter the formula in cell F20, the members of 0DIVISION that are currently filtered by the user, the static filters that are defined in the data source, and the filters by measure for this dimension are displayed in cell F20 as text. If no static filters are defined for the data source, only the dynamic filter members and filters by measure are displayed.