Hello, I'm using OBIEE and have created a column prompt that will display on a dashboard. The prompt allows the user to specify a string to be used as a filter on a field. The problem is, the text in the field is in all upper case letters, and if the user specifies a string containing lower case letters then it does not return any results. I added instructions to the report to tell the user to put their string in all caps, but am wondering if I can't make BI treat the specified string as all caps, or treat the search field as case-inspecific.

I thought that the answer might be to use a presentation variable, but that doesn't seem to be working.

Here's what I have done so far:

The prompt is set to filter on column 'Description'. I set the User Input as Text Field, told it to Require User Input, and then set a variable as Presentation Variable named 'Item'. I then set filter criteria on the 'Description' column with the operator 'contains any' and the variable expression Item. I put Item inside an upper command, so what is in the Variable Expr box is 'UPPER(Item)', in the hopes that it would effectively make treat any entry in the prompt as if it were in all caps, but it is not doing that. The prompt is still working, but UPPER doesn't seem to have any effect. Does anyone know what I could do differently?

It is worth noting that as things stand the report is functional, I'm just trying to make it better! Thanks!