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.
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.
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.
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.