We are using Oracle as the backend and the data that is stored in the columns is Case Sensitive.
For example: If I have a Region Prompt (query filter) in my webi report and it is enabled as Free Text (instead of list of values), if I enter "Americas" as the prompt value. I do not get any results back. If I enter "AMERICAS" (uppercase) I get results back. This is because the data for Region Column is stored in UPPERCASE in the table and is case sensitive.
My Questions is:
Ultimately the SQL Script should something like this - Select Region from Table01 where Region = UPPERCASE('Americas')
Any insights/suggestions are very much appreciated.