2801722 - When filtering searched members in the filter dialog, unexpected members are also filtered

When searching for members in the filter dialog, a list of members that match the search are displayed and can be selected. When selecting few members or all of them, unexpected members are also filtered.

SAP Analysis for Microsoft Office

This symptom occurs because when searching for members without deselecting the members already selected, these members will remain selected, although they do not appear in the search result.

This is not a bug in the tool. It is the intended behavior.

When searching for members, it is necessary to uncheck the option "Select All" to make sure there is no member selected:

Then search and select the desired members:

This is also mentioned in the User Guide of Analysis for Office, in chapter "To filter data by member".

User Guide of Analysis for Office - chapter "To filter data by member"

filtering, filter, add lines, adding, empty, not selected, all members, blank, filled, mandatory, restrict, restriction , KBA , BI-RA-AO-XLA , Excel Addin , Problem