Filtering sets

You can filter a set by one or more attributes to choose the members that appear in the set. You can apply filters to the Available members and the Current set lists in the set.

You can filter on name, level, or attribute values and choose operators (such as =, <, >, <=, =>) to create dynamic selections. You can combine up to three filter parameters in one go.

Filter options

To filter a set:
  1. Open the set by double-clicking the dimension tile or click the menu next to the dimension and select Open set editor.
  2. Under Available members or Current set, click Filter and enter your filter parameters.
  3. Select Match all of the following or Match any of the following to apply the filter statements to the set. The default selection is Match all of the following.
  4. Click Done.

    The Available members or Current set now shows all members that match the filter statements.

In the following example, Available members was filtered to include only members that contain ma and an in their name.

Filter applied to the name attribute

You can add the filtered results from Available members to the Current set by clicking Insert or Replace set with new insertion.

Once a filter is applied, the filter parameter clears from the Filter menu. This allows you to add more filters to further narrow your member selections.

For Available members, you can see the applied filters in the Member name list under or in the MDX.

Note: Replace the Current set with the filtered set and click MDX to see the applied filters.

Click MDX to see filters applied to the Current set.

MDX showing applied filter

When you apply a filter to an already filtered set, the new filter applies on top of the first filter.

For example, in the following MDX, a new filter was applied to an already filtered set to include only members with names that contain the letter r.

MDX showing multiple filters applied

You can click Reset or Undo to clear all the filters you applied and restore the set to its original state.