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.
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.
The list also returns the filter type: All Dimensions Independently, Most Detailed Dimension in Rows or Most Detailed Dimension in Columns.
This parameter is optional. ALL is the default value. You can also combine values of this parameter.
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.
Cell G20: =SAPListOfMeasureFilters("DS_1";"BEX")
Starting in cell G20, a list is displayed with all BEx conditions in data source DS_1.