Filtering the View of Members Based on Criteria

You define filters to view only members that meet your criteria. You can then select from the filtered list for your report. For example, you can display Regions in the United States division only. Filters are useful for reducing the number of members that are displayed.

For an SAP BW data source, your filtering criteria can include display attributes, which provide descriptive information about a dimensions, levels, or members. Filtering criteria can use wildcards and the Contains, Starts with, Ends with, and Is Null operators as well as the equal sign ( = ), less-than ( < ), an greater-than ( > ) operators.

  To define filters:

  1. Open a report.

  2. Double-click a dimension cell for which you want to edit a member.

    The Select members dialog box is displayed.

  3. Right-click inside the Available area and make one of the following selections:

    • Select Filter, and then Custom, highlight the lists of available functions, then click the Add button, Right Arrow icon, to move them to the Selected area.

    • Select Filter, and then Predefined, then highlight the desired list.

  4. Click OK.

  5. Click OK to return to your report.