Analytics Software

Hi,

I have a requirement where user wants to do a wildcard search(in prompt). Is it possible in OBIEE?

I have a prompt(edit box) where user has to enter a value. After entering the value the report is shown (using guided navigation) if the request returns any value.
Typing % in the edit box returns all the rows but entering something like xyz% doesnt return any row.

Please let me know if anyone has any suggession.

Thanks