Analytics Software

Hi Guys--

I have a user enter in a search string in a global filter and that string populates the presentation variable called pv_searchstr.

I then want to wrap this presentation variable with an UPPER() function and use it in a report filter with a LIKE operator. I want the filter on my report to look like this:

UPPER(Reports.Path) LIKE '%UPPER('@{pv_searchstr}')%'

This does not work because the filter thinks the upper function is part of the string. Is it possible to achieve what I am doing?

Another solution would be to wrap the presentation variable with an UPPER function and then send it to a new presentation variable. Then I could use the report filter UPPER(Reports.Path) LIKE '%'@{new_var}')%'. I know this works in the report filter, but I don't know how to set the new filter in the report. Can I do that in the Prefix or Postfix in the Advanced tab?