How to use a search string on a description column as a prompt — Oracle Analytics

Oracle Analytics Cloud and Server

Home› Oracle Analytics› Oracle Analytics Forums› Oracle Analytics Cloud and Server› Oracle Analytics Cloud and Server

Categories

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

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

2
Views
2
Comments
yaseennawaz
yaseennawaz Rank 4 - Community Specialist
edited Aug 13, 2024 5:15PM in Oracle Analytics Cloud and Server

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

Comments

  • Gianni Ceresa
    Gianni Ceresa Mod

    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
    yaseennawaz Rank 4 - Community Specialist

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

    Regards,

    Yaseen