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
- Try to filter the members in Analysis for Office;
- The Filter by Member dialog appears;
- Select the "Range Selection";
- Enter the filter condition;
- Click OK;
- 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