SAP Knowledge Base Article - Public

2596193 - Search in Filter by Member dialog is case-sensitive

Symptom

When searching for members using the "Filter by Member" dialog, the search is case-sensitive.

For example, when searching for "irland" in this list:

Search1.png

The member "Irland" is not returned:

Search2.png

When searching for "Irland", the member is returned:

Search3.png

Environment

SAP Analysis for 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

Product

SAP Analysis for Microsoft Office all versions