SAP Knowledge Base Article - Public

2673696 - Range Selection in the Filter by Member dialog filters by Key instead of Text


When trying to filter members in Analysis for Office, using the "Range Selection" in the Filter by Member dialog, the members are filtered according to the Key, instead of Text.


SAP BusinessObjects Analysis, edition for Microsoft Office

Reproducing the Issue

  1. Try to filter the members in Analysis for Office;
  2. The Filter by Member dialog appears;
  3. Select the "Range Selection";
  4. Enter the filter condition;
  5. Click OK;
  6. Confirm that the members are filtered according to their Key instead of Text.


This is not a bug in the tool, but how the tool works.

For the range definition, the key of the members is relevant, not the text. See chapter "To filter data by member" in the User Guide of Analysis Office.


text, key, filter by member, range, values , KBA , BI-RA-AO-XLA , Excel Addin , Problem


SAP Analysis for Microsoft Office all versions