Web Intelligence Prompts and Wild Card Selections

[Former Member]

Hello,

I have a WebI report connected to a SQL server database through a Universe.  There is a prompt on the report that is set to 'In List'.  If a wild card is enterd (Ex. for employee - '0001*') the list of values displays for all values starting with '0001',  but if '0001*' is entered as a Selected Value WebI does not recognize the wild card and displays no data.  Does WebI have the ability to have a wild card added as an actual selection?  Or is the wild card only used to bring up a list of values, which must then be selected by the user and moved to the 'Selected Value(s)' section?

Thank you.

[Former Member · Accepted solution]

Agree with Durgamadhab, you should use a query filter like "Matches pattern" (not in list):

Else here a neat trick in order to get use wildcards with Input Controls:

http://blog.davidg.com.au/2012/04/search-field-input-control-in-webi.html

Best regards,

Victor

[Former Member · Accepted solution]

Hi Victor,

I'd like to do something like this. Can we set this filter in multiple choice? 

For example I have region

     NY,

     Texas.

And I also have  stores like

     NY Store1,

     NY Store2,

     Texas Store1

How could I set filter to selection store according to region selection?  For the second selection set filter %region%

I opened a discussion for that :

[former_member221178 · Accepted solution]

Thanks!!! It worked like a charm. I was using $ or * wild cards and I am not getting the data I needed.

Weren't they used in the Webi query?

[Former Member]

If your database is oracle for wild card try using % as the spacial char. Also you should make the filter as match pattern(Like ) as well..