How to use a search string on a description column as a prompt

yaseennawaz

Hi,

I have a requirement wherein I have a column named PO description ,user would like to enter a search string which would be part of PO description column value and he would like to see the data in the report matching that search string.Can you please let me know how this can achieved.I used "LIKE pattern" in prompts and created a presentation variable and used this as a filter with the same "LIKE Pattern" criteria in the filter.It is not working.Please let me how i can achieve this.

Regards,

Yaseen

Gianni Ceresa

I used "LIKE pattern" in prompts and created a presentation variable and used this as a filter with the same "LIKE Pattern" criteria in the filter.It is not working.

And why it isn't working?

What does the generated SQL query looks like? What should be different in that query to make it work?

You are maybe just 1 step away to your solution, just look into what your OBIEE is doing and based on what you coded in your analysis and the generated code, you will maybe easily see you just need to add something (maybe it's only missing % before and after your filter value?).

yaseennawaz

Thanks Gianni...Worked like a charm. I had to use % before and after the filter value.

Regards,

Yaseen