Show TOC

SAPGetDimensionDynamicFilterLocate this document in the navigation structure

This function returns the dynamic filter of a dimension. Dynamic filters are defined by the user.

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: =SAPGetDimensionDynamicFilter("DS_1";"0DIVISION";"TEXT")

You add a filter for dimension 0DIVISION and the following members are displayed in the analysis: Paints, Lighting, Foods. If you enter the formula in cell F20, the three filtered members are displayed in cell F20 as text.