Filtering sets

You can filter a set by one or more attributes to choose the members that appear in the set. Filters are applied only to the Available members list 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, 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 shows all members that match the filter statements.

  5. Click Insert or Replace set with new insertion to add the filtered results to the Current set.

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

Filter applied to the name attribute

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. You can see the applied filters in the Member name list under Available members or in the MDX.

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

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 to clear all the filters you applied and restore the set to its original state.