In out webi reports there are universes filters that we add to the reports so when the report is refreshed the user is prompted to select the values that they want to query for.
Some of these list of values are quite extensive and the webi users often use the search facility.
However, the users are complaining that if they enter the search criteria in lowercase no results are returned.
I have tried using upper around the dimension but still cant get it to return values.
My thinking is that this search facility is actually searching the LOV file not doing a select from the database so using database functions of UPPEr etc will not work.
Is there any way that anyone can suggest that will allow finding of uppercase results using the search facility even if the search criteria is in lowercase.
TIA.
![[bandito]](/data/assets/smilies/bandito.gif "[bandito] [bandito]")
[blue]DBomrrsm[/blue]
[blue]Software code, like laws and sausages, should never be examined in production[/blue][black] - [/black][purple]Edward Tenner[/purple]
Some of these list of values are quite extensive and the webi users often use the search facility.
However, the users are complaining that if they enter the search criteria in lowercase no results are returned.
I have tried using upper around the dimension but still cant get it to return values.
My thinking is that this search facility is actually searching the LOV file not doing a select from the database so using database functions of UPPEr etc will not work.
Is there any way that anyone can suggest that will allow finding of uppercase results using the search facility even if the search criteria is in lowercase.
TIA.
[blue]DBomrrsm[/blue] [blue]Software code, like laws and sausages, should never be examined in production[/blue][black] - [/black][purple]Edward Tenner[/purple]