SAP Knowledge Base Article - Public

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

Symptom

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.

Environment

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.

Resolution

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.

Keywords

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

Product

SAP Analysis for Microsoft Office all versions