Symptom
When searching for members using the "Filter by Member" dialog, the search is case-sensitive.
For example, when searching for "irland" in the below list:
The member "Irland" is not returned:
When searching for "Irland", the member is returned:
Environment
SAP BusinessObjects Analysis, edition for Microsoft Office
Resolution
BW:
Text-Search: Is case-sensitive by default but it's possible to achieve case-insensitive search using the RSMD_RS_TXTSEARCH backend parameter in RSADMIN. To maintain parameters in RSADMIN table, use program SAP_RSADMIN_MAINTAIN.
Key-Search: Depends on the InfoObject modelling of the dimension. If the dimension supports LOWER_CASE_STRINGS the search is case-sensitive. Otherwise it's case-insensitive.
BW/HANA:
The search on texts can be customized in SPRO (Display View Settings for Value Help: Details) / or directly with transaction RSCUSTV33.
The 'Search On Text' allows to switch on a case insensitive search.
Keywords
search, searching, members, lov, case, sensitive, capital, list of values, results, result, filter, filtering, insensitive , KBA , BI-RA-AO-XLA , Excel Addin , Problem